PATH:
home
/
centosnipponia
/
public_html
/
wh
/
old
<?php date_default_timezone_set("Europe/Amsterdam"); echo date("Y-m-d H:i:s"); $today_midnight = mktime(0, 0, 0, date("m") , date("d"), date("Y")); $today_midnight_mysql = date ('Y-m-d H:i:s',$today_midnight); require __DIR__ . '/config.php'; ?> <!DOCTYPE html> <html lang="en" > <head> <meta charset="UTF-8"> <title>Trade and Traffic Plus - Deliveries for Mol Cargo</title> <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/normalize/5.0.0/normalize.min.css"> <link rel="stylesheet" href="./style.css"> <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.4.0/jquery.min.js"></script> <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery-validate/1.19.0/jquery.validate.min.js"></script> </head> <body> <!-- partial:index.partial.html --> <ul> <li><a href="http://wh.trade-traffic.com?production=true">Production</a></li> <li><a href="http://wh.trade-traffic.com">Staging</a></li> </ul> <h1>Trade and Traffic Plus - Deliveries for Mol Cargo (tranfers issued today)</h1> <h2>Trade and Traffic Plus - Sold and Consigned motorcycles(placed today)</h2> <p>This table shows only for the tranfers that have been imported in Odoo from today 00:00. </p> <table class="adap-table"> <?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)); //sale orders tranfers echo '<form action="" id="mainform" method="post" name="mainform">'; echo '<thead><tr><th>Tranfer number</th><th>Model</th><th>Qty</th><th>Destination(Customer-Address)</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_destination_address_order_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 } //internal tranfers $query_arguments=array('&','&',array('create_date','>=',$today_midnight_mysql),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 var_dump($uii); 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_destination_address'].'</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 } ?> </table> <input type="submit" value="Submit"> </form> <!-- partial --> <script> $(document).ready(function() { $("#mainform").validate(); }); </script> </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]