Exemple #1
0
 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;
     }
 }
Exemple #7
0
 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;
 }