public function getBillList($wheresql) { $sql = "\n select po.id, po.username, po.platformUsername, po.countryName, po.email, po.state, po.city, po.street, po.transportId , po.accountId,\n po.orderStatus, po.createdTime, po.calcWeight, po.pmId, po.platformId, sr.weighTime , por.originOrderId , pn.content from wh_shipping_order as po left join \n wh_shipping_order_relation as por on po.id = por.shipOrderId left join wh_shipping_order_records as sr on po.id=sr.shipOrderId left join \n\t\t\t\twh_shipping_orderdetail as pd on po.id = pd.shipOrderId left join wh_shipping_order_note_record as pn on po.id = pn.shipOrderId and pn.is_delete = 0 LEFT JOIN wh_order_tracknumber AS ot ON po.id = ot.shipOrderId where 1 {$wheresql};\n "; $staus_obj = new LibraryStatusModel(); $list = $this->dbconn->fetch_array_all($this->dbconn->query($sql)); foreach ($list as &$val) { //$val['shipingname'] = CommonModel::getShipingNameById($val['transportId']); $val['createdTime'] = date('Y-m-d H:i:s', $val['createdTime']); $val['weighTime'] = date('Y-m-d H:i:s', $val['weighTime']); $val['statusname'] = $staus_obj->statusIttoStr($val['orderStatus']); } return $list; }
function act_getLibraryStatusGroupNum($where) { //调用model层获取数据 $list = LibraryStatusModel::getLibraryStatusGroupNum($where); if ($list) { return $list; } else { self::$errCode = LibraryStatusModel::$errCode; self::$errMsg = LibraryStatusModel::$errMsg; return false; } }
public function act_orderWeighingCheck() { $orderid = isset($_POST['orderid']) ? $_POST['orderid'] : ""; $where = "where id={$orderid}"; $orderinfo = orderWeighingModel::selectRecord($where); if (!orderinfo) { self::$errCode = 502; self::$errMsg = "此发货单号不存在!"; return false; } if ($orderinfo[0]['orderStatus'] != PKS_WWEIGHING) { if ($orderinfo[0]['orderStatus'] == PKS_WDISTRICT) { self::$errCode = 514; self::$errMsg = "此发货单已在待分区,不用再扫描!"; return false; } else { if ($orderinfo[0]['orderStatus'] == PKS_WAITING_SORTING) { self::$errCode = 514; self::$errMsg = "此发货单还在待分拣中!"; return false; } else { self::$errCode = 514; self::$errMsg = "此发货单在" . LibraryStatusModel::getStatusNameByStatusCode($orderinfo[0]['orderStatus']) . "状态,请确认!"; return false; } } } $flat_transport = C('flat_transport'); $carrier = CommonModel::getShipingNameById($orderinfo[0]['transportId']); if (in_array($carrier, $flat_transport)) { $arr['type'] = "flat"; } else { self::$errCode = 503; self::$errMsg = "此发货单运输方式不属于小包,请确认!"; return false; } $partionId = CommonModel::getChannelIdByIds($orderinfo[0]['transportId'], $orderinfo[0]['countryName']); $account = CommonModel::getAccountNameById($orderinfo[0]['accountId']); //运输公司 $channelId = printLabelModel::getMcFromCarrier($orderinfo[0]['id'], $carrier, $orderinfo[0]['countryName'], $account); $arr['channelId'] = $channelId; $arr['transportId'] = $orderinfo[0]['transportId']; $arr['partionId'] = $partionId; $arr['countryName'] = $orderinfo[0]['countryName']; $arr['orderid'] = $orderid; return $arr; }
/** * 全部待打印列表 */ public function view_printList() { $pagesize = 100; $applicantId = $_SESSION['userId']; $where = ''; $count = OrderPrintListModel::getRcordNumber($where . " and is_delete=0 and applicantId='{$applicantId}'"); $pager = new Page($count, $pagesize); $printlist = OrderPrintListModel::getPrintList("*", $where . " where is_delete=0 and applicantId='{$applicantId}' order by id " . $pager->limit); foreach ($printlist as &$pval) { //数据整理 $pval['statusstr'] = LibraryStatusModel::printCodeTostr($pval['status']); $pval['applicantTimestr'] = date('Y-m-d H:i:s', $pval['applicantTime']); $orders_arr = explode(',', $pval['orderIds']); $pval['orderCount'] = count($orders_arr); } $toptitle = '出库订单打印'; $this->smarty->assign('toptitle', $toptitle); $this->smarty->assign('printlist', $printlist); $toplevel = 2; //顶层菜单 $this->smarty->assign('toplevel', $toplevel); $secondlevel = '22'; //当前的二级菜单 $this->smarty->assign('secondlevel', $secondlevel); $this->smarty->assign('secnev', 3); //二级导航 if ($count > $pagesize) { //分页 $pagestr = $pager->fpage(array(0, 2, 3, 4, 5, 6, 7, 8, 9)); } else { $pagestr = $pager->fpage(array(0, 2, 3)); } $this->smarty->assign('pagestr', $pagestr); $navlist = array(array('url' => 'index.php?mod=orderWaitforPrint&act=printList', 'title' => '出库'), array('url' => '', 'title' => '打印发货单')); $this->smarty->assign('navlist', $navlist); $this->smarty->display('orderprintlist.htm'); //输出页面 }
public function view_showForm() { global $memc_obj; $pagesize = 200; //页面大小 $whereSql = $this->buildWhereSql(); //echo $whereSql;exit; $packorder_obj = new PackingOrderModel(); $rownumber = $packorder_obj->getRowAllNumber($whereSql . ' group by po.id '); //获得所有的行数 $pager = new Page($rownumber, $pagesize); $billlist = $packorder_obj->getBillList($whereSql . ' group by po.id order by pd.pName ' . $pager->limit); //更具条件获得发货单 $packorder_obj->buildOrderinfo($billlist); /* //去除重复的 $currentid = NULL; $prekey = 0; foreach ($billlist as $key=>$valbill){ if ($currentid == $valbill['id']) { $billlist[$prekey]['originOrderId'] .= ', '.$valbill['originOrderId']; unset($billlist[$key]); }else { $prekey = $key; $currentid = $valbill['id']; } } */ $materInfo = CommonModel::getMaterInfoAll(); //获取包材信息 $materInfo = reverse_array($materInfo, 'pmName', 'id'); $shipingtyplist = CommonModel::getShipingTypeList(); //运输方式列表 $shipingtyplist = reverse_array($shipingtyplist, 'carrierNameCn', 'id'); $salesaccountlist = CommonModel::getSalesaccountList(); //获取销售帐号 $salesaccountlist = reverse_array($salesaccountlist, 'account', 'id'); //print_r($salesaccountlist);exit; $platformList = CommonModel::getPlatformInfo(); //获取平台帐号 $platformList = reverse_array($platformList, 'platform', 'id'); $this->smarty->assign('shipingtypelist', $shipingtyplist); $this->smarty->assign('salesaccountlist', $salesaccountlist); $this->smarty->assign('platformList', $platformList); foreach ($billlist as $key => $valbil) { $tracknumber = ''; $str_info = OmAvailableModel::getTNameList("wh_order_tracknumber", "tracknumber", "where shipOrderId='{$valbil['id']}' and is_delete=0"); if (!empty($str_info)) { $tracknumber = $str_info[0]['tracknumber']; } $billlist[$key]['tracknumber'] = $tracknumber; $originOrder_arr = array(); $originOrder_str = ''; $originOrder_info = OmAvailableModel::getTNameList("wh_shipping_order_relation", "originOrderId", "where shipOrderId='{$valbil['id']}'"); if (!empty($originOrder_info)) { foreach ($originOrder_info as $originOrder) { $originOrder_arr[] = $originOrder['originOrderId']; } $originOrder_str = implode(',', $originOrder_arr); } $billlist[$key]['originOrder'] = $originOrder_str; //运输方式 $billlist[$key]['shipingname'] = $shipingtyplist[$valbil['transportId']]; //包材 $billlist[$key]['materName'] = $materInfo[$valbil['pmId']]; //平台 $billlist[$key]['platformName'] = $platformList[$valbil['platformId']]; //销售账号 $billlist[$key]['salesaccountinfo'] = $salesaccountlist[$valbil['accountId']]; } if ($rownumber > $pagesize) { //分页 $pagestr = $pager->fpage(array(0, 2, 3, 4, 5, 6, 7, 8, 9)); } else { $pagestr = $pager->fpage(array(0, 2, 3)); } $this->smarty->assign('pagestr', $pagestr); $this->smarty->assign('billlist', $billlist); //发货单列表 $this->smarty->assign('secnev', 3); $libstu_obj = new LibraryStatusModel(); //出库状态类型 $libstatuslist = $libstu_obj->getAllLibStatusList(' and groupId in (4 ,5)'); $this->smarty->assign('outstatuslist', $libstatuslist); $toptitle = '订单查询'; //头部title $this->smarty->assign('toptitle', $toptitle); $storeId = isset($_GET['storeId']) ? intval($_GET['storeId']) : 0; if ($storeId == 1) { $navlist = array(array('url' => '', 'title' => '出库'), array('url' => '', 'title' => '发货单查询'), array('url' => '', 'title' => 'A仓发货单')); } elseif ($storeId == 2) { $navlist = array(array('url' => '', 'title' => '出库'), array('url' => '', 'title' => '发货单查询'), array('url' => '', 'title' => 'B仓发货单')); } else { $navlist = array(array('url' => '', 'title' => '出库'), array('url' => '', 'title' => '发货单查询')); } $this->smarty->assign('navlist', $navlist); $toplevel = 2; //一级菜单的序号 0 开始 $this->smarty->assign('toplevel', $toplevel); $secondlevel = isset($_GET['secondlevel']) ? trim($_GET['secondlevel']) : ''; if (empty($secondlevel)) { $secondlevel = '21'; //当前的二级菜单 } $this->smarty->assign('secondlevel', $secondlevel); $this->smarty->assign('platLists', $_SESSION['platformList']); $this->smarty->assign('accounts', $_SESSION['accountList']); $this->smarty->assign('shippingList', $_SESSION['shippingList']); $this->smarty->display('dispatchbillquery.htm'); }
public static function getLibraryStatusGroupNum($where = '') { self::initDB(); $sql = "select * from wh_storage_status_group where is_delete=0 {$where}"; $query = self::$dbConn->query($sql); if ($query) { $ret = self::$dbConn->num_rows($query); return $ret; } else { self::$errCode = "003"; self::$errMsg = "error"; return false; } }
function act_scanNum() { $userId = $_SESSION['userId']; $order_id = trim($_POST['ebay_id']); $ebay_sku = trim($_POST['ebay_sku']); $ebay_sku = get_goodsSn($ebay_sku); $sku_num = trim($_POST['sku_num']); $state_status = array(PKS_WIQC); //先核对订单 $p_real_ebayid = '#^\\d+$#'; if (!preg_match($p_real_ebayid, $order_id)) { self::$errCode = "1100"; self::$errMsg = "订单号[" . $order_id . "]格式有误"; return false; } if ($is_eub_package_type === true) { $ordercheck = ShippingOrderModel::getShippingOrderInfo("b.*", "where a.tracknumber='{$order_id}' and a.is_delete=0"); } else { $ordercheck = ShippingOrderModel::getShippingOrder("*", "where id='{$order_id}'"); } if (empty($ordercheck)) { self::$errCode = '100'; self::$errMsg = '未找到订单[' . $order_id . ']'; return false; } else { if (!in_array($ordercheck[0]['orderStatus'], $state_status)) { self::$errCode = '100'; self::$errMsg = "该订单[{$order_id}]在" . LibraryStatusModel::getStatusNameByStatusCode($ordercheck[0]['orderStatus']) . "状态,请确认!"; return false; } } $bool = 0; $sku_info = OrderReviewModel::getReviewList("*", "where shipOrderId='{$ordercheck[0]['id']}' and sku='{$ebay_sku}' and is_delete=0 and storeId=1"); if (empty($sku_info)) { self::$errCode = '005'; self::$errMsg = '订单不存在该料号[' . $ebay_sku . '],请重试'; return false; } elseif ($sku_num != $sku_info[0]['totalNums']) { self::$errCode = '007'; self::$errMsg = '料号[' . $ebay_sku . ']正确数量应为[' . $sku_info[0]['totalNums'] . '],请检查输入数量'; $u_sql = OrderReviewModel::updateRow("set amount='{$sku_num}',isScan=1", "where shipOrderId='{$ordercheck[0]['id']}' and sku='{$ebay_sku}' and is_delete=0 and storeId=1"); } else { self::$errMsg = '料号[' . $ebay_sku . ']数量[' . $sku_info[0]['totalNums'] . ']正确,如无误请扫描下一料号 '; $u_sql = OrderReviewModel::updateRow("set amount='{$sku_num}',isScan=1", "where shipOrderId='{$ordercheck[0]['id']}' and sku='{$ebay_sku}' and is_delete=0 and storeId=1"); if ($u_sql) { $skuinfos = OrderReviewModel::getReviewList("*", "where shipOrderId='{$ordercheck[0]['id']}' and is_delete=0 and storeId=1"); } //判断料号是否全部符合正确 foreach ($skuinfos as $info) { if ($info['isScan'] == 0) { $bool = 0; break; } else { $bool = 1; } } } self::$errCode = $bool; return $skuinfos; }