ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: home / centosnipponia / public_html / wh / capetown

<?php

require __DIR__ . '/functions_csv_handle.php';

$folder_path='/home/centosnipponia/public_html/wh/capetown/';

check_for_updates($folder_path);
 function create_insert_db($filepath) {
	
  //echo $filepath;
$sql_delivery =//"INSERT INTO saleunitscapetown(ArticuloCodigo,AnoFactura,MesFactura,ArticuloDescripcion,ArticuloClasificacion1,Zona,Bodega,Cliente,Vendedor,FACTURA,FechaFactura,SemanaFactura,TrimestreFactura,Cantidad,Impuesto1Local,Impuesto1Dolar,TotalImpuestoLocal,vin) VALUES ";
 "DROP TABLE IF EXISTS `saleunitscapetown`;
CREATE TABLE IF NOT EXISTS `saleunitscapetown` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `ArticuloCodigo` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ArticuloDescripcion` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ArticuloClasificacion1` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Zona` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Bodega` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Cliente` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Vendedor` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Factura` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `vin` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `FechaFactura` datetime DEFAULT NULL,
  `SemanaFactura` int(11) DEFAULT NULL,
  `MesFactura` int(11) DEFAULT NULL,
  `TrimestreFactura` int(11) DEFAULT NULL,
  `AnoFactura` int(11) DEFAULT NULL,
  `Cantidad` int(11) DEFAULT NULL,
  `Impuesto1Local` double(8,2) DEFAULT NULL,
  `Impuesto1Dolar` double(8,2) DEFAULT NULL,
  `TotalImpuestoLocal` double(8,2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  AUTO_INCREMENT=4595 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
INSERT INTO saleunitscapetown(ArticuloCodigo,AnoFactura,MesFactura,ArticuloDescripcion,ArticuloClasificacion1,Zona,Bodega,Cliente,Vendedor,FACTURA,FechaFactura,SemanaFactura,TrimestreFactura,Cantidad,Impuesto1Local,Impuesto1Dolar,TotalImpuestoLocal,vin) VALUES
";
$max_rows=count_csv_rows($filepath);

if($max_rows>0){

$row_current_nbr=2;
$lines="";
$row_comma_separated="";
$first_row=false;//den exei epikefalides
fix_file($filepath);
$file = fopen($filepath,"r");
while($row_current_nbr<$max_rows+1)
				  {
					  $row_current_nbr=$row_current_nbr+1;
					  if($first_row) {
						  $first_row=false;
						  
						  fgetcsv($file);
							  } else
					  {
						  //echo fgetcsv($file)[0];
				  //$cleaned_row=str_replace(",","",);
				  $cleaned_row=str_replace("'","\'",fgetcsv($file)[0]);
				  //$cleaned_row=str_replace(",",";", $cleaned_row);
				  $row_array =explode(";",$cleaned_row);
				 // print_r($row_array);
			
				 $row_comma_separated="('".implode("','", $row_array)."'),";
//print_r($row_comma_separated);
				//echo ($row_comma_separated);
				  
					  }
 		$lines.= $row_comma_separated;			  
				  }
				  	
 
fclose($file);
$sql_delivery.=$lines;
$sql_delivery=substr_replace($sql_delivery,";",-1);

} else
	
	{
	$sql_delivery ="SELECT 1"; 	
	}

//echo $sql_delivery;

return $sql_delivery;
}

[+] ..
[+] imported
[-] functions_csv_handle.php [edit]
[-] sql_command_import_capetown.php [edit]
[-] .htaccess.disabled [edit]