/**
* 查询出入库记录
*
* @param string $sdate 开始入库日期
* @param string $edate 结束入库日期
* @param string $goodsName 品名
* @param string $code 条码
* @param string $billNo 单据号
* @param string $inoutType 出/入库
* @param string $place 仓库
* @param string $billType 单据类型
* @return array
*/
public function query($sdate = '', $edate = '', $goodsName = '', $code = '*', $billNo = '', $inoutType = '', $place = '', $billType = '')
{
try {
$stoks = new StocksManagerAction();
$result = $stoks->query($sdate, $edate, $goodsName, $code, $billNo, $inoutType, '');
return $result;
} catch (Executive $e) {
system_out("StocksManager.query Exception:{$e}");
throw new Exception($e);
}
}
/**
* 查询库存明细
*
* @param String $condition
*/
public function queryStocksDetail($sdate = '', $edate = '', $goodsName = '', $barcode = '*', $client = '')
{
try {
$action = new StocksManagerAction();
$result = $action->query($sdate, $edate, $goodsName, $barcode, '', '', '', '', $client);
if ($result) {
//计算合计
$sumrecord['goodsName'] = '合计:';
$sumrecord["inqty"] = ExFunction::ex_array_sum($result, 'inqty');
$sumrecord["outqty"] = ExFunction::ex_array_sum($result, 'outqty');
array_push($result, $sumrecord);
}
$field = "billNo,billDate,goodsName,madeIn,code,factoryNo,spec,client,billType,inqty,outqty,voltage1,current1," . "direct,constant,grade,madeDate,memo,place,station";
$struct = $action->getStruct();
//如果字段不是全部的,则把必须的字段替换
if ($field != '*') {
$field = explode(',', $field);
$visible = array("_type_" => "INCLUDE", "data" => $field);
$struct["visible"] = $visible;
$struct["item"] = $field;
}
$rtn["struct"] = $struct;
$rtn["data"] = $result;
return $rtn;
} catch (Exception $e) {
system_out("Report.queryStocksDetail error" . $e);
throw new ExcelDateUtil($e);
}
}