public function act_addBatchPrintLists() { $appnum = intval(trim($_POST['appnum'])); $num = $appnum > 0 ? $appnum : 2000; $storeId = isset($_POST['storeId']) ? trim($_POST['storeId']) : 1; $where = " and po.orderStatus=400 and po.storeId={$storeId}"; //订单状态 $ordertimestart = isset($_POST['ordertimestart']) ? trim($_POST['ordertimestart']) : ''; //下单日期 开始 if ($ordertimestart != 0) { //开始时间 $ordertimestart_int = strtotime($ordertimestart); $where .= " and po.createdTime >= {$ordertimestart_int}"; } $ordertimeend = isset($_POST['ordertimeend']) ? trim($_POST['ordertimeend']) : ''; //下单日期 结束 if ($ordertimeend != 0) { //结束时间 $ordertimeend_int = strtotime($ordertimeend); //$ordertimeend_int += 86400; $where .= " and po.createdTime < {$ordertimeend_int}"; } $goodsouttimestart = isset($_POST['goodsouttimestart']) ? trim($_POST['goodsouttimestart']) : ''; //出库日期 开始 if ($goodsouttimestart != 0) { //出库开始时间 $goodsouttimestart_int = strtotime($goodsouttimestart); $where .= " and po.weighTime >= {$goodsouttimestart}"; } $goodsouttimeend = isset($_POST['goodsouttimeend']) ? trim($_POST['goodsouttimeend']) : ''; //出库日期 结束 if ($goodsouttimeend != 0) { //出库结束时间 $goodsouttimeend_int = strtotime($goodsouttimeend); $goodsouttimeend += 86400; $where .= " and po.weighTime < {$goodsouttimeend}"; } $isNote = intval($_POST['isNote']); switch ($isNote) { case 1: //有留言 $where .= ' and po.isNote=1'; break; case 2: //没留言 $where .= ' and po.isNote=0'; break; } $orderTypeId = intval($_POST['orderTypeId']); switch ($orderTypeId) { case 1: //发货单 $where .= ' and po.orderTypeId=1'; break; case 2: //配货单 $where .= ' and po.orderTypeId=2'; break; } $shiptype = trim($_POST['shiptype']); //运输方式 if ($shiptype != 0) { //运输方式 if ($shiptype == 200) { $nshiptype = "1,2,3"; } else { if ($shiptype == 200) { $nshiptype = "6,10,52,53"; } else { $nshiptype = $shiptype; } } $where .= " and po.transportId in({$nshiptype})"; } else { if (empty($_SESSION['shippingList'])) { $where = " and po.transportId =''"; } else { $nshiptype = implode(',', $_SESSION['shippingList']); $where .= " and po.transportId in({$nshiptype})"; } } $client_name = trim($_POST['clientname']); if ($client_name != '') { //按客户id搜索 $where .= " and po.platformUsername='******'"; } $salesaccount = trim($_POST['acc']); if ($salesaccount != '') { $where .= " and po.accountId='{$salesaccount}'"; } else { if (empty($_SESSION['accountList'])) { $where = " and po.accountId =''"; } else { $accountInfo = implode(',', $_SESSION['accountList']); $where .= " and po.accountId in({$accountInfo})"; } } $hunhe = intval($_POST['hunhe']); switch ($hunhe) { case 2: //单料号 $where .= ' and po.orderAttributes=' . SOA_SINGLE; break; case 1: //多料号 $where .= ' and po.orderAttributes=' . SOA_MULTIY; break; case 3: //组合订单 $where .= ' and po.orderAttributes=' . SOA_COMBIN; break; } $platformName = trim($_POST['platformName']); if ($platformName != '') { //平台 $where .= " and po.platformId= {$platformName}"; } else { if (empty($_SESSION['platformList'])) { $where .= " and po.platformId =''"; } else { $platformInfo = implode(',', $_SESSION['platformList']); $where .= " and po.platformId in({$platformInfo})"; } } //print_r($where);exit; $packorder_obj = new PackingOrderModel(); $billlist = $packorder_obj->getBillList($where . ' group by po.id order by pd.pName limit ' . $num); if (empty($billlist)) { self::$errCode = 0; self::$errMsg = '没有符合条件的订单!'; return; } $orderids = ''; $orderidArr = array(); foreach ($billlist as $list) { $orderidArr[] = $list['id']; } $orderids = implode(',', $orderidArr); $pm_obj = new printModel(); if ($pm_obj->insertPrintGroup($orderids, $storeId)) { self::$errCode = 200; self::$errMsg = '申请打印成功!'; return true; } else { self::$errCode = 0; self::$errMsg = '申请打印失败!'; return false; } }