";
return $out;
}
// --------------
// END PUBLIC API
var $boundsheets = array();
var $formatRecords = array();
var $fontRecords = array();
var $xfRecords = array();
var $colInfo = array();
var $rowInfo = array();
var $sst = array();
var $sheets = array();
var $data;
var $_ole;
var $_defaultEncoding = "UTF-8";
var $_defaultFormat = SPREADSHEET_EXCEL_READER_DEF_NUM_FORMAT;
var $_columnsFormat = array();
var $_rowoffset = 1;
var $_coloffset = 1;
/**
* List of default date formats used by Excel
*/
var $dateFormats = array (
0xe => "m/d/Y",
0xf => "M-d-Y",
0x10 => "d-M",
0x11 => "M-Y",
0x12 => "h:i a",
0x13 => "h:i:s a",
0x14 => "H:i",
0x15 => "H:i:s",
0x16 => "d/m/Y H:i",
0x2d => "i:s",
0x2e => "H:i:s",
0x2f => "i:s.S"
);
/**
* Default number formats used by Excel
*/
var $numberFormats = array(
0x1 => "0",
0x2 => "0.00",
0x3 => "#,##0",
0x4 => "#,##0.00",
0x5 => "\$#,##0;(\$#,##0)",
0x6 => "\$#,##0;[Red](\$#,##0)",
0x7 => "\$#,##0.00;(\$#,##0.00)",
0x8 => "\$#,##0.00;[Red](\$#,##0.00)",
0x9 => "0%",
0xa => "0.00%",
0xb => "0.00E+00",
0x25 => "#,##0;(#,##0)",
0x26 => "#,##0;[Red](#,##0)",
0x27 => "#,##0.00;(#,##0.00)",
0x28 => "#,##0.00;[Red](#,##0.00)",
0x29 => "#,##0;(#,##0)", // Not exactly
0x2a => "\$#,##0;(\$#,##0)", // Not exactly
0x2b => "#,##0.00;(#,##0.00)", // Not exactly
0x2c => "\$#,##0.00;(\$#,##0.00)", // Not exactly
0x30 => "##0.0E+0"
);
var $colors = Array(
0x00 => "#000000",
0x01 => "#FFFFFF",
0x02 => "#FF0000",
0x03 => "#00FF00",
0x04 => "#0000FF",
0x05 => "#FFFF00",
0x06 => "#FF00FF",
0x07 => "#00FFFF",
0x08 => "#000000",
0x09 => "#FFFFFF",
0x0A => "#FF0000",
0x0B => "#00FF00",
0x0C => "#0000FF",
0x0D => "#FFFF00",
0x0E => "#FF00FF",
0x0F => "#00FFFF",
0x10 => "#800000",
0x11 => "#008000",
0x12 => "#000080",
0x13 => "#808000",
0x14 => "#800080",
0x15 => "#008080",
0x16 => "#C0C0C0",
0x17 => "#808080",
0x18 => "#9999FF",
0x19 => "#993366",
0x1A => "#FFFFCC",
0x1B => "#CCFFFF",
0x1C => "#660066",
0x1D => "#FF8080",
0x1E => "#0066CC",
0x1F => "#CCCCFF",
0x20 => "#000080",
0x21 => "#FF00FF",
0x22 => "#FFFF00",
0x23 => "#00FFFF",
0x24 => "#800080",
0x25 => "#800000",
0x26 => "#008080",
0x27 => "#0000FF",
0x28 => "#00CCFF",
0x29 => "#CCFFFF",
0x2A => "#CCFFCC",
0x2B => "#FFFF99",
0x2C => "#99CCFF",
0x2D => "#FF99CC",
0x2E => "#CC99FF",
0x2F => "#FFCC99",
0x30 => "#3366FF",
0x31 => "#33CCCC",
0x32 => "#99CC00",
0x33 => "#FFCC00",
0x34 => "#FF9900",
0x35 => "#FF6600",
0x36 => "#666699",
0x37 => "#969696",
0x38 => "#003366",
0x39 => "#339966",
0x3A => "#003300",
0x3B => "#333300",
0x3C => "#993300",
0x3D => "#993366",
0x3E => "#333399",
0x3F => "#333333",
0x40 => "#000000",
0x41 => "#FFFFFF",
0x43 => "#000000",
0x4D => "#000000",
0x4E => "#FFFFFF",
0x4F => "#000000",
0x50 => "#FFFFFF",
0x51 => "#000000",
0x7FFF => "#000000"
);
var $lineStyles = array(
0x00 => "",
0x01 => "Thin",
0x02 => "Medium",
0x03 => "Dashed",
0x04 => "Dotted",
0x05 => "Thick",
0x06 => "Double",
0x07 => "Hair",
0x08 => "Medium dashed",
0x09 => "Thin dash-dotted",
0x0A => "Medium dash-dotted",
0x0B => "Thin dash-dot-dotted",
0x0C => "Medium dash-dot-dotted",
0x0D => "Slanted medium dash-dotted"
);
var $lineStylesCss = array(
"Thin" => "1px solid",
"Medium" => "2px solid",
"Dashed" => "1px dashed",
"Dotted" => "1px dotted",
"Thick" => "3px solid",
"Double" => "double",
"Hair" => "1px solid",
"Medium dashed" => "2px dashed",
"Thin dash-dotted" => "1px dashed",
"Medium dash-dotted" => "2px dashed",
"Thin dash-dot-dotted" => "1px dashed",
"Medium dash-dot-dotted" => "2px dashed",
"Slanted medium dash-dotte" => "2px dashed"
);
function read16bitstring($data, $start) {
$len = 0;
while (ord($data[$start + $len]) + ord($data[$start + $len + 1]) > 0) $len++;
return substr($data, $start, $len);
}
// ADDED by Matt Kruse for better formatting
function _format_value($format,$num,$f) {
// 49==TEXT format
// http://code.google.com/p/php-excel-reader/issues/detail?id=7
if ( (!$f && $format=="%s") || ($f==49) || ($format=="GENERAL") ) {
return array('string'=>$num, 'formatColor'=>null);
}
// Custom pattern can be POSITIVE;NEGATIVE;ZERO
// The "text" option as 4th parameter is not handled
$parts = explode(";",$format);
$pattern = $parts[0];
// Negative pattern
if (count($parts)>2 && $num==0) {
$pattern = $parts[2];
}
// Zero pattern
if (count($parts)>1 && $num<0) {
$pattern = $parts[1];
$num = abs($num);
}
$color = "";
$matches = array();
$color_regex = "/^\[(BLACK|BLUE|CYAN|GREEN|MAGENTA|RED|WHITE|YELLOW)\]/i";
if (preg_match($color_regex,$pattern,$matches)) {
$color = strtolower($matches[1]);
$pattern = preg_replace($color_regex,"",$pattern);
}
// In Excel formats, "_" is used to add spacing, which we can't do in HTML
$pattern = preg_replace("/_./","",$pattern);
// Some non-number characters are escaped with \, which we don't need
$pattern = preg_replace("/\\\/","",$pattern);
// Some non-number strings are quoted, so we'll get rid of the quotes
$pattern = preg_replace("/\"/","",$pattern);
// TEMPORARY - Convert # to 0
$pattern = preg_replace("/\#/","0",$pattern);
// Find out if we need comma formatting
$has_commas = preg_match("/,/",$pattern);
if ($has_commas) {
$pattern = preg_replace("/,/","",$pattern);
}
// Handle Percentages
if (preg_match("/\d(\%)([^\%]|$)/",$pattern,$matches)) {
$num = $num* 100;
$pattern = preg_replace("/(\d)(\%)([^\%]|$)/","$1%$3",$pattern);
}
// Handle the number itself
$number_regex = "/(\d+)(\.?)(\d*)/";
if (preg_match($number_regex,$pattern,$matches)) {
$left = $matches[1];
$dec = $matches[2];
$right = $matches[3];
if ($has_commas) {
$formatted = number_format($num,strlen($right));
}
else {
$sprintf_pattern = "%1.".strlen($right)."f";
$formatted = sprintf($sprintf_pattern, $num);
}
$pattern = preg_replace($number_regex, $formatted, $pattern);
}
return array(
'string'=>$pattern,
'formatColor'=>$color
);
}
/**
* Constructor
*
* Some basic initialisation
*/
function Spreadsheet_Excel_Reader($file='',$store_extended_info=true,$outputEncoding='') {
$this->_ole = new OLERead();
$this->setUTFEncoder('iconv');
if ($outputEncoding != '') {
$this->setOutputEncoding($outputEncoding);
}
for ($i=1; $i<245; $i++) {
$name = strtolower(( (($i-1)/26>=1)?chr(($i-1)/26+64):'') . chr(($i-1)%26+65));
$this->colnames[$name] = $i;
$this->colindexes[$i] = $name;
}
$this->store_extended_info = $store_extended_info;
if ($file!="") {
$this->read($file);
}
}
/**
* Set the encoding method
*/
function setOutputEncoding($encoding) {
$this->_defaultEncoding = $encoding;
}
/**
* $encoder = 'iconv' or 'mb'
* set iconv if you would like use 'iconv' for encode UTF-16LE to your encoding
* set mb if you would like use 'mb_convert_encoding' for encode UTF-16LE to your encoding
*/
function setUTFEncoder($encoder = 'iconv') {
$this->_encoderFunction = '';
if ($encoder == 'iconv') {
$this->_encoderFunction = function_exists('iconv') ? 'iconv' : '';
} elseif ($encoder == 'mb') {
$this->_encoderFunction = function_exists('mb_convert_encoding') ? 'mb_convert_encoding' : '';
}
}
function setRowColOffset($iOffset) {
$this->_rowoffset = $iOffset;
$this->_coloffset = $iOffset;
}
/**
* Set the default number format
*/
function setDefaultFormat($sFormat) {
$this->_defaultFormat = $sFormat;
}
/**
* Force a column to use a certain format
*/
function setColumnFormat($column, $sFormat) {
$this->_columnsFormat[$column] = $sFormat;
}
/**
* Read the spreadsheet file using OLE, then parse
*/
function read($sFileName) {
$res = $this->_ole->read($sFileName);
// oops, something goes wrong (Darko Miljanovic)
if($res === false) {
// check error code
if($this->_ole->error == 1) {
// bad file
die('The filename ' . $sFileName . ' is not readable');
}
// check other error codes here (eg bad fileformat, etc...)
}
$this->data = $this->_ole->getWorkBook();
$this->_parse();
}
/**
* Parse a workbook
*
* @access private
* @return bool
*/
function _parse() {
$pos = 0;
$data = $this->data;
$code = v($data,$pos);
$length = v($data,$pos+2);
$version = v($data,$pos+4);
$substreamType = v($data,$pos+6);
$this->version = $version;
if (($version != SPREADSHEET_EXCEL_READER_BIFF8) &&
($version != SPREADSHEET_EXCEL_READER_BIFF7)) {
return false;
}
if ($substreamType != SPREADSHEET_EXCEL_READER_WORKBOOKGLOBALS){
return false;
}
$pos += $length + 4;
$code = v($data,$pos);
$length = v($data,$pos+2);
while ($code != SPREADSHEET_EXCEL_READER_TYPE_EOF) {
switch ($code) {
case SPREADSHEET_EXCEL_READER_TYPE_SST:
$spos = $pos + 4;
$limitpos = $spos + $length;
$uniqueStrings = $this->_GetInt4d($data, $spos+4);
$spos += 8;
for ($i = 0; $i < $uniqueStrings; $i++) {
// Read in the number of characters
if ($spos == $limitpos) {
$opcode = v($data,$spos);
$conlength = v($data,$spos+2);
if ($opcode != 0x3c) {
return -1;
}
$spos += 4;
$limitpos = $spos + $conlength;
}
$numChars = ord($data[$spos]) | (ord($data[$spos+1]) << 8);
$spos += 2;
$optionFlags = ord($data[$spos]);
$spos++;
$asciiEncoding = (($optionFlags & 0x01) == 0) ;
$extendedString = ( ($optionFlags & 0x04) != 0);
// See if string contains formatting information
$richString = ( ($optionFlags & 0x08) != 0);
if ($richString) {
// Read in the crun
$formattingRuns = v($data,$spos);
$spos += 2;
}
if ($extendedString) {
// Read in cchExtRst
$extendedRunLength = $this->_GetInt4d($data, $spos);
$spos += 4;
}
$len = ($asciiEncoding)? $numChars : $numChars*2;
if ($spos + $len < $limitpos) {
$retstr = substr($data, $spos, $len);
$spos += $len;
}
else{
// found countinue
$retstr = substr($data, $spos, $limitpos - $spos);
$bytesRead = $limitpos - $spos;
$charsLeft = $numChars - (($asciiEncoding) ? $bytesRead : ($bytesRead / 2));
$spos = $limitpos;
while ($charsLeft > 0){
$opcode = v($data,$spos);
$conlength = v($data,$spos+2);
if ($opcode != 0x3c) {
return -1;
}
$spos += 4;
$limitpos = $spos + $conlength;
$option = ord($data[$spos]);
$spos += 1;
if ($asciiEncoding && ($option == 0)) {
$len = min($charsLeft, $limitpos - $spos); // min($charsLeft, $conlength);
$retstr .= substr($data, $spos, $len);
$charsLeft -= $len;
$asciiEncoding = true;
}
elseif (!$asciiEncoding && ($option != 0)) {
$len = min($charsLeft* 2, $limitpos - $spos); // min($charsLeft, $conlength);
$retstr .= substr($data, $spos, $len);
$charsLeft -= $len/2;
$asciiEncoding = false;
}
elseif (!$asciiEncoding && ($option == 0)) {
// Bummer - the string starts off as Unicode, but after the
// continuation it is in straightforward ASCII encoding
$len = min($charsLeft, $limitpos - $spos); // min($charsLeft, $conlength);
for ($j = 0; $j < $len; $j++) {
$retstr .= $data[$spos + $j].chr(0);
}
$charsLeft -= $len;
$asciiEncoding = false;
}
else{
$newstr = '';
for ($j = 0; $j < strlen($retstr); $j++) {
$newstr = $retstr[$j].chr(0);
}
$retstr = $newstr;
$len = min($charsLeft* 2, $limitpos - $spos); // min($charsLeft, $conlength);
$retstr .= substr($data, $spos, $len);
$charsLeft -= $len/2;
$asciiEncoding = false;
}
$spos += $len;
}
}
//$retstr = ($asciiEncoding) ? $retstr : $this->_encodeUTF16($retstr);
$retstr = ($asciiEncoding) ? iconv('iso-8859-1', $this->_defaultEncoding, $retstr) : $this->_encodeUTF16($retstr);
if ($richString){
$spos += 4* $formattingRuns;
}
// For extended strings, skip over the extended string data
if ($extendedString) {
$spos += $extendedRunLength;
}
$this->sst[]=$retstr;
}
break;
case SPREADSHEET_EXCEL_READER_TYPE_FILEPASS:
return false;
break;
case SPREADSHEET_EXCEL_READER_TYPE_NAME:
break;
case SPREADSHEET_EXCEL_READER_TYPE_FORMAT:
$indexCode = v($data,$pos+4);
if ($version == SPREADSHEET_EXCEL_READER_BIFF8) {
$numchars = v($data,$pos+6);
if (ord($data[$pos+8]) == 0){
$formatString = substr($data, $pos+9, $numchars);
} else {
$formatString = substr($data, $pos+9, $numchars*2);
}
} else {
$numchars = ord($data[$pos+6]);
$formatString = substr($data, $pos+7, $numchars*2);
}
$this->formatRecords[$indexCode] = $formatString;
break;
case SPREADSHEET_EXCEL_READER_TYPE_FONT:
$height = v($data,$pos+4);
$option = v($data,$pos+6);
$color = v($data,$pos+8);
$weight = v($data,$pos+10);
$under = ord($data[$pos+14]);
$font = "";
// Font name
$numchars = ord($data[$pos+18]);
if ((ord($data[$pos+19]) & 1) == 0){
$font = substr($data, $pos+20, $numchars);
} else {
$font = substr($data, $pos+20, $numchars*2);
$font = $this->_encodeUTF16($font);
}
$this->fontRecords[] = array(
'height' => $height / 20,
'italic' => !!($option & 2),
'color' => $color,
'under' => !($under==0),
'bold' => ($weight==700),
'font' => $font,
'raw' => $this->dumpHexData($data, $pos+3, $length)
);
break;
case SPREADSHEET_EXCEL_READER_TYPE_PALETTE:
$colors = ord($data[$pos+4]) | ord($data[$pos+5]) << 8;
for ($coli = 0; $coli < $colors; $coli++) {
$colOff = $pos + 2 + ($coli* 4);
$colr = ord($data[$colOff]);
$colg = ord($data[$colOff+1]);
$colb = ord($data[$colOff+2]);
$this->colors[0x07 + $coli] = '#' . $this->myhex($colr) . $this->myhex($colg) . $this->myhex($colb);
}
break;
case SPREADSHEET_EXCEL_READER_TYPE_XF:
$fontIndexCode = (ord($data[$pos+4]) | ord($data[$pos+5]) << 8) - 1;
$fontIndexCode = max(0,$fontIndexCode);
$indexCode = ord($data[$pos+6]) | ord($data[$pos+7]) << 8;
$alignbit = ord($data[$pos+10]) & 3;
$bgi = (ord($data[$pos+22]) | ord($data[$pos+23]) << 8) & 0x3FFF;
$bgcolor = ($bgi & 0x7F);
// $bgcolor = ($bgi & 0x3f80) >> 7;
$align = "";
if ($alignbit==3) { $align="right"; }
if ($alignbit==2) { $align="center"; }
$fillPattern = (ord($data[$pos+21]) & 0xFC) >> 2;
if ($fillPattern == 0) {
$bgcolor = "";
}
$xf = array();
$xf['formatIndex'] = $indexCode;
$xf['align'] = $align;
$xf['fontIndex'] = $fontIndexCode;
$xf['bgColor'] = $bgcolor;
$xf['fillPattern'] = $fillPattern;
$border = ord($data[$pos+14]) | (ord($data[$pos+15]) << 8) | (ord($data[$pos+16]) << 16) | (ord($data[$pos+17]) << 24);
$xf['borderLeft'] = $this->lineStyles[($border & 0xF)];
$xf['borderRight'] = $this->lineStyles[($border & 0xF0) >> 4];
$xf['borderTop'] = $this->lineStyles[($border & 0xF00) >> 8];
$xf['borderBottom'] = $this->lineStyles[($border & 0xF000) >> 12];
$xf['borderLeftColor'] = ($border & 0x7F0000) >> 16;
$xf['borderRightColor'] = ($border & 0x3F800000) >> 23;
$border = (ord($data[$pos+18]) | ord($data[$pos+19]) << 8);
$xf['borderTopColor'] = ($border & 0x7F);
$xf['borderBottomColor'] = ($border & 0x3F80) >> 7;
if (array_key_exists($indexCode, $this->dateFormats)) {
$xf['type'] = 'date';
$xf['format'] = $this->dateFormats[$indexCode];
if ($align=='') { $xf['align'] = 'right'; }
}elseif (array_key_exists($indexCode, $this->numberFormats)) {
$xf['type'] = 'number';
$xf['format'] = $this->numberFormats[$indexCode];
if ($align=='') { $xf['align'] = 'right'; }
}else{
$isdate = FALSE;
$formatstr = '';
if ($indexCode > 0){
if (isset($this->formatRecords[$indexCode]))
$formatstr = $this->formatRecords[$indexCode];
if ($formatstr!="") {
$tmp = preg_replace("/\;.*/","",$formatstr);
$tmp = preg_replace("/^\[[^\]]*\]/","",$tmp);
if (preg_match("/[^hmsday\/\-:\s\\\,AMP]/i", $tmp) == 0) { // found day and time format
$isdate = TRUE;
$formatstr = $tmp;
$formatstr = str_replace(array('AM/PM','mmmm','mmm'), array('a','F','M'), $formatstr);
// m/mm are used for both minutes and months - oh SNAP!
// This mess tries to fix for that.
// 'm' == minutes only if following h/hh or preceding s/ss
$formatstr = preg_replace("/(h:?)mm?/","$1i", $formatstr);
$formatstr = preg_replace("/mm?(:?s)/","i$1", $formatstr);
// A single 'm' = n in PHP
$formatstr = preg_replace("/(^|[^m])m([^m]|$)/", '$1n$2', $formatstr);
$formatstr = preg_replace("/(^|[^m])m([^m]|$)/", '$1n$2', $formatstr);
// else it's months
$formatstr = str_replace('mm', 'm', $formatstr);
// Convert single 'd' to 'j'
$formatstr = preg_replace("/(^|[^d])d([^d]|$)/", '$1j$2', $formatstr);
$formatstr = str_replace(array('dddd','ddd','dd','yyyy','yy','hh','h'), array('l','D','d','Y','y','H','g'), $formatstr);
$formatstr = preg_replace("/ss?/", 's', $formatstr);
}
}
}
if ($isdate){
$xf['type'] = 'date';
$xf['format'] = $formatstr;
if ($align=='') { $xf['align'] = 'right'; }
}else{
// If the format string has a 0 or # in it, we'll assume it's a number
if (preg_match("/[0#]/", $formatstr)) {
$xf['type'] = 'number';
if ($align=='') { $xf['align']='right'; }
}
else {
$xf['type'] = 'other';
}
$xf['format'] = $formatstr;
$xf['code'] = $indexCode;
}
}
$this->xfRecords[] = $xf;
break;
case SPREADSHEET_EXCEL_READER_TYPE_NINETEENFOUR:
$this->nineteenFour = (ord($data[$pos+4]) == 1);
break;
case SPREADSHEET_EXCEL_READER_TYPE_BOUNDSHEET:
$rec_offset = $this->_GetInt4d($data, $pos+4);
$rec_typeFlag = ord($data[$pos+8]);
$rec_visibilityFlag = ord($data[$pos+9]);
$rec_length = ord($data[$pos+10]);
if ($version == SPREADSHEET_EXCEL_READER_BIFF8){
$chartype = ord($data[$pos+11]);
if ($chartype == 0){
$rec_name = substr($data, $pos+12, $rec_length);
} else {
$rec_name = $this->_encodeUTF16(substr($data, $pos+12, $rec_length*2));
}
}elseif ($version == SPREADSHEET_EXCEL_READER_BIFF7){
$rec_name = substr($data, $pos+11, $rec_length);
}
$this->boundsheets[] = array('name'=>$rec_name,'offset'=>$rec_offset);
break;
}
$pos += $length + 4;
$code = ord($data[$pos]) | ord($data[$pos+1])<<8;
$length = ord($data[$pos+2]) | ord($data[$pos+3])<<8;
}
foreach ($this->boundsheets as $key=>$val){
$this->sn = $key;
$this->_parsesheet($val['offset']);
}
return true;
}
/**
* Parse a worksheet
*/
function _parsesheet($spos) {
$cont = true;
$data = $this->data;
// read BOF
$code = ord($data[$spos]) | ord($data[$spos+1])<<8;
$length = ord($data[$spos+2]) | ord($data[$spos+3])<<8;
$version = ord($data[$spos + 4]) | ord($data[$spos + 5])<<8;
$substreamType = ord($data[$spos + 6]) | ord($data[$spos + 7])<<8;
if (($version != SPREADSHEET_EXCEL_READER_BIFF8) && ($version != SPREADSHEET_EXCEL_READER_BIFF7)) {
return -1;
}
if ($substreamType != SPREADSHEET_EXCEL_READER_WORKSHEET){
return -2;
}
$spos += $length + 4;
while($cont) {
$lowcode = ord($data[$spos]);
if ($lowcode == SPREADSHEET_EXCEL_READER_TYPE_EOF) break;
$code = $lowcode | ord($data[$spos+1])<<8;
$length = ord($data[$spos+2]) | ord($data[$spos+3])<<8;
$spos += 4;
$this->sheets[$this->sn]['maxrow'] = $this->_rowoffset - 1;
$this->sheets[$this->sn]['maxcol'] = $this->_coloffset - 1;
unset($this->rectype);
switch ($code) {
case SPREADSHEET_EXCEL_READER_TYPE_DIMENSION:
if (!isset($this->numRows)) {
if (($length == 10) || ($version == SPREADSHEET_EXCEL_READER_BIFF7)){
$this->sheets[$this->sn]['numRows'] = ord($data[$spos+2]) | ord($data[$spos+3]) << 8;
$this->sheets[$this->sn]['numCols'] = ord($data[$spos+6]) | ord($data[$spos+7]) << 8;
} else {
$this->sheets[$this->sn]['numRows'] = ord($data[$spos+4]) | ord($data[$spos+5]) << 8;
$this->sheets[$this->sn]['numCols'] = ord($data[$spos+10]) | ord($data[$spos+11]) << 8;
}
}
break;
case SPREADSHEET_EXCEL_READER_TYPE_MERGEDCELLS:
$cellRanges = ord($data[$spos]) | ord($data[$spos+1])<<8;
for ($i = 0; $i < $cellRanges; $i++) {
$fr = ord($data[$spos + 8*$i + 2]) | ord($data[$spos + 8*$i + 3])<<8;
$lr = ord($data[$spos + 8*$i + 4]) | ord($data[$spos + 8*$i + 5])<<8;
$fc = ord($data[$spos + 8*$i + 6]) | ord($data[$spos + 8*$i + 7])<<8;
$lc = ord($data[$spos + 8*$i + 8]) | ord($data[$spos + 8*$i + 9])<<8;
if ($lr - $fr > 0) {
$this->sheets[$this->sn]['cellsInfo'][$fr+1][$fc+1]['rowspan'] = $lr - $fr + 1;
}
if ($lc - $fc > 0) {
$this->sheets[$this->sn]['cellsInfo'][$fr+1][$fc+1]['colspan'] = $lc - $fc + 1;
}
}
break;
case SPREADSHEET_EXCEL_READER_TYPE_RK:
case SPREADSHEET_EXCEL_READER_TYPE_RK2:
$row = ord($data[$spos]) | ord($data[$spos+1])<<8;
$column = ord($data[$spos+2]) | ord($data[$spos+3])<<8;
$rknum = $this->_GetInt4d($data, $spos + 6);
$numValue = $this->_GetIEEE754($rknum);
$info = $this->_getCellDetails($spos,$numValue,$column);
$this->addcell($row, $column, $info['string'],$info);
break;
case SPREADSHEET_EXCEL_READER_TYPE_LABELSST:
$row = ord($data[$spos]) | ord($data[$spos+1])<<8;
$column = ord($data[$spos+2]) | ord($data[$spos+3])<<8;
$xfindex = ord($data[$spos+4]) | ord($data[$spos+5])<<8;
$index = $this->_GetInt4d($data, $spos + 6);
$this->addcell($row, $column, $this->sst[$index], array('xfIndex'=>$xfindex) );
break;
case SPREADSHEET_EXCEL_READER_TYPE_MULRK:
$row = ord($data[$spos]) | ord($data[$spos+1])<<8;
$colFirst = ord($data[$spos+2]) | ord($data[$spos+3])<<8;
$colLast = ord($data[$spos + $length - 2]) | ord($data[$spos + $length - 1])<<8;
$columns = $colLast - $colFirst + 1;
$tmppos = $spos+4;
for ($i = 0; $i < $columns; $i++) {
$numValue = $this->_GetIEEE754($this->_GetInt4d($data, $tmppos + 2));
$info = $this->_getCellDetails($tmppos-4,$numValue,$colFirst + $i + 1);
$tmppos += 6;
$this->addcell($row, $colFirst + $i, $info['string'], $info);
}
break;
case SPREADSHEET_EXCEL_READER_TYPE_NUMBER:
$row = ord($data[$spos]) | ord($data[$spos+1])<<8;
$column = ord($data[$spos+2]) | ord($data[$spos+3])<<8;
$tmp = unpack("ddouble", substr($data, $spos + 6, 8)); // It machine machine dependent
if ($this->isDate($spos)) {
$numValue = $tmp['double'];
}
else {
$numValue = $this->createNumber($spos);
}
$info = $this->_getCellDetails($spos,$numValue,$column);
$this->addcell($row, $column, $info['string'], $info);
break;
case SPREADSHEET_EXCEL_READER_TYPE_FORMULA:
case SPREADSHEET_EXCEL_READER_TYPE_FORMULA2:
$row = ord($data[$spos]) | ord($data[$spos+1])<<8;
$column = ord($data[$spos+2]) | ord($data[$spos+3])<<8;
if ((ord($data[$spos+6])==0) && (ord($data[$spos+12])==255) && (ord($data[$spos+13])==255)) {
//String formula. Result follows in a STRING record
// This row/col are stored to be referenced in that record
// http://code.google.com/p/php-excel-reader/issues/detail?id=4
$previousRow = $row;
$previousCol = $column;
} elseif ((ord($data[$spos+6])==1) && (ord($data[$spos+12])==255) && (ord($data[$spos+13])==255)) {
//Boolean formula. Result is in +2; 0=false,1=true
// http://code.google.com/p/php-excel-reader/issues/detail?id=4
if (ord($this->data[$spos+8])==1) {
$this->addcell($row, $column, "TRUE");
} else {
$this->addcell($row, $column, "FALSE");
}
} elseif ((ord($data[$spos+6])==2) && (ord($data[$spos+12])==255) && (ord($data[$spos+13])==255)) {
//Error formula. Error code is in +2;
} elseif ((ord($data[$spos+6])==3) && (ord($data[$spos+12])==255) && (ord($data[$spos+13])==255)) {
//Formula result is a null string.
$this->addcell($row, $column, '');
} else {
// result is a number, so first 14 bytes are just like a _NUMBER record
$tmp = unpack("ddouble", substr($data, $spos + 6, 8)); // It machine machine dependent
if ($this->isDate($spos)) {
$numValue = $tmp['double'];
}
else {
$numValue = $this->createNumber($spos);
}
$info = $this->_getCellDetails($spos,$numValue,$column);
$this->addcell($row, $column, $info['string'], $info);
}
break;
case SPREADSHEET_EXCEL_READER_TYPE_BOOLERR:
$row = ord($data[$spos]) | ord($data[$spos+1])<<8;
$column = ord($data[$spos+2]) | ord($data[$spos+3])<<8;
$string = ord($data[$spos+6]);
$this->addcell($row, $column, $string);
break;
case SPREADSHEET_EXCEL_READER_TYPE_STRING:
// http://code.google.com/p/php-excel-reader/issues/detail?id=4
if ($version == SPREADSHEET_EXCEL_READER_BIFF8){
// Unicode 16 string, like an SST record
$xpos = $spos;
$numChars =ord($data[$xpos]) | (ord($data[$xpos+1]) << 8);
$xpos += 2;
$optionFlags =ord($data[$xpos]);
$xpos++;
$asciiEncoding = (($optionFlags &0x01) == 0) ;
$extendedString = (($optionFlags & 0x04) != 0);
// See if string contains formatting information
$richString = (($optionFlags & 0x08) != 0);
if ($richString) {
// Read in the crun
$formattingRuns =ord($data[$xpos]) | (ord($data[$xpos+1]) << 8);
$xpos += 2;
}
if ($extendedString) {
// Read in cchExtRst
$extendedRunLength =$this->_GetInt4d($this->data, $xpos);
$xpos += 4;
}
$len = ($asciiEncoding)?$numChars : $numChars*2;
$retstr =substr($data, $xpos, $len);
$xpos += $len;
$retstr = ($asciiEncoding)? $retstr : $this->_encodeUTF16($retstr);
}
elseif ($version == SPREADSHEET_EXCEL_READER_BIFF7){
// Simple byte string
$xpos = $spos;
$numChars =ord($data[$xpos]) | (ord($data[$xpos+1]) << 8);
$xpos += 2;
$retstr =substr($data, $xpos, $numChars);
}
$this->addcell($previousRow, $previousCol, $retstr);
break;
case SPREADSHEET_EXCEL_READER_TYPE_ROW:
$row = ord($data[$spos]) | ord($data[$spos+1])<<8;
$rowInfo = ord($data[$spos + 6]) | ((ord($data[$spos+7]) << 8) & 0x7FFF);
if (($rowInfo & 0x8000) > 0) {
$rowHeight = -1;
} else {
$rowHeight = $rowInfo & 0x7FFF;
}
$rowHidden = (ord($data[$spos + 12]) & 0x20) >> 5;
$this->rowInfo[$this->sn][$row+1] = Array('height' => $rowHeight / 20, 'hidden'=>$rowHidden );
break;
case SPREADSHEET_EXCEL_READER_TYPE_DBCELL:
break;
case SPREADSHEET_EXCEL_READER_TYPE_MULBLANK:
$row = ord($data[$spos]) | ord($data[$spos+1])<<8;
$column = ord($data[$spos+2]) | ord($data[$spos+3])<<8;
$cols = ($length / 2) - 3;
for ($c = 0; $c < $cols; $c++) {
$xfindex = ord($data[$spos + 4 + ($c* 2)]) | ord($data[$spos + 5 + ($c* 2)])<<8;
$this->addcell($row, $column + $c, "", array('xfIndex'=>$xfindex));
}
break;
case SPREADSHEET_EXCEL_READER_TYPE_LABEL:
$row = ord($data[$spos]) | ord($data[$spos+1])<<8;
$column = ord($data[$spos+2]) | ord($data[$spos+3])<<8;
$this->addcell($row, $column, substr($data, $spos + 8, ord($data[$spos + 6]) | ord($data[$spos + 7])<<8));
break;
case SPREADSHEET_EXCEL_READER_TYPE_EOF:
$cont = false;
break;
case SPREADSHEET_EXCEL_READER_TYPE_HYPER:
// Only handle hyperlinks to a URL
$row = ord($this->data[$spos]) | ord($this->data[$spos+1])<<8;
$row2 = ord($this->data[$spos+2]) | ord($this->data[$spos+3])<<8;
$column = ord($this->data[$spos+4]) | ord($this->data[$spos+5])<<8;
$column2 = ord($this->data[$spos+6]) | ord($this->data[$spos+7])<<8;
$linkdata = Array();
$flags = ord($this->data[$spos + 28]);
$udesc = "";
$ulink = "";
$uloc = 32;
$linkdata['flags'] = $flags;
if (($flags & 1) > 0 ) { // is a type we understand
// is there a description ?
if (($flags & 0x14) == 0x14 ) { // has a description
$uloc += 4;
$descLen = ord($this->data[$spos + 32]) | ord($this->data[$spos + 33]) << 8;
$udesc = substr($this->data, $spos + $uloc, $descLen* 2);
$uloc += 2* $descLen;
}
$ulink = $this->read16bitstring($this->data, $spos + $uloc + 20);
if ($udesc == "") {
$udesc = $ulink;
}
}
$linkdata['desc'] = $udesc;
$linkdata['link'] = $this->_encodeUTF16($ulink);
for ($r=$row; $r<=$row2; $r++) {
for ($c=$column; $c<=$column2; $c++) {
$this->sheets[$this->sn]['cellsInfo'][$r+1][$c+1]['hyperlink'] = $linkdata;
}
}
break;
case SPREADSHEET_EXCEL_READER_TYPE_DEFCOLWIDTH:
$this->defaultColWidth = ord($data[$spos+4]) | ord($data[$spos+5]) << 8;
break;
case SPREADSHEET_EXCEL_READER_TYPE_STANDARDWIDTH:
$this->standardColWidth = ord($data[$spos+4]) | ord($data[$spos+5]) << 8;
break;
case SPREADSHEET_EXCEL_READER_TYPE_COLINFO:
$colfrom = ord($data[$spos+0]) | ord($data[$spos+1]) << 8;
$colto = ord($data[$spos+2]) | ord($data[$spos+3]) << 8;
$cw = ord($data[$spos+4]) | ord($data[$spos+5]) << 8;
$cxf = ord($data[$spos+6]) | ord($data[$spos+7]) << 8;
$co = ord($data[$spos+8]);
for ($coli = $colfrom; $coli <= $colto; $coli++) {
$this->colInfo[$this->sn][$coli+1] = Array('width' => $cw, 'xf' => $cxf, 'hidden' => ($co & 0x01), 'collapsed' => ($co & 0x1000) >> 12);
}
break;
default:
break;
}
$spos += $length;
}
if (!isset($this->sheets[$this->sn]['numRows']))
$this->sheets[$this->sn]['numRows'] = $this->sheets[$this->sn]['maxrow'];
if (!isset($this->sheets[$this->sn]['numCols']))
$this->sheets[$this->sn]['numCols'] = $this->sheets[$this->sn]['maxcol'];
}
function isDate($spos) {
$xfindex = ord($this->data[$spos+4]) | ord($this->data[$spos+5]) << 8;
return ($this->xfRecords[$xfindex]['type'] == 'date');
}
// Get the details for a particular cell
function _getCellDetails($spos,$numValue,$column) {
$xfindex = ord($this->data[$spos+4]) | ord($this->data[$spos+5]) << 8;
$xfrecord = $this->xfRecords[$xfindex];
$type = $xfrecord['type'];
$format = $xfrecord['format'];
$formatIndex = $xfrecord['formatIndex'];
$fontIndex = $xfrecord['fontIndex'];
$formatColor = "";
$rectype = '';
$string = '';
$raw = '';
if (isset($this->_columnsFormat[$column + 1])){
$format = $this->_columnsFormat[$column + 1];
}
if ($type == 'date') {
// See http://groups.google.com/group/php-excel-reader-discuss/browse_frm/thread/9c3f9790d12d8e10/f2045c2369ac79de
$rectype = 'date';
// Convert numeric value into a date
$utcDays = floor($numValue - ($this->nineteenFour ? SPREADSHEET_EXCEL_READER_UTCOFFSETDAYS1904 : SPREADSHEET_EXCEL_READER_UTCOFFSETDAYS));
$utcValue = ($utcDays)* SPREADSHEET_EXCEL_READER_MSINADAY;
$dateinfo = gmgetdate($utcValue);
$raw = $numValue;
$fractionalDay = $numValue - floor($numValue) + .0000001; // The .0000001 is to fix for php/excel fractional diffs
$totalseconds = floor(SPREADSHEET_EXCEL_READER_MSINADAY* $fractionalDay);
$secs = $totalseconds % 60;
$totalseconds -= $secs;
$hours = floor($totalseconds / (60* 60));
$mins = floor($totalseconds / 60) % 60;
$string = date ($format, mktime($hours, $mins, $secs, $dateinfo["mon"], $dateinfo["mday"], $dateinfo["year"]));
} else if ($type == 'number') {
$rectype = 'number';
$formatted = $this->_format_value($format, $numValue, $formatIndex);
$string = $formatted['string'];
$formatColor = $formatted['formatColor'];
$raw = $numValue;
} else{
if ($format=="") {
$format = $this->_defaultFormat;
}
$rectype = 'unknown';
$formatted = $this->_format_value($format, $numValue, $formatIndex);
$string = $formatted['string'];
$formatColor = $formatted['formatColor'];
$raw = $numValue;
}
return array(
'string'=>$string,
'raw'=>$raw,
'rectype'=>$rectype,
'format'=>$format,
'formatIndex'=>$formatIndex,
'fontIndex'=>$fontIndex,
'formatColor'=>$formatColor,
'xfIndex'=>$xfindex
);
}
function createNumber($spos) {
$rknumhigh = $this->_GetInt4d($this->data, $spos + 10);
$rknumlow = $this->_GetInt4d($this->data, $spos + 6);
$sign = ($rknumhigh & 0x80000000) >> 31;
$exp = ($rknumhigh & 0x7ff00000) >> 20;
$mantissa = (0x100000 | ($rknumhigh & 0x000fffff));
$mantissalow1 = ($rknumlow & 0x80000000) >> 31;
$mantissalow2 = ($rknumlow & 0x7fffffff);
$value = $mantissa / pow( 2 , (20- ($exp - 1023)));
if ($mantissalow1 != 0) $value += 1 / pow (2 , (21 - ($exp - 1023)));
$value += $mantissalow2 / pow (2 , (52 - ($exp - 1023)));
if ($sign) {$value = -1* $value;}
return $value;
}
function addcell($row, $col, $string, $info=null) {
$this->sheets[$this->sn]['maxrow'] = max($this->sheets[$this->sn]['maxrow'], $row + $this->_rowoffset);
$this->sheets[$this->sn]['maxcol'] = max($this->sheets[$this->sn]['maxcol'], $col + $this->_coloffset);
$this->sheets[$this->sn]['cells'][$row + $this->_rowoffset][$col + $this->_coloffset] = $string;
if ($this->store_extended_info && $info) {
foreach ($info as $key=>$val) {
$this->sheets[$this->sn]['cellsInfo'][$row + $this->_rowoffset][$col + $this->_coloffset][$key] = $val;
}
}
}
function _GetIEEE754($rknum) {
if (($rknum & 0x02) != 0) {
$value = $rknum >> 2;
} else {
//mmp
// I got my info on IEEE754 encoding from
// http://research.microsoft.com/~hollasch/cgindex/coding/ieeefloat.html
// The RK format calls for using only the most significant 30 bits of the
// 64 bit floating point value. The other 34 bits are assumed to be 0
// So, we use the upper 30 bits of $rknum as follows...
$sign = ($rknum & 0x80000000) >> 31;
$exp = ($rknum & 0x7ff00000) >> 20;
$mantissa = (0x100000 | ($rknum & 0x000ffffc));
$value = $mantissa / pow( 2 , (20- ($exp - 1023)));
if ($sign) {
$value = -1* $value;
}
//end of changes by mmp
}
if (($rknum & 0x01) != 0) {
$value /= 100;
}
return $value;
}
function _encodeUTF16($string) {
$result = $string;
if ($this->_defaultEncoding){
switch ($this->_encoderFunction){
case 'iconv' : $result = @iconv('UTF-16LE', $this->_defaultEncoding, $string);
break;
case 'mb_convert_encoding' : $result = @mb_convert_encoding($string, $this->_defaultEncoding, 'UTF-16LE' );
break;
}
}
return $result;
}
function _GetInt4d($data, $pos) {
$value = ord($data[$pos]) | (ord($data[$pos+1]) << 8) | (ord($data[$pos+2]) << 16) | (ord($data[$pos+3]) << 24);
if ($value>=4294967294) {
$value=-2;
}
return $value;
}
}
?>
PK >\oV!k !k helpers/file/import/xml.phpnu W+A _getXmlFields() == true) {
$jinput = JFactory::getApplication()->input;
$jinput->set('columnheaders', $this->_xml_fields);
return true;
}
else {
/**
* Note: clearing the value when no fields found causes a problem when processing
* XML files with the 'use headers' option set because the function is called after the
* end of file has been reached. When an empty set of fields is returned, the program
* fails to terminate properly and loops endlessly through the import continuation page.
*/
return false;
}
}
/**
* Get the file position
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param
* @return int current position in the file
* @since 3.0
*/
public function getFilePos() {
return $this->linepointer;
}
/**
* Set the file position
*
* To be able to set the file position correctly, the XML reader needs to be at the start of the file
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param int $pos the position to move to
* @return int current position in the file
* @since 3.0
*/
public function setFilePos($pos) {
// Close the XML reader
$this->closeFile(false);
// Open a new XML reader
$this->processFile();
// Move the pointer to the specified position
return $this->_skipXmlRecords($pos);
}
/**
* Close the file
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param
* @return
* @since 3.0
*/
public function closeFile($removefolder=true) {
$this->data->close();
$this->_xml_cache = false;
$this->_closed = true;
parent::closeFile($removefolder);
}
/**
* Read the next line in the file
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param
* @return array with the line of data read | false if data cannot be read
* @since 3.0
*/
public function readNextLine() {
$jinput = JFactory::getApplication()->input;
$csvilog = $jinput->get('csvilog', null, null);
$csvilog->addDebug('Reading next line');
if ($this->_getXmlData() == true) {
$this->linepointer++;
return $this->_xml_data;
}
else {
return false;
}
}
/**
* Process the file to import
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param
* @return
* @since 3.0
*/
public function processFile() {
$jinput = JFactory::getApplication()->input;
$csvilog = $jinput->get('csvilog', null, null);
// Use a streaming approach to support large files
$this->data = new XMLReader();
$this->fp = $this->data->open($this->filename);
if ($this->fp == false) {
$csvilog->AddStats('incorrect', JText::_('COM_CSVI_ERROR_XML_READING_FILE'));
return false;
}
// File opened successfully - Prepare the arrays needed to read data from the XML file
$this->fp = $this->_getXmlSchema();
if ($this->fp == false) {
$this->closeFile();
$csvilog->AddStats('incorrect', JText::_('COM_CSVI_XML_INVALID_TABLE'));
return false;
}
return true;
}
/**
* Searches an XML file for a series of nodes representing a complete record. The name(s) of the nodes representing records
* must be supplied (via the 'xml_nodes_map' field) but the list of fields can be supplied in three ways:
* 1 No fields defined in the 'xml_nodes_map' field and the 'use headers' option set to 'off'. Despite the 'use headers' being set
* to 'off', the field nodes in the first record are used to configure the whole run. This requires that all fields be present in
* every record, the node names match the field names and that all of the 'field' nodes are one level below the 'record' node in
* the XML hierarchy.
* 2 No fields defined in the 'xml_nodes_map' field and the 'use headers' option set to 'on'. This causes the 'headers to be read
* from the XML nodes for every record. This is suitable if not all of the fields are populated for every record in the XML file
* but is slower than option 1.
* 3 Fields defined in the 'xml_nodes_map' field. The 'use headers' option is ignored. This gives the flexibility to set up a map
* so that an XML hierarchy can be modelled, node names to be mapped to field names and also allows fields to be extracted from
* node attributes.
*
* It is possible that the current node when the function is called is the start of the next record.
* Valid 'record' node names are held in the $this->_xml_records array.
* Valid 'field' node and attribute names are held in the $this->_xml_schema array.
* The arrays $this->_xml_data and $this->_xml_fields are populated with data and field names respectively. To prevent SQL errors
* when writing the data to the table, only fields found in the array $this->_supported_fields are included. This function could be
* extended.
*
* @copyright
* @author doorknob
* @todo
* @see
* @access private
* @param
* @return bool - indicates whether the array $this->_xml_data was populated.
* @since 3.0
*/
private function _getXmlFieldsAndData() {
$jinput = JFactory::getApplication()->input;
$csvilog = $jinput->get('csvilog', null, null);
// Initialise the arrays that will receive the data and field list from the next record
$this->_xml_data = array();
$this->_xml_fields = array();
// Validation checking disabled because a DTD (or RELAX NG) schema is required and is usually not available
$validate_xml = false;
if( $validate_xml == true ) {
// Note: When the DTD is external, this must be done before the first read()
$this->data->setParserProperty(XMLReader::VALIDATE, true);
}
/**
* Search for the start of the next record but only read the file if the next record is not already current
* Must be the correct element type (start of node) and in the list of valid record nodes.
* Note: Self closing notes are accepted because they may contain data in the attributes
*/
if (!$this->_isXmlRecordNode($this->data->nodeType, $this->data->name)) {
// Either no current node or the current node is not the start of a record
while( $this->data->read() ) {
if( $validate_xml == true ) {
$this->fp = $this->data->isValid();
if( $this->fp == false ){
$this->closeFile();
$csvilog->AddStats('incorrect', JText::_('COM_CSVI_XML_FILE_INVALID'));
return false;
}
}
if( $this->_isXmlRecordNode( $this->data->nodeType, $this->data->name ) ) {
// Record node found
break;
}
}
}
// Check whether a record was found
if ($this->_isXmlRecordNode($this->data->nodeType, $this->data->name)) {
// Start of a valid record
$self_closing = $this->data->isEmptyElement;
$record_name = strtolower($this->data->name);
// Extract any attributes, if defined
if (isset($this->_xml_schema[$record_name]['attrs']) ) {
// Record level attributes are defined as fields
while( $this->data->moveToNextAttribute() ) {
// Check each attribute to determine whether the value should be extracted
if( isset($this->_xml_schema[$record_name]['attrs'][strtolower($this->data->name)]) ) {
$this->_xml_fields[] = $this->_xml_schema[$record_name]['attrs'][strtolower($this->data->name)];
$this->_xml_data[] = $this->data->value;
}
}
}
if ($self_closing == false) {
// Now search for group/field nodes
$xml_path = array();
/**
* Note: $this->data->next() is used rather than $this->data->read() when the readInnerXML() function has been used
* to extract the contents of a node. Because the contect extracted may contain other nodes,$this->data->next() is
* used to skip to the closing node.
* readInnerXML() is used in case the data contains html tags but it doesn't move the file pointer.
* Subsequently using $this->data->next() forces the pointer to skip past any HTML tags that have already been read.
* The value does not need to be maintained between between calls to this function because readInnerXML() is
* never used immediately before exiting the function.
*/
$use_read = true;
while ($use_read == true ? $this->data->read() : $this->data->next() ) {
// XML error detection
if ($validate_xml == true) {
$this->fp = $this->data->isValid();
if( $this->fp == false ){
$this->closeFile();
$csvilog->AddStats('incorrect', JText::_('COM_CSVI_XML_FILE_INVALID'));
return false;
}
}
// Default to a reading a single node in the next loop
$use_read = true;
// Searching for a group or field node
if ($this->data->nodeType == XMLReader::ELEMENT) {
// New node found
$self_closing = $this->data->isEmptyElement;
if (empty($this->_xml_schema)) {
// Template fields being used to control the data extraction
if ($this->_isXmlFieldNameValid($this->data->name)) {
// Node corresponding to a supported field found - extract the data
$this->_xml_fields[] = strtolower($this->data->name);
$xmldata = $this->data->readInnerXML();
$xmldata = str_ireplace(array(''), '', $xmldata);
$this->_xml_data[] = $xmldata;
// At the next read, skip to the next node at this level
$use_read = false;
}
else {
// A node has been found that does not match the available fields list
$csvilog->addDebug(JText::sprintf('COM_CSVI_XML_NODE_NOT_MATCH_FIELD', $this->data->name));
}
}
else {
// The user defined map is being used to control the data extraction
$current_path = $this->_getXmlNodePath($xml_path, strtolower($this->data->name));
// The node may have attributes that map to fields, regardless of the type of node
if (isset($this->_xml_schema[$record_name]['nodes'][$current_path]['attrs'])) {
// Node has attributes that are defined as fields
while ($this->data->moveToNextAttribute()) {
// Check each attribute to determine whether the value should be extracted
if( isset($this->_xml_schema[$record_name]['nodes'][$current_path]['attrs'][strtolower($this->data->name)]) ) {
$this->_xml_fields[] = $this->_xml_schema[$record_name]['nodes'][$current_path]['attrs'][strtolower($this->data->name)];
$xmldata = $this->data->readInnerXML();
$xmldata = str_ireplace(array(''), '', $xmldata);
$this->_xml_data[] = $xmldata;
// At the next read, skip to the next node at this level
$use_read = false;
}
}
}
if (empty($this->_xml_schema[$record_name]['nodes'][$current_path]['field'])) {
// This node is not defined as a field
if (isset($this->_xml_schema[$record_name]['nodes'][$current_path]['field'])) {
// This is a 'group' node - add it to the path unless it is self closing
if( $self_closing == false ) {
$this->_pushXmlNodePath( $xml_path, $this->data->name );
}
}
else {
// Unknown node found - The file is not mapped correctly and the run cannot continue
$csvilog->addDebug(JText::sprintf('COM_CSVI_XML_UNMAPPED_NODE', $this->data->name));
$csvilog->AddStats('incorrect', JText::sprintf('COM_CSVI_XML_UNDEFINED_NODE', $this->data->name));
return false;
}
}
else {
// This node is defined as a field - extract the data
$this->_xml_fields[] = $this->_xml_schema[$record_name]['nodes'][$current_path]['field'];
$xmldata = $this->data->readInnerXML();
$xmldata = str_ireplace(array(''), '', $xmldata);
$this->_xml_data[] = $xmldata;
// At the next read, skip to the next node at this level
$use_read = false;
}
}
}
else if ($this->data->nodeType == XMLReader::END_ELEMENT) {
// Searching for the end of the record or the end of a group node
if( strtolower($this->data->name) == $record_name ) {
// End of record found
break;
} else {
// End of node - Only valid case is the end of a group node
if( !empty($this->_xml_schema) && !empty($xml_path) && $xml_path[count($xml_path)-1] == strtolower($this->data->name) ) {
// End of group node found - pop it from the stack
$this->_popXmlNodePath( $xml_path );
} else {
// Unknown end of node - error
$csvilog->addDebug(JText::sprintf('COM_CSVI_XML_UNEXPECTED_END_NODE', $this->data->name));
}
}
}
}
}
}
$this->_xml_cache = !empty($this->_xml_data);
return $this->_xml_cache;
}
/**
* Returns a boolean value to indicate whether the specified node is a new XML record type.
*
* @copyright
* @author doorknob
* @todo
* @see
* @access private
* @param
* @return bool true if record is a node | false if record is not a node
* @since 3.0
*/
private function _isXmlRecordNode( $node_type, $node_name ) {
return ($node_type == XMLReader::ELEMENT && in_array(strtolower($node_name), $this->_xml_records));
}
/**
* Returns the list of data values found in the most recently read XML record. If the getXmlFields() function has been
* called since the last call of this function, the cache may be full and the data can be returned without reading the file.
*
* @return array - The list of data values from the most recently read XML record (empty when end of file is reached)
*/
private function _getXmlData() {
$return = !empty($this->_xml_data);
if( $this->_xml_cache == false ) {
$return = $this->_getXmlFieldsAndData();
}
// Indicate that a new record will be required the next time this function is called
$this->_xml_cache = false;
return $return;
}
/**
* Returns the list of fields found in the most recently read XML record. If the cache is empty, the next record is
* read from the input file to ensure that the headers correspond with the data (in XML files, each record can have a
* different set of 'headers'). Checking the status of the cache indicator also prevents records being skipped if this
* function is called multiple times between records.
*
* @return array - The list of fields from the most recently read XML record (empty when end of file is reached)
*/
private function _getXmlFields() {
$return = !empty($this->_xml_fields);
if ($this->_xml_cache == false) {
$return = $this->_getXmlFieldsAndData();
}
return $return;
}
/**
* Skips through the XML file until the the required number 'record' nodes has been read
* Assume the file pointer is at the start of file
*
* @copyright
* @author doorknob, RolandD
* @todo
* @see
* @access private
* @param
* @return boolean true if records are skipped | false if records are not skipped
* @since 3.0
*/
private function _skipXmlRecords($pos) {
$jinput = JFactory::getApplication()->input;
$csvilog = $jinput->get('csvilog', null, null);
// Check whether the pointer needs to be moved
if ($pos <= 0) return true;
$count = 0;
/**
* Note: When the DTD is external, this must be done before the first read()
* Validation not used because invalid files generate php errors when validated
*/
$validate_xml = false;
if( $validate_xml == true ) {
$this->data->setParserProperty(XMLReader::VALIDATE, true);
}
while ($this->data->read()) {
// Validation checking disabled because a DTD (or RELAX NG) schema is required and is usually not available
if( $validate_xml == true ) {
$this->fp = $this->data->isValid();
if( $this->fp == false ){
$this->closeFile();
$csvilog->AddStats('incorrect', JText::_('COM_CSVI_XML_INVALID'));
return false;
}
}
// Searching for a valid record - must be the start of a node and in the list of valid record types
if( !$this->_isXmlRecordNode( $this->data->nodeType, $this->data->name ) ) {
// Not found - try again
continue;
}
else {
// Found a valid record
while( $this->_isXmlRecordNode( $this->data->nodeType, $this->data->name ) ) {
// Node is a valid record type - skip to the end of the record
$this->data->next();
$count++;
if( $count == $pos) {
return true;
}
}
}
}
// Hit EOF before skipping the required number of records
return false;
}
/**
* Build an array of xml nodes from the user defined map:
*
* $this->_xml_schema[record_node]['attrs'][attr_name] => field name
* $this->_xml_schema[record_node]['nodes'][field_node_path]['attrs'][attr_name] => field name
* $this->_xml_schema[record_node]['nodes'][field_node_path]['field'] => field name
* Note: field_node_path is a comma separated list of node names below the record node
*
* @return bool returns true if all fine else false
*/
private function _getXmlSchema() {
$jinput = JFactory::getApplication()->input;
$template = $jinput->get('template', null, null);
$xml_nodes_map = $template->get('xml_nodes_map', 'general', '', 'string', JREQUEST_ALLOWRAW);
$xml_node_path = array(); // Single copy of this array that is passed by reference only
$current_record = ''; // Single copy of this variable that is passed by reference only
return $this->_getXmlNode($xml_nodes_map, $current_record, $xml_node_path);
}
/**
* Process a node from the XML Map
* It is permitted for the XML to just define one or more tables without fields (when the 'use headers' option is used)
*
* Note: Calls itself recursively to process a tree
*
* @return bool returns true if all fine else false
*/
private function _getXmlNode($node_content, $current_record, $xml_path) {
$jinput = JFactory::getApplication()->input;
$csvilog = $jinput->get('csvilog', null, null);
$current_node = '';
$xml_schema = new XMLReader();
/**
* Add a wrapper to make the XML viable and ensure that self closing tags contain a space before the '/>'
* The XML may still be invalid but that's down to what the user entered
*/
$node_content = "\n".$node_content.'';
$xml_schema->XML($node_content);
// XML file to table map is valid XML - construct the arrays used in file extraction
$use_read = true;
// The XML could only be validated against a DTD if the syntax of the XML used for the map is made more complex
$validate_xml = false;
if ($validate_xml == true) {
// Note: When the DTD is external, the property value must be set before the first read()
$xml_schema->setParserProperty(XMLReader::VALIDATE, true);
}
while($use_read ? $xml_schema->read() : $xml_schema->next()) {
// Validation checking disabled because a DTD (or RELAX NG) schema is required.
if ($validate_xml == true) {
if( $xml_schema->isValid() == false ){
$xml_schema->close();
return false;
}
}
// Default to a reading a single node in the next loop
$use_read = true;
// Ignore any node associated with the root
if ($xml_schema->name == 'da_root' ) {
continue;
}
// Process start elements
if ($xml_schema->nodeType == XMLReader::ELEMENT) {
$self_closing = $xml_schema->isEmptyElement;
// Ready to add a new node - but only if the last node was closed
if (!empty($current_node)) {
$csvilog->AddStats('incorrect', JText::sprintf('COM_CSVI_XML_NODE_UNCLOSED', $current_node));
return false;
}
// A new node was found - Check whether this is a new record type
if (empty($current_record)) {
// New record type
// Check for a self-closing node
$self_closing = $xml_schema->isEmptyElement;
$current_record = strtolower($xml_schema->name);
$this->_xml_records[] = strtolower($current_record);
// Store any attributes
while ($xml_schema->moveToNextAttribute()) {
// Note1: $xml_schema->hasValue only indicates whether the element can have a value, not whether it does
// Note2: empty($xml_schema->value) always return true, regardless of the actual value
$value = $xml_schema->value;
if( !empty($value) ) {
if( $this->_isXmlFieldNameValid($xml_schema->value) ) {
$this->_xml_schema[$current_record]['attrs'][strtolower($xml_schema->name)] = trim($xml_schema->value);
}
else {
$csvilog->AddStats('incorrect', JText::sprintf('COM_CSVI_XML_FILE_MAP_NO_REFERENCE', $xml_schema->value));
$xml_schema->close();
return false;
}
}
}
// Check for a self-closing node
if( $self_closing == true ) {
$current_record = '';
}
}
else {
// New field type
$current_node = strtolower($xml_schema->name);
$current_path = $this->_getXmlNodePath($xml_path, $current_node);
// Store any attributes
while ($xml_schema->moveToNextAttribute()) {
// Note1: $xml_schema->hasValue only indicates whether the element can have a value, not whether it does
// Note2: empty($xml_schema->value) always return true, regardless of the actual value
$value = $xml_schema->value;
if( !empty($value) ) {
if( $this->_isXmlFieldNameValid( $xml_schema->value ) ) {
$this->_xml_schema[$current_record]['nodes'][$current_path]['attrs'][strtolower($xml_schema->name)] = trim($xml_schema->value);
}
else {
$csvilog->AddStats('incorrect', JText::_('COM_CSVI_XML_FILE_MAP_NO_REFERENCE', $xml_schema->value));
$xml_schema->close();
return false;
}
}
}
$sub_node_content = $xml_schema->readInnerXML();
// Check whether there are any lower level nodes
if (strstr($sub_node_content, '<') === false) {
/**
* Content has no embedded nodes - Assume a field name
* Note: An empty node gives a blank field name which indicates an unwanted node
* that is being mapped to prevent errors when processing the file
*/
if ($this->_isXmlFieldNameValid($sub_node_content)) {
$this->_xml_schema[$current_record]['nodes'][$current_path]['field'] = trim($sub_node_content);
}
else {
$this->_xml_schema[$current_record]['nodes'][$current_path]['field'] = '';
}
}
else {
// There are embedded nodes - go down another level
// Indicate a 'group' node by storing an empty field name
$this->_xml_schema[$current_record]['nodes'][$current_path]['field'] = '';
// Push the node name to the path stack
$this->_pushXmlNodePath($xml_path, $current_node);
if( $this->_getXmlNode($sub_node_content, $current_record, $xml_path) == false ) {
$xml_schema->close();
return false;
}
// At the next read, skip to the next node at this level
$use_read = false;
// Close the node
$current_node = '';
// Pop the last item off the path stack
$this->_popXmlNodePath($xml_path);
}
// Check for a self-closing node
if ($self_closing == true) {
$current_node = '';
}
}
}
// Process end elements
else if( $xml_schema->nodeType == XMLReader::END_ELEMENT ) {
// End of node found
// Check for end of record
if( !empty($current_record) && strtolower($xml_schema->name) == $current_record ) {
// End of record detected
$current_record = '';
} // Check that the expected node was closed
else if( !empty($current_node) && strtolower($xml_schema->name) == $current_node ) {
// End of current node detected
$current_node = '';
}
}
}
$xml_schema->close();
// Node not terminated
if (!empty($current_node) ) {
$csvilog->AddStats('incorrect', JText::sprintf('COM_CSVI_XML_NODE_NOT_CLOSED', $current_node));
return false;
}
if (empty($this->_xml_records) ) {
$csvilog->AddStats('incorrect', JText::_('COM_CSVI_XML_NO_RECORDS_DEFINED'));
return false;
}
return true;
}
/**
* Create a string to represent the XML node hierarchy from the 'record' node to a 'field' node
*
* @return string
*/
private function _getXmlNodePath($xml_path, $node_name) {
return implode(',', $xml_path).(empty($xml_path) ? '' : ',').$node_name;
}
/**
* Determines whether a specific field name is included in the list of
*
* @return boolean
*/
private function _isXmlFieldNameValid($field_name) {
return in_array(strtolower($field_name), $this->_supported_fields);
}
/**
* Add a new entry to the XML node stack
*/
private function _pushXmlNodePath($xml_path, $node_name) {
/**
* Note: The array index is made explicit because when a new row is added, the index value
* assigned is one greater than that previously assigned. When enries are being continuously
* added and removed, the automatically assigned index number becomes unpredictable
*/
$xml_path[count($xml_path)] = strtolower($node_name);
}
/**
* Remove the last entry from the XML node stack
*
* @copyright
* @author doorknob
* @todo
* @see
* @access private
* @param
* @return
* @since 3.0
*/
private function _popXmlNodePath($xml_path) {
if( count($xml_path) > 1 ) {
unset($xml_path[count($xml_path)-1]);
} else {
$xml_path = array();
}
}
/**
* Sets the file pointer back to beginning
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param
* @return
* @since 3.0
*/
public function rewind() {
$this->linepointer = 0;
}
/**
* Advances the file pointer 1 forward
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param bool $preview True if called from the preview
* @return
* @since 3.0
*/
public function next($preview=false) {
if (!$preview) $discard = $this->readNextLine();
}
}
?>
PK >\ helpers/file/import/index.htmlnu W+A PK >\FXʖ " helpers/file/import/ods_reader.phpnu W+A
*/
public function read($filename) {
$this->_file = $filename;
list($this->_xml_parser, $fp) = $this->new_xml_parser($this->_file);
if (!$this->_xml_parser) {
die("could not open XML input");
}
$data = '';
while (!feof($fp)) {
$data .= fread($fp, 4096);
}
fclose($fp);
if (!xml_parse($this->_xml_parser, $data, true)) {
die(sprintf("XML error: %s at line %d\n",
xml_error_string(xml_get_error_code($this->_xml_parser)),
xml_get_current_line_number($this->_xml_parser)));
}
xml_parser_free($this->_xml_parser);
$this->cols = count($this->_data[1]);
$this->rows = count($this->_data);
return true;
}
/**
* Handle the opening element
*/
private function startElement($parser, $tagname, $attribs) {
switch ($tagname) {
case 'TABLE:TABLE-ROW':
$this->_linecount++;
break;
case 'TABLE:TABLE-CELL':
$styles = array_keys($attribs);
if (empty($styles)) {
$this->_data[$this->_linecount]['options']['repeat'] = 1;
}
else {
foreach ($styles as $stylekey => $style) {
switch ($style) {
case 'TABLE:NUMBER-COLUMNS-REPEATED':
$this->_data[$this->_linecount]['options']['repeat'] = $attribs[$style];
break;
case 'OFFICE:VALUE-TYPE':
$this->_data[$this->_linecount]['options']['type'] = $attribs[$style];
break;
}
}
}
break;
case 'TEXT:P':
$this->_data[$this->_linecount];
break;
}
}
/**
* Handle the closing element
*/
private function endElement($parser, $name) {
if (array_key_exists($this->_linecount, $this->_data)) {
if (!array_key_exists('data', $this->_data[$this->_linecount])
&& array_key_exists('options', $this->_data[$this->_linecount])) {
foreach ($this->_data[$this->_linecount]['options'] as $option => $value) {
switch ($option) {
case 'type':
break;
case 'repeat':
for ($r=0; $r < $value; $r++) {
$this->_data[$this->_linecount][] = '';
}
break;
}
}
}
else unset($this->_data[$this->_linecount]['data']);
if (array_key_exists('options', $this->_data[$this->_linecount])) unset($this->_data[$this->_linecount]['options']);
}
}
/**
* Handle the data
*
* @todo parse
*/
private function characterData($parser, $data) {
foreach ($this->_data[$this->_linecount]['options'] as $option => $value) {
switch ($option) {
case 'type':
break;
case 'repeat':
for ($r=1; $r < $value; $r++) {
$this->_data[$this->_linecount][] = $data;
}
break;
}
}
$this->_data[$this->_linecount][] = $data;
unset($this->_data[$this->_linecount]['options']);
$this->_data[$this->_linecount]['data'] = true;
}
private function new_xml_parser($file) {
$this->_xml_parser = xml_parser_create("UTF-8");
xml_parser_set_option($this->_xml_parser, XML_OPTION_CASE_FOLDING, 1);
xml_set_object($this->_xml_parser, $this);
xml_set_element_handler($this->_xml_parser, "startElement", "endElement");
xml_set_character_data_handler($this->_xml_parser, "characterData");
$fp = fopen($file, "rb");
if (!$fp) return false;
else return array($this->_xml_parser, $fp);
}
}
?>
PK >\) helpers/file/import/.htaccessnu W+A
Order allow,deny
Deny from all
PK >\ helpers/file/index.htmlnu W+A PK >\ helpers/file/export/index.htmlnu W+A PK >\ # helpers/file/export/html/index.htmlnu W+A PK >\) " helpers/file/export/html/.htaccessnu W+A
Order allow,deny
Deny from all
PK >\F{E
( helpers/file/export/html/csvimproved.phpnu W+A contents = ''.chr(10);
$this->contents .= '
';
$topmenu = preg_replace("/(\s\s+)/", ' ', $topmenu);
?>
PK >\) helpers/.htaccessnu W+A
Order allow,deny
Deny from all
PK >\fU,
,
! helpers/com_virtuemart_config.phpnu W+A _vmcfgfile = JPATH_ADMINISTRATOR.'/components/com_virtuemart/virtuemart.cfg';
$this->_parse();
// Load the version information
if (file_exists(JPATH_ADMINISTRATOR.'/components/com_virtuemart/version.php')) {
require_once JPATH_ADMINISTRATOR.'/components/com_virtuemart/version.php';
$this->_vmcfg['release'] = vmVersion::$RELEASE;
}
else $this->_vncfg['release'] = null;
}
/**
* Finds a given VirtueMart setting
*
* @copyright
* @author RolandD
* @todo
* @see
* @access
* @param string $setting The config value to find
* @return mixed value if found | false if not found
* @since 4.0
*/
public function get($setting) {
if (isset($this->_vmcfg[$setting])) {
return $this->_vmcfg[$setting];
}
else return false;
}
/**
* Parse the VirtueMart configuration
*
* Here is a PHP 5.3 requirement and work-around
*
* @copyright
* @author RolandD
* @todo
* @see http://www.php.net/parse_ini_string
* @access private
* @param
* @return
* @since 4.0
*/
private function _parse() {
// Parse the configuration file
if (file_exists($this->_vmcfgfile)) {
$config = file_get_contents($this->_vmcfgfile);
// Do some cleanup
$config = str_replace('#', ';', $config);
// Check if the command is available
if (!function_exists('parse_ini_string') ) {
$array = array();
$lines = explode("\n", $config );
foreach( $lines as $line ) {
$statement = preg_match(
"/^(?!;)(?P[\w+\.\-]+?)\s*=\s*(?P.+?)\s*$/", $line, $match );
if( $statement) {
$key = $match[ 'key' ];
$value = $match[ 'value' ];
# Remove quote
if( preg_match( "/^\".*\"$/", $value ) || preg_match( "/^'.*'$/", $value ) ) {
$value = mb_substr( $value, 1, mb_strlen( $value ) - 2 );
}
$array[ $key ] = $value;
}
}
$this->_vmcfg = $array;
}
else $this->_vmcfg = parse_ini_string($config);
}
}
}PK >\D(5& & helpers/csvidb.phpnu W+A _database = JFactory::getDbo();
}
public function setQuery($sql, $offset = 0, $limit = 0) {
$this->_database->setQuery($sql, $offset, $limit);
if (!$this->cur = $this->_database->query()) {
$this->_error = $this->_database->getErrorMsg();
}
}
public function getRow() {
if (!is_object($this->cur)) $array = mysql_fetch_object($this->cur);
else $array = $this->cur->fetch_object();
if ($array) {
return $array;
}
else {
if (!is_object($this->cur)) mysql_free_result( $this->cur );
else $this->cur->free_result();
return false;
}
}
public function getErrorMsg() {
return $this->_error;
}
public function getNumRows() {
return $this->_database->getNumRows($this->cur);
}
public function getQuery() {
return $this->_database->getQuery();
}
}PK >\0* * helpers/template.phpnu W+A _settings = $data;
}
}
/**
* Find a value in the template
*
* @copyright
* @author RolandD
* @todo JRequest::_cleanVar
* @see JFilterInput
* @access public
* @param string $name the name of the parameter to find
* @param string $group the group in which to find the parameter
* @param string $default the default value to use when not found
* @param string $filter the filter to apply
* @param int $mask Filter bit mask. 1=no trim: If this flag is cleared and the
* input is a string, the string will have leading and trailing whitespace
* trimmed. 2=allow_raw: If set, no more filtering is performed, higher bits
* are ignored. 4=allow_html: HTML is allowed, but passed through a safe
* HTML filter first. If set, no more filtering is performed. If no bits
* other than the 1 bit is set, a strict filter is applied.
* @param bool $special if the field should require special processing
* @return mixed the value found
* @since 3.0
*/
public function get($name, $group='', $default = '', $filter=null, $mask=0, $special=true) {
// Set the initial value
$value = '';
// Find the value
if (empty($group)) {
if (array_key_exists($name, $this->_settings)) $value = $this->_settings[$name];
}
else {
if (array_key_exists($group, $this->_settings)) {
if (array_key_exists($name, $this->_settings[$group])) {
$value = $this->_settings[$group][$name];
}
}
}
// Return the found value
if (is_array($value) && empty($value)) $value = $default;
else if ('' === $value) $value = $default;
// Special processing
if ($special) {
switch ($name) {
case 'language':
case 'target_language':
$value = strtolower(str_replace('-', '_', $value));
break;
case 'field_delimiter':
if (strtolower($value) == 't') $value = "\t";
break;
}
}
// Clean up and return
if (is_null($filter) && $mask == 0) return $value;
else return JRequest::_cleanVar($value, $mask, $filter);
}
/**
* Set a value in the template
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param string $name the name of the parameter to find
* @param string $group the group in which to find the parameter
* @param string $value the value to set
* @return void
* @since 3.0
*/
public function set($name, $group='', $value = '') {
// Set the value
if (empty($group)) {
$this->_settings[$name] = $value;
}
else {
$this->_settings[$group][$name] = $value;
}
}
/**
* Load a template
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param int $id the ID of the template to load
* @return
* @since 4.0
*/
public function load($id) {
if ($id > 0) {
// Load the data
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select($db->quoteName('settings').', '.$db->quoteName('name'));
$query->from($db->quoteName('#__csvi_template_settings'));
$query->where($db->quoteName('id').' = '.$db->quote($id));
$db->setQuery($query);
$data = $db->loadObject();
// Fill the settings
$settings = json_decode($data->settings, true);
if (!is_array($settings)) $settings = array();
$this->_settings = $settings;
// Set the name
if (!empty($data)) $this->setName($data->name);
}
}
/**
* Set the template name
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param string $name the name of the template
* @return
* @since 4.0
*/
public function setName($name) {
// Set the template name
$this->_name = $name;
}
/**
* Get the name of the template
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param
* @return
* @since 4.0
*/
public function getName() {
return $this->_name;
}
/**
* Return all settings
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param
* @return
* @since 4.0
*/
public function getSettings() {
return $this->_settings;
}
}
?>
PK >\ helpers/com_akeebasubs.phpnu W+A input;
$this->_csvidata = $jinput->get('csvi_data', null, null);
}
/**
* Get a user ID
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param string $username the username to find the ID for
* @return int the ID of the user
* @since 4.0
*/
public function getUser($username) {
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select($db->quoteName('id'));
$query->from($db->quoteName('#__users'));
$query->where($db->quoteName('username').' = '.$db->quote($username));
$db->setQuery($query);
return $db->loadResult();
}
/**
* Get a subscription ID
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param string $subscription_title the name(s) of the subscription
* @return
* @since 4.0
*/
public function getSubscription($subscription_title) {
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select($db->quoteName('akeebasubs_level_id'));
$query->from($db->quoteName('#__akeebasubs_levels'));
$titles = explode(',', $subscription_title);
$newtitles = array();
foreach ($titles as $title) {
$newtitles[] = $db->quote(trim($title));
}
if (!empty($newtitles)) {
$query->where($db->quoteName('title').' IN ('.implode(',', $newtitles).')');
$db->setQuery($query);
$ids = $db->loadColumn();
if (!empty($ids)) {
return implode(',', $ids);
}
}
else return '';
}
/**
* Get the list of order users
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param
* @return array of objects
* @since 4.0
*/
public function getOrderUser() {
$jinput = JFactory::getApplication()->input;
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$filter = $jinput->get('filter');
$query->select($db->quoteName('user_id'));
$query->select($db->quoteName('name', 'user_name'));
$query->from($db->quoteName('#__akeebasubs_subscriptions', 's'));
$query->leftJoin($db->quoteName('#__users', 'u').' ON '.$db->quoteName('s').'.'.$db->quoteName('user_id').' = '.$db->quoteName('u').'.'.$db->quoteName('id'));
$query->where($db->quoteName('u').'.'.$db->quoteName('name').' LIKE '.$db->quote('%'.$filter.'%'));
$query->order($db->quoteName('name'));
$query->group($db->quoteName('user_id'));
$db->setQuery($query, 0, 10);
$users = $db->loadObjectList();
if ($users) return $users;
else return array();
}
/**
* Get the list of order products
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param
* @return array of objects
* @since 4.0
*/
public function getOrderProduct() {
$jinput = JFactory::getApplication()->input;
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$filter = $jinput->get('filter');
$query->select($db->quoteName('s').'.'.$db->quoteName('akeebasubs_level_id', 'product_sku'));
$query->select($db->quoteName('title', 'product_name'));
$query->from($db->quoteName('#__akeebasubs_subscriptions', 's'));
$query->leftJoin($db->quoteName('#__akeebasubs_levels', 'l').' ON '.$db->quoteName('s').'.'.$db->quoteName('akeebasubs_level_id').' = '.$db->quoteName('l').'.'.$db->quoteName('akeebasubs_level_id'));
$query->where($db->quoteName('l').'.'.$db->quoteName('title').' LIKE '.$db->quote('%'.$filter.'%'));
$query->order($db->quoteName('title'));
$query->group($db->quoteName('s').'.'.$db->quoteName('akeebasubs_level_id'));
$db->setQuery($query, 0, 10);
$products = $db->loadObjectList();
if ($products) return $products;
else return array();
}
}
?>PK >\-, -, helpers/cron.phpnu W+A initialise();
// Load the language file
$language = JFactory::getLanguage();
$language->load('com_csvi', JPATH_BASE.'/administrator');
// Load the plugin system
JPluginHelper::importPlugin('system');
// trigger the onAfterInitialise events
$mainframe->triggerEvent('onAfterInitialise');
// Run the cron job
$csvicron->runCron();
/**
* Handles all cron requests
*
* @package CSVI
*/
class CsviCron {
/** @var $basepath string the base of the installation */
var $basepath = '';
/** @var $_variables array of user set variables to override template settins */
var $_variables = '';
/**
* Initialise the cron
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param
* @return
* @since 3.5
*/
public function __construct() {
// Merge the default translation with the current translation
$jlang = JFactory::getLanguage();
$jlang->load('com_csvi', JPATH_ADMINISTRATOR, 'en-GB', true);
$jlang->load('com_csvi', JPATH_ADMINISTRATOR, $jlang->getDefault(), true);
$jlang->load('com_csvi', JPATH_ADMINISTRATOR, null, true);
// Get the domain name
require_once(JPATH_COMPONENT_ADMINISTRATOR.'/helpers/settings.php');
$settings = new CsviSettings();
$domainname = $settings->get('site.hostname', 'www.example.com');
// Check for the trailing slash at the domain name
if (substr($domainname, -1) == '/') $domainname = substr($domainname, 0, -1);
// Load the posted variables
$this->CollectVariables();
// Fill the server global with necessary information
$_SERVER['REQUEST_METHOD'] = 'post';
$_SERVER['HTTP_HOST'] = $domainname;
$_SERVER['REMOTE_ADDR'] = gethostbyname('localhost');
$_SERVER['SERVER_PORT'] = '';
$_SERVER['HTTP_USER_AGENT'] = 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:2.0) Gecko/20100101 Firefox/4.0';
$_SERVER['REQUEST_URI'] = '/administrator/index.php';
$_SERVER['QUERY_STRING'] = '';
$_SERVER['PHP_SELF'] = '/index.php';
$_SERVER['SCRIPT_NAME'] = '/index.php';
if (isset($this->_variables['adminpw'])) {
$_SERVER['QUERY_STRING'] = $this->_variables['adminpw'];
$_SERVER['REQUEST_URI'] .= '?'.$this->_variables['adminpw'];
}
}
/**
* Initialise some settings
*/
public function runCron() {
// Buffer all output to prevent conflicts with external software
ob_start();
// Start the clock
$starttime = time();
$db = JFactory::getDbo();
// First check if we deal with a valid user
if ($this->Login()) {
// Set some global values
$jinput = JFactory::getApplication()->input;
$jfilter = new JFilterInput();
// Get the parameters
require_once(JPATH_COMPONENT_ADMINISTRATOR.'/helpers/settings.php');
$settings = new CsviSettings();
// Check if we are running cron mode and set some necessary variables
$_SERVER['SERVER_ADDR'] = $_SERVER['HTTP_HOST'] = $settings->get('site.hostname');
$_SERVER['SCRIPT_NAME'] = '/index.php';
$_SERVER['REQUEST_URI'] = '/';
$_SERVER['PHP_SELF'] = '/index.php';
// Get the task to do
if (isset($this->_variables['task'])) $task = $jfilter->clean($this->_variables['task']);
else $task = '';
// Perform the requested task
switch ($task) {
case 'maintenance':
$jinput->set('task', 'maintenance.'.$this->_variables['operation']);
// Fire CSVI VirtueMart
$this->ExecuteJob();
break;
default:
// Second check if any template is set to process
if (array_key_exists('template_id', $this->_variables)) $template_id = $jfilter->clean($this->_variables['template_id'], 'int');
else $template_id = false;
if (array_key_exists('template_name', $this->_variables)) $template_name = $jfilter->clean($this->_variables['template_name']);
else $template_name = false;
if ($template_id || $template_name) {
// There is a template_id or template name, get some details to streamline processing
$where = empty($template_id) ? 'name='.$db->q($template_name) : 'id='.$template_id;
// There is a template name, get some details to streamline processing
$q = "SELECT id AS template_id, name AS template_name, settings
FROM #__csvi_template_settings
WHERE ".$where;
$db->setQuery($q);
$row = $db->loadObject();
if (is_object($row)) {
echo JText::sprintf('COM_CSVI_PROCESSING_STARTED', date('jS F Y, g:i a'))."\n";
echo JText::sprintf('COM_CSVI_TEMPLATE', $row->template_name)."\n";
// Set the template ID
$jinput->set('select_template', $row->template_id);
$jinput->set('template_id', $row->template_id);
$jinput->set('template_name', $row->template_name);
// Set the settings
if (array_key_exists('jform', $this->_variables)) $settings = CsviHelper::arrayExtend(json_decode($row->settings, true), $this->_variables['jform']);
else $settings = json_decode($row->settings, true);
// Set some export settings
if ($settings['options']['action'] == 'export') {
// Export settings
$jinput->set('task', 'exportfile.process');
// Set export to
if ($settings['general']['exportto'] == 'todownload') $settings['general']['exportto'] = 'tofile';
}
// Set some import settings
else if ($settings['options']['action'] == 'import') {
// Import settings
$jinput->set('task', 'importfile.doimport');
// Turn off preview
$settings['general']['show_preview'] = 0;
}
// Set a view so VirtueMart is happy
$jinput->set('view', 'products');
// Post the settings
$jinput->set('jform', $settings, 'post');
// Fire CSVI
$this->ExecuteJob();
}
else {
if ($template_name) echo JText::sprintf('COM_CSVI_NO_TEMPLATE_FOUND', $template_name)."\n";
else if ($template_id) echo JText::sprintf('COM_CSVI_NO_TEMPLATE_FOUND', $template_id)."\n";
}
}
else echo JText::_('COM_CSVI_NO_TEMPLATE_SPECIFIED')."\n";
break;
}
}
else {
$error = JError::getError();
echo $error->message."\n";
}
echo sprintf(JText::_('COM_CSVI_PROCESSING_FINISHED'), date('jS F Y, g:i a'))."\n";
$duration = time() - $starttime;
if ($duration < 60) echo sprintf(JText::_('COM_CSVI_PROCESSING_SECONDS'), $duration)."\n";
else echo sprintf(JText::_('COM_CSVI_PROCESSING_MINUTES'), (number_format($duration/60, 2)))."\n";
// Done, lets log the user out
$this->UserLogout();
// Display any generated messages
$messages = ob_get_contents();
@ob_end_clean();
echo $messages;
}
/**
* Collect the variables
*
* Running from the command line, the variables are stored in $argc and $argv.
* Here we put them in $_REQUEST so that they are available to the script
*/
private function CollectVariables() {
$arguments = false;
// Take the argument values and put them in $_REQUEST
if (isset($_SERVER['argv'])) {
foreach ($_SERVER['argv'] as $key => $argument) {
if ($key > 0) {
list($name, $value) = explode("=", $argument);
if (strpos($value, '|')) $value = explode('|', $value);
if (strpos($name, ':')) {
$names = explode(':', $name);
if (count($names) == 3 && $names[0] == 'jform') {
$this->_variables['jform'][$names[1]][$names[2]] = $value;
}
}
else $this->_variables[$name] = $value;
}
}
$arguments = true;
}
// Get the _GET
if (!empty($_GET)) {
$this->_storeVariables($_GET);
$arguments = true;
}
// Get the _POST
if (!empty($_POST)) {
$this->_storeVariables($_POST);
$arguments = true;
}
if (!$arguments) echo JText::_('COM_CSVI_NO_ARGUMENTS')."\n";
}
/**
* Store the variables
*
* @copyright
* @author RolandD
* @todo
* @see
* @access private
* @param $vars array the variables to store
* @return
* @since 3.2
*/
private function _storeVariables($vars) {
foreach ($vars as $name => $value) {
if (!empty($value)) {
if (strpos($value, '|')) $value = explode('|', $value);
if (substr($name, 0, 5) == 'jform') {
if (strpos($name, ':')) $names = explode(':', $name);
else $names = explode('_', $name);
if (count($names) == 3 && $names[0] == 'jform') {
$this->_variables['jform'][$names[1]][$names[2]] = $value;
}
}
else $this->_variables[$name] = $value;
}
}
}
/**
* Check if the user exists
*/
private function Login() {
$mainframe = JFactory::getApplication();
$jfilter = new JFilterInput();
$credentials['username'] = $jfilter->clean($this->_variables['username'], 'username');
$credentials['password'] = $jfilter->clean($this->_variables['passwd']);
$result = $mainframe->login($credentials, array('entry_url' => ''));
if (!JError::isError($result)) {
return true;
}
else return false;
}
/**
* Process the requested job
*/
function ExecuteJob() {
$jinput = JFactory::getApplication()->input;
$jinput->set('cron', true);
require(JPATH_COMPONENT_ADMINISTRATOR.'/csvi.php');
}
/**
* Log the user out
*/
private function UserLogout() {
global $mainframe;
ob_start();
$error = $mainframe->logout();
if(JError::isError($error)) {
ob_end_clean();
echo JText::_('COM_CSVI_PROBLEM_LOGOUT_USER')."\n";
}
else {
ob_end_clean();
echo JText::_('COM_CSVI_USER_LOGGED_OUT')."\n";
}
}
}
?>PK >\ w w helpers/csvisef.phpnu W+A _domainname = CsviHelper::getDomainName();
}
/**
* Create a SEF URL
*
* @copyright
* @author RolandD
* @todo Change exportsef to template
* @see
* @access private
* @param string $url The url to change to SEF
* @return string the new url
* @since 3.0
*/
public function getSiteRoute($url) {
$jinput = JFactory::getApplication()->input;
$template = $jinput->get('template', null, null);
$csvilog = $jinput->get('csvilog', null, null);
$parsed_url = null;
// Check which SEF component is installed
if (empty($this->_sef)) {
if ($template->get('exportsef', 'product', false)) {
// Joomla SEF
if (JPluginHelper::isEnabled('system', 'sef')) $this->_sef = 'joomla';
// sh404SEF check
if (JPluginHelper::isEnabled('system', 'shsef')) $this->_sef = 'sh404sef';
// JoomSEF check
if (JPluginHelper::isEnabled('system', 'joomsef')) $this->_sef = 'joomsef';
// AceSEF check
if (JPluginHelper::isEnabled('system', 'acesef')) $this->_sef = 'acesef';
// There is no SEF enabled
if (empty($this->_sef)) $this->_sef = 'nosef';
}
else $this->_sef = 'nosef';
}
switch ($this->_sef) {
case 'sh404sef':
$parsed_url = $this->_sh404Sef($url);
break;
case 'joomsef':
$parsed_url = $this->_joomSef($url);
break;
case 'joomla':
$parsed_url = $this->_joomlaSef($url);
break;
case 'acesef':
$parsed_url = $this->_aceSef($url);
break;
case 'nosef':
default:
// No SEF router found, returning regular URL
return $this->_domainname.JRoute::_($url);
break;
}
// Clean up the parsed SEF URL
if (!empty($parsed_url)) {
// Clean up the parsed SEF URL
if (substr($parsed_url, 4) == 'http') return $parsed_url;
else {
// Check for administrator in the domain
$adminpos = strpos($parsed_url,'/administrator/');
if ($adminpos !== false) $parsed_url = substr($parsed_url,$adminpos+15);
// Check if we have a domain name in the URL
if (!empty($this->_domainname)) {
$check_domain = str_replace('https', 'http', $this->_domainname);
$domain = strpos($parsed_url, $check_domain);
if ($domain === false) {
if (substr($parsed_url, 0, 1) == '/') $parsed_url = $this->_domainname.$parsed_url;
else $parsed_url = $this->_domainname.'/'.$parsed_url;
}
return $parsed_url;
}
else {
$csvilog->addDebug(JText::_('COM_CSVI_NO_DOMAINNAME_SET'));
return $url;
}
}
}
}
/**
* Create sh404SEF URLs
*
* @copyright
* @author RolandD
* @todo
* @see http://dev.anything-digital.com/sh404SEF/
* @see getSiteRoute()
* @access private
* @param string $url the original URL to turn into SEF
* @return string SEF URL
* @since 3.0
*/
private function _sh404Sef($url) {
// Load sh404SEF
require_once(JPATH_ADMINISTRATOR.'/components/com_sh404sef/sh404sef.class.php');
$sefConfig = shRouter::shGetConfig();
// Turn off any security and flooding setting
$sefConfig->shSecEnableSecurity = 0;
$sefConfig->shSecActivateAntiFlood = 0;
// Require some necessary files
require_once(JPATH_ROOT.'/components/com_sh404sef/shCache.php');
require_once(JPATH_ROOT.'/components/com_sh404sef/shSec.php');
// Start the sh404sef Router
if (class_exists('shRouter')) $shRouter = new shRouter();
else return $this->_domainname.'/'.$url;
// Force the domain name
$GLOBALS['shConfigLiveSite'] = $this->_domainname;
// Initialize sh404sef
include_once(JPATH_ROOT.'/components/com_sh404sef/shInit.php');
// Build the SEF URL
$uri = $shRouter->build($url);
$sefurl = $uri->toString();
if (strpos($sefurl, 'http://') === false) {
$sefurl = str_ireplace('http:/', 'http://', $sefurl);
}
return $sefurl;
}
/**
* Create JoomSEF URLs
*
* @copyright
* @author RolandD
* @todo
* @see http://www.artio.net/joomla-extensions/joomsef
* @see _getSiteRoute()
* @access private
* @param string $url the original URL to turn into SEF
* @return string SEF URL
* @since 3.0
*/
private function _joomSef($url) {
// Include Joomla files
jimport('joomla.application.router');
require_once(JPATH_ROOT.'/includes/application.php');
// Include JoomSEF
require_once(JPATH_ROOT.'/components/com_sef/sef.router.php');
$shRouter = new JRouterJoomSef();
// Build the SEF URL
$uri = $shRouter->build($url);
return $uri->toString();
}
/**
* Create Joomla SEF URLs
*
* @copyright
* @author RolandD
* @todo
* @see http://www.joomla.org/
* @see _getSiteRoute()
* @access private
* @param string $url the original URL to turn into SEF
* @return string SEF URL
* @since 3.0
*/
private function _joomlaSef($url) {
// Load Joomla core files for SEF
jimport('joomla.application.router');
require_once(JPATH_ROOT.'/includes/application.php');
require_once(JPATH_ROOT.'/includes/router.php');
$router = new JRouterSite(array('mode' => 1));
$uri = $router->build($url);
return $uri->toString();
}
/**
* Create aceSEF URLs
*
* @copyright
* @author RolandD
* @todo
* @see http://www.joomace.net/joomla-extensions/acesef
* @see _getSiteRoute()
* @access private
* @param string $url the original URL to turn into SEF
* @return string SEF URL
* @since 3.0
*/
private function _aceSef($url) {
jimport('joomla.application.router');
require_once(JPATH_ROOT.'/includes/application.php');
require_once(JPATH_ADMINISTRATOR.'/components/com_acesef/library/router.php');
require_once(JPATH_ADMINISTRATOR.'/components/com_acesef/library/loader.php');
$router = new JRouterAcesef();
$uri = $router->build($url);
return $uri->toString();
}
}
?>
PK >\c(, (, helpers/csvi.phpnu W+A $v) {
if( is_array($v) ) {
if( !isset($a[$k]) ) {
$a[$k] = $v;
} else {
$a[$k] = self::arrayExtend($a[$k], $v);
}
} else {
$a[$k] = $v;
}
}
return $a;
}
/**
* Recursive array diff
*
* @copyright
* @author Amund, RolandD
* @todo
* @see http://www.php.net/manual/en/function.array-merge.php#91756
* @access private
* @param array $aArray1 The array to update
* @param array $aArray2 The array with new values
* @return array with all new values
* @since 3.0
*/
public function recurseArrayDiff($aArray1, $aArray2) {
$aReturn = array();
if (is_array($aArray1) && is_array($aArray2)) {
foreach ($aArray1 as $mKey => $mValue) {
if (array_key_exists($mKey, $aArray2)) {
if (is_array($mValue)) {
$aRecursiveDiff = self::recurseArrayDiff($mValue, $aArray2[$mKey]);
if (count($aRecursiveDiff)) { $aReturn[$mKey] = $aRecursiveDiff; }
}
else {
if ($mValue != $aArray2[$mKey]) $aReturn[$mKey] = $mValue;
}
}
else {
$aReturn[$mKey] = $mValue;
}
}
}
return $aReturn;
}
/**
* Perform replacement on a value
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param int $id the id of the replacement rule
* @param string $value the text to replace
* @return string the replaced text
* @since 3.0
*/
public function replaceValue($id, $value) {
static $replacements;
if ($id > 0) {
if (!isset($this->replacements[$id])) {
// Get the replace details
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select($db->quoteName('findtext'));
$query->select($db->quoteName('replacetext'));
$query->select($db->quoteName('method'));
$query->from('#__csvi_replacements');
$query->where('id = '.$db->Quote($id));
$db->setQuery($query);
$replace = $db->loadObject();
$this->replacements[$id] = $replace;
}
else {
$replace = $this->replacements[$id];
}
// Perform the replacement
if (empty($replace)) return $value;
else {
switch ($replace->method) {
case 'text':
$fieldvalue = str_ireplace($replace->findtext, $replace->replacetext, $value);
break;
case 'regex':
$fieldvalue = preg_replace($replace->findtext, $replace->replacetext, $value);
break;
}
}
return $fieldvalue;
}
else return $value;
}
/**
* Get the list of custom tables
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param
* @return array list of order item product objects
* @since 3.0
*/
public function getCustomTables() {
$db = JFactory::getDbo();
$q = "SELECT component_table
FROM #__csvi_available_fields
WHERE core = 0
GROUP BY component_table";
$db->setQuery($q);
return $db->loadColumn();
}
/**
* Check whether a file referenced by a URL exists
*
* Note: The time taken to check a valid format url: 0.10 secs, regardless of whether the file exists
*
* @copyright
* @author doorknob, RolandD
* @todo
* @see
* @access public
* @param string $file The URL to be checked
* @return boolean true if file exists | false if file does not exist
* @since 2.17
*/
public function fileExistsRemote($file) {
// If it is an SSL file we cannot validate its existence
if (substr($file, 0, 5) == 'https') return true;
$jinput = JFactory::getApplication()->input;
$csvilog = $jinput->get('csvilog', null, null);
$url_parts = @parse_url($file);
$csvilog->addDebug('URL:'.$file);
if (!isset($url_parts['host']) || empty($url_parts['host'])) {
return false;
}
if (!isset($url_parts['path']) || empty($url_parts['path'])) {
$documentpath = '/';
}
else {
$documentpath = $url_parts['path'];
}
if (isset($url_parts['query']) && !empty($url_parts['query'])) {
$documentpath .= '?'.$url_parts['query'];
}
$host = $url_parts['host'];
if (!isset($url_parts['port']) || empty($url_parts['port'])) {
if ($url_parts['scheme'] == 'https') $port = '443';
else $port = '80';
}
else {
$port = $url_parts['port'];
}
if ($url_parts['scheme'] == 'https') {
$sslhost = 'ssl://'.$host;
}
else $sslhost = $host;
$errno = null;
$errstr = null;
$documentpath = str_replace(' ', '%20', $documentpath);
$socket = @fsockopen($sslhost, $port, $errno, $errstr, 30);
if ($socket) {
fwrite($socket, "HEAD $documentpath HTTP/1.1\r\nUser-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.11) Gecko/20071127 Firefox/2.0.0.11\r\nHost: $host\r\n\r\n");
$http_response = fgets($socket, 25);
fclose($socket);
// Parse the result
$csvilog->addDebug('HTTP response:'.$http_response);
if (stripos($http_response, '200 OK') === false && stripos($http_response, '302 Found') === false) {
return false;
}
else return true;
}
return false;
}
/**
* Find the primary key of a given table
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param $table string the name of the table to find the primary key
* @return string the fieldname that is the primary key
* @since 3.0
*/
public function getPrimaryKey($tablename) {
$db = JFactory::getDbo();
$q = "SHOW KEYS FROM ".$db->quoteName('#__'.$tablename)."
WHERE ".$db->quoteName('Key_name')." = ".$db->quote('PRIMARY');
$db->setQuery($q);
$key = $db->loadObject();
if (!is_object($key)) return '';
else return $key->Column_name;
}
/**
* Get the domainname
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param
* @return string domain name
* @since 3.4
*/
public function getDomainName() {
$jinput = JFactory::getApplication()->input;
$settings = $jinput->get('settings', null, null);
// Get the domainname
$domainname = $settings->get('site.hostname');
// Check for the trailing slash at the domain name
if (substr($domainname, -1) == '/') $domainname = substr($domainname, 0, -1);
// Assign the domainname
return $domainname;
}
/**
* Get supported components
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param
* @return array of supported components
* @since 4.0
*/
public function getComponents() {
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select('component AS value, component AS text');
$query->from($db->quoteName('#__csvi_template_types'));
$query->leftJoin('#__extensions ON #__csvi_template_types.component = #__extensions.element');
$query->where($db->quoteName('#__extensions.type').' = '.$db->Quote('component'));
$query->group('component');
$db->setQuery($query);
return $db->loadObjectList();
}
/**
* Get the buttons for the control panel
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param
* @return object with the button HTML data
* @since 3.0
*/
public function getButtons() {
// Get the Cpanel images
$cpanel_images = new stdClass();
$cpanel_images->process = $this->CpanelButton('csvi_process_48.png', 'index.php?option=com_csvi&view=process', 'COM_CSVI_PROCESS');
$cpanel_images->replacements = $this->CpanelButton('csvi_replace_48.png', 'index.php?option=com_csvi&view=replacements', 'COM_CSVI_REPLACEMENTS');
$cpanel_images->maintenance = $this->CpanelButton('csvi_maintenance_48.png', 'index.php?option=com_csvi&view=maintenance', 'COM_CSVI_MAINTENANCE');
$cpanel_images->help = $this->CpanelButton('csvi_help_48.png', 'http://www.csvimproved.com/csv-improved-documentation/', 'COM_CSVI_HELP');
$cpanel_images->about = $this->CpanelButton('csvi_about_48.png', 'index.php?option=com_csvi&view=about', 'COM_CSVI_ABOUT');
$cpanel_images->log = $this->CpanelButton('csvi_log_48.png', 'index.php?option=com_csvi&view=log', 'COM_CSVI_LOG');
$cpanel_images->availablefields = $this->CpanelButton('csvi_av_fields_48.png', 'index.php?option=com_csvi&view=availablefields', 'COM_CSVI_AVAILABLE_FIELDS');
$cpanel_images->settings = $this->CpanelButton('csvi_settings_48.png', 'index.php?option=com_csvi&view=settings', 'COM_CSVI_SETTINGS');
$cpanel_images->install = $this->CpanelButton('csvi_install_48.png', 'index.php?option=com_csvi&view=install', 'COM_CSVI_INSTALL');
return $cpanel_images;
}
/**
* Creates a button for the control panel
*
* @copyright
* @author RolandD
* @todo
* @see
* @access private
* @param string $image contains the name of the image
* @param string $link contains the target link for the image when clicked
* @param string $title contains the title of the button
* @return string returns a complete button for the control panel
* @since 3.0
*/
private function CpanelButton($image, $link, $title) {
if (substr($link, 0, 4) == "http") $attribs = ' target="_new"';
else $attribs = '';
$cpanelbutton = '
';
if (isset($this->csvi_data[$field_details['order']])) $message .= $this->csvi_data[$field_details['order']];
$message .= '
';
}
$message .= '
';
$csvilog->AddStats('incorrect', $message, true);
// Finish processing
$this->finishProcess(true);
$processdata = false;
}
}
// Load ICEcat data if user wants to
$this->getIcecat();
// Validate the fields
$csvi_data = new JObject();
foreach ($this->_csvifields as $name => $details) {
if ($details['published']) {
$datafield = $this->validateInput($details['name'], $details['replace']);
if ($datafield !== false) {
// Check if we are dealing with the last field
if ($details == $this->_lastfield) $details['combine'] = false;
// See if we are combining the field
if ($details['combine']) $this->setCombineField($datafield, $name);
else {
// Check if there are any fields to be combined
if (!empty($this->combine_fields)) {
// Get the fieldname the combine is for
$name = $this->combine_settings['fieldname'];
// Add the current data
$this->setCombineField($datafield);
// Get the combined data
$datafield = $this->getCombineField();
}
}
// Set the new value
$csvi_data->$name = $datafield;
}
}
}
$jinput->set('csvi_data', $csvi_data);
if ($this->_checkLimits()) {
// Notify the debug log what line we are one
$csvilog->addDebug(JText::sprintf('COM_CSVI_DEBUG_PROCESS_LINE', ($jinput->get('currentline', 0, 'int')+$jinput->get('totalline', 0, 'int'))));
// Start processing record
if ($routine->getStart()) {
if ($jinput->get('csvipreview', false, 'bool')) {
$this->loadSettings();
// Update preview data
foreach ($this->_csvifields as $fieldname => $value) {
if ($value['published']) {
if (isset($routine->$fieldname)) $preview_data[$value['order']] = $routine->$fieldname;
else if (empty($routine->$fieldname)) $preview_data[$value['order']] = '';
}
}
$data_preview[$jinput->get('currentline', 0, 'int')] = $preview_data;
if ($jinput->get('currentline', 0, 'int') == $settings->get('import.import_preview', 5)) {
// Set the headers
$headers = array();
foreach ($this->_csvifields as $fieldname => $value) {
if ($value['published']) {
if (isset($routine->$fieldname) || empty($routine->$fieldname)) $headers[] = $fieldname;
}
}
$jinput->set('headers_preview', $headers);
// Set the data
$jinput->set('data_preview', $data_preview);
// Clean the session
$this->getCleanPreview();
$processdata = false;
continue;
}
}
else {
// Now we import the rest of the records
$routine->getProcessRecord();
}
// Increase the number of records processed
$jinput->set('recordsprocessed', $jinput->get('recordsprocessed', 0, 'int')+1);
}
else {
// The routine reports a problem, usually unmet conditions
// Finish processing
$this->finishProcess(true);
// Stop from processing any further, no time left
$processdata = false;
}
// Increase linenumber
$jinput->set('currentline', $jinput->get('currentline', 0, 'int')+1);
}
else {
// Finish processing
$this->finishProcess(false);
// Stop from processing any further, no time left
$processdata = false;
}
}
}
// Prepare for page reload
else {
// Finish processing
$this->finishProcess(false);
// Stop from processing any further, no time left
$processdata = false;
}
}
// Post Processing
if (method_exists($routine, 'getPostProcessing')) {
$routine->getPostProcessing(array_keys($this->_csvifields));
}
}
else {
$csvilog->AddStats('incorrect', 'COM_CSVI_NO_VALID_CLASS_FOUND');
// Finish processing
$this->finishProcess(true);
}
}
/**
* Clean the session
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param
* @return void
* @since 3.0
*/
public function getCleanSession() {
$jinput = JFactory::getApplication()->input;
// Store the log results first
$log = $this->getModel('log');
$log->getStoreLogResults();
// Get session handler
$session = JFactory::getSession();
$option = $jinput->get('option');
// Unset all session values
$session->clear($option.'.csvicolumnheaders');
$session->clear($option.'.csvifields');
$session->clear($option.'.avfields');
$session->clear($option.'.csvifile');
$session->clear($option.'.filepos');
$session->clear($option.'.recordsprocessed');
$session->clear($option.'.template_id');
$session->clear($option.'.totalline');
$session->clear($option.'.csvilog');
$session->clear($option.'.global.template');
$session->clear($option.'.csvisettings');
$session->clear($option.'.helper_files');
}
/**
* Clean the session after preview
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param
* @return void
* @since 3.0
*/
private function getCleanPreview() {
$jinput = JFactory::getApplication()->input;
// Get session handler
$session = JFactory::getSession();
$option = $jinput->get('option');
// Load the correct position
if ($jinput->get('csvipreview', false, 'bool')) {
$template = $jinput->get('template', null, null);
$csvifile = $jinput->get('csvifile', null, null);
// Move back to the beginning
$csvifile->rewind();
// Move 1 row forward as this is the column header
if ($template->get('use_column_headers', 'general') || $template->get('skip_first_line', 'general')) {
$csvifile->next(true);
}
// Get the current position
$filepos = $csvifile->getFilePos();
}
else $filepos = 0;
// Unset all session values
$session->set($option.'.filepos', serialize($filepos));
$session->set($option.'.recordsprocessed', serialize(0));
$session->set($option.'.csvipreview', serialize(false));
}
/**
* Sets the system limits to user defined values
*
* Sets the system limits to user defined values to allow for longer and
* bigger uploaded files
*
* @copyright
* @author RolandD
* @todo Allow 0 or -1 value
* @see
* @access private
* @param
* @return
* @since 3.0
*/
private function _systemLimits() {
$jinput = JFactory::getApplication()->input;
// Set the start time of the script
$this->_starttime = time();
// Get the logger
$csvilog = $jinput->get('csvilog', null, null);
$template = $jinput->get('template', null, null);
// See if we need to use the new limits
if ($template->get('use_system_limits', 'limit')) {
$csvilog->addDebug('Setting system limits:');
// Apply the new memory limits
$execution_time = $template->get('max_execution_time');
if (strlen($exection_time) > 0) {
$csvilog->addDebug('Setting max_execution_time to '.$execution_time.' seconds');
@ini_set('max_execution_time', $execution_time);
}
$memory_limit = $template->get('memory_limit', 'limit');
if ($memory_limit == '-1') {
$csvilog->addDebug('Setting memory_limit to '.$memory_limit);
@ini_set('memory_limit', $memory_limit);
}
else if (strlen($memory_limit) > 0) {
$csvilog->addDebug('Setting memory_limit to '.$memory_limit.'M');
@ini_set('memory_limit', $memory_limit.'M');
}
$post_size = $template->get('post_max_size', 'limit');
if (strlen($post_size) > 0) {
$csvilog->addDebug('Setting post_max_size to '.$post_size.'M');
@ini_set('post_max_size', $post_size.'M');
}
$file_size = $template->get('upload_max_filesize', 'limit');
if (strlen($file_size) > 0) {
$csvilog->addDebug('Setting upload_max_filesize to '.$file_size.'M');
@ini_set('upload_max_filesize', $file_size.'M');
}
}
}
/**
* Function to check if execution time is going to be passed.
*
* Memory can only be checked if the function memory_get_usage is available.
* If the function is not available always return true. This could lead to
* out of memory failure.
*
* @copyright
* @author RolandD
* @todo
* @see http://www.php.net/memory_get_usage
* @access private
* @param
* @return bool true when limits are not reached|false when limit is reached
* @since 3.0
*/
private function _checkLimits() {
$jinput = JFactory::getApplication()->input;
$csvilog = $jinput->get('csvilog', null, null);
// Check for maximum execution time
$timepassed = time() - $this->_starttime;
if (($timepassed + 5) > ini_get('max_execution_time') && ini_get('max_execution_time') > 0) {
$csvilog->AddStats('information', JText::sprintf('COM_CSVI_MAXIMUM_EXECUTION_LIMIT_EXCEEDED', $timepassed));
return false;
}
// Check for maximum memory usage
if (!function_exists('memory_get_usage')) return true;
else {
// Get the size of the statistics
$statslength = 0;
if (isset($csvilog->stats)) {
foreach ($csvilog->stats as $type => $value) {
if (isset($value['message'])) $statslength += strlen($value['message']);
}
}
$statslength = round($statslength/(1024*1024));
// Get the size of the debug message
$debuglength = round(strlen($csvilog->debug_message)/(1024*1024));
// Get the size of the active memory in use
$activelength = round(memory_get_usage()/(1024*1024));
// Combine memory limits
$totalmem = $activelength + $statslength + $debuglength;
// Set the memory limit
$jinput->set('maxmem', $totalmem);
// Check if we are passing the memory limit
if (($totalmem * 1.5) > (int)ini_get('memory_limit')) {
$csvilog->AddStats('information', JText::_('COM_CSVI_MAXIMUM_MEMORY_LIMIT_EXCEEDED', $totalmem));
return false;
}
// All is good return true
return true;
}
}
/**
* Print out import details
*
* @copyright
* @author RolandD
* @todo
* @see
* @access private
* @param
* @return
* @since 3.0
*/
private function _importDetails() {
$jinput = JFactory::getApplication()->input;
// Get the logger
$csvilog = $jinput->get('csvilog', null, null);
// Get the template settings to see if we need a preview
$template = $jinput->get('template', null, null);
$csvilog->addDebug(JText::_('COM_CSVI_CSVI_VERSION_TEXT').JText::_('COM_CSVI_CSVI_VERSION'));
if (function_exists('phpversion')) $csvilog->addDebug(JText::sprintf('COM_CSVI_PHP_VERSION', phpversion()));
// General settings
$csvilog->addDebug(JText::_('COM_CSVI_GENERAL_SETTINGS'));
// Show which template is used
$csvilog->addDebug(JText::sprintf('COM_CSVI_TEMPLATE_NAME', $template->get('template_name')));
// Auto detect delimiters
$auto_detect = ($template->get('auto_detect_delimiters', 'general')) ? JText::_('COM_CSVI_YES') : JText::_('COM_CSVI_NO');
$csvilog->addDebug(JText::sprintf('COM_CSVI_AUTO_DETECT_DELIMITERS', $auto_detect));
if ($auto_detect == JText::_('COM_CSVI_NO')) {
// Check delimiter char
$csvilog->addDebug(JText::sprintf('COM_CSVI_USING_DELIMITER', $template->get('field_delimiter', 'general')));
// Check enclosure char
$csvilog->addDebug(JText::sprintf('COM_CSVI_USING_ENCLOSURE', $template->get('text_enclosure', 'general')));
}
// Show import settings
// Show template type
$csvilog->addDebug(JText::sprintf('COM_CSVI_CHOSEN_IMPORT_TYPE', JText::_('COM_CSVI_'.$template->get('operation', 'options'))));
// Use column headers as configuration
$use_header = ($template->get('use_column_headers', 'general')) ? JText::_('COM_CSVI_YES') : JText::_('COM_CSVI_NO');
$csvilog->addDebug(JText::sprintf('COM_CSVI_USE_HEADER', $use_header));
// Refresh xml headers for every record
$refresh_xml_headers = ($template->get('refresh_xml_headers', 'general')) ? JText::_('COM_CSVI_YES') : JText::_('COM_CSVI_NO');
$csvilog->addDebug(JText::sprintf('COM_CSVI_REFRESH_XML_HEADER', $use_header));
// Skip first line
$skip_first = ($template->get('skip_first_line', 'general')) ? JText::_('COM_CSVI_YES') : JText::_('COM_CSVI_NO');
$csvilog->addDebug(JText::sprintf('COM_CSVI_SKIP_FIRST_LINE', $skip_first));
// Ignore non-existing products
$ignore_non_exist = ($template->get('ignore_non_exist', 'general')) ? JText::_('COM_CSVI_YES') : JText::_('COM_CSVI_NO');
$csvilog->addDebug(JText::sprintf('COM_CSVI_IGNORE_NON_EXIST', $ignore_non_exist));
// Overwrite existing data
$overwrite = ($template->get('overwrite_existing_data', 'general')) ? JText::_('COM_CSVI_YES') : JText::_('COM_CSVI_NO');
$csvilog->addDebug(JText::sprintf('COM_CSVI_OVERWRITE_EXISTING_DATA', $overwrite));
// Skip default value
$skip_default = ($template->get('skip_default_value', 'general')) ? JText::_('COM_CSVI_YES') : JText::_('COM_CSVI_NO');
$csvilog->addDebug(JText::sprintf('COM_CSVI_SKIP_DEFAULT_VALUE', $skip_default));
// Show preview
$use_preview = ($template->get('show_preview', 'general')) ? JText::_('COM_CSVI_YES') : JText::_('COM_CSVI_NO');
$csvilog->addDebug(JText::sprintf('COM_CSVI_USING_PREVIEW', $use_preview));
// Products
// Unpublish products before import
$unpublish = ($template->get('unpublish_before_import', 'product')) ? JText::_('COM_CSVI_YES') : JText::_('COM_CSVI_NO');
$csvilog->addDebug(JText::sprintf('COM_CSVI_UNPUBLISH_BEFORE_IMPORT', $unpublish));
// Categories
// Append categories
$append_cats = ($template->get('append_categories', 'product')) ? JText::_('COM_CSVI_YES') : JText::_('COM_CSVI_NO');
$csvilog->addDebug(JText::sprintf('COM_CSVI_APPEND_CATEGORIES', $append_cats));
// Images
// General options
$process_image = ($template->get('process_image', 'image', false)) ? JText::_('COM_CSVI_YES') : JText::_('COM_CSVI_NO');
$csvilog->addDebug(JText::sprintf('COM_CSVI_PROCESS_IMAGE', $process_image));
// Create image name
$create_name = ($template->get('auto_generate_image_name', 'image')) ? JText::_('COM_CSVI_YES') : JText::_('COM_CSVI_NO');
$csvilog->addDebug(JText::sprintf('COM_CSVI_CREATE_IMAGE_NAME', $create_name));
// Generate image name
$csvilog->addDebug(JText::sprintf('COM_CSVI_IMAGE_BASED_ON', $template->get('type_generate_image_name', 'image')));
// Image name format
$csvilog->addDebug(JText::sprintf('COM_CSVI_IMAGE_NAME_FORMAT', $template->get('auto_generate_image_name_ext', 'image')));
// Full image
// Convert image
$csvilog->addDebug(JText::sprintf('COM_CSVI_CONVERT_IMAGE', $template->get('convert_type', 'image')));
// Save images on server
$on_server = ($template->get('save_images_on_server', 'image')) ? JText::_('COM_CSVI_YES') : JText::_('COM_CSVI_NO');
$csvilog->addDebug(JText::sprintf('COM_CSVI_SAVE_IMAGES_ON_SERVER', $on_server));
// Thumbnail image
// Automatic thumbnail creation
$auto_thumb = ($template->get('thumb_create', 'image')) ? JText::_('COM_CSVI_YES') : JText::_('COM_CSVI_NO');
$csvilog->addDebug(JText::sprintf('COM_CSVI_AUTOMATIC_THUMBS', $auto_thumb));
if ($auto_thumb == JText::_('COM_CSVI_YES')) {
// Thumbnail format
$csvilog->addDebug(JText::sprintf('COM_CSVI_FORMAT_THUMBS', $template->get('thumb_extension', 'image')));
// Thumbnail width x height
$csvilog->addDebug(JText::sprintf('COM_CSVI_DIMENSION_THUMBS', $template->get('thumb_width', 'image'), $template->get('thumb_height', 'image')));
}
// Show the file paths
$csvilog->addDebug(JText::sprintf('COM_CSVI_DEBUG_FILE_PATH_PRODUCT_IMAGES', $template->get('file_location_product_images', 'path')));
$csvilog->addDebug(JText::sprintf('COM_CSVI_DEBUG_FILE_PATH_CATEGORY_IMAGES', $template->get('file_location_category_images', 'path')));
$csvilog->addDebug(JText::sprintf('COM_CSVI_DEBUG_FILE_PATH_MEDIA', $template->get('file_location_media', 'path')));
// Show the max execution time
$csvilog->addDebug(JText::sprintf('COM_CSVI_DEBUG_MAX_EXECUTION_TIME', ini_get('max_execution_time')));
}
/**
* Unpublish products before import
*
* @copyright
* @author RolandD
* @todo
* @see prepareImport()
* @access private
* @param
* @return
* @since 3.0
*/
private function _unpublishProducts() {
$jinput = JFactory::getApplication()->input;
$csvilog = $jinput->get('csvilog', null, null);
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->update('#__virtuemart_products');
$query->set('published = 0');
$db->setQuery($query);
if ($db->query()) $csvilog->addDebug(JText::_('COM_CSVI_PRODUCT_UNPUBLISH_BEFORE_IMPORT'));
else $csvilog->addDebug(JText::_('COM_CSVI_COULD_NOT_UNPUBLISH_BEFORE_IMPORT'), true);
}
/**
* Builds arrays of field names and default values to be used during the creation of the headers list
* The creation of the headers from the data file may need to be carried out for every row when processing
* XML files and so efficiency is important for performance.
*
* Note: The array supported_fields should not be used as the basis for these arrays because it is a list of
* all available fields and some of these fields may not be mapped in the template.
*/
public function _fieldArrays() {
$jinput = JFactory::getApplication()->input;
$template = $jinput->get('template', null, null);
$db = JFactory::getDBO();
$this->_supportedfields = array();
$this->_field_defaults = array();
$this->_field_published = array();
if ($template->get('use_column_headers', 'general')) {
// Check if there are any avfields
if (empty($this->_avfields))
{
$option = $jinput->get('option');
$session = JFactory::getSession();
$this->_avfields = unserialize($session->get($option.'.avfields'));
}
$supportedfields = array_flip($this->_avfields);
foreach ($supportedfields as $name => $value) {
$this->_supported_fields[] = $name;
$this->_field_defaults[strtolower($name)] = null;
$this->_field_published[strtolower($name)] = 1;
}
}
// Use the template fields assigned to the template
else {
$import_fields = $template->get('import_fields');
if (isset($import_fields['_selected_name'])) {
$count = count($import_fields['_selected_name']);
for ($rows = 0; $rows < $count; $rows++) {
$this->_supported_fields[] = $import_fields['_selected_name'][$rows];
$this->_field_defaults[strtolower($import_fields['_selected_name'][$rows])] = $import_fields['_default_value'][$rows];
$this->_field_published[strtolower($import_fields['_selected_name'][$rows])] = $import_fields['_process_field'][$rows];
}
}
}
// Create the inverted array used to lookup the field name using lowercase
$this->_supportedfields = array();
foreach( $this->_supported_fields as $key => $value ) {
$this->_supportedfields[strtolower($value)] = $key;
}
}
/**
* Get the configuration fields the user wants to use
*
* The configuration fields can be taken from the uploaded file or from
* the database. Depending on the template settings.
*
* @copyright
* @author RolandD
* @todo Expand the no support fields message on line 398
* @see Templates()
* @access private
* @param
* @return bool true|false true when there are config fields|false when there are no or unsupported fields
* @since 3.0
*/
private function _retrieveConfigFields($csvifile=false) {
$jinput = JFactory::getApplication()->input;
$db = JFactory::getDbo();
$template = $jinput->get('template', null, null);
$csvilog = $jinput->get('csvilog', null, null);
if (!$csvifile) $csvifile = $jinput->get('csvifile', '', 'string');
if (empty($this->_supportedfields)) $this->_fieldArrays();
$columnheaders = $jinput->get('columnheaders', array(), 'array');
$csvifields = array();
$nosupport = array();
$csvilog->addDebug(JText::_('COM_CSVI_DEBUG_LOAD_CONFIG_FIELDS'));
if ($template->get('use_column_headers', 'general')) {
// The user has column headers in the file
$jinput->set('error_found', false);
if ($columnheaders) {
foreach ($columnheaders as $order => $name) {
// Trim the name in case the name contains any preceding or trailing spaces
$name = strtolower(trim($name));
// Check if the fieldname is supported
// No special field checking for Product Type Names upload
if (array_key_exists($name, $this->_supportedfields)) {
$csvilog->addDebug('Field: '.$name);
$mixed_name = $this->_supported_fields[$this->_supportedfields[$name]];
$csvifields[$mixed_name]['name'] = $mixed_name;
$csvifields[$mixed_name]['order'] = $order;
$csvifields[$mixed_name]['default_value'] = (array_key_exists($name, $this->_field_defaults)) ? $this->_field_defaults[$name] : null;
$csvifields[$mixed_name]['published'] = (array_key_exists($name, $this->_field_published)) ? $this->_field_published[$name] : 'Y';
$csvifields[$mixed_name]['combine'] = false;
$csvifields[$mixed_name]['replace'] = null;
}
else {
// Check if the user has any field that is not supported
if (strlen($name) == 0) $name = JText::_('COM_CSVI_FIELD_EMPTY');
// Field is not supported, let's skip it
$csvifields[$name]['name'] = $name;
$csvifields[$name]['order'] = $order;
$csvifields[$name]['default_value'] = null;
$csvifields[$name]['published'] = 'N';
$csvifields[$name]['combine'] = false;
$csvifields[$name]['replace'] = null;
// Unset the column header so we can check if any fields are left over
unset($columnheaders[$order]);
// Collect the fieldnames to report them
$nosupport[] = $name;
}
}
//if (empty($columnheaders)) {
// $csvilog->AddStats('incorrect', JText::_('COM_CSVI_NO_COLUMN_HEADERS_FOUND'));
// $jinput->set('error_found', true);
// return false;
//}
if (!empty($nosupport)) {
// Ensure the error message matches the file type
switch($csvifile->extension) {
case 'xml':
case 'sql':
$csvilog->AddStats('nosupport', implode(',', $nosupport).JText::_('COM_CSVI_FIELD_NOT_INCLUDED'));
break;
default:
$csvilog->AddStats('nosupport', JText::sprintf('COM_CSVI_NO_SUPPORT', '
'.implode('
', $nosupport).'
'));
break;
}
$csvilog->AddStats('information', JText::_('COM_CSVI_UNSUPPORTED_FIELDS'));
}
$csvilog->addDebug(JText::_('COM_CSVI_USING_FILE_FOR_CONFIGURATION'));
}
else {
$csvilog->AddStats('incorrect', JText::_('COM_CSVI_NO_COLUMN_HEADERS_FOUND'));
$jinput->set('error_found', true);
return false;
}
}
// Use the fields assigned to the template
else {
$fields = $template->get('import_fields');
if (!empty($fields)) {
foreach ($fields['_selected_name'] as $fid => $name) {
// Check if we are handling a combine field
if ($name == 'combine') $name .= $fid;
// Collect the data
$csvifields[$name]['name'] = $name;
$csvifields[$name]['order'] = $fid;
$csvifields[$name]['default_value'] = $fields['_default_value'][$fid];
$csvifields[$name]['published'] = $fields['_process_field'][$fid];
$csvifields[$name]['combine'] = $fields['_combine_field'][$fid];
$csvifields[$name]['replace'] = $fields['_replace_field'][$fid];
if (!$csvifields[$name]['published']) $name .= ' ('.JText::_('COM_CSVI_FIELD_SKIPPED').')';
$csvilog->addDebug(JText::sprintf('COM_CSVI_IMPORT_FIELD', $name));
}
$csvilog->addDebug(JText::_('COM_CSVI_USE_DATABASE_FOR_CONFIGURATION'));
}
else {
$csvilog->AddStats('incorrect', JText::_('NO_COLUMN_HEADERS_FOUND'));
return false;
}
}
// Make the fields to process global
$jinput->set('csvifields', $csvifields);
return true;
}
/**
* Handle the end of the import
*
* @copyright
* @author RolandD
* @todo Optimize adding ID to session
* @see
* @access private
* @param
* @return
* @since 3.0
*/
public function finishProcess($finished=false) {
$jinput = JFactory::getApplication()->input;
$template = $jinput->get('template', null, null);
$csvifile = $jinput->get('csvifile', null, null);
$csvilog = $jinput->get('csvilog', null, null);
// Adjust the current line, since it is not processing
$jinput->set('currentline', $jinput->get('currentline', 0, 'int')-1);
// Session init
$session = JFactory::getSession();
$option = $jinput->get('option');
if ($finished) {
// Close the file
if (is_object($csvifile)) $csvifile->closeFile(true);
// Clean the session
$this->getCleanSession();
// Add the ID to the session as we need it for the redirect to the result page
$session->set($option.'.run_id', $csvilog->getId());
$jinput->set('run_id', $csvilog->getId());
}
else {
// Flush the log details
// Store the log results first
$log = $this->getModel('log');
$log->getStoreLogResults();
// Create session variables
$session->set($option.'.global.template', serialize($template));
$session->set($option.'.csvicolumnheaders', serialize($jinput->get('columnheaders', null, 'array')));
$session->set($option.'.csvifields', serialize($this->_csvifields));
$session->set($option.'.csvifile', serialize($csvifile));
$session->set($option.'.csvilog', serialize($csvilog));
$session->set($option.'.filepos', serialize($csvifile->getFilePos()));
$session->set($option.'.recordsprocessed', serialize($jinput->get('recordsprocessed', 0, 'int')));
$session->set($option.'.totalline', serialize($jinput->get('currentline', 0, 'int') + $jinput->get('totalline', 0, 'int')));
// Close the file
$csvifile->closeFile(false);
}
}
/**
* Create a proxy for including other models
*
* @copyright
* @author RolandD
* @todo
* @see
* @access protected
* @param
* @return
* @since 3.0
*/
protected function getModel($model) {
return $this->getInstance($model, 'CsviModel');
}
/**
* Load some settings we need for the functions
* This will make the data available to the child product
*
* @copyright
* @author RolandD
* @todo
* @see
* @access private
* @param
* @return
* @since 3.0
*/
protected function loadSettings() {
$jinput = JFactory::getApplication()->input;
// Load the settings
$template = $jinput->get('template', null, null);
$this->_avfields = $jinput->get('avfields', array(), 'array');
$this->_skip_default_value = $template->get('skip_default_value', 'general');
// Set the last field, needed for the combine function
$this->_lastfield = end($jinput->get('csvifields', array(), 'array'));
}
/**
* Load the data to import
*
* @copyright
* @author RolandD
* @todo
* @see
* @access protected
* @param
* @return
* @since 3.4
*/
protected function loadData() {
$jinput = JFactory::getApplication()->input;
$this->csvi_data = $jinput->get('csvi_data', null, null);
}
/**
* Get the product currency from the vendor
*
* If the user does not use product currency we take the one from the current vendor
*
* @copyright
* @author RolandD
* @todo
* @see
* @access private
* @param integer $vendor_id the database ID of the vendor
* @return string the 3 letter product currency
* @since 3.0
*/
protected function productCurrency($vendor_id) {
$jinput = JFactory::getApplication()->input;
$csvilog = $jinput->get('csvilog', null, null);
$csvilog->addDebug(JText::_('COM_CSVI_DEBUG_PRODUCT_CURRENCY'));
if (array_key_exists($vendor_id, $this->_vendor_currencies)) {
$product_currency = strtoupper($this->_vendor_currencies[$vendor_id]);
}
else {
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select('vendor_currency');
$query->from('#__virtuemart_vendors');
$query->where('virtuemart_vendor_id = '.$vendor_id);
$db->setQuery($query);
$product_currency = $db->loadResult();
$csvilog->addDebug(JText::_('COM_CSVI_DEBUG_PRODUCT_CURRENCY'), true);
// Add the vendor currency to the cache
$this->_vendor_currencies[$vendor_id] = $product_currency;
}
return $product_currency;
}
/**
* Validate input data
*
* Checks if the field has a value, if not check if the user wants us to
* use the default value
*
* @copyright
* @author RolandD
* @todo
* @see
* @access protected
* @param string $fieldname the fieldname to validate
* @param int $replaceid the ID of the replacement rule
* @return true returns validated value | return false if the column count does not match
* @since
*/
protected function validateInput($fieldname, $replaceid=null) {
$jinput = JFactory::getApplication()->input;
$csvilog = $jinput->get('csvilog', null, null);
$template = $jinput->get('template', null, null);
$newvalue = '';
// Check if the user wants ICEcat data
if ($template->get('use_icecat', 'product', false, 'bool') && !empty($this->icecat_data) && (array_key_exists($fieldname, $this->icecat_data))) {
$csvilog->addDebug(JText::sprintf('COM_CSVI_USE_ICECAT_FIELD', $fieldname));
$newvalue = $this->icecat_data[$fieldname];
}
else if (isset($this->_csvifields[$fieldname])) {
// Check if the field has a value
if (array_key_exists($this->_csvifields[$fieldname]["order"], $this->csvi_data)
&& strlen($this->csvi_data[$this->_csvifields[$fieldname]["order"]]) > 0) {
$csvilog->addDebug(JText::_('COM_CSVI_USE_FIELD_VALUE'));
$newvalue = trim($this->csvi_data[$this->_csvifields[$fieldname]["order"]]);
}
// Field has no value, check if we can use default value
else if (!$this->_skip_default_value) {
$csvilog->addDebug(JText::_('COM_CSVI_USE_DEFAULT_VALUE'));
$newvalue = $this->_csvifields[$fieldname]["default_value"];
}
else {
$csvilog->addDebug(JText::_('COM_CSVI_USE_NO_VALUE'));
return '';
}
}
else return false;
// Replace the value and return
if (!empty($newvalue) && !empty($replaceid)) return CsviHelper::replaceValue($replaceid, $newvalue);
else return $newvalue;
}
/**
* Replace commas with periods for correct DB insertion of the prices
*
* @copyright
* @author RolandD
* @todo Handle multiple separators by removing them
* @see
* @access protected
* @param string $value the value to clean up
* @return string the cleaned up value with dots as separator
* @since 3.0
*/
protected function toPeriod($value) {
$clean = str_replace(",", ".", $value);
$lastpos = strrpos($clean, '.');
return str_replace('.', '' , substr($clean, 0, $lastpos)).substr($clean, $lastpos);
}
/**
* Format a datetime format
*
* Format of the date is day/month/year or day-month-year.
*
* @copyright
* @author RolandD
* @todo use JDate
* @see
* @access protected
* @param string $date the date to convert
* @return integer UNIX timestamp if date is valid otherwise return 0
* @since
*/
protected function convertDate($date) {
$new_date = preg_replace('/-|\./', '/', $date);
$date_parts = explode('/', $new_date);
if ((count($date_parts) == 3) && ($date_parts[0] > 0 && $date_parts[0] < 32 && $date_parts[1] > 0 && $date_parts[1] < 13 && (strlen($date_parts[2]) == 4))) {
$old_date = mktime(0,0,0,$date_parts[1],$date_parts[0],$date_parts[2]);
}
else $old_date = 0;
$date = JFactory::getDate($old_date);
return $date->toMySQL();
}
/**
* Add the query statistics to the log
*
* @copyright
* @author RolandD
* @todo
* @see
* @access protected
* @param
* @return
* @since 3.0
*/
protected function queryResult() {
$db = JFactory::getDBO();
return substr($db->getQuery(), 0, strpos($db->getQuery(),' '));
}
/**
* Clean up a price to only exist of numbers
*
* @copyright
* @author RolandD
* @todo
* @see
* @access protected
* @param string $price the price to clean
* @return float cleaned up price
* @since
*/
protected function cleanPrice($price) {
return JFilterInput::clean($this->toPeriod($price), 'float');
}
/**
* Load the ICEcat data for a product
*
* @copyright
* @author RolandD
* @todo
* @see
* @access protected
* @param
* @return
* @since 3.0
*/
protected function getIcecat() {
$jinput = JFactory::getApplication()->input;
$template = $jinput->get('template', null, null);
if ($template->get('use_icecat', 'product')) {
$csvilog = $jinput->get('csvilog', null, null);
// Load the ICEcat helper
if (is_null($this->_icecat)) $this->_icecat = new IcecatHelper();
// Clean the data holder
$this->icecat_data = null;
// Check conditions
// 1. Do we have an MPN
$mpn = $this->validateInput($template->get('mpn_column_name', 'product', 'product_sku'));
if ($mpn) {
$csvilog->addDebug(JText::sprintf('COM_CSVI_ICECAT_FOUND_REFERENCE', $mpn));
// 2. Do we have a manufacturer name
$mf_name = $this->validateInput('manufacturer_name');
$csvilog->addDebug(JText::sprintf('COM_CSVI_ICECAT_FOUND_MF_NAME', $mf_name));
if ($mf_name) {
// Load the ICEcat data
$this->icecat_data = $this->_icecat->getData($mpn, $mf_name);
}
else {
$csvilog->addDebug(JText::_('COM_CSVI_ICECAT_NO_MANUFACTURER'));
return false;
}
}
else {
$csvilog->addDebug(JText::_('COM_CSVI_ICECAT_NO_REFERENCE'));
return false;
}
}
return false;
}
/**
* Set a field to combine
*
* @copyright
* @author RolandD
* @todo
* @see
* @access protected
* @param string $data the data to be combined
* @param string $fieldname the name of the current field
* @return
* @since 3.0
*/
protected function setCombineField($data, $fieldname=null) {
if (!empty($data)) {
// Add the data to the array
$this->combine_fields[] = $data;
// Set the fieldname the data is for
if (empty($this->combine_settings['fieldname'])) $this->combine_settings['fieldname'] = $fieldname;
switch ($fieldname) {
case 'category_path':
$jinput = JFactory::getApplication()->input;
$template = $jinput->get('template', null, null);
$this->combine_settings['separator'] = $template->get('category_separator', 'general', '/');
break;
}
}
}
/**
* Get the combined fields
*
* @copyright
* @author RolandD
* @todo
* @see
* @access protected
* @param
* @return string the space separated combined data
* @since 3.0
*/
protected function getCombineField() {
// Get the combined data
$data = implode($this->combine_settings['separator'], $this->combine_fields);
// Empty some settings
$this->combine_fields = array();
$this->combine_settings['fieldname'] = null;
$this->combine_settings['separator'] = ' ';
// Return the data
return $data;
}
}PK >\]L models/about.phpnu W+A getValue('config.tmp_path'), '/');
$folders = array();
$root = JPath::clean(JPATH_ROOT, '/');
$folders[$tmp_path] = JFolder::exists($tmp_path);
$folders[CSVIPATH_TMP] = JFolder::exists(CSVIPATH_TMP);
$folders[CSVIPATH_DEBUG] = JFolder::exists(CSVIPATH_DEBUG);
return $folders;
}
/**
* Create missing folders
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param
* @return
* @since 3.0
*/
public function createFolder() {
$app = JFactory::getApplication();
jimport('joomla.filesystem.folder');
$folder = str_ireplace(JPATH_ROOT, '', JRequest::getVar('folder'));
return JFolder::create($folder);
}
}
?>PK >\4u models/maintenance.phpnu W+A input;
// Start the log
$csvilog = new CsviLog();
$import_id = $csvilog->setId();
$csvilog->SetAction('Maintenance');
$csvilog->SetActionType($jinput->get('task').'_LABEL');
$jinput->set('import_id', $import_id);
$jinput->set('csvilog', $csvilog);
}
/**
* Finish up maintenance
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param
* @return
* @since 3.3
*/
public function getFinishProcess() {
// Load the session data
$jinput = JFactory::getApplication()->input;
// See if we have the csvilog
$csvilog = $jinput->get('csvilog', null, null);
// If not, then check the session
if (empty($csvilog)) {
$session = JFactory::getSession();
$option = $jinput->get('option');
$csvilog = unserialize($session->get($option.'.csvilog'));
$jinput->set('csvilog', $csvilog);
}
// Store the log
$model_log = $this->getModel('log');
$model_log->getStoreLogResults();
}
/**
* Create a proxy for including other models
*
* @copyright
* @author RolandD
* @todo
* @see
* @access protected
* @param
* @return
* @since 3.0
*/
protected function getModel($model) {
return $this->getInstance($model, 'CsviModel');
}
/**
* Empty VirtueMart tables
*
* @copyright
* @author RolandD
* @todo Write out product type tables that get deleted
* @see
* @access public
* @param
* @return
* @since 3.0
*/
public function getEmptyDatabase() {
$jinput = JFactory::getApplication()->input;
$db = JFactory::getDBO();
$csvilog = $jinput->get('csvilog', null, null);
$linenumber = 1;
jimport('joomla.language.helper');
$languages = array_keys(JLanguageHelper::getLanguages('lang_code'));
$tables = $db->getTableList();
// Empty all the necessary tables
$csvilog->setLinenumber($linenumber++);
$q = "TRUNCATE TABLE `#__virtuemart_products`;";
$db->setQuery($q);
$csvilog->addDebug('Empty product table', true);
if ($db->query()) $csvilog->AddStats('empty', JText::_('COM_CSVI_PRODUCT_TABLE_HAS_BEEN_EMPTIED'));
else $csvilog->AddStats('incorrect', JText::_('COM_CSVI_PRODUCT_TABLE_HAS_NOT_BEEN_EMPTIED'));
foreach ($languages as $language) {
$table = $db->getPrefix().'virtuemart_products_'.strtolower(str_replace('-', '_', $language));
if (in_array($table, $tables)) {
$q = "TRUNCATE TABLE ".$db->quoteName($table).";";
$db->setQuery($q);
$csvilog->addDebug('Empty product language table', true);
if ($db->query()) $csvilog->AddStats('empty', JText::sprintf('COM_CSVI_PRODUCT_LANGUAGE_TABLE_HAS_BEEN_EMPTIED', $language));
else $csvilog->AddStats('incorrect', JText::sprintf('COM_CSVI_PRODUCT_LANGUAGE_TABLE_HAS_NOT_BEEN_EMPTIED', $language));
}
}
$csvilog->setLinenumber($linenumber++);
$q = "TRUNCATE TABLE `#__virtuemart_product_categories`;";
$db->setQuery($q);
$csvilog->addDebug('Empty product category link table', true);
if ($db->query()) $csvilog->AddStats('empty', JText::_('COM_CSVI_PRODUCT_CATEGORY_LINK_TABLE_HAS_BEEN_EMPTIED'));
else $csvilog->AddStats('incorrect', JText::_('COM_CSVI_PRODUCT_CATEGORY_LINK_TABLE_HAS_NOT_BEEN_EMPTIED'));
$csvilog->setLinenumber($linenumber++);
$q = "TRUNCATE TABLE `#__virtuemart_product_customfields`;";
$db->setQuery($q);
$csvilog->addDebug('Empty product custom fields table', true);
if ($db->query()) $csvilog->AddStats('empty', JText::_('COM_CSVI_PRODUCT_CUSTOMFIELDS_TABLE_HAS_BEEN_EMPTIED'));
else $csvilog->AddStats('incorrect', JText::_('COM_CSVI_PRODUCT_CUSTOMFIELDS_TABLE_HAS_NOT_BEEN_EMPTIED'));
$csvilog->setLinenumber($linenumber++);
$q = "TRUNCATE TABLE `#__virtuemart_product_downloads`;";
$db->setQuery($q);
$csvilog->addDebug('Empty product downloads table', true);
if ($db->query()) $csvilog->AddStats('empty', JText::_('COM_CSVI_PRODUCT_DOWNLOADS_TABLE_HAS_BEEN_EMPTIED'));
else $csvilog->AddStats('incorrect', JText::_('COM_CSVI_PRODUCT_DOWNLOADS_TABLE_HAS_NOT_BEEN_EMPTIED'));
$csvilog->setLinenumber($linenumber++);
$q = "TRUNCATE TABLE `#__virtuemart_product_manufacturers`;";
$db->setQuery($q);
$csvilog->addDebug('Empty product manufacturer link table', true);
if ($db->query()) $csvilog->AddStats('empty', JText::_('COM_CSVI_PRODUCT_MANUFACTURER_LINK_TABLE_HAS_BEEN_EMPTIED'));
else $csvilog->AddStats('incorrect', JText::_('COM_CSVI_PRODUCT_MANUFACTURER_LINK_TABLE_HAS_NOT_BEEN_EMPTIED'));
$csvilog->setLinenumber($linenumber++);
$q = "TRUNCATE TABLE `#__virtuemart_product_medias`;";
$db->setQuery($q);
$csvilog->addDebug('Empty product medias table', true);
if ($db->query()) $csvilog->AddStats('empty', JText::_('COM_CSVI_PRODUCT_MEDIAS_TABLE_HAS_BEEN_EMPTIED'));
else $csvilog->AddStats('incorrect', JText::_('COM_CSVI_PRODUCT_MEDIAS_TABLE_HAS_NOT_BEEN_EMPTIED'));
$csvilog->setLinenumber($linenumber++);
$q = "TRUNCATE TABLE `#__virtuemart_product_prices`;";
$db->setQuery($q);
$csvilog->addDebug('Empty product price table', true);
if ($db->query()) $csvilog->AddStats('empty', JText::_('COM_CSVI_PRODUCT_PRICE_TABLE_HAS_BEEN_EMPTIED'));
else $csvilog->AddStats('incorrect', JText::_('COM_CSVI_PRODUCT_PRICE_TABLE_HAS_NOT_BEEN_EMPTIED'));
$csvilog->setLinenumber($linenumber++);
$q = "TRUNCATE TABLE `#__virtuemart_product_relations`;";
$db->setQuery($q);
$csvilog->addDebug('Empty product relations table', true);
if ($db->query()) $csvilog->AddStats('empty', JText::_('COM_CSVI_PRODUCT_RELATIONS_TABLE_HAS_BEEN_EMPTIED'));
else $csvilog->AddStats('incorrect', JText::_('COM_CSVI_PRODUCT_RELATIONS_TABLE_HAS_NOT_BEEN_EMPTIED'));
$csvilog->setLinenumber($linenumber++);
$q = "TRUNCATE TABLE `#__virtuemart_product_shoppergroups`;";
$db->setQuery($q);
$csvilog->addDebug('Empty product shoppergroups table', true);
if ($db->query()) $csvilog->AddStats('empty', JText::_('COM_CSVI_PRODUCT_SHOPPERGROUPS_TABLE_HAS_BEEN_EMPTIED'));
else $csvilog->AddStats('incorrect', JText::_('COM_CSVI_PRODUCT_SHOPPERGROUPS_TABLE_HAS_NOT_BEEN_EMPTIED'));
$csvilog->setLinenumber($linenumber++);
$q = "TRUNCATE TABLE `#__virtuemart_categories`;";
$db->setQuery($q);
$csvilog->addDebug('Empty category table', true);
if ($db->query()) $csvilog->AddStats('empty', JText::_('COM_CSVI_CATEGORY_TABLE_HAS_BEEN_EMPTIED'));
else $csvilog->AddStats('incorrect', JText::_('COM_CSVI_CATEGORY_TABLE_HAS_NOT_BEEN_EMPTIED'));
foreach ($languages as $language) {
$table = $db->getPrefix().'virtuemart_categories_'.strtolower(str_replace('-', '_', $language));
if (in_array($table, $tables)) {
$q = "TRUNCATE TABLE ".$db->quoteName($table).";";
$db->setQuery($q);
$csvilog->addDebug('Empty category language table', true);
if ($db->query()) $csvilog->AddStats('empty', JText::sprintf('COM_CSVI_CATEGORY_LANGUAGE_TABLE_HAS_BEEN_EMPTIED', $language));
else $csvilog->AddStats('incorrect', JText::sprintf('COM_CSVI_CATEGORY_LANGUAGE_TABLE_HAS_NOT_BEEN_EMPTIED', $language));
}
}
$csvilog->setLinenumber($linenumber++);
$q = "TRUNCATE TABLE `#__virtuemart_category_categories`;";
$db->setQuery($q);
$csvilog->addDebug('Empty category link table', true);
if ($db->query()) $csvilog->AddStats('empty', JText::_('COM_CSVI_CATEGORY_LINK_TABLE_HAS_BEEN_EMPTIED'));
else $csvilog->AddStats('incorrect', JText::_('COM_CSVI_CATEGORY_LINK_TABLE_HAS_NOT_BEEN_EMPTIED'));
$csvilog->setLinenumber($linenumber++);
$q = "TRUNCATE TABLE `#__virtuemart_category_medias`;";
$db->setQuery($q);
$csvilog->addDebug('Empty category medias table', true);
if ($db->query()) $csvilog->AddStats('empty', JText::_('COM_CSVI_CATEGORY_MEDIAS_TABLE_HAS_BEEN_EMPTIED'));
else $csvilog->AddStats('incorrect', JText::_('COM_CSVI_CATEGORY_MEDIAS_TABLE_HAS_NOT_BEEN_EMPTIED'));
// Get the lowest manufacturer ID
$q = "SELECT MIN(virtuemart_manufacturer_id) AS mf_id FROM ".$db->quoteName('#__virtuemart_manufacturers');
$db->setQuery($q);
$mf_id = $db->loadResult();
// Delete anything higher than the lowest ID
$csvilog->setLinenumber($linenumber++);
$q = "DELETE FROM `#__virtuemart_manufacturers` WHERE virtuemart_manufacturer_id > ".$mf_id;
$db->setQuery($q);
$csvilog->addDebug('Empty manufacturer table', true);
if ($db->query()) $csvilog->AddStats('empty', JText::_('COM_CSVI_MANUFACTURER_TABLE_HAS_BEEN_EMPTIED'));
else $csvilog->AddStats('incorrect', JText::_('COM_CSVI_MANUFACTURER_TABLE_HAS_NOT_BEEN_EMPTIED'));
// Optimize the table
$csvilog->setLinenumber($linenumber++);
$q = "OPTIMIZE TABLE ".$db->quoteName('#__virtuemart_manufacturers');
$db->setQuery($q);
if ($db->query()) $csvilog->AddStats('information', JText::_('COM_CSVI_MANUFACTURER_TABLE_HAS_BEEN_OPTIMIZED'));
else $csvilog->AddStats('incorrect', JText::_('COM_CSVI_MANUFACTURER_TABLE_HAS_NOT_BEEN_OPTIMIZED'));
// Reset the auto increment
$csvilog->setLinenumber($linenumber++);
$q = "ALTER TABLE ".$db->quoteName('#__virtuemart_manufacturers')." AUTO_INCREMENT = ".($mf_id+1);
if ($db->query()) $csvilog->AddStats('information', JText::_('COM_CSVI_MANUFACTURER_AUTO_INCREMENT_RESET'));
else $csvilog->AddStats('incorrect', JText::_('COM_CSVI_MANUFACTURER_AUTO_INCREMENT_NOT_RESET'));
// Store the log count
$linenumber--;
$jinput->set('logcount', $linenumber);
return true;
}
/**
* Optimize CSVI VirtueMart and VirtueMart tables
*
* @todo clean up messages
*/
public function getOptimizeTables() {
$jinput = JFactory::getApplication()->input;
$db = JFactory::getDbo();
$csvilog = $jinput->get('csvilog', null, null);
$linenumber = 1;
$tables = $db->getTableList();
foreach ($tables as $id => $tablename) {
$csvilog->setLinenumber($linenumber++);
$q = "OPTIMIZE TABLE ".$tablename;
$db->setQuery($q);
if ($db->query()) $csvilog->AddStats('information', JText::sprintf('COM_CSVI_TABLE_HAS_BEEN_OPTIMIZED', $tablename));
else $csvilog->AddStats('incorrect', JText::sprintf('COM_CSVI_TABLE_HAS_NOT_BEEN_OPTIMIZED', $tablename));
}
// Store the log count
$linenumber--;
$jinput->set('logcount', $linenumber);
return true;
}
/**
* Add exchange rates
* The eurofxref-daily.xml file is updated daily between 14:15 and 15:00 CET
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param
* @return
* @since 3.0
*/
public function getExchangeRates() {
$jinput = JFactory::getApplication()->input;
$db = JFactory::getDBO();
$csvilog = $jinput->get('csvilog', null, null);
$linenumber = 1;
// Read eurofxref-daily.xml file in memory
$XMLContent= file("http://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml");
// Process the file
if ($XMLContent) {
// Empty table
$q = "TRUNCATE TABLE `#__csvi_currency`;";
$db->setQuery($q);
$db->query();
// Add the Euro
$q = "INSERT INTO #__csvi_currency (currency_code, currency_rate)
VALUES ('EUR', 1)";
$db->setQuery($q);
$db->query();
$currencyCode = array();
$rate = array();
foreach ($XMLContent as $line) {
if (preg_match("/currency='([[:alpha:]]+)'/",$line,$currencyCode)) {
if (preg_match("/rate='([[:graph:]]+)'/",$line,$rate)) {
$csvilog->setLinenumber($linenumber++);
$q = "INSERT INTO #__csvi_currency (currency_code, currency_rate)
VALUES (".$db->Quote($currencyCode[1]).", ".$rate[1].")";
$db->setQuery($q);
if ($db->query()) {
$rate_name = 'COM_CSVI_EXCHANGE_RATE_'.$currencyCode[1].'_ADDED';
$csvilog->AddStats('added', JText::_($rate_name));
}
else $csvilog->AddStats('incorrect', JText::_($rate_name));
}
}
}
}
else $csvilog->AddStats('incorrect', JText::_('COM_CSVI_CANNOT_LOAD_EXCHANGERATE_FILE'));
// Store the log count
$linenumber--;
$jinput->set('logcount', $linenumber);
}
/**
* Remove all categories that have no products
* Parent categories are only deleted if there are no more children left
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param
* @return
* @since 3.0
*/
public function getRemoveEmptyCategories() {
$jinput = JFactory::getApplication()->input;
$db = JFactory::getDBO();
$csvilog = $jinput->get('csvilog', null, null);
$this->getCategoryTreeModule();
$catpaths = $jinput->get('categorypaths', array(), 'array');
arsort($this->_catlevels);
foreach ($this->_catlevels as $catid => $nrlevels) {
// Check if there are any products in the category
$db->setQuery($this->getCatQuery($catid));
if ($db->loadResult() > 0 && array_key_exists($catid, $catpaths)) {
foreach ($catpaths[$catid] as $key => $level) {
unset($catpaths[$level]);
unset($this->_catlevels[$level]);
}
unset($catpaths[$catid]);
unset($this->_catlevels[$catid]);
}
else {
if (array_key_exists($catid, $catpaths)) {
foreach ($catpaths[$catid] as $key => $level) {
$db->setQuery($this->getCatQuery($level));
if ($db->loadResult() > 0) {
unset($catpaths[$level]);
unset($this->_catlevels[$level]);
}
}
}
}
}
$delcats = array_keys($catpaths);
if (!empty($delcats)) {
// Remove all categories except the ones we have
$q = "DELETE FROM #__vm_category
WHERE category_id IN (".implode(', ', $delcats).")";
$db->setQuery($q);
if ($db->query()) $csvilog->AddStats('deleted', JText::_('COM_CSVI_MAINTENANCE_CATEGORIES_DELETED'));
else $csvilog->AddStats('incorrect', JText::_('COM_CSVI_MAINTENANCE_CATEGORIES_NOT_DELETED'));
// Remove all category parent-child relations except the ones we have
$q = "DELETE FROM #__vm_category_xref
WHERE category_child_id IN (".implode(', ', $delcats).")";
$db->setQuery($q);
if ($db->query()) $csvilog->AddStats('deleted', JText::_('COM_CSVI_MAINTENANCE_CATEGORIES_XREF_DELETED'));
else $csvilog->AddStats('incorrect', JText::_('COM_CSVI_MAINTENANCE_CATEGORIES_XREF_NOT_DELETED'));
}
else $csvilog->AddStats('information', JText::_('COM_CSVI_NO_CATEGORIES_FOUND'));
}
/**
* Construct a query to count the number of references to a category
*
* @copyright
* @author RolandD
* @todo
* @see
* @access private
* @param
* @return string the query to count entries in a category
* @since 3.0
*/
private function getCatQuery($catid) {
return "SELECT COUNT(*)
FROM #__vm_product_category_xref
WHERE category_id = ".$catid;
}
/**
* Clean the CSVI cache
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param
* @return
* @since 3.0
*/
public function getCleanTemp() {
jimport('joomla.filesystem.file');
jimport('joomla.filesystem.folder');
$jinput = JFactory::getApplication()->input;
$db = JFactory::getDBO();
$csvilog = $jinput->get('csvilog', null, null);
$folder = CSVIPATH_TMP;
if (JFolder::exists($folder)) {
// Delete all import files left behind in the folder
JFile::delete(JFolder::files($folder, '.', false, true));
// Delete all import folders left behind in the folder
$folders = array();
$folders = JFolder::folders($folder, '.', true, true, array('debug'));
if (!empty($folders)) {
foreach ($folders as $path) {
JFolder::delete($path);
}
}
// Load the files
if (JFolder::exists(CSVIPATH_DEBUG)) {
$files = JFolder::files(CSVIPATH_DEBUG, '.', false, true);
if ($files) {
// Remove any debug logs that are still there but not in the database
$q = "SELECT CONCAT(".$db->Quote(CSVIPATH_DEBUG.'/com_csvi.log.').", import_id, '.php') AS filename
FROM #__csvi_logs
WHERE import_id > 0
GROUP BY import_id";
$db->setQuery($q);
$ids = $db->loadResultArray();
if (!is_array($ids)) $ids = (array)$ids;
// Delete all obsolete files
JFile::delete(array_diff($files, $ids));
}
}
$csvilog->AddStats('deleted', JText::_('COM_CSVI_TEMP_CLEANED'));
}
else $csvilog->AddStats('information', JText::_('COM_CSVI_TEMP_PATH_NOT_FOUND'));
}
/**
* Export all VirtueMart tables
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param
* @return
* @since 3.0
*/
public function getBackupVirtueMart() {
jimport('joomla.filesystem.file');
jimport('joomla.filesystem.folder');
$jinput = JFactory::getApplication()->input;
$db = JFactory::getDBO();
$csvilog = $jinput->get('csvilog', null, null);
$filepath = JPATH_SITE.'/tmp/com_csvi';
$filename = 'virtuemart_'.time().'.sql';
$file = $filepath.'/'.$filename;
$sqlstring = '';
$fp = fopen($file, "w+");
if ($fp) {
// Load a list of VirtueMart tables
$q = "SHOW TABLES LIKE '".$db->getPrefix()."virtuemart\_%'";
$db->setQuery($q);
$tables = $db->loadResultArray();
$linenumber = 1;
foreach ($tables as $table) {
$csvilog->setLinenumber($linenumber);
// Get the create table statement
$q = "SHOW CREATE TABLE ".$table;
$db->setQuery($q);
$tcreate = $db->loadAssocList();
$sqlstring .= "-- Table structure for table ".$db->quoteName($table)."\n\n";
$sqlstring .= $tcreate[0]['Create Table'].";\n\n";
// Check if there is any data in the table
$q = "SELECT COUNT(*) FROM ".$db->quoteName($table);
$db->setQuery($q);
$count = $db->loadResult();
if ($count > 0) {
$sqlstring .= "-- Data for table ".$db->quoteName($table)."\n\n";
// Get the field names
$q = "SHOW COLUMNS FROM ".$db->quoteName($table);
$db->setQuery($q);
$fields = $db->loadObjectList();
$sqlstring .= 'INSERT INTO '.$db->quoteName($table).' (';
foreach ($fields as $field) {
$sqlstring .= $db->quoteName($field->Field).',';
}
$sqlstring = substr(trim($sqlstring), 0, -1).") VALUES \n";
$start = 0;
while ($count > 0) {
$q = "SELECT * FROM ".$table." LIMIT ".$start.", 50";
$db->setQuery($q);
$records = $db->loadAssocList();
// Add the values
foreach ($records as $record) {
foreach ($record as $rkey => $value) {
if (!is_numeric($value)) $record[$rkey] = $db->Quote($value);
else $record[$rkey] = $value;
}
$sqlstring .= '('.implode(',', $record)."),\n";
}
$start += 50;
$count -= 50;
// Fix the end of the query
if ($count < 1) $sqlstring = substr(trim($sqlstring), 0, -1).";\n";
// Add a linebreak
$sqlstring .= "\n\n";
// Write the data to the file
fwrite($fp, $sqlstring);
// Empty the string
$sqlstring = '';
}
// Update the log
$csvilog->AddStats('added', JText::sprintf('COM_CSVI_BACKUP_COMPLETE_FOR', $table));
$linenumber++;
}
}
// Store the log count
$linenumber--;
$jinput->set('logcount', $linenumber);
// Zip up the file
jimport('joomla.filesystem.archive');
$zip = JArchive::getAdapter('zip');
$files = array();
$files[] = array('name' => $filename, 'time' => filemtime($file), 'data' => JFile::read($file));
if ($zip->create($filepath.'/'.$filename.'.zip', $files)) {
// Close the file
fclose($fp);
// Remove the SQL file
JFile::delete($file);
// Add a download link for the backup
$csvilog->setFilename(JHTML::link(JURI::root().'tmp/com_csvi/'.$filename.'.zip', JText::_('COM_CSVI_BACKUP_DOWNLOAD_LINK')));
}
else {
$csvilog->AddStats('incorrect', JText::_('COM_CSVI_BACKUP_NO_ZIP_CREATE'));
$csvilog->setFilename($filepath.'/'.$filename);
}
}
else {
$csvilog->AddStats('incorrect', JText::sprintf('COM_CSVI_COULD_NOT_OPEN_FILE', $file));
}
}
/**
* This function is repsonsible for returning an array containing category information
*
* @copyright
* @author RolandD
* @todo
* @see
* @access private
* @param
* @return
* @since 2.3.6
*/
private function getCategoryTreeModule() {
$database = JFactory::getDBO();
// Get all categories
$query = "SELECT category_child_id AS cid, category_parent_id AS pid
FROM #__vm_category, #__vm_category_xref
WHERE #__vm_category.category_id=#__vm_category_xref.category_child_id";
// Execute the query
$database->setQuery( $query );
$records = $database->loadObjectList();
// Check if there are any records
if (count($records[0]) == 0) {
$this->_categories = false;
return false;
}
else {
$this->_categories = array();
// Group all categories together according to their level
foreach( $records as $id => $record ) {
$this->_categories[$record->pid][$record->cid]["category_id"] = $record->pid;
$this->_categories[$record->pid][$record->cid]["category_child_id"] = $record->cid;
}
}
$this->CategoryPaths();
}
/**
* Create an array of subcategories per category
*
* @author RolandD
* @since 2.3.6
* @access private
*/
private function CategoryPaths() {
$catpath = array();
krsort($this->_categories);
foreach ($this->_categories as $pid => $categories) {
foreach ($categories as $cid => $category) {
$catpath[$cid] = $pid;
}
}
foreach ($catpath as $cid => $value) {
$catlevel = $value;
$this->_catpaths[$cid][] = $catlevel;
while ($catlevel > 0) {
$this->_catpaths[$cid][] = $catpath[$catlevel];
$catlevel = $catpath[$catlevel];
}
}
foreach ($this->_catpaths as $cid => $paths) {
$this->_catlevels[$cid] = count($paths);
}
asort($this->_catlevels);
$jinput->set('categorypaths', $this->_catpaths);
}
/**
* Load the ICEcat index file
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param
* @return bool true if index file is loaded | false if index file is not loaded
* @since 3.0
*/
public function getIcecatIndex() {
$jinput = JFactory::getApplication()->input;
$db = JFactory::getDbo();
$csvilog = $jinput->get('csvilog', null, null);
$settings = $jinput->get('settings', null, null);
$username = $settings->get('icecat.ice_username', false);
$password = $settings->get('icecat.ice_password', false);
$loadremote_index = false;
$loadremote_supplier = false;
$icecat_options = $jinput->get('icecat', array(), null);
if (in_array('icecat_index', $icecat_options)) $load_index = true;
else $load_index = false;
if (in_array('icecat_supplier', $icecat_options)) $load_supplier = true;
else $load_supplier = false;
// Should we load the index file in 1 go
$loadtype = JRequest::getBool('loadtype');
// What to do next?
$result = 'full';
// Check if we have a username and password
if ($username && $password) {
// Joomla includes
jimport('joomla.filesystem.folder');
jimport('joomla.filesystem.file');
jimport('joomla.filesystem.archive');
// Check if the files are stored on the server
$location = JRequest::getVar('icecatlocation');
if ($load_index) {
if (JFile::exists($location.'/icecat_index')) $icecat_index_file = $location.'/icecat_index';
else if (JFile::exists($location.'/icecat_index.gzip')) $icecat_index_file = $location.'/icecat_index.gzip';
else if (JFile::exists($location.'/icecat_index.zip')) $icecat_index_file = $location.'/icecat_index.zip';
else $loadremote_index = true;
}
if ($load_supplier) {
if (JFile::exists($location.'/icecat_supplier')) $icecat_supplier_file = $location.'/icecat_supplier';
else if (JFile::exists($location.'/icecat_supplier.gzip')) $icecat_supplier_file = $location.'/icecat_supplier.gzip';
else if (JFile::exists($location.'/icecat_supplier.zip')) $icecat_supplier_file = $location.'/icecat_supplier.zip';
else $loadremote_supplier = true;
}
// Load the remote files if needed
if ($loadremote_index || $loadremote_supplier) {
// Context for retrieving files
if (JRequest::getBool('icecat_gzip')) $gzip = "Accept-Encoding: gzip\r\n";
else $gzip = '';
$context = stream_context_create(array(
'http' => array(
'header' => "Authorization: Basic " . base64_encode($username.':'.$password)."\r\n".
$gzip
)
));
if ($load_index && $loadremote_index) {
// ICEcat index file
$icecat_url = $settings->get('icecat.ice_index', 'http://data.icecat.biz/export/freexml.int/INT/files.index.csv');
// Load the index file from the ICEcat server to a local file
$icecat_index_file = CSVIPATH_TMP.'/icecat_index';
if (JRequest::getBool('icecat_gzip')) $icecat_index_file .= '.gzip';
$fp_url = fopen($icecat_url, 'r', false, $context);
$fp_local = fopen($icecat_index_file, 'w+');
while($content = fread($fp_url,1024536)){
fwrite($fp_local, $content);
}
fclose($fp_url);
fclose($fp_local);
}
if ($load_supplier && $loadremote_supplier) {
// Load the manufacturer data
$icecat_mf = $settings->get('icecat.ice_supplier', 'http://data.icecat.biz/export/freexml.int/INT/supplier_mapping.xml');
// Load the index file from the ICEcat server to a local file
$icecat_supplier_file = CSVIPATH_TMP.'/icecat_supplier';
if (JRequest::getBool('icecat_gzip')) $icecat_supplier_file .= '.gzip';
$fp_url = fopen($icecat_mf, 'r', false, $context);
$fp_local = fopen($icecat_supplier_file, 'w+');
while($content = fread($fp_url,1024536)){
fwrite($fp_local, $content);
}
fclose($fp_url);
fclose($fp_local);
}
}
// Check if we need to unpack the files
if ($load_index) {
if (substr($icecat_index_file, -3) == 'zip') {
if (!$this->_unpack($icecat_index_file, CSVIPATH_TMP)) {
$csvilog->AddStats('incorrect', JText::_('COM_CSVI_ICECAT_INDEX_NOT_UNPACKED'));
return 'cancel';
}
else $icecat_index_file = CSVIPATH_TMP.'/icecat_index';
}
}
if ($load_supplier) {
if (substr($icecat_supplier_file, -3) == 'zip') {
if (!$this->_unpack($icecat_supplier_file, CSVIPATH_TMP)) {
$csvilog->AddStats('incorrect', JText::_('COM_CSVI_ICECAT_SUPPLIER_NOT_UNPACKED'));
return 'cancel';
}
else $icecat_supplier_file = CSVIPATH_TMP.'/icecat_supplier';
}
}
if ($load_index) {
// Empty the index table
$q = "TRUNCATE TABLE ".$db->quoteName('#__csvi_icecat_index');
$db->setQuery($q);
$db->query();
// Load the local file into the database
if (!$loadtype) {
$q = "LOAD DATA LOCAL INFILE ".$db->Quote($icecat_index_file)."
INTO TABLE ".$db->quoteName('#__csvi_icecat_index')."
IGNORE 1 LINES";
$db->setQuery($q);
if ($db->query()) $csvilog->AddStats('added', JText::_('COM_CSVI_ICECAT_INDEX_LOADED'));
else $csvilog->AddStats('incorrect', JText::sprintf('COM_CSVI_ICECAT_INDEX_NOT_LOADED', $db->getErrorMsg()));
}
else {
// Need to redirect for the batch import
$result = 'single';
}
}
if ($load_supplier) {
// Empty the supplier table
$q = "TRUNCATE TABLE ".$db->quoteName('#__csvi_icecat_suppliers');
$db->setQuery($q);
$db->query();
// Reset the supplier file
$xmlstr = file_get_contents($icecat_supplier_file);
$xml = new SimpleXMLElement($xmlstr);
$supplier_data = array();
foreach ($xml->SupplierMappings->children() as $key => $mapping) {
foreach ($mapping->attributes() as $attr_name => $attr_value) {
switch($attr_name) {
case 'supplier_id':
$supplier_id = $attr_value;
break;
case 'name':
$supplier_data[] = '('.$db->Quote($supplier_id).','.$db->Quote($attr_value).')';
}
}
foreach ($mapping->children() as $symbol) {
$supplier_data[] = '('.$db->Quote($supplier_id).','.$db->Quote($symbol).')';
}
}
$q = "INSERT IGNORE INTO ".$db->quoteName('#__csvi_icecat_suppliers')."
VALUES ".implode(',', $supplier_data);
$db->setQuery($q);
if ($db->query()) $csvilog->AddStats('added', JText::_('COM_CSVI_ICECAT_SUPPLIERS_LOADED'));
else $csvilog->AddStats('incorrect', JText::sprintf('COM_CSVI_ICECAT_SUPPLIERS_NOT_LOADED', $db->getErrorMsg()));
}
}
else {
$csvilog->AddStats('incorrect', JText::_('COM_CSVI_ICECAT_NO_USER_PASS'));
}
// See if we need to store some info
if ($loadtype) {
// Session init
$session = JFactory::getSession();
$option = JRequest::getVar('option');
$session->set($option.'.csvilog', serialize($csvilog));
$session->set($option.'.icecat_index_file', serialize($icecat_index_file));
$session->set($option.'.icecat_records', serialize(JRequest::getInt('icecat_records')));
$session->set($option.'.icecat_wait', serialize(JRequest::getInt('icecat_wait')));
}
return $result;
}
/**
* Load the ICEcat index in batches
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param
* @return
* @since 3.3
*/
public function getIcecatSingle() {
$jinput = JFactory::getApplication()->input;
// Session init
$session = JFactory::getSession();
$option = $jinput->get('option');
$csvilog = unserialize($session->get($option.'.csvilog'));
$icecat_index_file = unserialize($session->get($option.'.icecat_index_file'));
$totalrow = unserialize($session->get($option.'.icecat_rows'));
$records = unserialize($session->get($option.'.icecat_records', 1000));
$finished = false;
$continue = true;
// Sleep to please the server
sleep(unserialize($session->get($option.'.icecat_wait', 5)));
// Load the records line by line
$db = JFactory::getDBO();
$q = "INSERT INTO `#__csvi_icecat_index` (`path`, `product_id`, `updated`, `quality`, `supplier_id`, `prod_id`, `catid`, `m_prod_id`, `ean_upc`, `on_market`, `country_market`, `model_name`, `product_view`, `high_pic`, `high_pic_size`, `high_pic_width`, `high_pic_height`, `m_supplier_id`, `m_supplier_name`) VALUES ";
$lines = '';
if (($handle = fopen($icecat_index_file, "r")) !== FALSE) {
// Position pointers
$row = 0;
// Position file pointer
$pointer = unserialize($session->get($option.'.icecat_position'));
fseek($handle, $pointer);
// Start processing
while ($continue) {
if ($row < $records) {
$data = fgetcsv($handle, 1024, "\t");
if ($data) {
$row++;
$lines .= '(';
foreach ($data as $item) {
$lines .= $db->Quote($item).',';
}
$lines = substr($lines, 0, -1);
$lines .= '),';
}
else {
$finished = true;
$continue = false;
}
}
else $continue = false;
}
// Store the data
$lines = substr($lines, 0, -1);
$db->setQuery($q.$lines);
$db->query();
// Information for reload
$jinput->set('finished', $finished);
$sumrows = $totalrow+$row;
$jinput->set('linesprocessed', $sumrows);
// Store for future use
if (!$finished) {
$session->set($option.'.csvilog', serialize($csvilog));
$session->set($option.'.icecat_rows', serialize($sumrows));
$session->set($option.'.icecat_position', serialize(ftell($handle)));
}
else {
$csvilog->AddStats('added', JText::_('COM_CSVI_ICECAT_INDEX_LOADED'));
// Store the log results
$jinput->set('csvilog', $csvilog);
$this->getFinishProcess();
// Clear the session
$session->set($option.'.icecat_index_file', serialize('0'));
$session->set($option.'.icecat_rows', serialize('0'));
$session->set($option.'.icecat_position', serialize('0'));
$session->set($option.'.icecat_records', serialize('0'));
$session->set($option.'.icecat_wait', serialize('0'));
$session->set($option.'.csvilog', serialize('0'));
// Set the run ID
$jinput->set('run_id', $csvilog->getId());
}
fclose($handle);
}
}
/**
* Unpack the ICEcat index files
*
* @copyright
* @author RolandD
* @todo
* @see
* @access private
* @param string $archivename the full path and name of the file to extract
* @param string $extractdir the folder to copy the extracted file to
* @return bool true on success | false on failure
* @since 3.0
*/
private function _unpack($archivename, $extractdir) {
$adapter = JArchive::getAdapter('gzip');
if ($adapter)
{
$config = JFactory::getConfig();
$tmpfname = $config->getValue('config.tmp_path').'/'.uniqid('gzip');
$gzresult = $adapter->extract($archivename, $tmpfname);
if (JError::isError($gzresult))
{
@unlink($tmpfname);
return false;
}
$path = JPath::clean($extractdir);
JFolder::create($path);
$result = JFile::copy($tmpfname,$path.'/'.JFile::stripExt(basename(strtolower($archivename))));
@unlink($tmpfname);
}
return true;
}
/**
* Backup templates
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param
* @return
* @since 3.0
*/
public function getBackupTemplates() {
$jinput = JFactory::getApplication()->input;
$db = JFactory::getDBO();
$csvilog = $jinput->get('csvilog', null, null);
$linenumber = 1;
// Create the backup file
$filepath = JPATH_SITE.$jinput->get('backup_location', '/tmp/com_csvi', 'string');
$filename = 'csvi_templates_'.date('Ymd', time()).'.csv';
$file = JPath::clean($filepath.'/'.$filename, '/');
$fp = fopen($file, "w+");
if ($fp) {
$db->setQuery("SELECT ".$db->quoteName('name').", ".$db->quoteName('settings')." FROM #__csvi_template_settings");
$templates = $db->loadAssocList();
foreach ($templates as $template) {
$csvilog->setLinenumber($linenumber++);
if (fputcsv($fp, $template)) $csvilog->AddStats('information', JText::sprintf('COM_CSVI_BACKUP_TEMPLATE', $template['name']));
else $csvilog->AddStats('incorrect', JText::sprintf('COM_CSVI_BACKUP_NO_TEMPLATE', $template['name']));
}
fclose($fp);
$csvilog->AddStats('information', JText::sprintf('COM_CSVI_BACKUP_TEMPLATE_PATH', $file));
}
else {
$csvilog->AddStats('incorrect', JText::sprintf('COM_CSVI_COULD_NOT_OPEN_FILE', $file));
}
// Store the log count
$linenumber--;
$jinput->set('logcount', $linenumber);
}
/**
* Restore templates
*
* @copyright
* @author RolandD
* @todo Remove JRequest once jinput can handle files
* @see
* @access public
* @param
* @return
* @since 3.0
*/
public function getRestoreTemplates() {
$jinput = JFactory::getApplication()->input;
$db = JFactory::getDBO();
$csvilog = $jinput->get('csvilog', null, null);
$linenumber = 1;
jimport('joomla.filesystem.file');
// Load the restore file
$upload = JRequest::getVar('restore_file', '', 'files');
if (empty($upload) || $upload['error'] > 0) $upload = JRequest::getVar('file', '', 'files');
// Check if the file upload has an error
if (empty($upload)) {
$csvilog->AddStats('incorrect', JText::_('COM_CSVI_NO_UPLOADED_FILE_PROVIDED'));
return false;
}
else if ($upload['error'] == 0) {
if (is_uploaded_file($upload['tmp_name'])) {
// Get some basic info
$folder = CSVIPATH_TMP.'/'.time();
$upload_parts = pathinfo($upload['name']);
// Create the temp folder
if (JFolder::create($folder)) {
$this->folder = $folder;
// Move the uploaded file to its temp location
if (JFile::upload($upload['tmp_name'], $folder.'/'.$upload['name'])) {
// Read the uploaded file
$fp = fopen($folder.'/'.$upload['name'], "r");
if ($fp) {
while (($data = fgetcsv($fp, 0, ",")) !== FALSE) {
$csvilog->setLinenumber($linenumber++);
$db->setQuery("INSERT IGNORE INTO #__csvi_template_settings (".$db->quoteName('name').", ".$db->quoteName('settings').")
VALUES (".$db->Quote($data[0]).", ".$db->Quote($data[1]).")");
if ($db->query()) {
$csvilog->AddStats('added', JText::sprintf('COM_CSVI_RESTORE_TEMPLATE', $data[0]));
}
else {
$csvilog->AddStats('incorrect', JText::sprintf('COM_CSVI_NO_RESTORE_TEMPLATE', $data[0]));
$csvilog->AddStats('incorrect', $db->getQuery());
}
}
fclose($fp);
}
}
}
else {
$csvilog->AddStats('incorrect', JText::sprintf('COM_CSVI_CANNOT_CREATE_UNPACK_FOLDER', $folder));
return false;
}
}
// Error warning cannot save uploaded file
else {
$csvilog->AddStats('incorrect', JText::sprintf('COM_CSVI_NO_UPLOADED_FILE_PROVIDED', $upload['tmp_name']));
return false;
}
}
// Store the log count
$linenumber--;
$jinput->set('logcount', $linenumber);
}
/**
* Unpublish products in unpublished categories
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param
* @return
* @since 3.5
*/
public function getUnpublishProductByCategory() {
$jinput = JFactory::getApplication()->input;
$csvilog = $jinput->get('csvilog', null, null);
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select($db->quoteName('p').'.'.$db->quoteName('virtuemart_product_id'));
$query->from($db->quoteName('#__virtuemart_products').' AS p');
$query->innerJoin($db->quoteName('#__virtuemart_product_categories').' AS pc ON '.$db->quoteName('p').'.'.$db->quoteName('virtuemart_product_id').' = '.$db->quoteName('pc').'.'.$db->quoteName('virtuemart_product_id'));
$query->innerJoin($db->quoteName('#__virtuemart_categories').' AS c ON '.$db->quoteName('pc').'.'.$db->quoteName('virtuemart_category_id').' = '.$db->quoteName('c').'.'.$db->quoteName('virtuemart_category_id'));
$query->where($db->quoteName('p').'.'.$db->quoteName('published').' = '.$db->quote('1'));
$query->where($db->quoteName('c').'.'.$db->quoteName('published').' = '.$db->quote('0'));
// Get the IDs to unpublish
$q = "SELECT #__vm_product.product_id
FROM #__vm_product
INNER JOIN #__vm_product_category_xref
ON #__vm_product.product_id = #__vm_product_category_xref.product_id
INNER JOIN #__vm_category
ON #__vm_product_category_xref.category_id = #__vm_category.category_id
WHERE #__vm_product.product_publish = 'Y'
AND #__vm_category.category_publish = 'N'";
$db->setQuery($query);
$ids = $db->loadResultArray();
if (!empty($ids)) {
// Unpublish the IDs
$query = $db->getQuery(true);
$query->update($db->quoteName('#__virtuemart_products'));
$query->set($db->quoteName('published').' = '.$db->quote('0'));
$query->where($db->quoteName('virtuemart_product_id').' IN ('.implode(',', $ids).')');
$q = "UPDATE #__vm_product SET product_publish = 'N' WHERE product_id IN (".implode(',', $ids).")";
$db->setQuery($query);
if ($db->query()) {
$csvilog->AddStats('updated', JText::sprintf('COM_CSVI_PRODUCTS_UNPUBLISHED', $db->getAffectedRows()));
}
else {
$csvilog->AddStats('incorrect', JText::sprintf('COM_CSVI_PRODUCTS_NOT_UNPUBLISHED', $db->getErrorMsg()));
}
}
else $csvilog->AddStats('information', JText::_('COM_CSVI_PRODUCTS_NOT_FOUND'));
}
/**
* Get a list of available components
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param
* @return
* @since 4.0
*/
public function getComponents() {
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select('component AS value, component AS text');
$query->from($db->quoteName('#__csvi_template_types'));
$query->leftJoin('#__extensions ON #__csvi_template_types.component = #__extensions.element');
$query->where('#__extensions.type = '.$db->Quote('component'));
$query->group('component');
$db->setQuery($query);
$components = $db->loadObjectList();
$options = JHtml::_('select.option', '', JText::_('COM_CSVI_MAKE_CHOICE'), 'value', 'text', true);
array_unshift($components, $options);
return $components;
}
/**
* Sorts all VirtueMart categories in alphabetical order
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param
* @return bool true if categories are sorted | false if an error occured
* @since 3.0
*/
public function getSortCategories() {
$jinput = JFactory::getApplication()->input;
$db = JFactory::getDbo();
$csvilog = $jinput->get('csvilog', null, null);
$language = $jinput->get('language');
$linenumber = 1;
// Check if the table exists
$tables = $db->getTableList();
if (!in_array($db->getPrefix().'virtuemart_categories_'.$language, $tables)) {
$csvilog->AddStats('information', JText::sprintf('COM_CSVI_LANG_TABLE_NOT_EXIST', $language));
}
else {
// Get all categories
$query = $db->getQuery(true);
$query->select('LOWER('.$db->quoteName('category_name').') AS '.$db->quoteName('category_name'));
$query->select($db->quoteName('category_child_id').' AS '.$db->quoteName('cid'));
$query->select($db->quoteName('category_parent_id').' AS '.$db->quoteName('pid'));
$query->from($db->quoteName('#__virtuemart_categories').' AS '.$db->quoteName('c'));
$query->leftJoin($db->quoteName('#__virtuemart_category_categories').' AS '.$db->quoteName('cc').' ON '.$db->quoteName('c').'.'.$db->quoteName('virtuemart_category_id').' = '.$db->quoteName('cc').'.'.$db->quoteName('category_child_id'));
$query->leftJoin($db->quoteName('#__virtuemart_categories_'.$language).' AS '.$db->quoteName('cl').' ON '.$db->quoteName('cc').'.'.$db->quoteName('category_child_id').' = '.$db->quoteName('cl').'.'.$db->quoteName('virtuemart_category_id'));
// Execute the query
$db->setQuery($query);
$records = $db->loadObjectList();
if (count($records) > 0) {
$categories = array();
// Group all categories together according to their level
foreach ($records as $key => $record) {
$categories[$record->pid][$record->cid] = $record->category_name;
}
// Sort the categories and store the item list
foreach ($categories as $id => $category) {
asort($category);
$listorder = 1;
foreach ($category as $category_id => $category_name) {
// Store the new sort order
$query = $db->getQuery(true);
$query->update($db->quoteName('#__virtuemart_categories'));
$query->set($db->quoteName('ordering').' = '.$db->quote($listorder));
$query->where($db->quoteName('virtuemart_category_id').' = '.$db->quote($category_id));
$db->setQuery($query);
$db->query();
// Set the line number
$csvilog->setLinenumber($linenumber++);
$csvilog->AddStats('information', JText::sprintf('COM_CSVI_SAVED_CATEGORY', $category_name ,$listorder));
$listorder++;
}
}
// Store the log count
$linenumber--;
$jinput->set('logcount', $linenumber);
}
else $csvilog->AddStats('information', 'COM_CSVI_NO_CATEGORIES_FOUND');
}
return true;
}
/**
* Create a list of maintenance options
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param
* @return array of available options
* @since 4.0
*/
public function getMaintenanceOptions() {
$options = array();
$options[] = JHtml::_('select.option', '', JText::_('COM_CSVI_MAKE_CHOICE'), 'value', 'text', true);
return $options;
}
/**
* Load the languages in the system
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param
* @return array of available languages
* @since 4.0
*/
public function getLanguages() {
$language = JFactory::getLanguage();
$known = $language->getKnownLanguages();
$options = array();
foreach ($known as $tag => $lang) {
$options[] = JHtml::_('select.option', str_replace('-', '_', strtolower($lang['tag'])), $lang['name']);
}
return $options;
}
/**
* Get operations for a selected component
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param
* @return
* @since 4.0
*/
public function getOperations() {
$jinput = JFactory::getApplication()->input;
$component = $jinput->get('component');
$options = '';
switch ($component) {
case 'com_csvi':
$options .= '';
$options .= '';
$options .= '';
$options .= '';
$options .= '';
$options .= '';
$options .= '';
break;
case 'com_virtuemart':
$options .= '';
$options .= '';
$options .= '';
$options .= '';
$options .= '';
$options .= '';
break;
default:
$options .= '';
break;
}
// Return the output
return $options;
}
}
?>PK >\ZH H models/templates.phpnu W+A setQuery($q);
$templates = $db->loadObjectList();
if (!is_array($templates)) $templates = array();
$new = array();
$new[] = JHtml::_('select.option', '', JText::_('COM_CSVI_SAVE_AS_NEW_FOR_NEW_TEMPLATE'));
$templates = array_merge($new, $templates);
return $templates;
}
/**
* Save export settings
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param array $data the data to be stored
* @return bool true on success | false on failure
* @since 3.0
*/
public function save($data) {
$app = JFactory::getApplication();
$jinput = JFactory::getApplication()->input;
$table = $this->getTable('csvi_template_settings');
$bind = array();
$id = $jinput->get('template_id', 0, 'int');
if ($id > 0) $table->load($id);
else $bind['name'] = $jinput->get('template_name', 'Template '.time(), 'string');
$bind['settings'] = json_encode($data);
$table->bind($bind);
if ($table->store()) {
$app->enqueueMessage(JText::sprintf('COM_CSVI_PROCESS_SETTINGS_SAVED', $table->name));
}
else {
$app->enqueueMessage(JText::sprintf('COM_CSVI_PROCESS_SETTINGS_NOT_SAVED', $table->getError()), 'error');
}
return $table->id;
}
/**
* Remove a settings template
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param array $data the data to be stored
* @return bool true on success | false on failure
* @since 3.0
*/
public function remove() {
$app = JFactory::getApplication();
$jinput = JFactory::getApplication()->input;
$table = $this->getTable('csvi_template_settings');
$table->load($jinput->get('template_id', null, 'int'));
if ($table->delete()) {
$app->enqueueMessage(JText::sprintf('COM_CSVI_PROCESS_SETTINGS_DELETED', $table->name));
}
else {
$app->enqueueMessage(JText::sprintf('COM_CSVI_PROCESS_SETTINGS_NOT_DELETED', $table->getError()), 'error');
}
}
/**
* Get the template details
*
* Retrieves the template details from the csvi_templates table. If the
* template id is 0, it will automatically retrieve the template details
* for the template with the lowest ID in the database
*
* @see self::GetFirstTemplateId();
* @param $templateid integer Template ID to retrieve
*/
public function _getTemplate() {
$row = $this->getTable($this->_tablename);
if ($this->_id == 0) {
$this_id = $this->GetFirstTemplateId();
}
$row->load($this->_id);
// Fix the price format
$row->export_price_formats = self::getNumberFormat($row->export_price_format);
return $row;
}
/**
* Load the template types based on type
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param string $type The type of template to filter on
* @return array list of template types
* @since 3.0
*/
function getTemplateTypes($type=false, $component=false) {
$db = JFactory::getDBO();
$q = "SELECT CONCAT('COM_CSVI_', UPPER(template_type_name)) AS name, template_type_name AS value
FROM #__csvi_template_types ";
// Check any selectors
$selectors = array();
if ($type) $selectors[] = "template_type = ".$db->Quote($type);
if ($component) $selectors[] = "component = ".$db->Quote($component);
if (!empty($selectors)) $q .= "WHERE ".implode(' AND ', $selectors);
// Order by name
$q .= " ORDER BY template_type_name";
$db->setQuery($q);
$types = $db->loadObjectList();
// Translate the strings
foreach ($types as $key => $type) {
$type->value = JText::_($type->value);
$types[$key] = $type;
}
return $types;
}
}
?>PK >\E E models/log.phpnu W+A setState('filter.action', $app->getUserStateFromRequest($this->_context.'.filter.action', 'filter_actiontype', false, 'word'));
// List state information.
// Controls the query ORDER BY
parent::populateState('l.logstamp', 'desc');
}
/**
* Build an SQL query to load the list data.
*
* @copyright
* @author RolandD
* @todo
* @see
* @access protected
* @param
* @return object the query to execute
* @since 4.0
*/
protected function getListQuery() {
// Create a new query object.
$jinput = JFactory::getApplication()->input;
$db = $this->getDbo();
$query = $db->getQuery(true);
// Select the required fields from the table.
$query->select('run_id AS id, userid, logstamp, action, action_type, template_name, records, run_id, file_name, run_cancelled');
$query->from('#__csvi_logs AS l');
// Add all the filters
$filters = array();
if ($this->getState('filter.action')) $filters[] = $db->quoteName('action').' = '.$db->Quote($this->getState('filter.action'));
if (!empty($filters)) {
// Add the clauses to the query.
$query->where('('.implode(' AND ', $filters).')');
}
// Add the list ordering clause.
$orderCol = $this->state->get('list.ordering');
$orderDirn = $this->state->get('list.direction');
$query->order($db->getEscaped($orderCol.' '.$orderDirn));
return $query;
}
/**
* Set the log ID
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param
* @return
* @since 4.0
*/
public function setId($id) {
$this->_id = $id;
}
/**
* Store the log results after import/export
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param
* @return void
* @since 3.0
*/
public function getStoreLogResults() {
// Load the settings
$jinput = JFactory::getApplication()->input;
$settings = $jinput->get('settings', null, null);
if ($settings->get('log.log_store', 1)) {
$db = JFactory::getDbo();
$csvilog = $jinput->get('csvilog', null, null);
$template = $jinput->get('template', null, null);
$logresult = $csvilog->getStats();
$details = array();
$logcount = array();
// Get the number of lines processed based on type
switch ($logresult['action']) {
case 'import':
$logcount['import'] = $jinput->get('recordsprocessed', 0, 'int');
break;
case 'export':
$logcount['export'] = $jinput->get('logcount', 0, 'int');
break;
case 'maintenance':
$logcount['maintenance'] = $csvilog->GetLineNumber();
break;
}
// Get the database connector
$rowlog = $this->getTable('csvi_logs');
// Check for an existing ID
if (!$csvilog->getLogid()) {
// Get user ID
$my = JFactory::getUser();
$details['userid'] = $my->id;
// Create GMT timestamp
jimport('joomla.utilities.date');
$jnow = new JDate(time());
$details['logstamp'] = $jnow->toMySQL();
// Set action if it is import or export
$details['action'] = $logresult['action'];
// Type of action
$details['action_type'] = $logresult['action_type'];
// Name of template used
$details['template_name'] = $logresult['action_template'];
// Get the number of records
$details['records'] = $logcount[$logresult['action']];
// Get the import ID
$details['run_id'] = $csvilog->getId();
// Get the import filename
$details['file_name'] = $csvilog->getFilename();
// Bind the data
if (!$rowlog->bind($details)) {
JError::raiseWarning(0, JText::_('COM_CSVI_CANNOT_BIND_LOG_DATA'));
}
// Check the data
if (!$rowlog->check()) {
JError::raiseWarning(0, JText::_('COM_CSVI_CANNOT_CHECK_LOG_DATA'));
}
// Store the data
if (!$rowlog->store()) {
JError::raiseWarning(0, JText::_('COM_CSVI_CANNOT_STORE_LOG_DATA'));
}
else {
// Clean up any old logs
$csvilog->cleanUpLogs();
}
$csvilog->setLogid($rowlog->id);
$rowlog->reset();
}
else {
$rowlog->load($csvilog->getLogid());
if (array_key_exists('action', $logresult) && isset($logcount[$logresult['action']])) $rowlog->records = $logcount[$logresult['action']];
else $rowlog->records = 0;
$rowlog->store();
}
// Store the log details
if (is_array($logresult) && !empty($logresult)) {
$q = 'INSERT INTO `#__csvi_log_details` ( `id`,`log_id`,`line`,`description`,`result`,`status` ) VALUES ';
$qvalue = '';
foreach ($logresult as $linenr => $result) {
if (is_int($linenr)) {
foreach ($result['status'] as $status => $stat) {
$qvalue .= "(0, ".$csvilog->getLogid().", ".$linenr.", ".$db->Quote(trim($stat['message'])).", '".$stat['result']."', '".$status."'),\n";
}
}
}
if (!empty($qvalue)) {
$q .= substr(trim($qvalue), 0, -1).';';
$db->setQuery($q);
if ($db->query()) $csvilog->cleanStats();
}
else $csvilog->cleanStats();
}
}
}
/**
* Delete 1 or more selected log entries
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param
* @return array of results
* @since 3.0
*/
public function getDelete() {
$jinput = JFactory::getApplication()->input;
jimport('joomla.filesystem.file');
$db = JFactory::getDBO();
$cids = $jinput->get('cid', array(), 'array');
$file_not_found = 0;
$file_deleted = 0;
$file_not_deleted = 0;
$log_del = 0;
$log_del_error = 0;
$log_detail_del = 0;
$log_detail_del_error = 0;
// Make it an array
if (!is_array($cids)) (array)$cids;
$rowlog = $this->getTable('csvi_logs');
foreach ($cids as $key => $run_id) {
$filename = CSVIPATH_DEBUG.'/com_csvi.log.'.$run_id.'.php';
if (JFile::exists($filename)){
if (JFile::delete($filename)) {
$file_deleted++;
}
else $file_not_deleted++;
}
else $file_not_found++;
// Delete the log entry
if (empty($run_id)) $q = "SELECT id FROM #__csvi_logs WHERE (run_id = '' OR run_id IS NULL)";
else $q = "SELECT id FROM #__csvi_logs WHERE run_id = ".$run_id;
$db->setQuery($q);
$ids = $db->loadResultArray();
foreach ($ids as $idkey => $id) {
if (!$rowlog->delete($id)) $log_del_error++;
else {
$log_del++;
}
// Delete the log details
$q = "DELETE FROM #__csvi_log_details
WHERE log_id = ".$id;
$db->setQuery($q);
if (!$db->query()) $log_detail_del_error++;
else $log_detail_del++;
}
}
// Set the results
$results = array();
if ($file_not_found > 0) {
if ($file_not_found == 1) $results['ok'][] = JText::_('COM_CSVI_DELETE_LOG_FILE_NOT_FOUND');
else $results['ok'][] = JText::sprintf('COM_CSVI_DELETE_LOGS_FILE_NOT_FOUND', $file_not_found);
}
if ($file_deleted > 0) {
if ($file_deleted == 1) $results['ok'][] = JText::_('COM_CSVI_DELETE_LOG_FILE');
else $results['ok'][] = JText::sprintf('COM_CSVI_DELETE_LOGS_FILE', $file_deleted);
}
if ($file_not_deleted > 0) {
if ($file_not_deleted == 1) $results['nok'][] = JText::_('COM_CSVI_CANNOT_DELETE_LOG_FILE');
else $results['nok'][] = JText::sprintf('COM_CSVI_CANNOT_DELETE_LOGS_FILE', $file_not_deleted);
}
if ($log_del > 0) {
if ($log_del == 1) $results['ok'][] = JText::_('COM_CSVI_DELETE_LOG_DATA');
else $results['ok'][] = JText::sprintf('COM_CSVI_DELETE_LOGS_DATA', $log_del);
}
if ($log_del_error > 0) {
if ($log_del == 1) $results['nok'][] = JText::_('COM_CSVI_CANNOT_DELETE_LOG_DATA');
else $results['nok'][] = JText::sprintf('COM_CSVI_CANNOT_DELETE_LOGS_DATA', $log_del);
}
if ($log_detail_del > 0) {
if ($log_del == 1) $results['ok'][] = JText::_('COM_CSVI_DELETE_LOG_DETAILS_DATA');
else $results['ok'][] = JText::sprintf('COM_CSVI_DELETE_LOGS_DETAILS_DATA', $log_detail_del);
}
if ($log_detail_del_error > 0) {
if ($log_del == 1) $results['nok'][] = JText::_('COM_CSVI_CANNOT_DELETE_LOG_DETAILS_DATA');
else $results['nok'][] = JText::sprintf('COM_CSVI_CANNOT_DELETE_LOGS_DETAILS_DATA', $log_detail_del_error);
}
return $results;
}
/**
* Delete all log entries
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param
* @return array of results
* @since 3.0
*/
public function getDeleteAll() {
$db = JFactory::getDBO();
$results = array();
// Empty the log table
$q = "TRUNCATE ".$db->quoteName('#__csvi_logs');
$db->setQuery($q);
if ($db->query()) $results['ok'][] = JText::_('COM_CSVI_DELETE_LOG_DATA_ALL_OK');
else $results['nok'][] = JText::_('COM_CSVI_DELETE_LOG_DATA_ALL_NOK');
// Empty the log details table
$q = "TRUNCATE ".$db->quoteName('#__csvi_log_details');
$db->setQuery($q);
if ($db->query()) $results['ok'][] = JText::_('COM_CSVI_DELETE_LOG_DATA_DETAILS_ALL_OK');
else $results['nok'][] = JText::_('COM_CSVI_DELETE_LOG_DATA_DETAILS_ALL_NOK');
return $results;
}
/**
* Load the statistics for displaying
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param
* @return
* @since 3.0
*/
public function getStats() {
$jinput = JFactory::getApplication()->input;
$db = JFactory::getDbo();
$csvilog = $jinput->get('csvilog', null, null);
if ($csvilog) $run_id = $csvilog->getId();
else if ($jinput->get('run_id', '', 'int') > 0) $run_id = $jinput->get('run_id', '', 'int');
else {
// Try to get it from the cid
$cids = $jinput->get('cid', array(), 'array');
if (is_array($cids) && array_key_exists('0', $cids)) $run_id = $cids[0];
else return false;
}
$details = array();
if ($run_id) {
jimport('joomla.filesystem.file');
// Add the run ID
$details['run_id'] = $run_id;
// Get the total number of records
$q = "SELECT SUM(records) AS total_records
FROM #__csvi_logs
WHERE run_id = ".$run_id;
$db->setQuery($q);
$details['total_records'] = $db->loadResult();
// Get the general details
$q = "SELECT MIN(id) AS min_id, MAX(id)+1 AS max_id, file_name, action, action_type, run_cancelled
FROM #__csvi_logs WHERE run_id = ".$run_id."
GROUP BY id";
$db->setQuery($q);
$min_max = $db->loadObject();
if (!empty($min_max)) { // Protect against 'record not found'
// Set the filename
$details['file_name'] = $min_max->file_name;
// Set the action
$details['action'] = $min_max->action;
// Set the action type
$details['action_type'] = $min_max->action_type;
// Set if the action was cancelled
$details['run_cancelled'] = $min_max->run_cancelled;
// Get some status results
$q = "SELECT COUNT(status) AS total_result, result, status
FROM #__csvi_log_details WHERE log_id BETWEEN ".$min_max->min_id." AND ".$min_max->max_id."
GROUP BY status";
$db->setQuery($q);
$details['result'] = $db->loadObjectList('status');
}
// Check if there is a debug log file
$logfile = CSVIPATH_DEBUG.'/com_csvi.log.'.$run_id.'.php';
if (JFile::exists($logfile)) {
$details['debug'] = JHtml::_('link', JRoute::_('index.php?option=com_csvi&task=log.downloaddebug&run_id='.$run_id), JText::_('COM_CSVI_DOWNLOAD_DEBUG_LOG'));
$attribs = 'class="modal" onclick="" rel="{handler: \'iframe\', size: {x: 950, y: 500}}"';
$details['debugview'] = JHtml::_('link', JRoute::_('index.php?option=com_csvi&task=log.logreader&tmpl=component&run_id='.$run_id), JText::_('COM_CSVI_VIEW_DEBUG_LOG'), $attribs);
}
else {
$details['debug'] = JText::_('COM_CSVI_NO_DEBUG_LOG_FOUND');
$details['debugview'] = '';
}
}
return $details;
}
/**
* Load the statistics
*/
public function getStatsMessage() {
$jinput = JFactory::getApplication()->input;
$db = JFactory::getDBO();
$run_id = $jinput->get('run_id', false, 'int');
if (!$run_id) {
/* Try to get it from the cid */
$cids = $jinput->get('cid', array(), 'array');
if (is_array($cids) && array_key_exists('0', $cids)) $run_id = $cids[0];
else return false;
}
$details = array();
if ($run_id) {
$q = "SELECT line, description, status, log_id, result
FROM #__csvi_log_details
WHERE log_id IN (SELECT id FROM #__csvi_logs WHERE run_id = ".$run_id.")
ORDER BY line";
$db->setQuery($q);
$details = $db->loadObjectList();
}
return $details;
}
/**
* Download a debug report
*/
public function downloadDebug() {
jimport('joomla.filesystem.file');
jimport('joomla.filesystem.archive');
$jinput = JFactory::getApplication()->input;
$run_id = $jinput->get('run_id', 0, 'int');
$filepath = CSVIPATH_DEBUG.'/';
$filename = 'com_csvi.log.'.$run_id.'.';
$zip = JArchive::getAdapter('zip');
$files = array();
$files[] = array('name' => $filename.'php', 'time' => filemtime($filepath.$filename.'php'), 'data' => JFile::read($filepath.$filename.'php'));
$zip->create($filepath.$filename.'zip', $files);
if (preg_match('/Opera[\s|\/]([^\s]+)/i', $_SERVER['HTTP_USER_AGENT'])) {
$UserBrowser = "Opera";
}
elseif (preg_match('/MSIE\s([^\s|;]+)/i', $_SERVER['HTTP_USER_AGENT'])) {
$UserBrowser = "IE";
} else {
$UserBrowser = '';
}
$mime_type = ($UserBrowser == 'IE' || $UserBrowser == 'Opera') ? 'application/octetstream' : 'application/octet-stream';
/* Clean the buffer */
while( @ob_end_clean() );
header('Content-Description: File Transfer');
header('Content-Type: ' . $mime_type);
header('Content-Transfer-Encoding: binary');
header('Expires: ' . gmdate('D, d M Y H:i:s') . ' GMT');
header('Content-Length: ' . filesize($filepath.$filename.'zip'));
if ($UserBrowser == 'IE') {
header('Content-Disposition: inline; filename="'.$filename.'zip"');
header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
header('Pragma: public');
} else {
header('Content-Disposition: attachment; filename="'.$filename.'zip"');
header('Pragma: no-cache');
}
/* Send the file */
readfile($filepath.$filename.'zip');
JFile::delete($filepath.$filename.'zip');
/* Close the transmission */
exit();
}
/**
* Get the action types
*
* @author RolandD
* @access public
* @return array list of action types
*/
public function getActionTypes() {
$db = JFactory::getDbo();
$options = array();
$options[] = JHtml::_('select.option', '', JText::_('COM_CSVI_LOG_DONT_USE'));
$q = "SELECT UPPER(action) FROM #__csvi_logs GROUP BY action";
$db->setQuery($q);
$actions = $db->loadResultArray();
if (!empty($actions)) {
foreach ($actions as $action) {
$options[] = JHTML::_('select.option', $action, JText::_('COM_CSVI_'.$action));
}
}
return $options;
}
/**
* Reads a log file and displays its results
*
* @author RolandD
* @since 2.3.11
* @access public
* @return array of log lines
*/
public function getLogfile() {
$jinput = JFactory::getApplication()->input;
$run_id = $jinput->get('run_id', 0, 'int');
$log = array();
if ($run_id > 0) {
$logfile = CSVIPATH_DEBUG.'/com_csvi.log.'.$run_id.'.php';
$loglines = array();
if (file_exists($logfile)) {
$loglines = file($logfile);
foreach ($loglines as $key => $line) {
switch ($key) {
case '0':
// Skip the first line
break;
case '1':
// Get the date
if (strstr($line, ':')) {
list($text, $value) = explode(': ', $line);
}
else $value = '';
$log['date'] = $value;
break;
case '2':
// Get the Joomla version
if (strstr($line, ':')) {
list($text, $value) = explode(': ', $line);
}
else $value = '';
$log['joomla'] = $value;
break;
case '3':
// This is an empty line
break;
case '4':
// Get the fields
if (strstr($line, ':')) {
list($text, $value) = explode(': ', $line);
$fields = preg_split("/\t/", $value);
foreach ($fields as $fkey => $field) {
$log['fields'][] = $field;
}
}
else $log['fields'] = array();
break;
default:
// The actual log lines
$log['entries'][] = preg_split("/\t/", $line);
break;
}
}
}
}
return $log;
}
}
?>PK >\UȲ, , models/category.phpnu W+A _tables_loaded) $this->_loadTables();
}
/**
* Gets the ID belonging to the category path
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param string $category_path the path to get the ID for
* @param int $vendor_id the vendor ID the category belongs to
* @return array containing category_id
* @since 3.0
*/
public function getCategoryIdFromPath($category_path, $vendor_id=1) {
// Check for any missing categories, otherwise create them
$category = $this->_csvCategory($category_path, $vendor_id);
return array('category_id' => $category[0]);
}
/**
* Inserts the category/categories for a product
*
* Any existing categories will be removed first, after that the new
* categories will be imported.
*
* @copyright
* @author RolandD
* @todo
* @see _csvCategory()
* @access
* @param integer $product_id contains the product ID the category/categories belong to
* @param integer $category_path contains the category/categories path for the product
* @param integer $category_id contains a single or array of category IDs
* @param integer $product_list the product order in the category
* @param integer $vendor_id the id of the vendor the category belongs to
* @return
* @since
*/
public function checkCategoryPath($product_id=false, $category_path=false, $category_id=false, $ordering='NULL', $vendor_id=1) {
$jinput = JFactory::getApplication()->input;
$csvilog = $jinput->get('csvilog', null, null);
$template = $jinput->get('template', null, null);
$csvilog->addDebug('Checking category');
// Check if there is a product ID
if (!$product_id) return false;
else {
// If product_parent_id is true, we have a child product, child products do not have category paths
// We have a category path, need to find the ID
if (!$category_id) {
// Use CsvCategory() method to confirm/add category tree for this product
// Modification: $category_id now is an array
$category_id = $this->_csvCategory($category_path, $vendor_id);
}
// We have a category_id, no need to find the path
if ($category_id) {
// Delete old entries only if the user wants us to
if (!$template->get('append_categories', 'product', false)) {
$db = JFactory::getDBO();
$q = "DELETE FROM #__virtuemart_product_categories WHERE virtuemart_product_id = ".$product_id;
$db->setQuery($q);
$db->query();
$csvilog->addDebug(JText::_('COM_CSVI_DELETE_OLD_CATEGORIES_XREF'), true);
}
else $csvilog->addDebug(JText::_('COM_CSVI_NOT_DELETE_OLD_CATEGORIES_XREF'));
// Insert new product/category relationships
$category_xref_values = array('virtuemart_product_id' => $product_id, 'ordering' => $ordering);
foreach( $category_id as $value ) {
$category_xref_values['virtuemart_category_id'] = $value;
$this->_product_categories_xref->bind($category_xref_values);
$this->_product_categories_xref->store();
$this->_product_categories_xref->reset();
$category_xref_values['virtuemart_category_id'] = '';
}
}
}
}
/**
* Load the category related tables
*
* @copyright
* @author RolandD
* @todo
* @see
* @access private
* @param
* @return
* @since 3.0
*/
private function _loadTables() {
$this->_categories = $this->getTable('categories');
$this->_categories_lang = $this->getTable('categories_lang');
$this->_categories_xref = $this->getTable('categories_xref');
$this->_product_categories_xref = $this->getTable('product_categories_xref');
$this->_tables_loaded = true;
}
/**
* Cleaning the product related tables
*
* @copyright
* @author RolandD
* @todo
* @see
* @access private
* @param
* @return
* @since 3.0
*/
private function _cleanTables() {
$this->_categories->reset();
$this->_categories_lang->reset();
$this->_categories_xref->reset();
// Clean the local variables
$class_vars = get_class_vars(get_class($this));
foreach ($class_vars as $name => $value) {
if (substr($name, 0, 1) != '_') $this->$name = $value;
}
}
/**
* Creates categories from slash delimited line
*
* @copyright
* @author John Syben, RolandD
* @todo
* @see
* @access
* @param array $category_path contains the category/categories for a product
* @param int $vendor_id the id of the vendor the category belongs to
* @return array containing category IDs
* @since
*/
private function _csvCategory($category_path, $vendor_id=1) {
$jinput = JFactory::getApplication()->input;
$db = JFactory::getDBO();
$csvilog = $jinput->get('csvilog', null, null);
$template = $jinput->get('template', null, null);
// Load the category separator
if (is_null($this->_catsep)) {
$this->_catsep = $template->get('category_separator', 'general', '/');
}
// Check if category_path is an array, if not make it one
if (!is_array($category_path)) $category_path = array($category_path);
// Get all categories in this field delimited with |
foreach ($category_path as $line) {
$csvilog->addDebug('Checking category path: '.$line);
// Explode slash delimited category tree into array
$category_list = explode($this->_catsep, $line);
$category_count = count($category_list);
$category_parent_id = '0';
// For each category in array
for($i = 0; $i < $category_count; $i++) {
// Check the cache first
if (array_key_exists($category_parent_id.'.'.$category_list[$i], $this->_category_cache)) {
$category_id = $this->_category_cache[$category_parent_id.'.'.$category_list[$i]];
}
else {
// See if this category exists with it's parent in xref
$lang = $template->get('language', 'general');
$query = $db->getQuery(true);
$query->select('c.virtuemart_category_id');
$query->from('#__virtuemart_categories c');
$query->leftJoin('#__virtuemart_category_categories x ON c.virtuemart_category_id = x.category_child_id');
$query->leftJoin('#__virtuemart_categories_'.$lang.' l ON l.virtuemart_category_id = c.virtuemart_category_id');
$query->where('l.category_name = '.$db->Quote($category_list[$i]));
$query->where('x.category_child_id = c.virtuemart_category_id');
$query->where('x.category_parent_id = '.$category_parent_id);
$db->setQuery($query);
$category_id = $db->loadResult();
$csvilog->addDebug(JText::_('COM_CSVI_CHECK_CATEGORY_EXISTS'), true);
// Add result to cache
$this->_category_cache[$category_parent_id.'.'.$category_list[$i]] = $category_id;
}
// Category does not exist - create it
if (is_null($category_id)) {
$timestamp = time();
// Let's find out the last category in the level of the new category
$query = $db->getQuery(true);
$query->select('MAX(c.ordering) + 1 AS ordering');
$query->from('#__virtuemart_categories c');
$query->leftJoin('#__virtuemart_category_categories x ON c.virtuemart_category_id = x.category_child_id');
$query->where('x.category_child_id = c.virtuemart_category_id');
$query->where('x.category_parent_id = '.$category_parent_id);
$db->setQuery($query);
$list_order = $db->loadResult();
if (is_null($list_order)) $list_order = 1;
// Find the category and flypage setting
$configname = 'Csvi'.$template->get('component', 'options').'_Config';
$config = new $configname();
// Add category
$this->_categories->set('virtuemart_vendor_id', $vendor_id);
$this->_categories->set('created_on', $timestamp);
$this->_categories->set('modified_on', $timestamp);
$this->_categories->set('ordering', $list_order);
$this->_categories->set('published', $this->category_publish);
$this->_categories->set('category_template', $config->get('categorytemplate'));
$this->_categories->set('category_layout', $config->get('categorylayout'));
$this->_categories->set('products_per_row', $config->get('products_per_row'));
$this->_categories->set('category_product_layout', $config->get('productlayout'));
$this->_categories->store();
$csvilog->addDebug('Add new category:', true);
$category_id = $this->_categories->get('virtuemart_category_id');
// Add the category name to the language table
$this->_categories_lang->set('virtuemart_category_id', $category_id);
$this->_categories_lang->set('category_name', $category_list[$i]);
$this->_categories_lang->check();
$this->_categories_lang->store();
// Add result to cache
$this->_category_cache[$category_parent_id.'.'.$category_list[$i]] = $category_id;
// Create xref with parent
$this->_categories_xref->set('category_parent_id', $category_parent_id);
$this->_categories_xref->set('category_child_id', $category_id);
$this->_categories_xref->store();
$csvilog->addDebug('Add new category xref:', true);
// Clean for the next row
$this->_categories->reset();
$this->_categories_lang->reset();
$this->_categories_xref->reset();
}
// Set this category as parent of next in line
$category_parent_id = $category_id;
}
$category[] = $category_id;
}
// Return an array with the last category_ids which is where the product goes
return $category;
}
}
?>PK >\v models/cron.phpnu W+A input;
$db = JFactory::getDbo();
$settings = $jinput->get('com_csvi.data', array(), 'array');
$cronline = '';
$notemplate = false;
$details = new StdClass;
// Get the template used
$template_id = $jinput->get('template_id', 0, 'int');
if ($template_id) {
$cronline .= ' template_id="'.$template_id.'"';
// Load the template settings to compare against selection
$query = $db->getQuery(true);
$query->select('settings');
$query->from('#__csvi_template_settings');
$query->where('id = '.$template_id);
$db->setQuery($query);
$template = new CsviTemplate(json_decode($db->loadResult(), true));
$details->type = $template->get('action', 'options');
}
else {
$notemplate = true;
// Initialise the details
$details->type = $settings['options']['action'];
}
// Check if this is an import or export cron
if ($details->type == 'export') {
foreach ($settings as $group => $values) {
switch($group) {
case 'options':
break;
case 'general':
if ($notemplate) $general = $settings['general'];
else $general = CsviHelper::recurseArrayDiff($settings['general'], $template->get('general'));
foreach ($general as $name => $setting) {
switch ($name) {
case 'exportto':
if (!empty($setting)) {
if ($setting == 'todownload') $setting = 'tofile';
$cronline .= ' jform:general:'.$name.'="'.$setting.'" ';
}
break;
case 'localpath':
if (!empty($setting)) {
if ($template->get('exportto', 'general') == 'todownload' || $template->get('exportto', 'general') == 'tofile') {
$cronline .= ' jform:general:'.$name.'="'.$setting.'" ';
}
}
break;
default:
if (!empty($setting)) $cronline .= ' jform:general:'.$name.'="'.$setting.'" ';
break;
}
}
break;
case 'export_fields':
if ($notemplate) {
if (array_key_exists('export_fields', $settings)) $fields = $settings['export_fields'];
else $fields = array();
}
else $fields = $template->get('export_fields', '', array());
if (!empty($fields)) {
$fields['_selected_name'] = CsviHelper::recurseArrayDiff($settings['export_fields']['_selected_name'], $fields['_selected_name']);
if (!empty($fields['_selected_name'])) {
$cronline .= ' jform:export_fields:_selected_name = "'.implode('|', $settings['export_fields']['_selected_name']).'|"';
$cronline .= ' jform:export_fields:_column_header = "'.implode('|', $settings['export_fields']['_column_header']).'|"';
$cronline .= ' jform:export_fields:_default_value = "'.implode('|', $settings['export_fields']['_default_value']).'|"';
$cronline .= ' jform:export_fields:_process_field = "'.implode('|', $settings['export_fields']['_process_field']).'|"';
}
}
break;
default:
if ($notemplate) $values = $settings[$group];
else $values = CsviHelper::recurseArrayDiff($settings[$group], $template->get($group));
$cronline .= $this->_getCronSetting($values, $group);
break;
}
}
}
else if ($details->type == 'import') {
foreach ($settings as $group => $values) {
switch($group) {
case 'options':
break;
case 'import_fields':
if ($notemplate) {
if (array_key_exists('import_fields', $settings)) $fields = $settings['import_fields'];
else $fields = array();
}
else {
// Create a default value
$default = array();
$default['_selected_name'][] = '';
$fields = $template->get('import_fields', '', $default);
$fields['_selected_name'] = CsviHelper::recurseArrayDiff($settings['import_fields']['_selected_name'], $fields['_selected_name']);
}
if (!empty($fields)) {
if (!empty($fields['_selected_name'])) {
$cronline .= ' jform:import_fields:_selected_name = "'.implode('|', $settings['import_fields']['_selected_name']).'|"';
$cronline .= ' jform:import_fields:_default_value = "'.implode('|', $settings['import_fields']['_default_value']).'|"';
$cronline .= ' jform:import_fields:_process_field = "'.implode('|', $settings['import_fields']['_process_field']).'|"';
}
}
break;
default:
if ($notemplate) {
$values = $settings[$group];
if (!is_array($values)) {
$values = array();
$values[$group] = $settings[$group];
}
}
else $values = CsviHelper::recurseArrayDiff($settings[$group], $template->get($group));
$cronline .= $this->_getCronSetting($values, $group);
break;
}
}
}
return $cronline;
}
/**
* Build the command to use for the cron command to do a maintenance task
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param
* @return string the parameters for the cron line
* @since 3.0
*/
public function getCronLineMaintenance() {
$jinput = JFactory::getApplication()->input;
$operation = $jinput->get('operation');
$cronline = 'task="maintenance" operation="'.strtolower($operation).'"';
// Handle the ICEcat settings
switch ($operation) {
case 'icecatindex':
$cronline .= ' icecatlocation="'.$jinput->get('icecatlocation', '', 'var').'"';
$cronline .= ' icecat_gzip="'.$jinput->get('icecat_gzip', 1, 'int').'"';
$icecat_options = $jinput->get('icecat', array(), 'var');
if (!empty($icecat_options)) {
$cronline .= ' icecat="'.implode('|', $icecat_options).'"';
}
break;
case 'restoretemplates':
$cronline = ' restore_file=""';
break;
}
return $cronline;
}
/**
* Create the cron parameter
*
* @copyright
* @author RolandD
* @todo
* @see
* @access private
* @param string $values array of values to add to the cronline
* @param string $type the name of the export type
* @return string the command line
* @since 3.0
*/
private function _getCronSetting($values, $type) {
$cronline = '';
if (is_array($values)) {
foreach ($values as $name => $setting) {
switch ($name) {
case 'custom_table':
$cronline .= ' jform:'.$type.'="'.$setting.'"';
break;
default:
if (!empty($setting)) {
if (is_array($setting)) {
if (!empty($setting[0])) $cronline .= ' jform:'.$type.':'.$name.'="'.implode('|', $setting).'|"';
}
else $cronline .= ' jform:'.$type.':'.$name.'="'.$setting.'"';
}
break;
}
}
}
return $cronline;
}
}
?>PK >\ע!( ( models/install.phpnu W+A _getVersion();
if (empty($version)) $version = 'current';
return $version;
}
/**
* Start performing the upgrade
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param
* @return string the result of the upgrade
* @since 3.0
*/
public function getUpgrade() {
// Get the currently installed version
$version = $this->_translateVersion();
// Migrate the data in the tables
if ($this->_migrateTables($version)) $this->_results['messages'][] = JText::_('COM_CSVI_UPGRADE_OK');
// Update the version number in the database
$this->_setVersion();
// Load the components
$this->_loadComponents();
// Send the results back
return $this->_results;
}
/**
* Migrate the tables
*
* @copyright
* @author RolandD
* @todo
* @see
* @access private
* @param string $version the version being migrated from
* @return bool true if migration is OK | false if errors occured during migration
* @since 3.0
*/
private function _migrateTables($version) {
$db = JFactory::getDbo();
switch ($version) {
case '4.0':
break;
default:
break;
}
}
/**
* Proxy function for calling the update the available fields
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param
* @return
* @since 3.0
*/
public function getAvailableFields() {
// Get the logger class
$jinput = JFactory::getApplication()->input;
$csvilog = new CsviLog();
$jinput->set('csvilog', $csvilog);
$model = $this->getModel('Availablefields');
// Prepare to load the available fields
$model->prepareAvailableFields();
// Update the available fields
$model->getFillAvailableFields();
}
/**
* Proxy function for installing sample templates
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param
* @return
* @since 3.0
*/
public function getSampleTemplates() {
$db = JFactory::getDbo();
// Read the example template file
$fp = fopen(JPATH_COMPONENT_ADMINISTRATOR.'/install/example_templates.csv', "r");
if ($fp) {
while (($data = fgetcsv($fp, 0, ",")) !== FALSE) {
$db->setQuery("INSERT IGNORE INTO #__csvi_template_settings (".$db->quoteName('name').", ".$db->quoteName('settings').")
VALUES (".$db->Quote($data[0]).", ".$db->Quote($data[1]).")");
if ($db->query()) {
$this->_results['messages'][] = JText::sprintf('COM_CSVI_RESTORE_TEMPLATE', $data[0]);
}
else {
$this->_results['messages'][] = $db->getErrorMsg();
$this->_results['messages'][] = JText::sprintf('COM_CSVI_COMPONENT_HAS_NOT_BEEN_ADDED', $file);
}
}
fclose($fp);
}
}
/**
* Create a proxy for including other models
*
* @copyright
* @author RolandD
* @todo
* @see
* @access protected
* @param
* @return
* @since 3.0
*/
protected function getModel($model) {
return $this->getInstance($model, 'CsviModel');
}
/**
* Set the current version in the database
*
* @copyright
* @author RolandD
* @todo
* @see
* @access private
* @param
* @return
* @since 3.1
*/
private function _setVersion() {
$db = JFactory::getDbo();
$q = "INSERT IGNORE INTO #__csvi_settings (id, params) VALUES (2, '".JText::_('COM_CSVI_CSVI_VERSION')."')
ON DUPLICATE KEY UPDATE params = '".JText::_('COM_CSVI_CSVI_VERSION')."'";
$db->setQuery($q);
$db->query();
}
/**
* Get the current version in the database
*
* @copyright
* @author RolandD
* @todo
* @see
* @access private
* @param
* @return
* @since 3.2
*/
private function _getVersion() {
$db = JFactory::getDbo();
$q = "SELECT params
FROM #__csvi_settings
WHERE id = 2";
$db->setQuery($q);
return $db->loadResult();
}
/**
* Translate version
*
* @copyright
* @author RolandD
* @todo
* @see
* @access private
* @param
* @return string with the working version
* @since 3.5
*/
private function _translateVersion() {
$jinput = JFactory::getApplication()->input;
$version = $jinput->get('version', 'current', 'string');
switch ($version) {
case '4.0.1':
case '4.1':
case '4.2':
return '4.0';
break;
default:
return $version;
break;
}
}
/**
* Load supported components
*
* @copyright
* @author RolandD
* @todo
* @see
* @access private
* @param
* @return
* @since 4.0
*/
private function _loadComponents() {
$db = JFactory::getDbo();
jimport('joomla.filesystem.file');
jimport('joomla.filesystem.folder');
$files = JFolder::files(JPATH_COMPONENT_ADMINISTRATOR.'/install', '.sql', false, false, array('.svn', 'CVS', '.DS_Store', '__MACOSX', 'availablefields_extra.sql'));
if (!empty($files)) {
foreach ($files as $file) {
$error = false;
if (JFile::exists(JPATH_COMPONENT_ADMINISTRATOR.'/install/'.$file)) {
$q = JFile::read(JPATH_COMPONENT_ADMINISTRATOR.'/install/'.$file);
$queries = $db->splitSql(JFile::read(JPATH_COMPONENT_ADMINISTRATOR.'/install/'.$file));
foreach ($queries as $query) {
$query = trim($query);
if (!empty($query)) {
$db->setQuery($query);
if (!$db->query()) {
$this->_results['messages'][] = $db->getErrorMsg();
$error = true;
}
}
}
if ($error) $this->_results['messages'][] = JText::sprintf('COM_CSVI_COMPONENT_HAS_NOT_BEEN_ADDED', $file);
else $this->_results['messages'][] = JText::sprintf('COM_CSVI_COMPONENT_HAS_BEEN_ADDED', $file);
}
else $this->_results['messages'][] = JText::sprintf('COM_CSVI_COMPONENT_NOT_FOUND', $file);
}
}
}
}
?>PK >\
;3 3 models/csvi.phpnu W+A PK >\=> models/templatetype.phpnu W+A loadForm($this->context, 'templatetype', array('control' => 'jform', 'load_data' => $loadData));
if (empty($form)) return false;
return $form;
}
/**
* Method to get the data that should be injected in the form.
*
* @return mixed The data for the form.
* @since 1.6
*/
protected function loadFormData() {
// Check the session for previously entered form data.
$data = JFactory::getApplication()->getUserState('com_csvi.edit.templatetype.data', array());
if (empty($data)) {
$data = $this->getItem();
}
return $data;
}
}
?>
PK >\Z0 0 controller.phpnu W+A
PK >\
changelog.txtnu W+A CSVI Free
Author: RolandD Cyber Produksi (contact@csvimproved.com)
Website: http://www.csvimproved.com/
Version: 5.15
Date: 1 december 2013
Status: $Id: changelog.txt 2549 2013-11-26 01:42:51Z RolandD $
Legenda:
+ Added
- Removed
* Fixed
/ Changed
Changelog
Version 5.12
Import
* Fixed available fields not always set
/ Cleanup some code
* Fixed VirtueMart category and manufacturer import options
General
* Fixed database error on installation
About
/ Changed the Magic Quotes check
Version 5.11
General
/ Changed the installation routine
Version 4.5.5
Import
* Fixed custom fields not added correctly
Export
* Fixed the shopper_group_name and shopper_group_name_price fields
Version 4.5.4
Import
* Fixed price shopper group check on VirtueMart Product import
* Fixed images path not taken on VirtueMart Product import
* Fixed product slug on VirtueMart Product import
* Fixed VM version not available
* Fixed manufacturer category import on VirtueMart Manufacturer Category import
Version 4.5.3.2
Export
* Fixed custom paramater delimiter in VirtueMart Product export
Version 4.5.3.1
Import
* Fixed missing config helper
Version 4.5.3
Import
* Fixed a missing table file
Version 4.5.2
Import
* Fixed fatal error in VirtueMart Product import for shopper groups
+ Added shopper_group_name_price to VirtueMart Product import
* Fixed product discount price missing mathop for VirtueMart Product import
* Fixed images in subfolders on VirtueMart Product import
* Fixed images in subfolders on VirtueMart Media import
* Fixed issues with accented characters in error reporting
/ Updated newly created manufacturers are assigned a category on VirtueMart Product import
* Fixed product_packaging and product_box on VirtueMart Product import
Export
* Fixed issue with price field exports
General
/ Let cron use hostname from settings
* Fixed export template not show source
Version 4.5.1
Import
* Fixed manufacturer slug being recreated on VirtueMart Product import
/ Changed custom values separator from | to ~
/ Changed system limits only applied if they have a value
Export
* Fixed export limits
+ Added front-end download option
* Fixed cron export
General
- Removed option to delete CSVI backup tables (tables are no longer created)
+ Added Live Update
Version 4.5
Import
+ Added multiple shopper groups for VirtueMart product import
* Fixed VirtueMart user info import
* Fixed fatal error on VirtueMart manufacturer category details import
* Fixed shopper group not stored for product
Export
* Fixed VirtueMart category export
* Fixed front-end export
Version 4.4
Import
+ Added product_discount_id to VirtueMart Product import
/ Updated override value for VirtueMart Product import
* Fixed product_discount on VirtueMart Product import
Export
/ Fixed VirtueMart user info export
General
/ Updated installer
Version 4.3
Import
- Removed setting manufacturer category to 1 on VirtueMart Product import
- Removed automatic setting override option
/ Fixed wait time not being applied
+ Added removal of manufacturer images on deletion of VirtueMart manufacturers
+ Added multi-language support to VirtueMart Category import
Export
* Fixed min_order_level on VirtueMart Product export
* Fixed max_order_level on VirtueMart Product export
/ Changed VirtueMart Product export to handle VirtueMart core changes in prices
/ Fixed some possible issues on loading VirtueMart order export page
* Fixed possible warning with category_id export
General
+ Added some info about the site to the About dialog
/ Changed PHP requirement to PHP 5.2
/ Fixed replacements being stripped
- Removed built-in version check, now using Joomla version check
Version 4.2
Import
* Fixed product discount with a % sign
+ Added file_url and file_url_thumb fields to VirtueMart Product export
+ Added min_order_level and max_order_level to VirtueMart product import
+ Added product_override_price to be converted to dots
* Fixed product currency on VirtueMart product import
* Fixed undefined warning on VirtueMart manufacturer import
* Fixed stockable child products issue on VirtueMart product import
+ Added VirtueMart Product import stockable variants
+ Added support for new VirtueMart customtitle field on categories and products
- Removed category_path constraint for child products
Export
* Fixed category selector on VirtueMart products
* Fixed manufacturers selection list
+ Added file_url and file_url_thumb fields to VirtueMart Product export
Version 4.1
Import
* Fixed I'm Mac option
* Fixed image name generation
* Fixed cron not using template override
* Fixed prices containing commas
* Fixed product discount ID not using -1
* Fixed image handling
* Fixed product_discount in VirtueMart product import
+ Added product_override_price in VirtueMart product import
Export
* Fixed missing custom field export
* Fixed manufacturers selection list
Version 4.0.1
Import
* Fixed VirtueMart transliteration
* Fixed image options
* Fixed VirtueMart product import custom fields missing ID field
Export
* Fixed VirtueMart category details export
* Fixed export to e-mail
* Fixed VirtueMart media import not linking to products
+ Added Akeeba subscriptions export options
* Fixed VirtueMart calculation rule category export
* Fixed VirtueMart rating export publish field
* Fixed VirtueMart shopperfield export publish field
Replacement
/ Changed replace field not to be mandatory
General
+ Added always load en-GB as backup language
/ Changed use of INFORMATON_SCHEMA as shared hosts don't always allow this
Version 4.0
General
/ Major rewrite to work with Joomla 2.5 and VirtueMart 2.0
Version 3.7
Import
* Fixed product files import for non-images
* Fixed combine separator for categories
* Fixed order item import not showing log information
+ Added Billing address and shipping address options to address_type
* Fixed checking uppercase image extension
Export
* Fixed product type names export
* Fixed adding signature gives empty column
* Fixed missing producttypenames field on product export
Version 3.6
Import
* Fixed import not taking template text enclosure
+ Added setting for processing images
* Fixed product type parameters import
Export
* Fixed logdetails link
* Fixed product currency not applied
* Fixed price conversion not working
* Fixed setting the memory limit
+ Added product_type_name to product type parameters export
General
+ Added component name to template types
Version 3.5
Import
+ Added reset of child products when parent product gets deleted
+ Added option to skip non-existing files in the product files import
* Fixed child products attributes
/ Reset counters if import crashed
* Fixed product type names import not correctly checking product ID
* Fixed session not to be overloaded
* Fixed thumbnails not created when create image name from product SKU
+ Added import overrides (like Joomla template overrides)
+ Added remember last used template
+ Added support for VMF
* Fixed looking for product currency
* Fixed checking for existing multiple price
* Fixed producttypenames expecting a comma
+ Added possibility to add fields not in import file
Export
* Fixed fieldname not used when column header is empty
* Fixed attribute_with_tax field
+ Added shipping fee table for shopper sites
- Removed default value for decimal separator
- Removed default value for thousand separator
+ Added product price filter
+ Added export overrides (like Joomla template overrides)
/ Updated Google Base export to handle tax field
+ Added support for VMF
* Fixed price_with_discount being incorrect when using fixed value
Maintenance
/ Changed the loading of available fields
+ Added option to unpublish published products in unpublished categories
+ Added option to delete CSVI VirtueMart backup tables
General
* Fixed configuration settings lost between updates
* Fixed filtering with the log details
/ Changed storing of files in the administrator/cache folder to the tmp folder
+ Added list of available template types and explanation
* Fixed settings being reloaded on every request
/ Changed cron to work with : instead of . for separation of commands
+ Added support for Admin Tools secret word
Version 3.4.1
Import
* Fixed missing available fields
Version 3.4
Import
/ Improved import performance
* Fixed import timer when using preview
* Fixed product type names import when using product_type_id field
+ Added ICEcat tolerant matching MPN
/ Improved image handling
Export
+ Added option to only export parent products and products without children
+ Added option to only export child products and products without children
* Fixed field check not returning correct value
* Fixed front-end export
+ Added category state filter to product export
General
* Fixed Update button on Available Fields page
Version 3.3.1
Import
* Fixed jumping around of radio buttons
* Fixed related products
* Fixed thumbnail import to lose / in http://
Export
* Fixed jumping around of radio buttons
+ Added check for combine field
General
+ Added German language
* Fixed hardcoded jos in installation
- Removed VirtueMart check
Version 3.3
Import
* Fixed fatal error Call to undefined method CsviLog::AddStat()
+ Added timer and progressbar
/ Improved handling of unknown extensions
/ Updated cron handling in case of errors
* Fixed the manufacturer xref not created when only importing manufacturer_name
/ Not force the path settings
Export
/ Not force the text enclosure
* Fixed sh404SEF URLs on cron export
* Fixed category_path not using CDATA
Maintenance
/ Cleaned up sample templates
+ Added staggered import for ICEcat index file
+ Added gzip option for ICEcat
/ Cleaned up functions
General
* Fixed XML nodes map not being converted
Version 3.2.3
Export
* Another go at fixing the custom table handling
General
* Fixed available fields showing wrong fields
Version 3.2.2
Import
* Fixed custom table not showing on loading template
Export
* Fixed custom table not showing on loading template
* Fixed custom table not showing when only 1 selected
General
* Fixed Empty Database warnings
/ Updated ICEcat loading
Version 3.2.1
General
* Fixed Settings could not be saved
Version 3.2
Import
/ Improved error messaging on import errors
* Fixed import failing when using template fields
* Fixed import looping when running into maximum execution time limit
* Fixed result page when not saving log reports
/ Updated replacements to be editable after saving
Export
* Fixed category tree not showing more than 2 levels
* Fixed frontend XML/HTML export fatal error
/ Updated replacements to be editable after saving
General
+ Added Settings reset button
* Fixed website not showing on HTML selection
+ Added _POST variables to cron
Version 3.1
Import
* Fixed cancel button not going back to import screen
+ Added tax rates import
* Fixed fatal error when uploading a file with .txt extension
* Fixed fatal error when importing XML with fieldnames
* Fixed 0 values being ignored
+ Added waiting list import
Export
/ Made replacement feature work more granular
* Fixed JoomFish languages not being shown
+ Added tax rates export
+ Added waiting list export
Maintenance
* Fixed logdetails on maintenance result screen
+ Added more options to load ICEcat indexes
* Fixed ICEcat index file not importing
General
* Fixed toolbar buttons Log page not working
/ Updated help pages
* Fixed custom tables not showing when only 1 selected
+ Added FlexTax (http://www.virtuemartflextax.com/) support
/ Updated installer
Version 3.0
Import
/ Changed layout to include all settings
+ Added replacement option
+ Added load file from FTP
/ Changed unsupported fields are now skipped, import will use known fields found
/ Improved status reporting
* Fixed user fields import not adding new user fields
/ Improved the preview
+ Added option to import based on SKU, MPN or child SKU
+ Added product type names to the product import
+ Added option to change case of image name
+ Added option to empty image data if image does not exist
+ Added option to keep original image files
+ Added option to check thumbnail file type
* Fixed memory limit of -1 not set correctly
+ Added cleanup for prices that use currency
+ Added ICEcat integration for product import
+ Added ICEcat integration for product type names import
+ Added ICEcat integration for product files import
+ Added custom tables import
+ Added quick add fields option
+ Added combining of fields
+ Added option to load file from URL
+ Added manufacturer_delete field to allow deleting manufacturers
+ Added resizing of full images
+ Added category separator setting
Export
/ Changed layout to include all settings
+ Added replacement to export template
+ Added FTP support
* Fixed time field on review export
* Fixed cdate, mdate and product price on multiple prices export
* Fixed coupon_value on coupon export
* Fixed shipping_rate_value and shipping_rate_package_fee on shipping rates export
* Fixed shopper_group_discount on user info export
+ Added published filter to category, reviews, product type, product files export
/ Frontend export shows the URL it was called from in the log
+ Added combining of fields
* Fixed category details export grouping too greedy
+ Added product name to multiple prices export
+ Added date and time modifiers to the export filename
+ Added product type names to product export
* Fixed child product URLs on export
+ Added AceSEF support
+ Added collect debug support
+ Added custom tables export
+ Added option to also select subcategories when only parent categories are selected
+ Added JoomFish translation
+ Added quick add fields option
+ Added sort option
+ Added header/footer options
+ Added cutomized XML exports
+ Added category separator setting
/ Updated product SKU filter to allow for more SKU's
General
- Removed replacement view
- Removed template view
- Removed template fields view
+ Added automatic log cleanup
+ Added log settings
+ Added line limit to debug log settings
+ Added version check
+ Added internal help system
/ Upgraded jQuery to version 1.4.4
/ Upgraded jQuery UI to version 1.8.6
+ Added log details view with filters
+ Added create option for missing folders
/ Updated the complete language file
* Fixed missing ; on comments in database backup
+ Added installer
+ Added template backup/restore
+ Added help files
Version 2.3.18.1
Import
* Fixed Call to undefined method TableCsvivirtuemart_templates::getValue()
* Fixed product files import not finding image
* Fixed memory check if set to -1
Export
- Removed check if any templates are defined
* Fixed mail not being sent over SMTP
Version 2.3.18
Import
* Fixed product price to be emptied when importing as unpublished field
* Fixed XLS preview to be moved over 1 column
* Fixed memory setting of -1 appplied incorrectly
Export
* Fixed the encryption key not being read correctly
* Fixed product type names export getting confused of duplicate column names
+ Added product name to multiple prices export
+ Added AceSEF support
+ Added export filename customizing with date and time tags
* Fixed product price export not being formatted correctly on multiple prices export
General
/ Cleaned up log report by removing duplicate line number
Version 2.3.17
Import
* Fixed non-image product files
+ Added remote file check (thanks Phil)
Maintenance
* Fixed possible undefined error on removing empty categories
Version 2.3.16.1
Import
* Fixed fatal error when cleaning filename
Version 2.3.16
Import
+ Added custom fields import for product files
+ Added support for default values for XML import (thanks Phil)
* Fixed attribute on a non-record node (thanks Phil)
* Fixed fatal error on import when creating image name based on product ID
Version 2.3.15.1
Import
* Fixed a code error on the product type parameters import
* Fixed fields for order item import
Version 2.3.15
Import
/ Change the handling of product_box and product_packaging. They both need to be used.
* Fixed handling non-image files in another folder
* Fixed mixed case headings on import (thanks Phil)
+ Added suppression of error messages when resizing images (thanks Phil)
* Fixed problems with remote URLs (thanks Phil)
* Fixed error messages on cron usage (thanks Phil)
* Fixed BOM check
+ Added support for customer number
Export
/ Updating SEF export
+ Added full_name and order_status_name to order item export
Version 2.3.14
Import
* Fixed category details import not handling images
* Fixed issue with shopper_group_id
Export
* Update the cron generator
* Fixed product type names export matching wrong tablename
* Fixed category_name in product export
General
/ Further improvements in image handling
Version 2.3.13
Import
* Generated image name gets extension none
/ Polish up image handling
* Fix possible warnings on reading column headers
Export
+ Added export filters to Basic export
+ Added more price fields to use the price format from the template
+ Added option to turn of SEF URL generation on export
Replacement
- Removed automatic adding of / before and after regular expression to support modifiers
+ Added confirmation on replacement delete
General
/ Update jQuery to version 1.4.2
/ Improved domain name parsing
+ On installation whitelist CSVI VirtueMart with RS Firewall (thanks to the RS Firewall team)
Version 2.3.12
Import
* Fixed field order for XML files
/ Rename selectfile to choosefile to prevent false/positive
+ Added Collect debug information to basic import
/ Workaround for MySQL bug (http://bugs.mysql.com/bug.php?id=37521)
Export
+ Added filter for exporting featured products
+ Added support for JoomSEF SEF URLs
+ Added support for Joomla SEF URLs
+ Added template system limits to export
+ Added modification date to export filter for user info export
General
/ Improved writable folder check
Version 2.3.11
Import
/ Improved cron support
/ Improved order import details
* Fixed order items import
* Fixed order import
/ Improved image handling
/ Improved support for downloadable files
* Fixed a download issue with non-image product files
* Fixed category image handling
Export
* Fixed front-end export not showing domainname
* Fixed some undefined errors on e-mail export
General
+ Added a log viewer
Version 2.3.10
Import
+ Added products per row from VirtueMart config when creating a category on product import
/ More work on the product files import
* Fixed misaligned columns when using template fields
/ Changed order import behavior. Orders can now be imported with an order ID.
Export
+ Added signature to cron export generator
/ Better handling of exporting non-existing product type names
General
+ Added overview of folder permissions
* Fixed incorrect fields on sample templates
+ Added more sample templates (order import, order item import)
+ Added folder checks in About section
Version 2.3.9
Import
* Fixed external image on product files import
* Fixed XLS file eating first column
* Fixed preview using template fields
/ Changed product_discount to properly handle a value of 0
Export
+ Added option to add a UTF-8 signature (BOM) on export
Version 2.3.8
Import
* Fixed product stock import
* Fixed product files import
* Fixed preview not showing when Import lines set to 0
* Fixed first line not being skipped in preview
+ Added some runtime statistics to cron import
Templates
* Fixed pasting of file paths
Version 2.3.7
Import
* Fixed remote images import
/ Improved error reporting on preview screen
+ Added use of template ID for cron import
* Fixed XLS import
Templates
+ Added template ID to templates list
General
+ Added another JPEG signature
Version 2.3.6
Import
* Fixed XLS import
* Fixed XML mixed case column headers
Export
* Fixed price_with_discount sometimes calculate incorrectly
General
* Fixed an issue with installing sample templates
/ Minor changes for Joomla 1.6 compatibility
+ Added update button on the Available Fields button
* Fixed Empty categories deleting too many categories
Version 2.3.5
Import
/ More work on the image handling
Export
* Fixed product type names export not to use replacement
Templates
+ Added confirmation dialog for deleting template
+ Added existing available fields check for the template fields
General
/ Some changes to the cron handler
* Fixed error in case of non-existing template in replacement
Version 2.3.4
Import
* Fixed broken product type parameters import
* Fixed cron import
/ Always uppercase product currency
Export
+ Added order ID list selection
* Fixed category details export to be filled with fieldnames in case field is empty
* Fixed user info export
General
+ Added the column Cancelled on log view to see if an import was cancelled
+ Added filter on the Log view
Version 2.3.3
Import
* Fixed duplicate data on product files import
+ Added a number of options for image handling
/ Improved error handling in preview
/ Rewrote image handling
Export
* Fixed a possible error using the regex replacement
* Fixed price format and this time it should really be fixed
/ Updated export result screen
/ Better handling if no export fields are chosen
/ Better handling of the basic export
+ Added general export options to the basic export
* Fixed front-end export not creating a unique ID
General
* Fixed the sample templates
Version 2.3.2
Import
+ Added basic import
+ Product price can now contain thousand separator e.g. 1,300.25 or 1.300,25
* Fixed product files thumbnail not always having correct name
* Fixed using wrong path name on image check
Export
* Fixed price format
+ Added basic export
* Fixed a number of small issues
Templates
- Removed replace field as it is superseded by the Replacement section
General
+ Added PHP requirement to installation routine
Version 2.3.1
Import
* Fixed first line being imported
* Fixed products always being unpublished
* Fixed preview not always showing
* Fixed incorrect column check
/ Cleaned up import files
* Fixed shopper group ID not to update correctly on user info import
* Fixed vendor ID not to update correctly on user info import
* Fixed maintenance not working via cron (Thanks Erik)
Replacement
+ Added option to clone replacement
* Fixed pagination to not load all templates
General
+ Added result counters to Replacement, Available Fields and Templates lists
+ Added sample templates for user info import/export
Version 2.3
Import
* Fixed import hang
+ Added advanced XML import (thanks Phil)
* Fixed image resizing not handling uppercase extensions
+ Added support for mixed case fieldnames (thanks Phil)
/ Changed product_cdate to always be applied if supplied
* Fixed external image URLs not creating thumbnails
Replacement
* Fixed field name not being stored when adding a new replacement
Export
* Fixed some fields not being replaced
General
/ Changed defaults for text delimiter to , and text enclosure "
Version 2.2.1
Import
/ Changed first line check to handle text delimiters in strings (thanks Phil)
* Fixed missing files for order item export
* Fixed skipping a line too many with XLS import
Export
* Fixed missing files for order item export
* Fixed category export not grouping on category_name
General
/ Updated log layout
/ Updated installer package layout
Version 2.2
Import
+ Added order import
+ Added order items import
+ Added support for encrypted user passwords. Use the field password_crypt
+ Added support for image URLs without image name
Export
+ Added order payment method for order export
/ Changed handling of price format. Check your templates if you customized it !!
* Fixed price quantity start from and price quantity end
+ Added order items export
Maintenance
+ Added VirtueMart backup
* Fixed public_html been given 777 permission
General
* Fixed log details not always showing up
* Fixed SQL error on installation
* Fixed deprecated messages
- Removed all languages except English due to being too old
Version 2.1.3
Export
* Fixed manufacturer details export not exporting data
/ Improved the SEF url export for products
/ Updated domain name handling using cron
* Fixed replacement not working as should for product exports
General
* Fixed Invalid argument warning on using Clean cache
* Fixed Argument #1 is not an array on using Clean cache
Version 2.1.2
General
* Fixed installer not creating export price format column
Version 2.1.1
Import
* Fixed skipping first line issue (thanks Phil)
+ Added timer to check for possible script termination
* Fixed import hangs when image is corrupted
Export
+ Added select options for multiple price groups
Templates
+ Added check if website is chosen for XML export
+ Added option to set price format output
- Removed the Column Header field for import templates
General
* Fixed old logs not deleted (thanks Phil)
+ Added finer control over the replacement, is now set per field
+ Added field order when using Quick Add
Version 2.1
Import
* Fixed attribute_with_tax not handling prices in thousands correctly
* Fixed LOCAL_FILE_DOESNT_EXIST on import with preview
+ Added unlimited import
* Fixed product type names import not finding new product IDs
/ Check for valid image creation on generating thumbnails
* Fixed shipping rates import
* Fixed product type names import not importing on different case
+ Added cancel button to import process
Export
* Really fix the product_url
* Fixed user details export
+ Added order last modified date to selection criteria
Templates
+ Add input filter to template list
General
/ Keep configuration between new installations
/ Change installation to check if old CSV Improved tables exist
/ Updated log handling
+ Added clear cache to maintenance
+ Added number of preview lines in the settings
/ Updated Hungarian language
* Fixed calendars not working on order options
Version 2.0.2
Import
+ Added option to import zip files (only 1 file per zip for now)
* Cleanup after imported file is no longer needed
/ Expanded debug report
* Fixed Fatal error: Class 'CsvimprovedModelAvailablefields' not found on Product Type Parameters import
* Fixed product price not set correctly
/ Changed product_tax behavior to do nothing when field is empty
* Fixed numerous issues in the product type name import
+ Added support for image SEF urls
Export
/ Changed product type parameter names export, can now mix different parameter types
* Fixed front-end export not working in subdomain
* Fixed Column 'list_order' in field list is ambiguous on order export
/ Updated the replacement during export
General
+ Added Czech language thanks to Komanche
* Fixed Update available fields overwriting other product_type_x tables except last one
/ Clean up for PHP 5.3 compatibility
Version 2.0.1
Import
/ Fixed delimiters not always set correctly
/ Fixed category_path mistaken for category_id
Export
/ Fixed product_url missing domain name
/ Fixed picture_url missing forward slash
General
+ Added product_type_x fields to the list of available fields
+ Added search filter to available fields page
/ Fixed sorting on available fields page
/ Updated French language
Version 2.0
Import
/ Improved shopper group ID check
* Fixed product_files_url for downloadable products
+ Added category browse and flypage to new category creation
* Fixed product type names to lose HTML formatting
+ Added option to store remote images on the server
+ Added option to auto-generate imagenames based on SKU
+ Added option to unpublish products before import
* Fixed possible crash if template type not found on import
+ Added option to auto-detect CSV delimiter and enclosure characters
* Fixed several issues with product files import
+ Added category_delete field
+ Added field attribute_with_tax
* Fixed product_discount_id keeps previous value
+ Added userfields import
+ Added product reviews import
+ Added product_files_delete option
+ Added calculations to product_in_stock field
/ Improved product manufacturer relation check
Export
* Fixed attribute export causing undefined error
+ Added initialisation of big SQL selects
+ Added replacement feature
+ Added Google Base channel header
+ Added e-mail export option
* Fixed child products not being exported with category filter
* Fixed non-existing product discounts to export as 0.00
+ Added option to choose VirtueMart Item ID
* Fixed issues with sh404SEF
+ Added category_name to productexport
+ Added field attribute_with_tax
+ Added userfields export
+ Added product reviews export
+ Added cron command line generator
+ Added HTML export format
+ Added front-end export
/ Fixed multiple category id export
Templates
+ Added Quick Template Fields
General
* Fixed cron not using language file
* Fixed cron not using domain name
+ Added replacement table
+ Added maintenance option to cron support
+ Added settings screen
* Fixed tooltips on import/export screen
/ A lot of optimizations done to product import
+ Added option to not store logging
+ Added global category separator
+ Added sorting to Available Fields
+ Added sorting to Templates List
/ Moved sample templates to maintenance section
/ Updated German language
Version 1.9
Import
+ Added support for ignoring empty lines thanks to doorknob
* More fixing of thumbnail creation
+ Added message on preview screen to click Import
* Fixed template fields import not importing duplicate fields
* Fixed category details import to not always look for category_id
* Fixed user info import to not handle user_info_id correctly
+ Added extra signature for JPG files
+ Added test check for delimiters on import failure
Export
* Fixed price_with_discount export
* Fixed price_with_tax export not to remove too many 0
* Fixed writing to file garbles UTF-8 text
* Fixed export results not being shown
* Fixed undefined property with custom fields on coupon export
* Fixed export with same field names to use only the last
+ Added condition field to Google Base sample as this is now a required field
* Fixed Unknown column 'jos_vm_order_user_info.first_name' in 'field list'
* Fixed product type names export to be empty when choosing Don't use
Templates
+ Added template name when editing template
+ Added option to specify different kind of paths
* Fixed field order ID to follow the highest order number
General
+ Added delete all option for log entries
+ Added support for multiple select boxes to cron
+ Added another jpeg signature
+ Added German translation thanks to crissxcross
/ Updated French translation
/ Updated Hungarian translation
/ Updated Brazilian-Portugese translation
/ Updated Slovenian translation
Version 1.8.1
Import
* Fixed Fatal error: Call to undefined method TableVm_product::setValue()
Export
* Fixed export could give error not using product_sku
Version 1.8
Import
* Fixed external images not being resized
* Fixed shopper_group_id ignored on user info import
* Fixed shopper_group_name not foud on user info import
/ Changed product file import to use thumbnail sizes from template setting when not creating thumbnail
* Fixed thumbnail creation for subfolders. A resized folder MUST be specified now.
* Fixed file_url to be always the same for product files import
/ Changed import not to stop on error but only report it
* Fixed user info import not creating shopper vendor xref
* Fixed user info import not to create a name for Joomla user
* Fixed product files import causing index.php on file download
* Fixed shopper <--> vendor relation for user
* Fixed undefined errors on userinfoimport
* Fixed product_packaging being reset to 0
* Fixed double / in product_url
+ Added product stock import
* Fixed Not overwrite existing data always return product exists when disabled
* Fixed manufacturer details import not working without manufacturer_id
* Fixed template fields import not handling "not overwrite existing data" correctly
* Added check if category_name matches category_path
/ Updated memory usage check
* Fixed incorrect import when using category_path and category_id in upload file
* Fixed product files thumbnail not being put in resized/ folder
+ Added modal window to show template fields
* Fixed undefined error in case of incorrect attribute
Export
* Fixed undefined error for export filename
+ Added sh404SEF URLs for product URL export
* Fixed missing product_box field
+ Added modal window to show template fields
General
+ Added Russian translation thanks to progressor
/ Updated Slovenian translation
/ Updated French translation
/ Updated Hungarian translation
Version 1.7
Import
* Fixed bug where filename loses first character on the product files import
* Fixed fatal error when overwrite data is unchecked
* Fixed fatal error with ToPeriod function
* Fixed product_mdate and product_cdate not being processed
* Fixed category list order not being processed
+ Added Joomla user details to user info import
* Fixed XML import not using first entry
+ Added shipping rates import
* Improved product deletion
* Fixed manufacturer ID import
+ Added comma to period conversion on multiple prices import
+ Added detailed output on column mismatch
+ Added option to import selected columns
/ Changed filename handling for product files
+ Added check for category details import if category_name matches category_path
Export
+ Added payment method to order export
* Fixed template export not showing template selection list
* Fixed template fields export not showing template selection list
* Fixed order export to fail on a number of fields
+ Remove slashes in vendor name on user info export
+ Added country name to order export
+ Added Joomla user details to user info export
* Fixed category details export
+ Added shipping rates export
+ Added currency conversion on export
* Fixed missing product_box
Templates
+ Added option to add currency to price on export
Maintenance
+ Added product files table to emtpy database
+ Added option to remove empty categories
General
+ Added Portugese translation thanks to dadus
+ Added Brazilian Portugese translation thanks to Igaeta
+ Added French translation thanks to ahamel
+ Added Hungarian translation thanks to dkg11hu
* Fixed control panel images and links
+ Added template name to log view
+ Added Slovenian translation thanks to VidKo
+ Added Swedish translation thanks to cpthaddock
+ Added Dutch translation thanks to djors
Version 1.6
Import
+ Added coupon import
/ Updated thumbnail creation process to check for sensible thumb sizes
* Fixed product files import creating duplicate entries
* Fixed product type names import warning if product type does not exist
* Fixed vendor_id returning no result
Export
* Fixed product with discount has no tax
+ Added stock level values to product export
+ Added user-interactive user selector
+ Added user-interactive product selector
* Fixed Product Type Names not exporting column headers
/ Changed product type names export not to force lowercase
+ Added coupon export
* Fixed product files export
* Fixed manufacturer details export not working
+ Added product_files_download to product files export
+ Added product SKU filter for product export
+ Added product type name filter
* Fixed product_attribute not using CDATA
Maintenance
+ Added confirmation message to database delete
+ Added option to resize product name field
General
+ Added jQuery for improved GUI
+ Added Croation language thanks to tatamata
Version 1.5.2.1
Export
* Fixed category export being ignored
+ Added multiple category selection
Version 1.5.2
Import
* Fixed error when only importing manufacturer ID
* Fixed incorrect preview
/ Changed processing of related SKU's to be more efficient
Export
* Fixed product export when manufacturer is set
* Fixed fatal error when mysqli is set as database handler
* Fixed vendor_id not exporting
* Fixed delimiters not duplicated if they occur in the text
/ Made group by checkbox checked by default
+ Added order export option to export shipping address in case it exists
+ Added category selection to product export
Templates
+ Added filter for import/export templates
General
* Fixed license check
/ Updated folder layout
Version 1.5.1
Import
* Fixed manufacturer not assigned to first product if manufacturer doesn't exist
/ Changed handling of auto creating thumbnails
+ Added auto creating thumbnails for category details import
+ Added some performance tweaks
/ Changed import routine to stop immediately when timeout has been reached
/ Changed product type names import to only update the parameters specified in uploaded file
Export
* Fixed incorrect flypage as VirtueMart config is ignored
* Fixed group by not ignoring a few custom fields
+ Added option to set date format on export templates
General
* Fixed cron not logging out user
/ Changed informational messages to be no longer classified as success
* Fixed some undefined errors in the logging
* Fixed version number not always showing on about page
Version 1.5 Stable
Import
/ Updated product type parameters
/ Changed applying system limits only if value is greater than 0
* Fixed template import
* Fixed template fields import
+ Added template_name field to template fields import
- Removed converting HTML entities to real characters on product description
/ Update thumbnail creation check
* Fixed undefined errors when database structure is bad
Export
+ Added tab delimiter
* Fixed missing price_with_discount field
* Fixed template export not showing all templates
* Fixed template export in XML format no CDATA tag on cusom field value
+ Added template_name field to template fields import
+ Added disable Export button if no templates with fields are found
/ Fixed handling of templates with 0 fields in case the export gets called
/ Fixed file export to disk not UTF-8
/ Fixed Beslist.nl XML export to not include linebreaks for elements
/ Fixed errors showing up when no records are found to export
* Fixed undefined errors when database structure is bad
General
/ Updated license check
/ Updated installer to check if database can be read
/ Updated images
Version 1.5 RC 2
Import
+ Added default currency read from VirtueMart on Multiple Prices import
/ Fixed shopper groups ignored on Multiple Prices import
+ Added attributes tag to Product Import
+ Added product_sku tag to Multiple Prices import
+ Added shopper_group_name tag to Multiple Prices import
* Fixed products per row not working on category details import
- Removed UTF-8 conversion as it does more bad than good
+ Added first manufacturer is assigned to product when importing new products without manufacturer
Export
* Fixed filtering on address did not work for order and user info export
/ Changed loading of usernames to not load if there are more than 5000 users
+ Added disable export templates without fields
+ Added attributes tag to Product Export
+ Added product_sku tag to Multiple Prices export
+ Added shopper_group_name tag to Multiple Prices export
/ Fixed cron ignoring filepath set in general settings
* Fixed product type names export
Templates
+ Added missing text for non-existing images
General
* Fixed unclosed quotes in installation script
* Moved requirements checks to beginning of script
+ Added memory limits to sample templates
+ Added removal of images folder on un-installation as Joomla doesn't clean up
/ Updated install XML DTD
/ Changed license check
- Removed CURL requirement
/ Replaced license check on external server with license key
Version 1.5 RC 1
Import
* Fixed tax not associated with product
+ Added preview column to import selection screen
+ Added shopper details to user info import
* Fixed undefined errors in cron
* Fixed undefined errors on result page
* Fixed a bug in thumbnail creation where file is not found
Export
* Fixed undefined error on export result screen
/ Moved record grouping from order export to general settings
+ Added user address filter to user info export
+ Added user vendor filter to user info export
+ Added user permission filter to user info export
+ Added custom field to user info export
+ Added full_name field to user info export (combines first, middle and last name)
+ Added full_name field to order export (combines first, middle and last name)
+ Added discount_percentage field to order export (order_discount/order_total)
+ Added product_price_total field to order export (product_price*product_quantity)
+ Added total_order_items field to order export (counts number of items per order)
+ Added shopper details to user info export
* Fixed undefined errors in cron
* Fixed undefined errors on result page
Templates
+ Added auto increment value when adding template fields
/ Changed field size of column headers to give more space
Maintenance
* Fixed not deleting product type names tables > 9
General
+ Added links to the available fields online help pages
* Fixed pagination on available fields page
+ Added server address to About page
/ Updated license check for working locally
Version 1.5 beta 5
Import
/ Updated available fields for product import
+ Added changing product_weight commas to periods
+ Added changing product_length commas to periods
+ Added changing product_width commas to periods
+ Added changing product_height commas to periods
- Removed category details from product import
Export
/ Updated available fields for product export
* Fixed filename incorrect when downloading file
+ Added product type export
+ Added product type parameters export
+ Added product type names export
+ Added currency filter to order export
/ Changed some order export options to multiple select
- Removed category details from product export
Templates
* Fixed file location having mixed path separators
Version 1.5 beta 4
Import
* Fixed category_id not processed
Export
* Fixed file location not used when exporting to local file based on template
+ Added log entry when SQL query is incorrect
* Fixed product_parent_sku missing
* Fixed local file not saving in the correct folder
+ Added option to group records together on order export
+ Added option to select address type on order export
* Fixed missing product_sku, product_name on order export
Templates
* Fixed error message if no templates are created
General
* Fix icons not showing if installed in subfolder
Version 1.5 beta 3.0.1
General
/ Updated license check
* Fixed license expire date incorrectly shown
Version 1.5 beta 3
Import
* Fixed categories not added correctly
+ Added product_list
Export
* Fixed product_name export
/ Changed product_url to be enclosed in CDATA tags for XML exports
* Fixed custom field not handled in product export
Templates
* Fixed typo in Google Base template
* Fixed template list not always showing
General
/ Completely revised language file
Version 1.5 beta 2.2
Import
* Fixed manufacturer_name not being imported
* Fixed tax rate not being imported
Export
* Fixed category_name Category Details export
* Fixed category_path misssing from Category Details export
Templates
+ Added default system values for System Limits
General
* Fixed error messages when no logs exist
Version 1.5 beta 2.1
Import
+ Added check and warning if no templates exist
+ Added a default selected template
Export
+ Added check and warning if no templates exist
+ Added a default selected template
* Fixed missing category_path on product export
* Fixed missing number of fields
General
+ Added Romanian thanks to Danny
Version 1.5 beta 2
Import
+ Added option to append categories
/ Fixed bug where multiple categories per product were not imported
Export
+ Added order export by sold product
Templates
/ Fixed wrong save button
Version 1.5 beta 1.3
General
/ Moved the creation of the log object to the parts that use it
Version 1.5 beta 1.2
General
/ Updated license check
/ Update database table definition to prevent possible key length error
Version 1.5 beta 1.1
General
/ Updated license check
Version 1.5 beta 1
Import
+ Added price calculations for both regular and multiple prices import
+ Added price_with_tax
+ Added option to ignore non-existing products
+ Added manufacturer category ID
+ Added downloadable files option to Multiple Files import (product_files_download)
+ Added product_type_parameter_delete option
+ Added manufacturer_category_details import
- Removed 100 character limitation on import preview
+ Added support for ODS files (OpenOffice Spreadsheet)
+ Added check if cache folder is writable
* Fixed cron support
+ Added default values from template to preview
+ Added option to set default thumbnail format
+ Added user info import
Export
+ Added order export by order number
+ Added order export by date range
+ Added order export by order status
+ Added order export by price
+ Added order export by customer name
+ Added removal of linebreaks on export
+ Added export results to log table
* Fixed dates exporting as Unix timestamps
* Fixed cron support
+ Added XML support for Oodle.com
+ Added user info export
/ Drastically reduced memory usage on export
General
/ Converted to Joomla 1.5 codebase
+ Added logging storage
+ Added browseable list of available fields
Version 0.9
Import
* Fixed the product type parameters not able to update
Export
+ Added removal of linebreaks for product export
* Fixed discount start and end date to export as regular dates
* Fixed product type exports were broken
* product_thumb_image was exported as product_full_image
Templates
/ Changed field adding and removing to no longer use AJAX
/ Updated layout to specify add field section
General
/ Changed DB layout check to ensure DB structure consistency
Version 0.9 RC 1
Import
* Fixed multiple prices import to reset shopper groups
* Fixed Fatal error: Class 'product_files' not found in product type parameters
Templates
* Fixed template not being saved
* Fixed manufacturer selection got lost
Version 0.9 beta 2
Import
* Fixed conversion option lost
+ Add price field check if entry is numeric
* Fixed preview losing convert choice
* Fixed cron throwing a GetObject() on a non-object error
Export
* Fixed order export to include non-existing users
* Fixed export not exporting first record
Templates
* Fixed settings getting lost
General
/ Updated installer script
Version 0.9 beta 1
Import
+ Added cron import via command line
+ Added support for passwords without salt
+ Added warning if more than 1 product <--> manufacturer link exists
* Fixed manufacturer name not being escaped for database insert
* Fixed generic manufacturers created when only importing manufacturer ID
+ Added category_id
+ Added custom database fields from the #__vm_product table
+ Added support for CSVI XML
* Improved the file upload handling
/ Changed the preview layout
Export
* Fix price_with_discount using wrong discount
+ Added category_id
/ Updated Google Base XML for category paths
* Fix picture URL path
/ Updated product description for Google Base to always be filled
+ Added custom database fields from the #__vm_product table
+ Added support for CSVI XML
+ Added export per manufacturer for products
Templates
+ Added export filename
+ Added system limit settings
- Removed standard delimiters
+ Added wizard for adding and editing templates
/ Redo Field management
* Fix error when publishing no selected fields
/ Moved renumber icon from toolbar to field list
Languages
+ Added French translation by Michel Loriaut and Xavier Lemoine
/ Updated Spanish translation by Juan Ferrari
/ Updated Polish translation by Keran from Quarkbit Software
Version 0.8 Stable
Import
* Fixed attribute_values not properly added
* Fixed duplicate product_tax_id
Languages
/ Updated German language file thanks kaltokri
Version 0.8 RC 3
Export
+ Add user_id and product_id fields to order export
* Updated XML export by adding CDATA tags
* Added UTF-8 encoding to the Froogle XML export
/ Changed mf_name to manufacturer_name for order export
+ Added username to order export
* Fixed duplication of products on export
* Fixed category details export
/ Changed export filename to use template name
Import
* Fixed fatal error Call to undefined method CsviSupportedFields::FieldsProductTypeXref()
* Fixed cannot access empty property in the rpc file
* Fixed Fatal error: Call to undefined method CsviRegistry::CloneObje()
+ Added Create manufacturer link if none exists
* Fixed undefined $debug
* Fixed a timeout bug where max_execution_time is set to 0
* Fixed incorrect manufacturer <---> product links
* Fixed possible double vendor_id in add product query
Maintenance
/ Changed layout of maintenance page
General
* Fixed VirtueMart check
Version 0.8 RC 2.1
Export
* Fix layout of discounted price
* Fix exports giving blank files
Version 0.8 RC 2
Import
* Fixed product_parent_sku deleted on import
* Fixed Fatal error: Class 'product_files' not found on multiple prices import
- Removed product type cross reference import
+ Product type names spaces converted to underscores
Export
+ Added Order export
* Fix attribute_values for downloadables
* Fix incorrect fieldname for order export
+ Added manufacturer name to order export
- Removed product type cross reference export
+ Added record limits to all exports
Templates
+ Added page navigation to template list
+ Added filter to field page
+ Added alternate row colors on template and field page
General
* Merged the product type cross reference into product type names import
Version 0.8 RC 1
Import
* Fixed invalid reference in mime type detection
* Fixed preview mode broken with imported file only 5 lines
* Fixed debug reporting being overridden
* Fixed template fields import
* Fixed product discount id not being used
+ Added more details for import preview errors
* Fixed product files import
* Fixed import not reading fields correctly
/ Changed loading of template details now uses AJAX
Export
* Fix hardcoded table prefixes
+ Add manufacturer export
* Fixed incorrect column header
/ Changed loading of template details now uses AJAX
Templates
/ Changed template fields page to Joomla style
+ Added button to add custom field
* Standard thumb width and height set to 90x90
General
- Removed Help section
+ Added link to wiki (http://www.csvimproved.com/wiki/doku.php/)
+ Added AJAX support
Version 0.8 beta 6
Import
+ Added option to choose to convert encoding
+ Added check if iconv is available
+ Added BOM removal
+ Added check if memory_get_usage is available
* Fixed linenumbers not always showing
* Fixed the mdate/cdate import fields
+ Added default file location path to import template
Export
- Removed standard UTF-8 export, iconv might not be installed
* Fixed the export to file, not being able to write
General
- Removed PHP 4 support
+ Added check for PHP 5 installation
Version 0.8 beta 5
Import
+ Added filename to import results
+ Added button to return to import page on results page
+ Added manufacturer data import
/ Changed template list to only show import templates
+ Added table of site limits for import for user to check
+ Added check for maximum execution time
+ Added category details import
+ Added preview option for templates and template fields
+ Added character translation to UTF-8
Export
* Fixed missing delimiter on product price in CSV export
+ Added export limits
/ Changed template list to only show export templates
+ Added export per shopper group
+ Added export to local file
+ Added product url suffix
/ Changed product_url to force http
+ Added list of templates to export
/ Changed export to respect template fields
+ Added record limits to filename if used
+ Added category details export
/ Changed file encoding to be UTF-8
+ Added field to export discounted price
+ Added option to export published/unpublished/both products
- Removed full server path from imagename
Templates
+ Added tabs to clarify what options are meant for
+ Added thumbnail sizes for import
- Removed support for required field
+ Added option to clone templates
+ Added configurable file location for product files/product images
+ Added check if no more fields available to add
+ Added automatic field ordering
+ Added option to select state of products to export
Maintenance
* Fixed product type tables not being deleted
+ Added option to sort categories alphabetically
General
+ Added check if Virtuemart is installed
+ Added logging class
* Recoded import process
+ Added support for Virtuemart 1.1 display options
+ Added Italian translation by Crisalex
+ Added Joomla 1.5 support using legacy mode
+ Added CSVI standard templates
Version 0.8 beta 4.1
Import
* Fixed data not being processed
* Fixed txt file upload causing foreach error
Export
* Fixed not allowed in XML export
Version 0.8 beta 4
Import
* Fixed preview to show on all product imports
+ Added multiple prices import to also update prices
* Fixed not using default values
+ Added Excel support
* Fixed missing price_delete field
- Removed radiobutton selection
* Fixed field configuration not matching
Export
* Fixed bug with product discount that has too many delimiters
* Fixed default values not always used
* Fixed product_available_date not being exported correctly
* Fixed XML entities
/ Changed export filenames to be more descriptive
* Fixed invalid XML file header
General
* Cleaned up file import code to allow other filetypes to upload
+ Supported fields now being alphabetized
Version 0.8 beta 3
Import
+ Added tax value import
* Fixed import of category names with apostrophe
- Removed Empty Database option
- Removed the Price List Only Upload obsolete due to templates
/ Changed page layout
+ Added template import
+ Added template fields import
Export
* Fixed export not using CSVI configuration table
* Fixed product_available_date not adding field delimiter
/ Changed page layout
+ Added creation of product URL if there is none in the database
+ Added support for custom column names
+ Added template export
+ Added template fields export
+ Added picture url export
+ Added price with tax export
+ Added XML support for beslist.nl
+ Added XML support for froogle.com
* Fixed manufacturer_name and manufacturer_id
Templates
* Fixed fatal error on templates page
* Fixed bug available fields not selected on template ID
* Fixed bug where template fields were not deleted on template removal
* Fixed cancel returning to templates page showing no templates
/ Changed page layout
+ Added custom fields
+ Added a Froogle Export template
Maintenance
+ Added Empty Database option
+ Added Removal of orphaned fields
+ Added Optimization of the CSV Improved tables
General
+ Added Russian translation by Sbmart
+ Added Spanish translation by Joao
+ Added Polish translation by Jurek
+ Added German translation by Jingo
+ Added icons kindly supplied by Joao
/ Changed layout of program
+ Added maintenance page
/ Changed output totals to only show if count is greater than 0
* Choose language according to Joomla language setting
* Split the language file. Help texts are now separated from main texts
Version 0.8 beta 2.1
Import
* Fixed updating of discounts when field not used
* Fixed updating of prices when field not used
+ Added updating to product type names imports
* Fixed preview mode
Export
* Fixed product type export layout as it had an incorrect column header
* Fixed product type names export layout. Removed ^ at the end of the line
Version 0.8 beta 2
Import
* Fixed fatal error with manufacturer import
Export
/ Changed price export to drop trailing zeroes after second digit
* Order export on SKU
+ Added product type parameters export
+ Added product type names export
General
/ Changed tab system to use Joomla tabs
+ Added Joomla toolbar
- Removed deletion of tables on uninstall
Version 0.8 beta 1
Import
* Fixed product type details upload
* Fixed error where child products did not have a price set
Export
+ Added product type export
* Fixed export of customized ordering
+ Export now uses the template settings
/ Changed the types of export to match the types of import
Templates
/ Changed layout of templates
* Fixed " and ' as delimiter not showing
* Fixed skip first line not being updated
General
+ Converted CSV Improved into Joomla! component
* Added product_relations table to empty database list
Version 0.7.5
Import
* Fixed product adding error in certain cases
+ Added SQL Error reporting
/ Changed unsupported fields reporting
* Fixed bug with shopper group name if not specified
+ Added related products
+ Added multiple files
+ Added template system for import
General
+ Added attribute documentation
+ Created CSV Improved language file
+ Created CSV Improved CSS file
- Removed Dutch since the file is too old
Version 0.7.4
Import
* Fixed error "Missing argument 1 for product_details::ProcessDiscount()."
* Fixed first line of file not imported
* Fixed not adding or updating products
* Fixed category path not updated
Version 0.7.3
Import
- Removed product_discount_id
* Fixed child products upload
+ Added shopper group name to multiple prices upload
* Improved error handling on multiple prices upload
* Improved code for stabilizing import
Preview
* Removed Continue button when an error is encountered
General
* Updated language file
* Updated help texts
Version 0.7.2
Import
* Fixed error with field enclosure set to none
* Fixed error "Cannot break/continue ..."
* Fixed undefined variable
Configuration
* Fixed error with wrong datatype on saving the configuration
Version 0.7.1
Import
* Fixed product discount not being imported
* Fixed problem where download dialog pops up
* Fixed update of several fields not working
* Fixed price update if price is 0 or blank
* Re-added product_discount_id
* Fixed child products
Export
+ Added column headers to the Default ordering
* Export takes all fields as stated in configuration page
General
* Improved debug collection
* Fixed image not to display from front-end
* Fixed navigation bar in front-end after saving configuration
* Code rewrite export
- Removed required fields from configuration
Version 0.7
Import
+ Added field product_currency
+ Added option to import product types
+ Added option to import multiple prices per product
+ Added option to empty database
* Fixed skip first line with preview mode
* Fixed updating non-existing prices
* Fixed preview layout that is wider than the screen
Configuration
* Fixed Add Field button does not work
* Fixed problem with existing fields in csv table that are not supported
General
* Code rewrite
* Improved debug collection
* Updated Documentation tab
* Updated Available Fields tab
Translations
+ Added Dutch translation by giovi2002
Version 0.6.1
Import
* Fixed preview not working
* Fixed preview with Upload price list only
* Fixed preview with " or ' as enclosure character
* Fixed problem that uploaded file was always saved in cache folder
Version 0.6
Import
+ Added option to use column headers as configuration
+ Added option to preview import
+ Added option to collect debug information
* Improved support for child products
* Fixed bug with date import for product_available_date
Export
* Fixed broken export
General
* Replaced text input fields in configuration tab with dropdown menus for
easier configuration
* Finalized changes Documentation page
+ Added the About page
Version 0.5.1
Import
* Fixed bug where Price List Upload only did not work because of not
overwriting existing data
Version 0.5
Import
+ Added option to do a Upload price list only
* Only product_sku is mandatory now
* Fixed bug when using custom enclosure and/or delimeter
+ Added option to import manufacturers
* Fixed bug where product_publish was added twice to the SQL query
* Fixed bug where commas in product_price was not replaced with a period
* Fixed bug where all fields were imported
General
* Updated documentation
Version 0.4
Import
+ Added option to import product_available_date using a regular date format
+ Added option to import product_box
+ Added option to import product_packaging
+ Added option to import product discounts
* Fixed bug if product_publish is not used, items were not published
* Fixed bug if product_delete is not used, items were not added, import crashed
General
+ Added import statistics to the CSV upload result page
* Updated the message output on the CSV upload result page
* Updated localization
* Updated the descriptions on the Available Fields page
Version 0.3
Import
* Fixed if product_publish is empty, default is now set to Yes
* Fixed the vendor id. If no vendor is set, vendor id should be 1 instead of 0
+ Added a check for correct number of columns
+ Added option to choose not to overwrite existing data
+ Added option to skip the default value and not use the field in the update
Settings
/ Changed default field delimiter to ^ and text enclosure to ~
General
+ Added a link to the CSV import/export on the CSV upload result page
+ Added import flow description to readme.txt
* Updated the Available Fields page with the minimal required fields
* Updated the layout of the import/export tab
Version 0.2.1
Import
* Fixed a few undefined variables
* Fixed check for required fields
Version 0.2
Import
+ Allow empty fields
+ Made all fields from the product table optional except for product_id,
product_sku, vendor_id, cdate, mdate, product_name.
+ Possibility to delete products on import
General
+ Added a tab with the possible fields that can be used including documentation
/ Changed layout of the result page
/ Changed font size on the description page so it reads better in Firefox.
Version 0.1
Import
+ Numbers imported with a comma are changed to a period for correct database
insertion. This I found necessary since my locale uses comma as a seperator.
The only thing I do not know/understand is, how to get a comma on the webshop
frontend?
+ Imported data is sanitized for database insertion. This means that you can
use regular HTML code in your long description or apostrophe in your products
name for example.
Export
+ Removed backslashes from the export
Settings
+ Added the delimiter and field closure from Lauries Excel Generator
+ Added an inputbox for both the delimeter and field closure
+ Added an option to choose to add column headers
General
+ Renamed Field Required? to Field Included?
+ Made the system honor the choice to include or not include a field for exportPK >\) assets/.htaccessnu W+A
Order allow,deny
Deny from all
PK >\ assets/js/jquery.alerts.jsnu W+A // jQuery Alert Dialogs Plugin
//
// Version 1.1
//
// Cory S.N. LaViska
// A Beautiful Site (http://abeautifulsite.net/)
// 14 May 2009
//
// Visit http://abeautifulsite.net/notebook/87 for more information
//
// Usage:
// jAlert( message, [title, callback] )
// jConfirm( message, [title, callback] )
// jPrompt( message, [value, title, callback] )
//
// History:
//
// 1.00 - Released (29 December 2008)
//
// 1.01 - Fixed bug where unbinding would destroy all resize events
//
// License:
//
// This plugin is dual-licensed under the GNU General Public License and the MIT License and
// is copyright 2008 A Beautiful Site, LLC.
//
(function($) {
$.alerts = {
// These properties can be read/written by accessing $.alerts.propertyName from your scripts at any time
verticalOffset: -75, // vertical offset of the dialog from center screen, in pixels
horizontalOffset: 0, // horizontal offset of the dialog from center screen, in pixels/
repositionOnResize: true, // re-centers the dialog on window resize
overlayOpacity: .01, // transparency level of overlay
overlayColor: '#FFF', // base color of overlay
draggable: true, // make the dialogs draggable (requires UI Draggables plugin)
okButton: ' OK ', // text for the OK button
cancelButton: ' Cancel ', // text for the Cancel button
dialogClass: null, // if specified, this class will be applied to all dialogs
// Public methods
alert: function(message, title, callback) {
if( title == null ) title = 'Alert';
$.alerts._show(title, message, null, 'alert', function(result) {
if( callback ) callback(result);
});
},
confirm: function(message, title, callback) {
if( title == null ) title = 'Confirm';
$.alerts._show(title, message, null, 'confirm', function(result) {
if( callback ) callback(result);
});
},
prompt: function(message, value, title, callback) {
if( title == null ) title = 'Prompt';
$.alerts._show(title, message, value, 'prompt', function(result) {
if( callback ) callback(result);
});
},
// Private methods
_show: function(title, msg, value, type, callback) {
$.alerts._hide();
$.alerts._overlay('show');
$("BODY").append(
'
');
$("#popup_prompt").width( $("#popup_message").width() );
$("#popup_ok").click( function() {
var val = $("#popup_prompt").val();
$.alerts._hide();
if( callback ) callback( val );
});
$("#popup_cancel").click( function() {
$.alerts._hide();
if( callback ) callback( null );
});
$("#popup_prompt, #popup_ok, #popup_cancel").keypress( function(e) {
if( e.keyCode == 13 ) $("#popup_ok").trigger('click');
if( e.keyCode == 27 ) $("#popup_cancel").trigger('click');
});
if( value ) $("#popup_prompt").val(value);
$("#popup_prompt").focus().select();
break;
}
// Make draggable
if( $.alerts.draggable ) {
try {
$("#popup_container").draggable({ handle: $("#popup_title") });
$("#popup_title").css({ cursor: 'move' });
} catch(e) { /* requires jQuery UI draggables */ }
}
},
_hide: function() {
$("#popup_container").remove();
$.alerts._overlay('hide');
$.alerts._maintainPosition(false);
},
_overlay: function(status) {
switch( status ) {
case 'show':
$.alerts._overlay('hide');
$("BODY").append('');
$("#popup_overlay").css({
position: 'absolute',
zIndex: 99998,
top: '0px',
left: '0px',
width: '100%',
height: $(document).height(),
background: $.alerts.overlayColor,
opacity: $.alerts.overlayOpacity
});
break;
case 'hide':
$("#popup_overlay").remove();
break;
}
},
_reposition: function() {
var top = (($(window).height() / 2) - ($("#popup_container").outerHeight() / 2)) + $.alerts.verticalOffset;
var left = (($(window).width() / 2) - ($("#popup_container").outerWidth() / 2)) + $.alerts.horizontalOffset;
if( top < 0 ) top = 0;
if( left < 0 ) left = 0;
// IE6 fix
if( $.browser.msie && parseInt($.browser.version) <= 6 ) top = top + $(window).scrollTop();
$("#popup_container").css({
top: top + 'px',
left: left + 'px'
});
$("#popup_overlay").height( $(document).height() );
},
_maintainPosition: function(status) {
if( $.alerts.repositionOnResize ) {
switch(status) {
case true:
$(window).bind('resize', $.alerts._reposition);
break;
case false:
$(window).unbind('resize', $.alerts._reposition);
break;
}
}
}
}
// Shortuct functions
jAlert = function(message, title, callback) {
$.alerts.alert(message, title, callback);
}
jConfirm = function(message, title, callback) {
$.alerts.confirm(message, title, callback);
};
jPrompt = function(message, value, title, callback) {
$.alerts.prompt(message, value, title, callback);
};
})(jQuery);PK >\) assets/js/.htaccessnu W+A
Order allow,deny
Deny from all
PK >\ assets/js/index.htmlnu W+A PK >\d5C C assets/js/jquery.tablednd_0_5.jsnu W+A /**
* TableDnD plug-in for JQuery, allows you to drag and drop table rows
* You can set up various options to control how the system will work
* Copyright (c) Denis Howlett
* Licensed like jQuery, see http://docs.jquery.com/License.
*
* Configuration options:
*
* onDragStyle
* This is the style that is assigned to the row during drag. There are limitations to the styles that can be
* associated with a row (such as you can't assign a border--well you can, but it won't be
* displayed). (So instead consider using onDragClass.) The CSS style to apply is specified as
* a map (as used in the jQuery css(...) function).
* onDropStyle
* This is the style that is assigned to the row when it is dropped. As for onDragStyle, there are limitations
* to what you can do. Also this replaces the original style, so again consider using onDragClass which
* is simply added and then removed on drop.
* onDragClass
* This class is added for the duration of the drag and then removed when the row is dropped. It is more
* flexible than using onDragStyle since it can be inherited by the row cells and other content. The default
* is class is tDnD_whileDrag. So to use the default, simply customise this CSS class in your
* stylesheet.
* onDrop
* Pass a function that will be called when the row is dropped. The function takes 2 parameters: the table
* and the row that was dropped. You can work out the new order of the rows by using
* table.rows.
* onDragStart
* Pass a function that will be called when the user starts dragging. The function takes 2 parameters: the
* table and the row which the user has started to drag.
* onAllowDrop
* Pass a function that will be called as a row is over another row. If the function returns true, allow
* dropping on that row, otherwise not. The function takes 2 parameters: the dragged row and the row under
* the cursor. It returns a boolean: true allows the drop, false doesn't allow it.
* scrollAmount
* This is the number of pixels to scroll if the user moves the mouse cursor to the top or bottom of the
* window. The page should automatically scroll up or down as appropriate (tested in IE6, IE7, Safari, FF2,
* FF3 beta
* dragHandle
* This is the name of a class that you assign to one or more cells in each row that is draggable. If you
* specify this class, then you are responsible for setting cursor: move in the CSS and only these cells
* will have the drag behaviour. If you do not specify a dragHandle, then you get the old behaviour where
* the whole row is draggable.
*
* Other ways to control behaviour:
*
* Add class="nodrop" to any rows for which you don't want to allow dropping, and class="nodrag" to any rows
* that you don't want to be draggable.
*
* Inside the onDrop method you can also call $.tableDnD.serialize() this returns a string of the form
* []=&[]= so that you can send this back to the server. The table must have
* an ID as must all the rows.
*
* Other methods:
*
* $("...").tableDnDUpdate()
* Will update all the matching tables, that is it will reapply the mousedown method to the rows (or handle cells).
* This is useful if you have updated the table rows using Ajax and you want to make the table draggable again.
* The table maintains the original configuration (so you don't have to specify it again).
*
* $("...").tableDnDSerialize()
* Will serialize and return the serialized string as above, but for each of the matching tables--so it can be
* called from anywhere and isn't dependent on the currentTable being set up correctly before calling
*
* Known problems:
* - Auto-scoll has some problems with IE7 (it scrolls even when it shouldn't), work-around: set scrollAmount to 0
*
* Version 0.2: 2008-02-20 First public version
* Version 0.3: 2008-02-07 Added onDragStart option
* Made the scroll amount configurable (default is 5 as before)
* Version 0.4: 2008-03-15 Changed the noDrag/noDrop attributes to nodrag/nodrop classes
* Added onAllowDrop to control dropping
* Fixed a bug which meant that you couldn't set the scroll amount in both directions
* Added serialize method
* Version 0.5: 2008-05-16 Changed so that if you specify a dragHandle class it doesn't make the whole row
* draggable
* Improved the serialize method to use a default (and settable) regular expression.
* Added tableDnDupate() and tableDnDSerialize() to be called when you are outside the table
*/
jQuery.tableDnD = {
/** Keep hold of the current table being dragged */
currentTable : null,
/** Keep hold of the current drag object if any */
dragObject: null,
/** The current mouse offset */
mouseOffset: null,
/** Remember the old value of Y so that we don't do too much processing */
oldY: 0,
/** Actually build the structure */
build: function(options) {
// Set up the defaults if any
this.each(function() {
// This is bound to each matching table, set up the defaults and override with user options
this.tableDnDConfig = jQuery.extend({
onDragStyle: null,
onDropStyle: null,
// Add in the default class for whileDragging
onDragClass: "tDnD_whileDrag",
onDrop: null,
onDragStart: null,
scrollAmount: 5,
serializeRegexp: /[^\-]*$/, // The regular expression to use to trim row IDs
serializeParamName: null, // If you want to specify another parameter name instead of the table ID
dragHandle: null // If you give the name of a class here, then only Cells with this class will be draggable
}, options || {});
// Now make the rows draggable
jQuery.tableDnD.makeDraggable(this);
});
// Now we need to capture the mouse up and mouse move event
// We can use bind so that we don't interfere with other event handlers
jQuery(document)
.bind('mousemove', jQuery.tableDnD.mousemove)
.bind('mouseup', jQuery.tableDnD.mouseup);
// Don't break the chain
return this;
},
/** This function makes all the rows on the table draggable apart from those marked as "NoDrag" */
makeDraggable: function(table) {
var config = table.tableDnDConfig;
if (table.tableDnDConfig.dragHandle) {
// We only need to add the event to the specified cells
var cells = jQuery("td."+table.tableDnDConfig.dragHandle, table);
cells.each(function() {
// The cell is bound to "this"
jQuery(this).mousedown(function(ev) {
jQuery.tableDnD.dragObject = this.parentNode;
jQuery.tableDnD.currentTable = table;
jQuery.tableDnD.mouseOffset = jQuery.tableDnD.getMouseOffset(this, ev);
if (config.onDragStart) {
// Call the onDrop method if there is one
config.onDragStart(table, this);
}
return false;
});
})
} else {
// For backwards compatibility, we add the event to the whole row
var rows = jQuery("tr", table); // get all the rows as a wrapped set
rows.each(function() {
// Iterate through each row, the row is bound to "this"
var row = jQuery(this);
if (! row.hasClass("nodrag")) {
row.mousedown(function(ev) {
if (ev.target.tagName == "TD") {
jQuery.tableDnD.dragObject = this;
jQuery.tableDnD.currentTable = table;
jQuery.tableDnD.mouseOffset = jQuery.tableDnD.getMouseOffset(this, ev);
if (config.onDragStart) {
// Call the onDrop method if there is one
config.onDragStart(table, this);
}
return false;
}
}).css("cursor", "move"); // Store the tableDnD object
}
});
}
},
updateTables: function() {
this.each(function() {
// this is now bound to each matching table
if (this.tableDnDConfig) {
jQuery.tableDnD.makeDraggable(this);
}
})
},
/** Get the mouse coordinates from the event (allowing for browser differences) */
mouseCoords: function(ev){
if(ev.pageX || ev.pageY){
return {x:ev.pageX, y:ev.pageY};
}
return {
x:ev.clientX + document.body.scrollLeft - document.body.clientLeft,
y:ev.clientY + document.body.scrollTop - document.body.clientTop
};
},
/** Given a target element and a mouse event, get the mouse offset from that element.
To do this we need the element's position and the mouse position */
getMouseOffset: function(target, ev) {
ev = ev || window.event;
var docPos = this.getPosition(target);
var mousePos = this.mouseCoords(ev);
return {x:mousePos.x - docPos.x, y:mousePos.y - docPos.y};
},
/** Get the position of an element by going up the DOM tree and adding up all the offsets */
getPosition: function(e){
var left = 0;
var top = 0;
/** Safari fix -- thanks to Luis Chato for this! */
if (e.offsetHeight == 0) {
/** Safari 2 doesn't correctly grab the offsetTop of a table row
this is detailed here:
http://jacob.peargrove.com/blog/2006/technical/table-row-offsettop-bug-in-safari/
the solution is likewise noted there, grab the offset of a table cell in the row - the firstChild.
note that firefox will return a text node as a first child, so designing a more thorough
solution may need to take that into account, for now this seems to work in firefox, safari, ie */
e = e.firstChild; // a table cell
}
while (e.offsetParent){
left += e.offsetLeft;
top += e.offsetTop;
e = e.offsetParent;
}
left += e.offsetLeft;
top += e.offsetTop;
return {x:left, y:top};
},
mousemove: function(ev) {
if (jQuery.tableDnD.dragObject == null) {
return;
}
var dragObj = jQuery(jQuery.tableDnD.dragObject);
var config = jQuery.tableDnD.currentTable.tableDnDConfig;
var mousePos = jQuery.tableDnD.mouseCoords(ev);
var y = mousePos.y - jQuery.tableDnD.mouseOffset.y;
//auto scroll the window
var yOffset = window.pageYOffset;
if (document.all) {
// Windows version
//yOffset=document.body.scrollTop;
if (typeof document.compatMode != 'undefined' &&
document.compatMode != 'BackCompat') {
yOffset = document.documentElement.scrollTop;
}
else if (typeof document.body != 'undefined') {
yOffset=document.body.scrollTop;
}
}
if (mousePos.y-yOffset < config.scrollAmount) {
window.scrollBy(0, -config.scrollAmount);
} else {
var windowHeight = window.innerHeight ? window.innerHeight
: document.documentElement.clientHeight ? document.documentElement.clientHeight : document.body.clientHeight;
if (windowHeight-(mousePos.y-yOffset) < config.scrollAmount) {
window.scrollBy(0, config.scrollAmount);
}
}
if (y != jQuery.tableDnD.oldY) {
// work out if we're going up or down...
var movingDown = y > jQuery.tableDnD.oldY;
// update the old value
jQuery.tableDnD.oldY = y;
// update the style to show we're dragging
if (config.onDragClass) {
dragObj.addClass(config.onDragClass);
} else {
dragObj.css(config.onDragStyle);
}
// If we're over a row then move the dragged row to there so that the user sees the
// effect dynamically
var currentRow = jQuery.tableDnD.findDropTargetRow(dragObj, y);
/**
if (currentRow) {
// TODO worry about what happens when there are multiple TBODIES
if (movingDown && jQuery.tableDnD.dragObject != currentRow) {
jQuery.tableDnD.dragObject.parentNode.insertBefore(jQuery.tableDnD.dragObject, currentRow.nextSibling);
} else if (! movingDown && jQuery.tableDnD.dragObject != currentRow) {
jQuery.tableDnD.dragObject.parentNode.insertBefore(jQuery.tableDnD.dragObject, currentRow);
}
}
*/
if (currentRow) {
// TODO worry about what happens when there are multiple TBODIES
if (movingDown && jQuery.tableDnD.dragObject != currentRow) {
if(currentRow.parentNode == jQuery.tableDnD.dragObject.parentNode) {
jQuery.tableDnD.dragObject.parentNode.insertBefore(jQuery.tableDnD.dragObject, currentRow.nextSibling);
}
}
else if (! movingDown && jQuery.tableDnD.dragObject != currentRow) {
if(currentRow.parentNode == jQuery.tableDnD.dragObject.parentNode) {
jQuery.tableDnD.dragObject.parentNode.insertBefore(jQuery.tableDnD.dragObject, currentRow);
}
}
}
}
return false;
},
/** We're only worried about the y position really, because we can only move rows up and down */
findDropTargetRow: function(draggedRow, y) {
var rows = jQuery.tableDnD.currentTable.rows;
for (var i=0; i rowY - rowHeight) && (y < (rowY + rowHeight))) {
// that's the row we're over
// If it's the same as the current row, ignore it
if (row == draggedRow) {return null;}
var config = jQuery.tableDnD.currentTable.tableDnDConfig;
if (config.onAllowDrop) {
if (config.onAllowDrop(draggedRow, row)) {
return row;
} else {
return null;
}
} else {
// If a row has nodrop class, then don't allow dropping (inspired by John Tarr and Famic)
var nodrop = jQuery(row).hasClass("nodrop");
if (! nodrop) {
return row;
} else {
return null;
}
}
return row;
}
}
return null;
},
mouseup: function(e) {
if (jQuery.tableDnD.currentTable && jQuery.tableDnD.dragObject) {
var droppedRow = jQuery.tableDnD.dragObject;
var config = jQuery.tableDnD.currentTable.tableDnDConfig;
// If we have a dragObject, then we need to release it,
// The row will already have been moved to the right place so we just reset stuff
if (config.onDragClass) {
jQuery(droppedRow).removeClass(config.onDragClass);
} else {
jQuery(droppedRow).css(config.onDropStyle);
}
jQuery.tableDnD.dragObject = null;
if (config.onDrop) {
// Call the onDrop method if there is one
config.onDrop(jQuery.tableDnD.currentTable, droppedRow);
}
jQuery.tableDnD.currentTable = null; // let go of the table too
}
},
serialize: function() {
if (jQuery.tableDnD.currentTable) {
return jQuery.tableDnD.serializeTable(jQuery.tableDnD.currentTable);
} else {
return "Error: No Table id set, you need to set an id on your table and every row";
}
},
serializeTable: function(table) {
var result = "";
var tableId = table.id;
var rows = table.rows;
for (var i=0; i 0) result += "&";
var rowId = rows[i].id;
if (rowId && rowId && table.tableDnDConfig && table.tableDnDConfig.serializeRegexp) {
rowId = rowId.match(table.tableDnDConfig.serializeRegexp)[0];
}
result += tableId + '[]=' + rowId;
}
return result;
},
serializeTables: function() {
var result = "";
this.each(function() {
// this is now bound to each matching table
result += jQuery.tableDnD.serializeTable(this);
});
return result;
}
}
jQuery.fn.extend(
{
tableDnD : jQuery.tableDnD.build,
tableDnDUpdate : jQuery.tableDnD.updateTables,
tableDnDSerialize: jQuery.tableDnD.serializeTables
}
);PK >\\
assets/js/jquery.timers.jsnu W+A /**
* jQuery.timers - Timer abstractions for jQuery
* Written by Blair Mitchelmore (blair DOT mitchelmore AT gmail DOT com)
* Licensed under the WTFPL (http://sam.zoy.org/wtfpl/).
* Date: 2009/10/16
*
* @author Blair Mitchelmore
* @version 1.2
*
**/
jQuery.fn.extend({
everyTime: function(interval, label, fn, times) {
return this.each(function() {
jQuery.timer.add(this, interval, label, fn, times);
});
},
oneTime: function(interval, label, fn) {
return this.each(function() {
jQuery.timer.add(this, interval, label, fn, 1);
});
},
stopTime: function(label, fn) {
return this.each(function() {
jQuery.timer.remove(this, label, fn);
});
}
});
jQuery.extend({
timer: {
global: [],
guid: 1,
dataKey: "jQuery.timer",
regex: /^([0-9]+(?:\.[0-9]*)?)\s*(.*s)?$/,
powers: {
// Yeah this is major overkill...
'ms': 1,
'cs': 10,
'ds': 100,
's': 1000,
'das': 10000,
'hs': 100000,
'ks': 1000000
},
timeParse: function(value) {
if (value == undefined || value == null)
return null;
var result = this.regex.exec(jQuery.trim(value.toString()));
if (result[2]) {
var num = parseFloat(result[1]);
var mult = this.powers[result[2]] || 1;
return num * mult;
} else {
return value;
}
},
add: function(element, interval, label, fn, times) {
var counter = 0;
if (jQuery.isFunction(label)) {
if (!times)
times = fn;
fn = label;
label = interval;
}
interval = jQuery.timer.timeParse(interval);
if (typeof interval != 'number' || isNaN(interval) || interval < 0)
return;
if (typeof times != 'number' || isNaN(times) || times < 0)
times = 0;
times = times || 0;
var timers = jQuery.data(element, this.dataKey) || jQuery.data(element, this.dataKey, {});
if (!timers[label])
timers[label] = {};
fn.timerID = fn.timerID || this.guid++;
var handler = function() {
if ((++counter > times && times !== 0) || fn.call(element, counter) === false)
jQuery.timer.remove(element, label, fn);
};
handler.timerID = fn.timerID;
if (!timers[label][fn.timerID])
timers[label][fn.timerID] = window.setInterval(handler,interval);
this.global.push( element );
},
remove: function(element, label, fn) {
var timers = jQuery.data(element, this.dataKey), ret;
if ( timers ) {
if (!label) {
for ( label in timers )
this.remove(element, label, fn);
} else if ( timers[label] ) {
if ( fn ) {
if ( fn.timerID ) {
window.clearInterval(timers[label][fn.timerID]);
delete timers[label][fn.timerID];
}
} else {
for ( var fn in timers[label] ) {
window.clearInterval(timers[label][fn]);
delete timers[label][fn];
}
}
for ( ret in timers[label] ) break;
if ( !ret ) {
ret = null;
delete timers[label];
}
}
for ( ret in timers ) break;
if ( !ret )
jQuery.removeData(element, this.dataKey);
}
}
}
});
jQuery(window).bind("unload", function() {
jQuery.each(jQuery.timer.global, function(index, item) {
jQuery.timer.remove(item);
});
});
PK >\Y~n n assets/js/jquery.jsnu W+A /*! jQuery v1.7.1 jquery.com | jquery.org/license */
(function(a,b){function cy(a){return f.isWindow(a)?a:a.nodeType===9?a.defaultView||a.parentWindow:!1}function cv(a){if(!ck[a]){var b=c.body,d=f("<"+a+">").appendTo(b),e=d.css("display");d.remove();if(e==="none"||e===""){cl||(cl=c.createElement("iframe"),cl.frameBorder=cl.width=cl.height=0),b.appendChild(cl);if(!cm||!cl.createElement)cm=(cl.contentWindow||cl.contentDocument).document,cm.write((c.compatMode==="CSS1Compat"?"":"")+""),cm.close();d=cm.createElement(a),cm.body.appendChild(d),e=f.css(d,"display"),b.removeChild(cl)}ck[a]=e}return ck[a]}function cu(a,b){var c={};f.each(cq.concat.apply([],cq.slice(0,b)),function(){c[this]=a});return c}function ct(){cr=b}function cs(){setTimeout(ct,0);return cr=f.now()}function cj(){try{return new a.ActiveXObject("Microsoft.XMLHTTP")}catch(b){}}function ci(){try{return new a.XMLHttpRequest}catch(b){}}function cc(a,c){a.dataFilter&&(c=a.dataFilter(c,a.dataType));var d=a.dataTypes,e={},g,h,i=d.length,j,k=d[0],l,m,n,o,p;for(g=1;g0){if(c!=="border")for(;g=0===c})}function S(a){return!a||!a.parentNode||a.parentNode.nodeType===11}function K(){return!0}function J(){return!1}function n(a,b,c){var d=b+"defer",e=b+"queue",g=b+"mark",h=f._data(a,d);h&&(c==="queue"||!f._data(a,e))&&(c==="mark"||!f._data(a,g))&&setTimeout(function(){!f._data(a,e)&&!f._data(a,g)&&(f.removeData(a,d,!0),h.fire())},0)}function m(a){for(var b in a){if(b==="data"&&f.isEmptyObject(a[b]))continue;if(b!=="toJSON")return!1}return!0}function l(a,c,d){if(d===b&&a.nodeType===1){var e="data-"+c.replace(k,"-$1").toLowerCase();d=a.getAttribute(e);if(typeof d=="string"){try{d=d==="true"?!0:d==="false"?!1:d==="null"?null:f.isNumeric(d)?parseFloat(d):j.test(d)?f.parseJSON(d):d}catch(g){}f.data(a,c,d)}else d=b}return d}function h(a){var b=g[a]={},c,d;a=a.split(/\s+/);for(c=0,d=a.length;c)[^>]*$|#([\w\-]*)$)/,j=/\S/,k=/^\s+/,l=/\s+$/,m=/^<(\w+)\s*\/?>(?:<\/\1>)?$/,n=/^[\],:{}\s]*$/,o=/\\(?:["\\\/bfnrt]|u[0-9a-fA-F]{4})/g,p=/"[^"\\\n\r]*"|true|false|null|-?\d+(?:\.\d*)?(?:[eE][+\-]?\d+)?/g,q=/(?:^|:|,)(?:\s*\[)+/g,r=/(webkit)[ \/]([\w.]+)/,s=/(opera)(?:.*version)?[ \/]([\w.]+)/,t=/(msie) ([\w.]+)/,u=/(mozilla)(?:.*? rv:([\w.]+))?/,v=/-([a-z]|[0-9])/ig,w=/^-ms-/,x=function(a,b){return(b+"").toUpperCase()},y=d.userAgent,z,A,B,C=Object.prototype.toString,D=Object.prototype.hasOwnProperty,E=Array.prototype.push,F=Array.prototype.slice,G=String.prototype.trim,H=Array.prototype.indexOf,I={};e.fn=e.prototype={constructor:e,init:function(a,d,f){var g,h,j,k;if(!a)return this;if(a.nodeType){this.context=this[0]=a,this.length=1;return this}if(a==="body"&&!d&&c.body){this.context=c,this[0]=c.body,this.selector=a,this.length=1;return this}if(typeof a=="string"){a.charAt(0)!=="<"||a.charAt(a.length-1)!==">"||a.length<3?g=i.exec(a):g=[null,a,null];if(g&&(g[1]||!d)){if(g[1]){d=d instanceof e?d[0]:d,k=d?d.ownerDocument||d:c,j=m.exec(a),j?e.isPlainObject(d)?(a=[c.createElement(j[1])],e.fn.attr.call(a,d,!0)):a=[k.createElement(j[1])]:(j=e.buildFragment([g[1]],[k]),a=(j.cacheable?e.clone(j.fragment):j.fragment).childNodes);return e.merge(this,a)}h=c.getElementById(g[2]);if(h&&h.parentNode){if(h.id!==g[2])return f.find(a);this.length=1,this[0]=h}this.context=c,this.selector=a;return this}return!d||d.jquery?(d||f).find(a):this.constructor(d).find(a)}if(e.isFunction(a))return f.ready(a);a.selector!==b&&(this.selector=a.selector,this.context=a.context);return e.makeArray(a,this)},selector:"",jquery:"1.7.1",length:0,size:function(){return this.length},toArray:function(){return F.call(this,0)},get:function(a){return a==null?this.toArray():a<0?this[this.length+a]:this[a]},pushStack:function(a,b,c){var d=this.constructor();e.isArray(a)?E.apply(d,a):e.merge(d,a),d.prevObject=this,d.context=this.context,b==="find"?d.selector=this.selector+(this.selector?" ":"")+c:b&&(d.selector=this.selector+"."+b+"("+c+")");return d},each:function(a,b){return e.each(this,a,b)},ready:function(a){e.bindReady(),A.add(a);return this},eq:function(a){a=+a;return a===-1?this.slice(a):this.slice(a,a+1)},first:function(){return this.eq(0)},last:function(){return this.eq(-1)},slice:function(){return this.pushStack(F.apply(this,arguments),"slice",F.call(arguments).join(","))},map:function(a){return this.pushStack(e.map(this,function(b,c){return a.call(b,c,b)}))},end:function(){return this.prevObject||this.constructor(null)},push:E,sort:[].sort,splice:[].splice},e.fn.init.prototype=e.fn,e.extend=e.fn.extend=function(){var a,c,d,f,g,h,i=arguments[0]||{},j=1,k=arguments.length,l=!1;typeof i=="boolean"&&(l=i,i=arguments[1]||{},j=2),typeof i!="object"&&!e.isFunction(i)&&(i={}),k===j&&(i=this,--j);for(;j0)return;A.fireWith(c,[e]),e.fn.trigger&&e(c).trigger("ready").off("ready")}},bindReady:function(){if(!A){A=e.Callbacks("once memory");if(c.readyState==="complete")return setTimeout(e.ready,1);if(c.addEventListener)c.addEventListener("DOMContentLoaded",B,!1),a.addEventListener("load",e.ready,!1);else if(c.attachEvent){c.attachEvent("onreadystatechange",B),a.attachEvent("onload",e.ready);var b=!1;try{b=a.frameElement==null}catch(d){}c.documentElement.doScroll&&b&&J()}}},isFunction:function(a){return e.type(a)==="function"},isArray:Array.isArray||function(a){return e.type(a)==="array"},isWindow:function(a){return a&&typeof a=="object"&&"setInterval"in a},isNumeric:function(a){return!isNaN(parseFloat(a))&&isFinite(a)},type:function(a){return a==null?String(a):I[C.call(a)]||"object"},isPlainObject:function(a){if(!a||e.type(a)!=="object"||a.nodeType||e.isWindow(a))return!1;try{if(a.constructor&&!D.call(a,"constructor")&&!D.call(a.constructor.prototype,"isPrototypeOf"))return!1}catch(c){return!1}var d;for(d in a);return d===b||D.call(a,d)},isEmptyObject:function(a){for(var b in a)return!1;return!0},error:function(a){throw new Error(a)},parseJSON:function(b){if(typeof b!="string"||!b)return null;b=e.trim(b);if(a.JSON&&a.JSON.parse)return a.JSON.parse(b);if(n.test(b.replace(o,"@").replace(p,"]").replace(q,"")))return(new Function("return "+b))();e.error("Invalid JSON: "+b)},parseXML:function(c){var d,f;try{a.DOMParser?(f=new DOMParser,d=f.parseFromString(c,"text/xml")):(d=new ActiveXObject("Microsoft.XMLDOM"),d.async="false",d.loadXML(c))}catch(g){d=b}(!d||!d.documentElement||d.getElementsByTagName("parsererror").length)&&e.error("Invalid XML: "+c);return d},noop:function(){},globalEval:function(b){b&&j.test(b)&&(a.execScript||function(b){a.eval.call(a,b)})(b)},camelCase:function(a){return a.replace(w,"ms-").replace(v,x)},nodeName:function(a,b){return a.nodeName&&a.nodeName.toUpperCase()===b.toUpperCase()},each:function(a,c,d){var f,g=0,h=a.length,i=h===b||e.isFunction(a);if(d){if(i){for(f in a)if(c.apply(a[f],d)===!1)break}else for(;g0&&a[0]&&a[j-1]||j===0||e.isArray(a));if(k)for(;i1?i.call(arguments,0):b,j.notifyWith(k,e)}}function l(a){return function(c){b[a]=arguments.length>1?i.call(arguments,0):c,--g||j.resolveWith(j,b)}}var b=i.call(arguments,0),c=0,d=b.length,e=Array(d),g=d,h=d,j=d<=1&&a&&f.isFunction(a.promise)?a:f.Deferred(),k=j.promise();if(d>1){for(;c
a",d=q.getElementsByTagName("*"),e=q.getElementsByTagName("a")[0];if(!d||!d.length||!e)return{};g=c.createElement("select"),h=g.appendChild(c.createElement("option")),i=q.getElementsByTagName("input")[0],b={leadingWhitespace:q.firstChild.nodeType===3,tbody:!q.getElementsByTagName("tbody").length,htmlSerialize:!!q.getElementsByTagName("link").length,style:/top/.test(e.getAttribute("style")),hrefNormalized:e.getAttribute("href")==="/a",opacity:/^0.55/.test(e.style.opacity),cssFloat:!!e.style.cssFloat,checkOn:i.value==="on",optSelected:h.selected,getSetAttribute:q.className!=="t",enctype:!!c.createElement("form").enctype,html5Clone:c.createElement("nav").cloneNode(!0).outerHTML!=="<:nav>",submitBubbles:!0,changeBubbles:!0,focusinBubbles:!1,deleteExpando:!0,noCloneEvent:!0,inlineBlockNeedsLayout:!1,shrinkWrapBlocks:!1,reliableMarginRight:!0},i.checked=!0,b.noCloneChecked=i.cloneNode(!0).checked,g.disabled=!0,b.optDisabled=!h.disabled;try{delete q.test}catch(s){b.deleteExpando=!1}!q.addEventListener&&q.attachEvent&&q.fireEvent&&(q.attachEvent("onclick",function(){b.noCloneEvent=!1}),q.cloneNode(!0).fireEvent("onclick")),i=c.createElement("input"),i.value="t",i.setAttribute("type","radio"),b.radioValue=i.value==="t",i.setAttribute("checked","checked"),q.appendChild(i),k=c.createDocumentFragment(),k.appendChild(q.lastChild),b.checkClone=k.cloneNode(!0).cloneNode(!0).lastChild.checked,b.appendChecked=i.checked,k.removeChild(i),k.appendChild(q),q.innerHTML="",a.getComputedStyle&&(j=c.createElement("div"),j.style.width="0",j.style.marginRight="0",q.style.width="2px",q.appendChild(j),b.reliableMarginRight=(parseInt((a.getComputedStyle(j,null)||{marginRight:0}).marginRight,10)||0)===0);if(q.attachEvent)for(o in{submit:1,change:1,focusin:1})n="on"+o,p=n in q,p||(q.setAttribute(n,"return;"),p=typeof q[n]=="function"),b[o+"Bubbles"]=p;k.removeChild(q),k=g=h=j=q=i=null,f(function(){var a,d,e,g,h,i,j,k,m,n,o,r=c.getElementsByTagName("body")[0];!r||(j=1,k="position:absolute;top:0;left:0;width:1px;height:1px;margin:0;",m="visibility:hidden;border:0;",n="style='"+k+"border:5px solid #000;padding:0;'",o="
