mysql insert

最新推荐文章于 2024-07-22 03:04:14 发布

yangpjit

最新推荐文章于 2024-07-22 03:04:14 发布

阅读量454

点赞数

本文链接：https://blog.csdn.net/yangpit/article/details/85233430

版权

*
**加粗样式**
function update_transin_diff($djbh,$ydjh){    //根据商品编号查询记录    $sql = "SELECT
           gb.barcode,et.entryOrderCode,purchaseOrderCode,et.itemCode,et.planQty,et.`status`,et.diff_qty,et.qty
           FROM spjhd
           INNER JOIN spjhdmx on spjhd.id = spjhdmx.p_id
           INNER JOIN goods_barcode gb ON gb.goods_id = spjhdmx.goods_id AND gb.color_id = spjhdmx.color_id AND gb.size_id =    spjhdmx.size_id
           INNER JOIN goods_child_barcode gcb on gcb.barcode = gb.barcode
           inner join cangku on cangku.id=spjhd.ck_id
   						inner JOIN elle_transin et on et.itemCode  = gcb.out_code
           where spjhd.ydjh = '{$ydjh}' AND (et.purchaseOrderCode = '{$ydjh}' OR et.entryOrderCode = '{$ydjh}') AND spjhdmx.djbh    ='{$djbh}' AND qty != 0";    $info = $GLOBALS['db']->getAll($sql);    $sql2 =  "insert into elle_transin_diff (djbh,entryOrderCode,purchaseOrderCode,itemCode,planQty,qty,diff_qty,`status`,interface_status,ysrq)    values ";    foreach ($info as $k => $v){
       $sql2 .= "('" . $djbh . "','" .$v['entryOrderCode']. "','" . $v['purchaseOrderCode'] . "','" .
           $v['itemCode'] . "','" . $v['planQty']. "','" .  $v['qty'] . "','" .$v['diff_qty'] .
           "','" . $v['status'] . "','" . $v['status'] . "','" . time() . "'),";    }    $sql2 = substr($sql2, 0, -1);    $GLOBALS['db']->query($sql2); }

*