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

PATH: home / centosnipponia / public_html / wh

<?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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ArticuloDescripcion` varchar(191)  CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ArticuloClasificacion1` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Zona` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Bodega` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Cliente` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Vendedor` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Factura` varchar(191)  CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `vin` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `FechaFactura` datetime CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `SemanaFactura` int(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `MesFactura` int(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `TrimestreFactura` int(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `AnoFactura` int(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Cantidad` int(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Impuesto1Local` double(8,2) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Impuesto1Dolar` double(8,2) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `TotalImpuestoLocal` double(8,2) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3618 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;
}

[+] ..
[+] ediwarehousebot
[+] 2
[-] style.css [edit]
[-] config.php [edit]
[-] test1.php [edit]
[-] t1.php [edit]
[-] header.php [edit]
[-] ml.php-an theloume na to steiloyme mono toy [edit]
[+] vendor
[-] headerpending.php [edit]
[-] error_log [edit]
[-] pending.php [edit]
[-] delivered.php [edit]
[-] 2.php [edit]
[-] script.js [edit]
[-] headerdelivered.php [edit]
[-] 3.php [edit]
[+] old
[+] cgi-bin
[+] .well-known
[+] E3
[+] drage
[+] f7
[+] eviball
[+] capetown
[+] eurostock
[+] 2fast
[+] biq
[+] cite
[+] ilark
[+] pride
[+] dragb
[+] itank
[-] sql_command_import_capetown.php [edit]
[+] itango
[+] sales_rd
[+] rd
[+] one
[-] jSignature-master.zip [edit]
[+] jsi
[+] nce
[-] sales_rd.zip [edit]
[+] RrVFn0it5f
[-] wap.php [edit]
[-] index.php [edit]
[-] products.php [edit]
[-] detail.php [edit]
[-] .htaccess.disabled [edit]
[-] 1.php.quarantine [edit]