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;
}
