/**
* 单据查询 01
*
* @param string $request
*/
private function billsQuery($request)
{
try {
$dno = $request["body"]["no"];
$dno = ereg_replace("[^a-zA-Z0-9,-]", '', $dno);
$dno = str_replace(',', "','", $dno);
$dno = "'" . $dno . "'";
$condition = "dno in (" . $dno . ") or adno in (" . $dno . ")";
$model = new AirwaybillModel();
$result = $model->where($condition)->select();
if ($result) {
for ($i = 0; $i < count($result); $i++) {
$item .= "<item>";
$item .= "<ID>" . $result[$i]["ID"] . "</ID>";
$item .= "<DNO>" . $result[$i]["ADNO"] . "</DNO>";
$item .= "<DBilldate>" . $result[$i]["DBilldate"] . "</DBilldate>";
$item .= "<Departure>" . $result[$i]["Departure"] . "</Departure>";
$item .= "<Destination>" . $result[$i]["Destination"] . "</Destination>";
$item .= "<Qty>" . $result[$i]["Qty"] . "</Qty>";
$item .= "<Weight>" . $result[$i]["Weight"] . "</Weight>";
$item .= "<SignIn>" . $result[$i]["SignIn"] . "</SignIn>";
$item .= "<SignDate>" . $result[$i]["SignDate"] . "</SignDate>";
$item .= "<Memo>" . $result[$i]["Memo"] . "</Memo>";
$item .= "</item>";
}
return $this->createResult($request["head"]["type"], 1, '', count($result), $item);
} else {
return $this->createResult($request["head"]["type"], 1, '', 0);
}
} catch (Exception $e) {
return $this->createResult($request["head"]["type"], -1, "error in bills query");
}
}
