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

PATH: home / centosnipponia / public_html / wh / old

<?php
require __DIR__ . '/header.php';
//sale orders tranfers
$query_arguments=array('&','&','&','&','&',array('product_type','=','product'),array(['order_id.warehouse_id'][0],'=',158),array('qty_delivered','=',0),array('state','=','sale'),array('create_date','>=',$today_midnight_mysql),array('x_tracking_product','=','serial'));
$uii=$models->execute_kw($db, $uid, $password,'sale.order.line', 'search_read',array($query_arguments), array('limit'=>100));
//var_dump($uii);
//sale orders tranfers   
//$csv = "Tranfer number,Model,Qty,Destination(Customer-Address),Phone number,Date created \n";//Column headers
$csv = "Company;Tranfer number;Model;Colour;Speed;Qty;Destination Name;Destination Address;Destination Post Code;Destination City;Destination Country;Phone No.;Date created \n";//Column headers

echo '<thead><tr><th>Company</th><th>Tranfer number</th><th>Model</th><th>Color</th><th>Speedversion</th><th>Qty</th><th>Destination Name</th><th>Destination Address</th><th>Destination Post Code</th><th>Destination City</th><th>Destination Country</th><th>Phone No.</th><th>Date created</th><th>VIN delivered</th><th></th></thead>'."\n";
foreach($uii as $result) {
//echo '<tr><td>'.'Sale Order '.$result['order_id'][1].'</td><td>'.$result['name'].'</td><td>'.$result['product_uom_qty'].'</td><td>'.$result['x_dest_address_va'].' - Ph:'.$result['x_dest_ph_va'].'</td><td>'.$result['create_date'].'</td><td>  <input type=text id='.'SOi'.$result['id'].' minlength=3 required  name='.'SO'.$result['id'].'></td><td><label id='.'SOi'.$result['id'].' for='.'SO'.$result['id'].'></label> </td></tr>'."\n";//order_id,create_date
echo '<tr><td>Trade & Traffic</td><td>'.'Sale Order '.$result['order_id'][1].'</td><td>'.explode("(",$result['product_id'][1])[0].'</td><td>'.$result['x_scolorva2'].'</td><td>'.str_replace("Speedversion: ","",$result['x_sspeedva2']).'</td><td>'.$result['product_uom_qty'].'</td><td>'.$result['x_sdest_companyva2'].'</td><td>'.$result['x_dest_street_va2'].'</td><td>'.$result['x_sdest_zip_va2'].'</td><td>'.$result['x_sdest_city_va2'].'</td><td>'.$result['x_sdest_countryva2'].'</td><td>'.$result['x_dest_ph_va'].'</td><td>'.$result['create_date'].'</td><td>  <input type=text pattern=[a-zA-Z0-9]+ minlength=4 maxlength=10 id=lname name='.'CN'.$result['id'].'></td><td><label for='.'CN'.$result['id'].'></label></td></tr>'."\n";//order_id,create_date
//$csv.= 'Sale Order '.$result['order_id'][1].','.preg_replace('/[^A-Za-z0-9\-]/', ' ', $result['name']).','.$result['product_uom_qty'].','.preg_replace('!\s+!', ' ', $result['x_dest_address_va']).','.preg_replace('!\s+!', '', $result['x_dest_ph_va']).','.$result['create_date']." \n"; //Append data to csv

$csv.= '70267;Sale Order '.$result['order_id'][1].';'.preg_replace('/[^A-Za-z0-9\-]/', ' ', explode("(",$result['product_id'][1])[0]).';'.$result['x_scolorva2'].';'.preg_replace('!\s+!', ' ', str_replace("Speedversion: ","",$result['x_sspeedva2'])).';'.$result['product_uom_qty'].';'.$result['x_sdest_companyva'].';'.$result['x_dest_street_va2'].';'.preg_replace('!\s+!', '', $result['x_sdest_zip_va2']).';'.$result['x_sdest_city_va2'].';'.$result['x_sdest_countryva2'].';'.$result['x_dest_ph_va2'].';'.$result['create_date']." \n"; //Append data to csv

}
//var_dump($uii);
//internal tranfers
$query_arguments=array('&','&','&',array('create_date','>=',$today_midnight_mysql),array('lot_id','=',False),array('picking_code','=','internal'),array(['location_id'][0],'=',2075));
$uii=$models->execute_kw($db, $uid, $password,'stock.move.line', 'search_read',array($query_arguments), array('limit'=>100));

//internal tranfers

foreach($uii as $result) {
$qtyinternal=$result['product_uom_qty']+1;
//echo '<tr><td>'.'Internal Tranfer '.$result['picking_id'][1].'</td><td>'.$result['product_id'][1].'</td><td>'.$qtyinternal.'</td><td>'.$result['x_dest_address_va'].' - Ph:'.$result['x_dest_ph_va'].'</td><td>'.$result['create_date'].'</td><td>  <input type=text pattern=[a-zA-Z0-9]+ minlength=4 maxlength=10 id=lname name='.'CN'.$result['id'].'></td><td><label for='.'CN'.$result['id'].'></label></td></tr>'."\n";//order_id,create_date
echo '<tr><td>Trade & Traffic</td><td>'.'Internal Tranfer '.$result['picking_id'][1].'</td><td>'.explode("(",$result['product_id'][1])[0].'</td><td>'.$result['x_colorva2'].'</td><td>'.str_replace("Speedversion: ","",$result['x_speedva2']).'</td><td>'.$qtyinternal.'</td><td>'.$result['x_dest_companyva'].'</td><td>'.$result['x_dest_street_va'].'</td><td>'.$result['x_dest_zip_va'].'</td><td>'.$result['x_dest_city_va'].'</td><td>'.$result['x_dest_countryva'].'</td><td>'.$result['x_dest_ph_va'].'</td><td>'.$result['create_date'].'</td><td>  <input type=text pattern=[a-zA-Z0-9]+ minlength=4 maxlength=10 id=lname name='.'CN'.$result['id'].'></td><td><label for='.'CN'.$result['id'].'></label></td></tr>'."\n";//order_id,create_date

//$csv.='Internal Tranfer '.$result['picking_id'][1].','.preg_replace('/[^A-Za-z0-9\-]/', ' ', $result['product_id'][1]).','.$qtyinternal.','.preg_replace('!\s+!', ' ', $result['x_dest_address_va']).','.preg_replace('!\s+!', ' ', $result['x_dest_ph_va']).','.$result['create_date']." \n"; //Append data to csv
//$csv.='Internal Tranfer '.$result['picking_id'][1].','.preg_replace('/[^A-Za-z0-9\-]/', ' ', $result['product_id'][1]).','.$qtyinternal.','.preg_replace('!\s+!', ' ', $result['x_dest_address_va']).','.preg_replace('!\s+!', ' ', $result['x_dest_ph_va']).','.$result['create_date']." \n"; //Append data to csv
$csv.= '70267;Internal Tranfer '.$result['picking_id'][1].';'.preg_replace('/[^A-Za-z0-9\-]/', ' ', explode("(",$result['product_id'][1])[0]).';'.$result['x_colorva2'].';'.preg_replace('!\s+!', ' ', str_replace("Speedversion: ","",$result['x_speedva2'])).';'.$qtyinternal.';'.$result['x_dest_companyva'].';'.$result['x_dest_street_va'].';'.preg_replace('!\s+!', '', $result['x_dest_zip_va']).';'.$result['x_dest_city_va'].';'.$result['x_dest_countryva'].';'.$result['x_dest_ph_va'].';'.$result['create_date']." \n"; //Append data to csv

}

$timestamp = strtotime("now");
$time = date('Y_m_d_his', $timestamp);
$filenameunique=$time.'.csv';
$csv_handler = fopen ($filenameunique,'w');
fwrite ($csv_handler,$csv);
fclose ($csv_handler);
//var_dump($uii);
//require __DIR__ . '/ml.php';
?>

</table>

</body>

</html>

[+] ..
[-] index.php-old 181121 [edit]
[-] index.php-old [edit]
[-] index.php-oldn [edit]
[-] index.php-old2 [edit]
[-] index-old.php [edit]
[-] index.php-old11102021 [edit]
[-] index.php1307 [edit]
[-] .htaccess.disabled [edit]