bind('so_id', $so_id); $db->bind('user_id', $_SESSION['user_id']); $data = $db->query("SELECT * FROM shipping_order_unread WHERE so_id = :so_id and user_id = :user_id"); return $data[0]['status']; } function getAllPOWithoutSO(){ global $db; $db->bind('company_id', $_SESSION['company_id']); $data = $db->query("SELECT * FROM purchase_orders WHERE po_id not in (select po_id from shipping_orders where po_id is not null) and company_id = :company_id"); $PO = ""; foreach ($data as $key => $value) { $PO .= "'; } return $PO; } function getLastForwarder(){ global $db; $db->bind('company_id', $_SESSION['company_id']); $db->bind('branch_id', $_SESSION['branch_id']); $data = $db->query("SELECT * FROM shipping_orders WHERE company_id = :company_id and branch_id = :branch_id ORDER BY so_id DESC LIMIT 1"); if(count($data > 0)){ return $data[0]['forwarder_id']; }else{ return ""; } } function getSOTotalCtn($so_id){ global $db; $db->bind('so_id', $so_id); $data = $db->query("SELECT SUM(packaging_quantity) as total FROM shipping_order_items WHERE so_id = :so_id"); return $data[0]['total']; } function checkPOExist($so_id){ global $db; $db->bind('so_id', $so_id); $data = $db->query("SELECT * FROM shipping_orders WHERE so_id = :so_id"); if($data[0]['po_id'] == null){ return false; }else{ return true; } } function getSOTotalCBM($so_id){ global $db; $db->bind('so_id', $so_id); $data = $db->query("SELECT SUM(packaging_cbm) as total FROM shipping_order_items WHERE so_id = :so_id"); return $data[0]['total']; } function getSOTotalWeight($so_id){ global $db; $db->bind('so_id', $so_id); $data = $db->query("SELECT SUM(packaging_gross) as total FROM shipping_order_items WHERE so_id = :so_id"); return $data[0]['total']; } function getSOTotalCarton($so_id){ global $db; $db->bind('so_id', $so_id); $data = $db->query("SELECT SUM(packaging_quantity) as total FROM shipping_order_items WHERE so_id = :so_id"); return $data[0]['total']; } function getSOData($so_id, $kol){ global $db; $db->bind('so_id', $so_id); $data = $db->query("SELECT * FROM shipping_orders WHERE so_id = :so_id"); return $data[0][$kol]; } function getSOItems($so_id){ global $db; $db->bind('so_id', $so_id); $data = $db->query("SELECT * FROM shipping_order_items WHERE so_id = :so_id"); return $data; } function getSOItem($id, $kol){ global $db; $db->bind('id', $id); $data = $db->query("SELECT * FROM shipping_order_items WHERE id = :id"); return $data[0][$kol]; } function isSOMine($so_id){ global $db; $company_id = getCompany($_SESSION['user_id']); $db->bind('so_id', $so_id); $data = $db->query("SELECT * FROM shipping_orders WHERE so_id = :so_id"); if ($company_id == $data[0]['forwarder_id'] || $company_id == $data[0]['company_id']){ return true; }else{ return false; } } function getModalPackingList($so_id){ global $db; $html = ""; $x = 1; $html .= '
'; $SOItems = getSOItems($so_id); foreach($SOItems as $key => $SOItem){ $html .= ''; $x++; } $html .= '
No Description Model Qty UOM Height Width Depth Gross Nett Photo
'. $x .' '. $SOItem['description'] .' '. $SOItem['model_no'] .' '. $SOItem['packaging_quantity'] .' '. $SOItem['packaging_type'] .' '. $SOItem['packaging_height'] .' '. $SOItem['packaging_width'] .' '. $SOItem['packaging_depth'] .' '. $SOItem['packaging_gross'] .' '. $SOItem['packaging_nett'] .'
'; return $html; } function getModalMarking($so_id){ global $db; $html = ""; $urlencode = urlencode("http://". $_SERVER['HTTP_HOST'] . "/shipping-order/details/" . $so_id); $html .= '

'.getSOData($so_id, 'marking_no').'

仓库地址 '.getSOData($so_id, "warehouse_address").'
收件人 '.get_warehouse(getSOData($so_id, "warehouse_id"), "contact_person").'
联系号码 '.get_warehouse(getSOData($so_id, "warehouse_id"), "contact_person_no").'
'; return $html; }