/** * 查询当前库存 * * @param $conditon */ public function queryCurrentStocks($condition) { try { $dao = new CurrentStocksDao(); $result = $dao->findAll($condition)->toResultSet(); return $result; } catch (Exception $e) { throw new Exception($e); } }
/** * 检查已挂表的表位是否全部确认完毕 * @param array $data 已经挂了表的表位 * @param string $state U 挂表 D 取表 * * @return boolean ; * */ public function checkStationConfirmComplete($data, $state) { $stations = array(); return true; try { $confirm = new ConfirmStationAction(); $result = $confirm->queryUnconfirmStation("state ='{$state}' and confirm=0 "); //如果没有记录,则表示全部确认了 if (!$result) { return true; } $temp = "'" . implode("','", $data) . "'"; $stocks = new CurrentStocksDao(); $exits = $stocks->findAll("station in (" . $temp . ")")->toResultSet(); if ($exits) { $temp = array(); for ($i = 0; $i < sizeof($exits); $i++) { array_push($temp, $exits[$i]["station"]); } $exits = $temp; } for ($i = 0; $i < sizeof($result); $i++) { $val = $result[$i]["station"]; $rtn = array_search($val, $exits); //如果已经入仓,则跳过 if (is_numeric($rtn)) { continue; } $rtn = array_search($val, $data); if (is_numeric($rtn)) { $stations[] = $val; } } //返回值 $rtn = array(); $data = implode(',', $stations); if ($data) { $data = '还有表位挂了表未确认:' . $data; array_push($rtn, $data); } //是否有两个表,确认了同一个表位 $confirm = new ConfirmStationAction(); $result = $confirm->checkWhetherDuplic(); if ($result) { for ($i = 0; $i < sizeof($result); $i++) { $err = "[" . $result[$i]["station"] . "]表位确认了多个表[" . $result[$i]['code'] . "]请更正"; array_push($rtn, $err); } } //如果没有错误信息,则返回true return $rtn ? $rtn : true; } catch (Executive $e) { system_out("StocksManager.checkStationConfirmComplete error:{$e}"); throw new Exception($e); } }
/** * 确认表所放的位置 * * @param $billno 单据号 * @param $data 数据 array("station"=>,"code"=>) * @return boolean */ public function confirmInstation($billdata, $data) { $sysno = $billdata['sysno']; $billdate = $billdata['billDate']; //明细表 $stocks = new StocksDao(); $stocks->startTrans(); //当前库存表 $current = new CurrentStocksDao(); $current->startTrans(); //未确认表位 $unconfirm = new UnconfirmstationDao(); $unconfirm->startTrans(); try { $newinsert = false; $station = $data["station"]; $code = $data["code"]; $result = $current->findAll("`code`='{$code}'")->toResultSet(); if (sizeof($result) == 0 && NOBILL_SCAN == false) { $stocks->rollback(); $current->rollback(); $unconfirm->rollback(); $this->setError("库存里找不到该条码[{$code}]对应的表计!"); return false; } else { if (sizeof($result) == 0) { $newinsert = true; $codeinfo = new CodeInfo(); $codedetail = $codeinfo->getInfoByCode($code); $vo = $stocks->createVo('add', '', 'id', 0, $codedetail); $vo->id = 0; $vo->inoutType = 'IN'; $vo->code = $code; $vo->sysno = $billdata['sysno']; $vo->placeno = $billdata['placeno']; $vo->place = $billdata['place']; $vo->billType = $billdata['billType']; $vo->billDate = $billdata['billDate']; $vo->billNo = $billdata['billNo']; $vo->sendMan = $billdata['sendMan']; $vo->saveMan = $billdata['saveMan']; $vo->orderNo = $billdata['orderNo']; $vo->client = $billdata['client']; $vo->inqty = 1; $vo->outqty = 0; $vo->station = $station; //inert new records $stocksmanageraction = new StocksManagerAction(); $savedata["modify"] = array($vo->toArray()); $result = $stocksmanageraction->save($savedata); if (!$result) { system_out("create new recod error:" . $stocksmanageraction->getError()); $this->setError($stocksmanageraction->getError()); return false; } } } $sql = "UPDATE " . (DB_PREFIX ? DB_PREFIX . "_" : "") . "currentstocks\n\t\t\t SET `station`='{$station}'\n\t\t\t\t\t WHERE `code` ='{$code}'"; system_out("update sql:" . $sql); $current->execute($sql); if (!$newinsert) { //返写stocks $result = StocksIndexAction::getTableNameByDate($billdate); if ($result == '') { $stocks->rollback(); $current->rollback(); $unconfirm->rollback(); system_out("get tablename error,billdate:" . $billdate); $this->setError("获取存储表出错!"); return false; } $tablename = $result; $sql = "UPDATE\t`{$tablename}`\n\t\t\t\t\t\t SET `station` = '{$station}'\n\t\t\t\t\t\t WHERE `code` = '{$code}' and\n\t\t\t\t\t\t \t\t`sysno` = '{$sysno}' "; $stocks->execute($sql); } //标记已经确认的开灯记录 $sql = "UPDATE " . (DB_PREFIX ? DB_PREFIX . "_" : "") . "unconfirmstation\n\t\t\t SET `confirm` = 1\n\t\t\t\t\t WHERE `station` = '{$station}' and `state`='U'"; $unconfirm->execute($sql); } catch (Exception $e) { $stocks->rollback(); $current->rollback(); $unconfirm->rollback(); system_out("UnconfirmstationAction.confirmInstation error:{$e},\n\t\t\t\t\t\tsysno:{$sysno},data:" . print_r($data, true)); throw new Exception($e); } //commit $stocks->commit(); $current->commit(); $unconfirm->commit(); return true; }