Find this useful? Enter your email to receive occasional updates for securing PHP code.
Signing you up...
Thank you for signing up!
PHP Decode
<?php namespace App\Models\Application\Logistics; use PDO; use App\Models\User; use App\..
Decoded Output download
<?php
namespace App\Models\Application\Logistics; use PDO; use App\Models\User; use App\Token; use App\Config; class InvoiceModel extends \Core\Model { public $errors = array(); public function __construct($data = array()) { foreach ($data as $key => $value) { $this->{$key} = $value; } } public static function deleteContainer($trackingId) { try { $sql = "UPDATE WHS.Tracking SET DisableDate = GetDate() WHERE TrackingId = :TrackingId"; $db = static::getDBSQL(); $stmt = $db->prepare($sql); $stmt->bindValue(":TrackingId", $trackingId, PDO::PARAM_INT); return $stmt->execute(); } catch (\PDOException $e) { echo $e->getMessage(); } } public function createHeader() { $user = User::findByID($_SESSION["user_id"]); $sql = "INSERT INTO WHS.Invoice (\xa DeliveryName
,OrganizationId
,CustomerId
,InvoiceDate
,Departure
,MotherVessel\xa ,ConnectingVessel
,ShippingLine
,Forwarder
,CreationDate\xa ,CreatedBy\xa ,ShipmentType
,CIStatus\xa )
VALUES (\xa :DeliveryName
,:OrganizationId\xa ,:CustomerId\xa ,:InvoiceDate\xa ,:Departure\xa ,:MotherVessel\xa ,:ConnectingVessel\xa ,:ShippingLine
,:Forwarder\xa ,GetDate()\xa ,:CreatedBy\xa ,:ShipmentType\xa ,'OPEN'
)"; $db = static::getDBSQL(); $stmt = $db->prepare($sql); $export = "Export"; $stmt->bindParam(":DeliveryName", $this->DeliveryName, PDO::PARAM_STR); $stmt->bindParam(":OrganizationId", $this->OrganizationId, PDO::PARAM_INT); $stmt->bindParam(":CustomerId", $this->CustomerId, PDO::PARAM_INT); $stmt->bindParam(":InvoiceDate", $this->InvoiceDate, PDO::PARAM_STR); $stmt->bindParam(":Departure", $this->Departure, PDO::PARAM_STR); $stmt->bindParam(":MotherVessel", $this->MotherVessel, PDO::PARAM_STR); $stmt->bindParam(":ConnectingVessel", $this->ConnectingVessel, PDO::PARAM_STR); $stmt->bindParam(":ShippingLine", $this->ShippingLine, PDO::PARAM_STR); $stmt->bindParam(":Forwarder", $this->Forwarder, PDO::PARAM_STR); $stmt->bindParam(":CreatedBy", $user->id, PDO::PARAM_STR); $stmt->bindParam(":ShipmentType", $export, PDO::PARAM_STR); $stmt->execute(); $lastId = $db->lastInsertId(); return $lastId; } public function create() { try { $user = User::findByID($_SESSION["user_id"]); if (empty($this->errors)) { if (!$this->invoiceExist()) { return $this->createHeader(); } } return false; } catch (\PDOException $e) { echo $e->getMessage(); } } public static function getDeliveryList() { try { $sql = "SELECT I.DeliveryId, I.OrganizationId, I.DeliveryName, I.InvoiceDate, I.OrderNumber, I.CustomerId, I.DeliveryDate, I.Departure, I.MotherVessel, I.ConnectingVessel, I.ShippingLine, I.Forwarder, I.Remarks,
I.CreationDate, I.CreatedBy, I.UpdatedDate, I.UpdatedBy, I.ShipmentType, I.Status, O.OrganizationName, HZ.Party.PartyName
FROM WHS.Invoice AS I LEFT OUTER JOIN
HZ.Party ON I.CustomerId = HZ.Party.PartyCode LEFT OUTER JOIN
APP.Organization AS O ON I.OrganizationId = O.Id\xaORDER BY I.DeliveryName"; $db = static::getDBSQL(); $stmt = $db->prepare($sql); $stmt->execute(); $result = $stmt->fetchAll(PDO::FETCH_OBJ); return $result; } catch (\PDOException $e) { echo $e->getMessage(); } } public static function getLoadingById($id) { try { $sql = "EXEC [EXP].[loadingreport] ?"; $db = static::getDBSQL(); $stmt = $db->prepare($sql); $stmt->bindParam(1, $id, PDO::PARAM_STR); $stmt->execute(); $result = $stmt->fetchAll(PDO::FETCH_OBJ); return $result; } catch (\PDOException $e) { echo $e->getMessage(); } } public static function getDeliveryByName($name) { try { $sql = "SELECT *,(select Weight from WHS.ShipmentObject\xa WHERE ObjectName = 'WoodPallet')*ISNULL(Pallet,0) PWeight, \xa (select CBM from WHS.ShipmentObject\xa WHERE ObjectName = 'WoodPallet')*ISNULL(Pallet,0) PCBM FROM WHS.Invoice d
INNER JOIN app.Organization o
ON d.OrganizationId = o.Id WHERE d.DeliveryName = :DeliveryName"; $db = static::getDBSQL(); $stmt = $db->prepare($sql); $stmt->bindParam(":DeliveryName", $name, PDO::PARAM_STR); $stmt->execute(); $result = array(); while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { $result = $row; } return $result; } catch (\PDOException $e) { echo $e->getMessage(); } } public static function getContainerByInvoiceId($id) { try { $sql = "SELECT cast(Count(size) as varchar(10))+ ' X ' + Size ContainerCount FROM WHS.Tracking \xa WHERE DeliveryId = :DeliveryId AND DisableDate is null group by Size"; $db = static::getDBSQL(); $stmt = $db->prepare($sql); $stmt->bindParam(":DeliveryId", $id, PDO::PARAM_STR); $stmt->execute(); $result = array(); while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { $result[] = $row; } return $result; } catch (\PDOException $e) { echo $e->getMessage(); } } public static function getContainerListByInvoiceId($id) { try { $sql = "SELECT * FROM WHS.Tracking \xa WHERE DeliveryId = :DeliveryId AND DisableDate is null"; $db = static::getDBSQL(); $stmt = $db->prepare($sql); $stmt->bindParam(":DeliveryId", $id, PDO::PARAM_STR); $stmt->execute(); $result = $stmt->fetchAll(PDO::FETCH_OBJ); return $result; } catch (\PDOException $e) { echo $e->getMessage(); } } public static function getDeliveryNameById($id) { try { $sql = "SELECT DeliveryName FROM WHS.Invoice WHERE DeliveryId = :DeliveryId"; $db = static::getDBSQL(); $stmt = $db->prepare($sql); $stmt->bindParam(":DeliveryId", $id, PDO::PARAM_STR); $stmt->execute(); $result = $stmt->fetchColumn(); return $result; } catch (\PDOException $e) { echo $e->getMessage(); } } public static function getInvoiceIdByName($id) { try { $sql = "SELECT DeliveryId FROM WHS.Invoice WHERE DeliveryName = :DeliveryName"; $db = static::getDBSQL(); $stmt = $db->prepare($sql); $stmt->bindParam(":DeliveryName", $id, PDO::PARAM_STR); $stmt->execute(); $result = $stmt->fetchColumn(); return $result; } catch (\PDOException $e) { echo $e->getMessage(); } } public static function findInvoiceByName($invoiceName) { try { $sql = "Select * from WHS.Invoice WHERE DeliveryName =:name "; $db = static::getDBSQL(); $stmt = $db->prepare($sql); $stmt->bindValue(":name", $invoiceName, PDO::PARAM_STR); $stmt->setFetchMode(PDO::FETCH_CLASS, get_called_class()); $stmt->execute(); return $stmt->fetch(); } catch (\PDOException $e) { echo $e->getMessage(); } } public function getItemDetail($id) { try { $sql = "Select * from WHS.Deliveries where Id= :DeliveryDetailId"; $db = static::getDBSQL(); $stmt = $db->prepare($sql); $stmt->bindValue(":DeliveryDetailId", $id, PDO::PARAM_STR); $stmt->setFetchMode(PDO::FETCH_CLASS, get_called_class()); $stmt->execute(); return $stmt->fetch(); } catch (\PDOException $e) { echo $e->getMessage(); } } public function invoiceExist() { $name = static::findInvoiceByName($this->DeliveryName); if ($name) { if ($name->DeliveryId != null) { return true; } } return false; } public static function getHeader($id) { try { $sql = "SELECT
*, D.Address ConsingneeAddress\xa FROM
WHS.Invoice D LEFT OUTER JOIN APP.Organization O ON D.OrganizationId = O.Id
WHERE D.DeliveryId = :DeliveryId"; $result = array(); $db = static::getDBSQL(); $stmt = $db->prepare($sql); $stmt->bindValue(":DeliveryId", $id, PDO::PARAM_INT); $stmt->setFetchMode(PDO::FETCH_CLASS, get_called_class()); $stmt->execute(); return $stmt->fetch(); } catch (\PDOException $e) { echo $e->getMessage(); } } public static function getItemDetailById($id) { try { $sql = "SELECT * FROM WHS.Deliveries D WHERE D.DeliveryHeaderId = :DeliveryHeaderId"; $result = array(); $db = static::getDBSQL(); $stmt = $db->prepare($sql); $stmt->bindValue(":DeliveryHeaderId", $id, PDO::PARAM_INT); $stmt->setFetchMode(PDO::FETCH_CLASS, get_called_class()); $stmt->execute(); return $stmt->fetch(); } catch (\PDOException $e) { echo $e->getMessage(); } } public function getCustomer($id) { try { $sql = "SELECT * FROM HZ.Party WHERE PartyType =:PartyType "; $result = array(); $db = static::getDBSQL(); $stmt = $db->prepare($sql); $stmt->bindValue(":PartyType", "customer", PDO::PARAM_STR); $stmt->setFetchMode(PDO::FETCH_CLASS, get_called_class()); $stmt->execute(); return $stmt->fetch(); } catch (\PDOException $e) { echo $e->getMessage(); } } public static function getItem($deliverName) { try { $sql = "SELECT * FROM WHS.Deliveries D INNER JOIN WHS.Invoice I
ON D.DeliveryHeaderId = I.DeliveryId where I.DeliveryName =:DeliveryName"; $result = array(); $db = static::getDBSQL(); $stmt = $db->prepare($sql); $stmt->bindValue(":DeliveryName", $deliverName, PDO::PARAM_INT); $stmt->execute(); $result = $stmt->fetchAll(PDO::FETCH_OBJ); return $result; } catch (\PDOException $e) { echo $e->getMessage(); } } public static function deleteItems($itemId) { try { $sql = "DELETE FROM WHS.Deliveries where Id =:Id"; $result = array(); $db = static::getDBSQL(); $stmt = $db->prepare($sql); $stmt->bindValue(":Id", $itemId, PDO::PARAM_STR); return $stmt->execute(); } catch (\PDOException $e) { echo $e->getMessage(); } } public function getContainer($id) { try { $sql = "SELECT * FROM WHS.Tracking WHERE DeliveryId = :DeliveryId AND DisableDate is null "; $result = array(); $db = static::getDBSQL(); $stmt = $db->prepare($sql); $stmt->bindValue(":DeliveryId", $id, PDO::PARAM_STR); $stmt->execute(); $result = $stmt->fetchAll(PDO::FETCH_OBJ); return $result; } catch (\PDOException $e) { echo $e->getMessage(); } } public static function getContainerById($id) { try { $sql = "SELECT * FROM WHS.Tracking WHERE TrackingId = :TrackingId "; $result = array(); $db = static::getDBSQL(); $stmt = $db->prepare($sql); $stmt->bindValue(":TrackingId", $id, PDO::PARAM_STR); $stmt->execute(); $stmt->setFetchMode(PDO::FETCH_CLASS, get_called_class()); $stmt->execute(); return $stmt->fetch(); } catch (\PDOException $e) { echo $e->getMessage(); } } public function createContainer($id) { try { $user = User::findByID($_SESSION["user_id"]); $sql = "INSERT INTO WHS.Tracking (\xa DeliveryId\xa ,Size
,Seal
,TrackingNum\xa ,CreationDate\xa ,CreatedBy
)\xa VALUES\xa (\xa :DeliveryId\xa ,:Size
,:Seal\xa ,:TrackingNum
,GetDate()
,:CreatedBy)"; $result = array(); $db = static::getDBSQL(); $stmt = $db->prepare($sql); $stmt->bindValue(":DeliveryId", $id, PDO::PARAM_STR); $stmt->bindValue(":Size", $this->Size, PDO::PARAM_STR); $stmt->bindValue(":Seal", $this->Seal, PDO::PARAM_STR); $stmt->bindValue(":TrackingNum", $this->TrackingNum, PDO::PARAM_STR); $stmt->bindValue(":CreatedBy", $user->id, PDO::PARAM_STR); return $stmt->execute(); } catch (\PDOException $e) { echo $e->getMessage(); } } public function updateContainer($id) { try { $user = User::findByID($_SESSION["user_id"]); $sql = "UPDATE WHS.Tracking SET\xa Size = :Size\xa ,Seal = :Seal
,TrackingNum = :TrackingNum\xa ,DisableDate = :DisableDate\xa ,UpdatedDate = GetDate()
,UpdatedBy = :UpdatedBy \xa where TrackingId = :TrackingId"; $db = static::getDBSQL(); $stmt = $db->prepare($sql); $stmt->bindValue(":Size", $this->Size, PDO::PARAM_STR); $stmt->bindValue(":Seal", $this->Seal, PDO::PARAM_STR); $stmt->bindValue(":TrackingNum", $this->TrackingNum, PDO::PARAM_STR); $stmt->bindValue(":DisableDate", $this->DisableDate == null ? null : $this->DisableDate, PDO::PARAM_STR); $stmt->bindValue(":UpdatedBy", $user->id, PDO::PARAM_STR); $stmt->bindValue(":TrackingId", $id, PDO::PARAM_STR); return $stmt->execute(); } catch (\PDOException $e) { echo $e->getMessage(); } } public function createItems($id, $headerid) { try { $sql = "DELETE WHS.Deliveries WHERE DeliveryHeaderId = :DeliveryHeaderId"; $db = static::getDBSQL(); $stmt = $db->prepare($sql); $stmt->bindValue(":DeliveryHeaderId", $headerid, PDO::PARAM_INT); $stmt->execute(); $db = static::getOraDB(); $con = oci_connect(Config::ORA_USER, Config::ORA_PASSWORD, $db, "AL32UTF8"); $func = new foo(); if ($con) { $results = array(); $mysql = array(); $stid = oci_parse($con, "SELECT \xa WSH_PICK_TICKET_MANDARO_V.DELIVERY_ID,\xa WSH_PICK_TICKET_MANDARO_V.DELIVERY_DETAIL_ID,
WSH_PICK_TICKET_MANDARO_V.INVENTORY_ITEM_ID,
WSH_PICK_TICKET_MANDARO_V.NAME, \xa WSH_PICK_TICKET_MANDARO_V.ITEM_DESCRIPTION,
WSH_PICK_TICKET_MANDARO_V.DELIVERY_ASSIGNMENT_ID, \xa WSH_PICK_TICKET_MANDARO_V.REQUESTED_QUANTITY, \xa WSH_PICK_TICKET_MANDARO_V.SEGMENT1, \xa WSH_PICK_TICKET_MANDARO_V.ORG, \xa WSH_PICK_TICKET_MANDARO_V.ORGANIZATION_ID, \xa WSH_PICK_TICKET_MANDARO_V.REQUESTED_QUANTITY_UOM,
WSH_PICK_TICKET_MANDARO_V.BOX_QTY,
WSH_PICK_TICKET_MANDARO_V.NW, \xa WSH_PICK_TICKET_MANDARO_V.GW, \xa WSH_PICK_TICKET_MANDARO_V.CBM, \xa WSH_PICK_TICKET_MANDARO_V.SCHEDULE_SHIP_DATE,
WSH_PICK_TICKET_MANDARO_V.SOURCE_LINE_ID, \xa WSH_PICK_TICKET_MANDARO_V.TRACKING_NUMBER,
WSH_PICK_TICKET_MANDARO_V.SEAL_CODE, \xa WSH_PICK_TICKET_MANDARO_V.CUST_PO_NUMBER,
WSH_PICK_TICKET_MANDARO_V.CUSTOMER_NAME,
WSH_PICK_TICKET_MANDARO_V.ATTRIBUTE7, \xa WSH_PICK_TICKET_MANDARO_V.ATTRIBUTE3, \xa WSH_PICK_TICKET_MANDARO_V.ORDER_NUMBER,
WSH_PICK_TICKET_MANDARO_V.JOB_NAME
FROM PHOM.WSH_PICK_TICKET_MANDARO_V \xa WHERE \xa WSH_PICK_TICKET_MANDARO_V.NAME LIKE '" . $id . "%'"); oci_execute($stid); while ($row = oci_fetch_array($stid, OCI_ASSOC + OCI_RETURN_NULLS)) { $DeliveryId = $func->mssql_escape_string($row["DELIVERY_ID"]); $InventoryItemId = $func->mssql_escape_string($row["INVENTORY_ITEM_ID"]); $DeliveryName = $func->mssql_escape_string($row["NAME"]); $ItemDescription = $func->mssql_escape_string($row["ITEM_DESCRIPTION"]); $DeliveryAssignmentId = $func->mssql_escape_string($row["DELIVERY_ASSIGNMENT_ID"]); $DeliveryDetailId = $func->mssql_escape_string($row["DELIVERY_DETAIL_ID"]); $RequestedQuantity = $func->mssql_escape_string($row["REQUESTED_QUANTITY"]); $Item = $func->mssql_escape_string($row["SEGMENT1"]); $OrganizationId = $func->mssql_escape_string($row["ORGANIZATION_ID"]); $UnitOfMeasure = $func->mssql_escape_string($row["REQUESTED_QUANTITY_UOM"]); $BoxQuantity = $func->mssql_escape_string($row["BOX_QTY"]); $NetWeight = $func->mssql_escape_string($row["NW"]); $GrossWeight = $func->mssql_escape_string($row["GW"]); $CBM = $func->mssql_escape_string($row["CBM"]); $ScheduleShipDate = $func->mssql_escape_string($row["SCHEDULE_SHIP_DATE"]); $SourceLineId = $func->mssql_escape_string($row["SOURCE_LINE_ID"]); $TrackingNumber = $func->mssql_escape_string($row["TRACKING_NUMBER"]); $SealCode = $func->mssql_escape_string($row["SEAL_CODE"]); $CustomerOrderNumber = $func->mssql_escape_string($row["CUST_PO_NUMBER"]); $Attribute7 = $func->mssql_escape_string($row["ATTRIBUTE7"]); $Attribute3 = $func->mssql_escape_string($row["ATTRIBUTE3"]); $OrderNumber = $func->mssql_escape_string($row["ORDER_NUMBER"]); $JobName = $func->mssql_escape_string($row["JOB_NAME"]); $CustomerName = $func->mssql_escape_string($row["CUSTOMER_NAME"]); $mysql = "INSERT INTO WHS.Deliveries (
DeliveryId
,InventoryItemId\xa ,DeliveryName\xa ,ItemDescription\xa ,DeliveryAssignmentId
,DeliveryDetailId\xa ,RequestedQuantity
,Item\xa ,OrganizationId
,UnitOfMeasure\xa ,BoxQuantity\xa ,NetWeight\xa ,GrossWeight\xa ,CBM\xa ,ScheduleShipDate\xa ,SourceLineId\xa ,TrackingNumber
,SealCode\xa ,CustomerOrderNumber
,Attribute7\xa ,Attribute3
,OrderNumber\xa ,JobName\xa ,DeliveryHeaderId\xa ,CustomerName\xa )\xa VALUES(
'" . $DeliveryId . "'
,N'" . $InventoryItemId . "'\xa ,N'" . $DeliveryName . "'\xa ,N'" . $ItemDescription . "'
,N'" . $DeliveryAssignmentId . "'\xa ,N'" . $DeliveryDetailId . "'\xa ,N'" . $RequestedQuantity . "'
,N'" . $Item . "'
,N'" . $OrganizationId . "'\xa ,N'" . $UnitOfMeasure . "'
,N'" . $BoxQuantity . "'
,N'" . $NetWeight . "'
,N'" . $GrossWeight . "'\xa ,N'" . $CBM . "'
,N'" . $ScheduleShipDate . "'
,N'" . $SourceLineId . "'
,N'" . $TrackingNumber . "'\xa ,N'" . $SealCode . "'
,N'" . $CustomerOrderNumber . "'
,N'" . $Attribute7 . "'\xa ,N'" . $Attribute3 . "'
,N'" . $OrderNumber . "'\xa ,N'" . $JobName . "'\xa ,N'" . $headerid . "'\xa ,N'" . $CustomerName . "'\xa )"; $dbmy = static::getDBSQL(); $stmt1 = $dbmy->prepare($mysql); $stmt1->execute(); } echo "Connect successfully."; } else { echo "Cannot connect to Oracle."; } oci_close($con); } catch (\PDOException $e) { echo $e->getMessage(); } } public function updateHeader($id) { try { $user = User::findByID($_SESSION["user_id"]); $sql = "UPDATE WHS.Invoice\xa SET\xa DeliveryName = :DeliveryName
,OrganizationId = :OrganizationId\xa ,CustomerId = :CustomerId\xa ,InvoiceDate = :InvoiceDate
,Departure = :Departure
,MotherVessel = :MotherVessel
,ConnectingVessel = :ConnectingVessel
,ShippingLine = :ShippingLine\xa ,Forwarder = :Forwarder
,UpdatedDate = GetDate()\xa ,UpdatedBy = :UpdatedBy\xa ,Remarks = :Remarks
,Revision = :Revision\xa ,Pallet = :Pallet\xa ,ConsigneeName = :ConsigneeName\xa ,ConsigneeAddress = :ConsigneeAddress\xa WHERE DeliveryId ='" . $id . "'"; $db = static::getDBSQL(); $stmt = $db->prepare($sql); $stmt->bindValue(":DeliveryName", $this->DeliveryName, PDO::PARAM_INT); $stmt->bindValue(":OrganizationId", $this->OrganizationId, PDO::PARAM_INT); $stmt->bindValue(":CustomerId", $this->CustomerId, PDO::PARAM_INT); $stmt->bindValue(":InvoiceDate", $this->InvoiceDate == null ? null : $this->InvoiceDate, PDO::PARAM_STR); $stmt->bindValue(":Departure", $this->Departure == null ? null : $this->Departure, PDO::PARAM_STR); $stmt->bindValue(":MotherVessel", $this->MotherVessel, PDO::PARAM_STR); $stmt->bindValue(":ConnectingVessel", $this->ConnectingVessel, PDO::PARAM_STR); $stmt->bindValue(":ShippingLine", $this->ShippingLine, PDO::PARAM_STR); $stmt->bindValue(":Forwarder", $this->Forwarder, PDO::PARAM_STR); $stmt->bindValue(":UpdatedBy", $user->id, PDO::PARAM_INT); $stmt->bindValue(":Remarks", $this->Remarks, PDO::PARAM_STR); $stmt->bindValue(":Revision", $this->Revision, PDO::PARAM_STR); $stmt->bindValue(":Pallet", $this->Pallet, PDO::PARAM_STR); $stmt->bindValue(":ConsigneeName", $this->ConsigneeName == NULL ? '' : $this->ConsigneeName, PDO::PARAM_STR); $stmt->bindValue(":ConsigneeAddress", $this->ConsigneeAddress == NULL ? '' : $this->ConsigneeAddress, PDO::PARAM_STR); return $stmt->execute(); } catch (\PDOException $e) { echo $e->getMessage(); } } public function updateItemDetail($id) { try { $user = User::findByID($_SESSION["user_id"]); $sql = "UPDATE WHS.Deliveries
SET \xa -- InventoryItemId = :InventoryItemId
DeliveryName = :DeliveryName\xa ,InventoryItemId = :InventoryItemId\xa ,RequestedQuantity = :RequestedQuantity\xa ,UnitOfMeasure = :UnitOfMeasure
,BoxQuantity = :BoxQuantity
,NetWeight = :NetWeight\xa ,GrossWeight = :GrossWeight\xa ,CBM = :CBM\xa WHERE Id = :id"; $db = static::getDBSQL(); $stmt = $db->prepare($sql); $stmt->bindValue(":DeliveryName", $this->DeliveryName, PDO::PARAM_INT); $stmt->bindValue(":InventoryItemId", $this->InventoryItemId, PDO::PARAM_STR); $stmt->bindValue(":RequestedQuantity", $this->RequestedQuantity, PDO::PARAM_STR); $stmt->bindValue(":UnitOfMeasure", $this->UnitOfMeasure, PDO::PARAM_STR); $stmt->bindValue(":BoxQuantity", $this->BoxQuantity, PDO::PARAM_STR); $stmt->bindValue(":NetWeight", $this->NetWeight, PDO::PARAM_STR); $stmt->bindValue(":GrossWeight", $this->GrossWeight, PDO::PARAM_STR); $stmt->bindValue(":CBM", $this->CBM, PDO::PARAM_INT); $stmt->bindValue(":id", $id, PDO::PARAM_INT); $stmt->execute(); } catch (\PDOException $e) { echo $e->getMessage(); } } private function headerOnUpdate() { try { $user = User::findByID($_SESSION["user_id"]); $id = $this->DeliveryName; $sql = "UPDATE IMP.Deliveries\xa SET\xa UpdatedDate = :UpdatedDate
UpdatedBy =: UpdatedBy,
WHERE \xa DeliveryName ='" . $id . "'"; $db = static::getDBSQL(); $stmt = $db->prepare($sql); $stmt->bindValue(":UpdatedDate", $this->UpdatedDate, PDO::PARAM_STR); $stmt->bindValue(":UpdatedBy", $user->id, PDO::PARAM_STR); $stmt->execute(); } catch (\PDOException $e) { echo $e->getMessage(); } } private function updateItems() { try { $id = $this->DeliveryName; $db = static::getOraDB(); $con = oci_connect(Config::ORA_USER, Config::ORA_PASSWORD, $db, "AL32UTF8"); $func = new foo(); if ($con) { $results = array(); $mysql = array(); $stid = oci_parse($con, "SELECT * FROM PHOM.SANVINO WHERE NAME like '" . $id . "'"); oci_execute($stid); while ($row = oci_fetch_array($stid, OCI_ASSOC + OCI_RETURN_NULLS)) { $sql = "select ID_ITEM, ID_PROGRAMA from B_PROGRAMA_EVALUACION_BIPS WHERE ID_ITEM=" . $row["ID_ITEM"] . " AND ID_PROGRAMA=" . $row["ID_PROGRAMA"]; $stmt = $db->prepare($sql); $stmt->execute(); $result = $stmt->fetchAll(PDO::FETCH_OBJ); $DeliveryId = $func->mssql_escape_string($row["DELIVERY_ID"]); $InventoryItemId = $func->mssql_escape_string($row["INVENTORY_ITEM_ID"]); $DeliveryName = $func->mssql_escape_string($row["NAME"]); $ItemDescription = $func->mssql_escape_string($row["ITEM_DESCRIPTION"]); $DeliveryAssignmentId = $func->mssql_escape_string($row["DELIVERY_ASSIGNMENT_ID"]); $DeliveryDetailId = $func->mssql_escape_string($row["DELIVERY_DETAIL_ID"]); $RequestedQuantity = $func->mssql_escape_string($row["REQUESTED_QUANTITY"]); $Item = $func->mssql_escape_string($row["SEGMENT1"]); $OrganizationId = $func->mssql_escape_string($row["ORGANIZATION_ID"]); $UnitOfMeasure = $func->mssql_escape_string($row["REQUESTED_QUANTITY_UOM"]); $BoxQuantity = $func->mssql_escape_string($row["BOX_QTY"]); $NetWeight = $func->mssql_escape_string($row["NW"]); $GrossWeight = $func->mssql_escape_string($row["GW"]); $CBM = $func->mssql_escape_string($row["CBM"]); $ScheduleShipDate = $func->mssql_escape_string($row["SCHEDULE_SHIP_DATE"]); $SourceLineId = $func->mssql_escape_string($row["SOURCE_LINE_ID"]); $TrackingNumber = $func->mssql_escape_string($row["TRACKING_NUMBER"]); $SealCode = $func->mssql_escape_string($row["SEAL_CODE"]); $CustomerOrderNumber = $func->mssql_escape_string($row["CUST_PO_NUMBER"]); $Attribute7 = $func->mssql_escape_string($row["ATTRIBUTE7"]); $Attribute3 = $func->mssql_escape_string($row["ATTRIBUTE3"]); $OrderNumber = $func->mssql_escape_string($row["ORDER_NUMBER"]); $JobName = $func->mssql_escape_string($row["JOB_NAME"]); if ($rows["DeliveryName"] == $row["DeliveryName"] && $rows["OrganizationId"] == $row["OrganizationId"]) { $sql = "UPDATE B_PROGRAMA_EVALUACION_BIPS SET ID_PROGRAMA='" . $row["ID_PROGRAMA"] . "', ANO='" . $row["ANO"] . "', COPIA='" . $row["COPIA"] . "', TIPO_PROGRAMA_ER='" . $row["TIPO_PROGRAMA_ER"] . "', EVALUACION='" . mysqli_real_escape_string($db, $row["EVALUACION"]) . "', ID_CARACTERICACION='" . $row["ID_CARACTERICACION"] . "',
NOTA='" . $row["NOTA"] . "' WHERE ID_ITEM=" . $row["ID_ITEM"]; $mysql = "insert into dbo.DeliveryDetail (
DeliveryId
,InventoryItemId
,DeliveryName
,ItemDescription
,DeliveryAssignmentId
,DeliveryDetailId
,RequestedQuantity
,Item\xa ,OrganizationId\xa ,UnitOfMeasure\xa ,BoxQuantity
,NetWeight\xa ,GrossWeight
,CBM
,ScheduleShipDate
,SourceLineId
,TrackingNumber\xa ,SealCode
,CustomerOrderNumber\xa ,Attribute7\xa ,Attribute3\xa ,OrderNumber\xa ,JobName\xa )\xa VALUES(\xa '" . $DeliveryId . "'
,N'" . $InventoryItemId . "'
,N'" . $DeliveryName . "'\xa ,N'" . $ItemDescription . "'\xa ,N'" . $DeliveryAssignmentId . "'\xa ,N'" . $DeliveryDetailId . "'\xa ,N'" . $RequestedQuantity . "'\xa ,N'" . $Item . "'\xa ,N'" . $OrganizationId . "'\xa ,N'" . $UnitOfMeasure . "'\xa ,N'" . $BoxQuantity . "'
,N'" . $NetWeight . "'\xa ,N'" . $GrossWeight . "'
,N'" . $CBM . "'
,N'" . $ScheduleShipDate . "'\xa ,N'" . $SourceLineId . "'
,N'" . $TrackingNumber . "'
,N'" . $SealCode . "'\xa ,N'" . $CustomerOrderNumber . "'\xa ,N'" . $Attribute7 . "'
,N'" . $Attribute3 . "'
,N'" . $OrderNumber . "'\xa )"; $dbmy = static::getDBSQL(); $stmt = $dbmy->prepare($mysql); $stmt->execute(); } } echo "Connect successfully."; } else { echo "Cannot connect to Oracle."; } oci_close($con); } catch (\PDOException $e) { echo $e->getMessage(); } } public static function getCustomerList() { try { $sql = "SELECT * FROM HZ.PARTY ORDER BY PartyName ASC"; $db = static::getDBSQL(); $stmt = $db->prepare($sql); $stmt->execute(); $result = $stmt->fetchAll(PDO::FETCH_OBJ); return $result; } catch (\PDOException $e) { echo $e->getMessage(); } } public static function getAvailableInvoice($status) { try { $organizationId = $_SESSION["organization"]; $in = str_repeat("?,", count($status) - 1) . "?"; $sql = "SELECT * FROM WHS.Invoice I LEFT OUTER JOIN HZ.Party P ON I.CustomerId = p.PartyCode
WHERE I.OrganizationId = ? AND I.CIStatus in (" . $in . ")"; $db = static::getDBSQL(); $stmt = $db->prepare($sql); $params = array_merge(array($organizationId), $status); $stmt->execute($params); $result = $stmt->fetchAll(PDO::FETCH_OBJ); return $result; } catch (\PDOException $e) { echo $e->getMessage(); } } public static function posting() { try { $sql = "DELETE FROM WHS.Deliveries where Id =:Id"; $result = array(); $db = static::getDBSQL(); $stmt = $db->prepare($sql); $stmt->bindValue(":Id", $itemId, PDO::PARAM_STR); return $stmt->execute(); } catch (\PDOException $e) { echo $e->getMessage(); } } } class foo { function mssql_escape_string($data) { if (!isset($data) or empty($data)) { return ''; } if (is_numeric($data)) { return $data; } $non_displayables = array("/%0[0-8bcef]/", "/%1[0-9a-f]/", "/[\x00-\x08]/", "/\x0b/", "/\x0c/", "/[\x0e-\x1f]/"); foreach ($non_displayables as $regex) { $data = preg_replace($regex, '', $data); } $data = str_replace("'", "''", $data); return $data; } } ?>Did this file decode correctly?
Original Code
<?php
namespace App\Models\Application\Logistics; use PDO; use App\Models\User; use App\Token; use App\Config; class InvoiceModel extends \Core\Model { public $errors = array(); public function __construct($data = array()) { foreach ($data as $key => $value) { $this->{$key} = $value; } } public static function deleteContainer($trackingId) { try { $sql = "\125\120\104\x41\x54\x45\40\x20\127\x48\123\x2e\x54\x72\141\x63\x6b\151\x6e\x67\x20\x53\x45\x54\40\104\151\x73\141\142\x6c\145\x44\x61\164\x65\x20\75\x20\x47\x65\x74\x44\x61\x74\x65\50\51\40\127\110\105\122\x45\x20\124\x72\141\143\x6b\x69\156\x67\x49\x64\40\75\40\x3a\x54\x72\141\143\153\151\x6e\x67\x49\x64"; $db = static::getDBSQL(); $stmt = $db->prepare($sql); $stmt->bindValue("\72\124\162\x61\x63\153\x69\x6e\x67\x49\144", $trackingId, PDO::PARAM_INT); return $stmt->execute(); } catch (\PDOException $e) { echo $e->getMessage(); } } public function createHeader() { $user = User::findByID($_SESSION["\165\163\x65\x72\137\151\144"]); $sql = "\111\x4e\x53\105\x52\x54\x20\x49\x4e\x54\x4f\x20\127\x48\123\x2e\111\156\x76\157\151\x63\x65\40\x28\xa\40\x20\40\x20\40\40\40\40\40\40\x20\40\104\x65\154\x69\166\145\x72\171\116\141\155\x65\12\x20\x20\x20\40\40\x20\40\x20\40\40\x20\x2c\x4f\x72\x67\141\x6e\x69\x7a\141\x74\x69\157\156\x49\144\12\40\40\40\x20\x20\x20\40\40\40\x20\40\54\x43\x75\163\x74\157\x6d\x65\162\x49\144\12\40\x20\40\x20\x20\40\40\x20\40\40\x20\x2c\x49\x6e\166\x6f\x69\143\145\104\141\x74\x65\12\40\40\40\40\x20\40\x20\x20\x20\x20\x20\x2c\104\145\x70\141\162\164\x75\x72\145\12\x20\40\40\40\x20\40\40\x20\x20\40\40\x2c\x4d\x6f\x74\150\x65\x72\x56\x65\163\x73\x65\x6c\xa\x20\40\x20\40\40\40\x20\x20\x20\40\x20\54\x43\157\x6e\156\x65\143\164\151\156\147\126\x65\163\163\x65\154\12\x20\x20\x20\40\40\40\40\x20\x20\40\x20\x2c\x53\x68\151\160\160\151\156\147\114\x69\156\145\12\x20\x20\x20\x20\40\40\40\40\x20\40\40\x2c\106\x6f\x72\167\141\162\x64\x65\x72\12\40\x20\x20\40\x20\40\x20\40\x20\x20\x20\x2c\103\x72\145\x61\164\x69\157\156\104\141\164\x65\xa\x20\x20\40\x20\40\x20\x20\x20\x20\40\x20\54\x43\162\x65\141\x74\145\144\x42\171\xa\x20\x20\x20\40\x20\x20\40\40\40\x20\x20\x2c\x53\150\x69\x70\155\145\156\x74\124\171\160\145\12\x20\x20\x20\40\40\40\40\40\x20\x20\x20\54\x43\111\x53\x74\141\164\x75\x73\xa\x20\x20\40\x20\40\x20\40\40\x20\40\x20\51\12\40\40\40\40\x20\x20\40\x56\101\x4c\x55\105\123\40\x28\xa\40\40\40\x20\x20\x20\x20\40\x20\x20\40\x20\x3a\x44\x65\154\x69\166\145\x72\171\116\141\155\x65\12\x20\40\x20\x20\40\40\x20\40\40\40\40\x2c\x3a\x4f\x72\147\141\x6e\151\x7a\141\x74\151\157\156\111\x64\xa\40\x20\40\x20\40\40\x20\x20\40\x20\40\54\x3a\x43\x75\163\164\157\155\x65\162\111\144\xa\x20\x20\x20\x20\40\x20\x20\x20\x20\x20\40\54\72\x49\156\166\157\x69\143\145\x44\x61\164\x65\xa\40\40\40\40\x20\40\x20\40\x20\40\x20\54\72\x44\145\x70\x61\x72\164\x75\162\145\xa\40\40\40\40\x20\x20\40\x20\x20\40\x20\x2c\72\x4d\x6f\164\x68\x65\162\x56\x65\x73\163\x65\154\xa\x20\40\x20\40\x20\40\40\40\40\40\x20\x2c\x3a\x43\157\156\x6e\145\x63\x74\x69\x6e\x67\126\x65\163\x73\145\154\xa\x20\40\x20\x20\40\40\x20\x20\40\x20\40\x2c\72\123\x68\x69\x70\x70\x69\156\x67\114\151\x6e\145\12\x20\x20\x20\x20\40\40\40\x20\40\40\x20\54\72\x46\x6f\162\167\x61\162\144\x65\x72\xa\40\x20\40\x20\x20\x20\x20\x20\x20\40\40\x2c\x47\145\x74\x44\x61\164\x65\50\51\xa\40\x20\40\40\x20\x20\x20\40\40\40\x20\54\x3a\103\x72\x65\x61\164\145\x64\x42\x79\xa\40\x20\40\40\40\40\x20\x20\40\40\40\x2c\x3a\x53\150\x69\x70\155\145\156\164\x54\x79\160\145\xa\40\40\x20\40\x20\x20\x20\x20\x20\x20\x20\54\x27\x4f\x50\x45\116\47\12\x20\40\x20\x20\40\40\x20\40\40\40\40\51"; $db = static::getDBSQL(); $stmt = $db->prepare($sql); $export = "\105\x78\x70\157\162\164"; $stmt->bindParam("\72\x44\145\x6c\151\166\145\162\171\116\141\155\x65", $this->DeliveryName, PDO::PARAM_STR); $stmt->bindParam("\x3a\x4f\162\x67\141\x6e\x69\172\141\164\x69\x6f\x6e\x49\x64", $this->OrganizationId, PDO::PARAM_INT); $stmt->bindParam("\72\103\165\x73\x74\157\155\x65\x72\x49\144", $this->CustomerId, PDO::PARAM_INT); $stmt->bindParam("\x3a\x49\156\166\x6f\151\x63\x65\x44\x61\x74\145", $this->InvoiceDate, PDO::PARAM_STR); $stmt->bindParam("\x3a\104\145\x70\141\x72\x74\165\162\145", $this->Departure, PDO::PARAM_STR); $stmt->bindParam("\72\x4d\x6f\x74\x68\145\162\x56\145\163\x73\x65\x6c", $this->MotherVessel, PDO::PARAM_STR); $stmt->bindParam("\x3a\x43\157\156\156\145\x63\164\x69\156\147\x56\145\163\x73\145\x6c", $this->ConnectingVessel, PDO::PARAM_STR); $stmt->bindParam("\72\x53\x68\151\160\160\151\x6e\x67\114\151\156\x65", $this->ShippingLine, PDO::PARAM_STR); $stmt->bindParam("\72\106\157\x72\x77\141\x72\144\145\162", $this->Forwarder, PDO::PARAM_STR); $stmt->bindParam("\72\103\x72\145\x61\x74\145\x64\x42\171", $user->id, PDO::PARAM_STR); $stmt->bindParam("\72\123\x68\x69\x70\155\145\x6e\x74\x54\171\x70\x65", $export, PDO::PARAM_STR); $stmt->execute(); $lastId = $db->lastInsertId(); return $lastId; } public function create() { try { $user = User::findByID($_SESSION["\x75\x73\x65\x72\137\151\x64"]); if (empty($this->errors)) { if (!$this->invoiceExist()) { return $this->createHeader(); } } return false; } catch (\PDOException $e) { echo $e->getMessage(); } } public static function getDeliveryList() { try { $sql = "\x53\x45\114\x45\103\x54\x20\x20\40\x20\40\x20\x20\x20\111\x2e\104\x65\x6c\151\x76\x65\x72\171\x49\x64\54\40\x49\56\117\x72\147\x61\x6e\x69\x7a\141\x74\151\157\156\111\x64\54\40\111\x2e\x44\x65\x6c\x69\x76\145\162\x79\x4e\141\x6d\x65\x2c\x20\x49\56\x49\156\x76\x6f\x69\143\x65\104\141\x74\145\54\40\111\x2e\117\x72\144\x65\162\116\x75\x6d\142\145\162\54\40\x49\x2e\x43\165\163\164\x6f\x6d\x65\162\111\x64\x2c\x20\x49\56\104\145\x6c\x69\166\x65\x72\171\x44\141\164\x65\54\40\x49\x2e\104\145\x70\141\x72\164\165\162\145\54\40\111\x2e\x4d\157\164\x68\145\x72\x56\145\163\163\145\154\54\40\111\56\x43\x6f\x6e\156\145\x63\x74\x69\156\x67\x56\x65\163\163\145\x6c\54\x20\111\56\123\x68\x69\160\x70\x69\x6e\147\114\x69\156\x65\x2c\40\111\x2e\106\x6f\162\x77\x61\x72\144\145\x72\54\x20\x49\x2e\122\145\x6d\x61\x72\x6b\163\x2c\x20\12\40\x20\40\40\40\40\x20\40\x20\40\x20\x49\x2e\103\x72\145\141\164\x69\157\x6e\x44\141\x74\145\x2c\x20\x49\x2e\103\162\145\x61\164\145\x64\102\171\54\x20\111\56\125\160\x64\x61\x74\x65\144\104\141\164\x65\x2c\x20\x49\56\x55\x70\x64\x61\x74\x65\144\102\171\54\40\x49\56\x53\150\x69\x70\x6d\145\x6e\164\124\x79\160\145\54\40\x49\56\x53\x74\x61\x74\x75\163\x2c\x20\117\x2e\x4f\162\x67\x61\156\x69\172\x61\x74\151\157\156\116\141\155\x65\54\x20\110\x5a\x2e\120\141\x72\x74\171\56\x50\141\x72\164\171\x4e\x61\x6d\145\12\x46\122\x4f\x4d\40\40\40\x20\40\x20\40\40\x20\40\40\40\x57\110\123\56\x49\156\x76\157\151\x63\145\x20\x41\x53\x20\x49\40\x4c\x45\x46\124\x20\117\x55\124\x45\122\x20\x4a\117\111\116\12\40\40\40\x20\x20\40\40\x20\x20\40\x20\x48\132\x2e\x50\x61\x72\x74\171\40\x4f\116\40\x49\56\103\x75\163\164\157\155\145\162\x49\x64\40\x3d\x20\x48\132\56\120\x61\x72\164\x79\56\120\x61\162\164\x79\103\157\x64\145\x20\x4c\x45\x46\124\x20\117\x55\124\105\x52\40\x4a\x4f\111\x4e\12\40\40\40\40\x20\40\40\x20\x20\40\40\x41\120\x50\56\x4f\x72\147\141\156\151\172\x61\164\151\x6f\x6e\40\101\x53\x20\117\x20\117\116\x20\x49\x2e\117\162\147\x61\156\151\x7a\x61\x74\151\x6f\156\x49\144\40\x3d\x20\117\56\x49\144\xa\x4f\x52\x44\105\122\40\102\131\40\111\x2e\x44\x65\x6c\x69\166\145\x72\171\x4e\141\x6d\145"; $db = static::getDBSQL(); $stmt = $db->prepare($sql); $stmt->execute(); $result = $stmt->fetchAll(PDO::FETCH_OBJ); return $result; } catch (\PDOException $e) { echo $e->getMessage(); } } public static function getLoadingById($id) { try { $sql = "\105\x58\105\x43\x20\133\x45\130\120\135\x2e\x5b\154\157\141\144\x69\156\147\162\145\160\157\162\x74\135\x20\x3f"; $db = static::getDBSQL(); $stmt = $db->prepare($sql); $stmt->bindParam(1, $id, PDO::PARAM_STR); $stmt->execute(); $result = $stmt->fetchAll(PDO::FETCH_OBJ); return $result; } catch (\PDOException $e) { echo $e->getMessage(); } } public static function getDeliveryByName($name) { try { $sql = "\x53\x45\x4c\x45\103\x54\x20\x2a\x2c\x28\163\145\154\145\x63\164\40\127\145\x69\147\150\164\x20\146\x72\157\x6d\x20\127\x48\123\56\x53\150\151\x70\155\x65\156\x74\x4f\142\x6a\x65\143\x74\xa\40\40\40\x20\x20\x20\40\x20\40\40\40\40\x20\40\40\40\40\x20\x20\x20\x57\x48\105\122\x45\x20\x4f\x62\x6a\145\143\x74\116\x61\x6d\x65\40\x3d\40\x27\x57\x6f\x6f\144\120\141\154\154\145\164\x27\x29\x2a\x49\x53\x4e\125\114\114\50\x50\x61\154\154\x65\x74\54\60\51\x20\120\x57\145\151\x67\150\x74\x2c\x20\xa\x20\x20\x20\40\40\40\x20\x20\40\x20\x20\40\x20\x20\40\40\x20\40\40\x20\50\163\x65\x6c\x65\143\x74\x20\x43\102\x4d\x20\146\162\x6f\x6d\x20\x57\x48\123\x2e\123\150\x69\x70\x6d\x65\x6e\164\117\x62\x6a\145\x63\164\xa\x20\40\x20\40\40\x20\x20\x20\40\40\x20\x20\x20\x20\x20\40\x20\40\40\40\x57\110\105\x52\x45\x20\x4f\142\152\145\x63\x74\116\141\x6d\145\40\x3d\40\47\x57\157\157\144\120\141\x6c\x6c\x65\x74\x27\x29\x2a\111\123\116\125\114\114\50\x50\x61\154\x6c\x65\164\x2c\60\x29\40\x50\103\x42\x4d\40\106\122\x4f\115\40\x57\110\x53\56\x49\156\x76\x6f\151\x63\x65\x20\144\12\40\x20\40\x20\40\x20\x20\40\x20\x20\40\40\x20\x20\40\40\x20\x20\x20\x20\111\x4e\116\105\x52\x20\112\x4f\111\x4e\x20\141\x70\160\56\117\x72\147\x61\x6e\151\172\141\164\x69\157\156\x20\x6f\12\40\40\40\40\40\x20\x20\40\40\40\x20\x20\40\x20\x20\40\x20\x20\x20\40\x4f\x4e\x20\x64\56\x4f\x72\x67\x61\156\151\x7a\141\x74\x69\x6f\156\x49\x64\40\75\x20\157\x2e\x49\144\40\127\x48\x45\122\105\40\144\56\104\145\154\x69\166\x65\x72\x79\x4e\141\155\145\x20\75\x20\x3a\x44\145\x6c\151\166\145\162\171\116\141\155\x65"; $db = static::getDBSQL(); $stmt = $db->prepare($sql); $stmt->bindParam("\x3a\x44\x65\154\151\166\x65\162\171\x4e\x61\155\x65", $name, PDO::PARAM_STR); $stmt->execute(); $result = array(); while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { $result = $row; } return $result; } catch (\PDOException $e) { echo $e->getMessage(); } } public static function getContainerByInvoiceId($id) { try { $sql = "\x53\x45\x4c\105\103\124\40\143\x61\163\164\50\103\157\165\156\x74\50\163\x69\x7a\x65\x29\x20\x61\x73\x20\x76\141\x72\x63\150\x61\x72\x28\61\x30\51\x29\53\40\47\x20\x58\x20\47\x20\53\x20\x20\123\x69\x7a\145\40\40\40\103\157\x6e\x74\x61\151\x6e\145\162\x43\157\165\x6e\164\x20\x20\106\122\x4f\115\40\127\110\123\x2e\124\x72\141\143\153\151\156\x67\40\xa\x20\40\x20\40\x20\40\x20\x20\x20\x20\x20\x20\40\x20\x20\x20\40\x20\x20\x20\x20\x20\40\40\40\x20\x20\x20\x57\110\105\x52\105\40\104\145\154\x69\x76\145\162\x79\111\x64\x20\x3d\x20\72\x44\145\x6c\151\x76\145\162\171\111\x64\x20\x41\x4e\x44\x20\104\151\x73\x61\x62\x6c\145\104\141\164\145\40\x20\x69\163\x20\x6e\x75\x6c\x6c\x20\147\x72\157\165\x70\x20\142\171\x20\x53\x69\172\145"; $db = static::getDBSQL(); $stmt = $db->prepare($sql); $stmt->bindParam("\72\x44\x65\x6c\151\166\x65\x72\171\x49\144", $id, PDO::PARAM_STR); $stmt->execute(); $result = array(); while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { $result[] = $row; } return $result; } catch (\PDOException $e) { echo $e->getMessage(); } } public static function getContainerListByInvoiceId($id) { try { $sql = "\123\105\x4c\x45\103\124\x20\52\x20\40\106\x52\117\x4d\x20\127\110\123\x2e\x54\x72\x61\143\153\x69\x6e\x67\x20\xa\x20\40\x20\x20\40\x20\40\x20\40\40\40\40\40\x20\x20\40\40\x20\40\x20\40\x20\x20\40\x20\x20\40\x20\x57\x48\x45\122\x45\x20\x44\145\x6c\x69\166\x65\x72\171\x49\x64\x20\x3d\x20\72\104\145\154\x69\x76\x65\162\x79\111\144\40\x41\116\x44\40\x44\x69\x73\x61\x62\154\145\x44\141\164\145\40\x20\x69\163\x20\x6e\165\x6c\154"; $db = static::getDBSQL(); $stmt = $db->prepare($sql); $stmt->bindParam("\x3a\104\145\154\x69\166\145\x72\171\111\x64", $id, PDO::PARAM_STR); $stmt->execute(); $result = $stmt->fetchAll(PDO::FETCH_OBJ); return $result; } catch (\PDOException $e) { echo $e->getMessage(); } } public static function getDeliveryNameById($id) { try { $sql = "\x53\105\x4c\x45\103\x54\x20\104\145\154\151\166\x65\162\x79\116\141\155\x65\x20\106\122\x4f\x4d\40\127\110\123\x2e\x49\156\x76\x6f\151\x63\x65\x20\127\110\x45\x52\x45\40\x44\x65\x6c\151\x76\145\162\171\111\x64\40\75\x20\x3a\x44\x65\x6c\151\166\x65\162\171\x49\144"; $db = static::getDBSQL(); $stmt = $db->prepare($sql); $stmt->bindParam("\72\104\145\154\x69\166\x65\162\x79\111\144", $id, PDO::PARAM_STR); $stmt->execute(); $result = $stmt->fetchColumn(); return $result; } catch (\PDOException $e) { echo $e->getMessage(); } } public static function getInvoiceIdByName($id) { try { $sql = "\x53\x45\114\x45\103\124\40\x44\145\154\151\166\x65\x72\171\x49\x64\x20\x46\x52\x4f\115\x20\127\110\123\56\x49\x6e\x76\157\x69\x63\x65\40\x57\x48\x45\122\x45\x20\x44\145\x6c\x69\166\145\x72\x79\116\x61\x6d\x65\x20\x3d\x20\x3a\104\x65\154\151\166\x65\162\x79\116\x61\155\x65"; $db = static::getDBSQL(); $stmt = $db->prepare($sql); $stmt->bindParam("\72\104\x65\154\x69\166\145\x72\171\x4e\x61\x6d\x65", $id, PDO::PARAM_STR); $stmt->execute(); $result = $stmt->fetchColumn(); return $result; } catch (\PDOException $e) { echo $e->getMessage(); } } public static function findInvoiceByName($invoiceName) { try { $sql = "\x53\145\154\145\x63\164\x20\x2a\x20\146\x72\x6f\x6d\40\127\110\123\56\x49\156\x76\157\151\x63\145\x20\127\110\105\122\x45\x20\104\x65\x6c\x69\x76\145\x72\171\x4e\x61\155\x65\x20\75\72\x6e\x61\x6d\x65\x20"; $db = static::getDBSQL(); $stmt = $db->prepare($sql); $stmt->bindValue("\72\x6e\141\155\145", $invoiceName, PDO::PARAM_STR); $stmt->setFetchMode(PDO::FETCH_CLASS, get_called_class()); $stmt->execute(); return $stmt->fetch(); } catch (\PDOException $e) { echo $e->getMessage(); } } public function getItemDetail($id) { try { $sql = "\x53\x65\x6c\145\x63\x74\x20\x2a\40\146\x72\157\155\40\x57\x48\123\x2e\104\x65\x6c\151\x76\x65\x72\151\x65\163\x20\x77\150\x65\162\x65\40\111\x64\x3d\40\x3a\x44\145\x6c\151\x76\145\162\171\104\145\164\x61\151\x6c\111\x64"; $db = static::getDBSQL(); $stmt = $db->prepare($sql); $stmt->bindValue("\72\104\145\x6c\151\166\145\x72\171\x44\145\164\x61\151\154\111\x64", $id, PDO::PARAM_STR); $stmt->setFetchMode(PDO::FETCH_CLASS, get_called_class()); $stmt->execute(); return $stmt->fetch(); } catch (\PDOException $e) { echo $e->getMessage(); } } public function invoiceExist() { $name = static::findInvoiceByName($this->DeliveryName); if ($name) { if ($name->DeliveryId != null) { return true; } } return false; } public static function getHeader($id) { try { $sql = "\123\x45\114\105\103\x54\x20\x20\40\40\40\40\40\40\12\40\40\x20\x20\x20\x20\x20\x20\40\40\40\x20\x20\x20\x20\40\40\x20\40\x20\40\x20\x2a\54\x20\104\56\x41\x64\144\x72\145\x73\x73\40\x43\157\156\x73\x69\156\x67\156\145\x65\101\x64\144\x72\x65\163\163\xa\40\x20\40\x20\x20\40\40\x20\x20\x20\40\x20\x20\40\40\x20\40\x20\40\x20\106\122\x4f\115\x20\40\x20\40\40\40\x20\40\40\x20\40\40\12\x20\40\x20\40\x20\x20\40\x20\40\40\40\40\x20\40\40\40\40\x20\x20\40\40\x20\x20\40\x57\x48\x53\x2e\111\156\x76\x6f\x69\x63\x65\x20\104\40\x4c\x45\x46\x54\x20\117\x55\124\x45\122\x20\112\x4f\x49\x4e\x20\x41\120\120\56\117\x72\x67\141\x6e\x69\x7a\141\x74\151\x6f\x6e\40\x4f\40\117\116\x20\104\x2e\117\x72\x67\141\156\151\172\141\x74\x69\x6f\156\111\144\x20\75\x20\117\56\111\x64\12\40\x20\x20\40\x20\40\x20\40\40\x20\40\x20\x20\40\x20\40\40\x20\40\40\x20\40\x20\x20\12\40\x20\40\40\40\x20\x20\x20\40\x20\x20\40\x20\40\x20\40\40\x20\x20\x20\40\127\110\x45\x52\x45\40\x20\104\56\x44\x65\x6c\x69\x76\145\x72\x79\111\144\40\75\40\72\x44\x65\154\x69\166\145\x72\x79\x49\144"; $result = array(); $db = static::getDBSQL(); $stmt = $db->prepare($sql); $stmt->bindValue("\72\104\145\x6c\x69\x76\x65\162\171\111\x64", $id, PDO::PARAM_INT); $stmt->setFetchMode(PDO::FETCH_CLASS, get_called_class()); $stmt->execute(); return $stmt->fetch(); } catch (\PDOException $e) { echo $e->getMessage(); } } public static function getItemDetailById($id) { try { $sql = "\x53\x45\114\105\103\x54\40\x2a\40\x20\x46\122\x4f\115\40\x20\x57\110\x53\56\104\145\154\151\x76\x65\162\x69\x65\163\x20\x44\x20\127\110\x45\x52\x45\x20\40\104\x2e\x44\145\154\151\166\145\162\x79\110\145\141\x64\x65\x72\x49\x64\40\75\40\x3a\104\145\x6c\x69\166\x65\162\x79\110\x65\141\144\x65\x72\111\x64"; $result = array(); $db = static::getDBSQL(); $stmt = $db->prepare($sql); $stmt->bindValue("\x3a\x44\145\154\151\x76\145\x72\x79\110\145\141\x64\145\x72\x49\144", $id, PDO::PARAM_INT); $stmt->setFetchMode(PDO::FETCH_CLASS, get_called_class()); $stmt->execute(); return $stmt->fetch(); } catch (\PDOException $e) { echo $e->getMessage(); } } public function getCustomer($id) { try { $sql = "\123\105\114\105\103\x54\x20\52\x20\106\x52\117\115\40\110\x5a\x2e\120\141\x72\x74\x79\40\127\x48\x45\122\105\x20\120\141\162\164\171\x54\x79\160\145\40\x3d\72\120\141\x72\x74\171\x54\171\160\x65\x20"; $result = array(); $db = static::getDBSQL(); $stmt = $db->prepare($sql); $stmt->bindValue("\x3a\120\141\162\164\x79\124\x79\160\145", "\143\x75\163\164\x6f\155\145\x72", PDO::PARAM_STR); $stmt->setFetchMode(PDO::FETCH_CLASS, get_called_class()); $stmt->execute(); return $stmt->fetch(); } catch (\PDOException $e) { echo $e->getMessage(); } } public static function getItem($deliverName) { try { $sql = "\123\x45\x4c\x45\103\124\x20\x2a\x20\106\122\x4f\x4d\x20\x57\110\123\x2e\x44\x65\x6c\x69\x76\x65\x72\151\145\163\40\x44\40\111\x4e\x4e\x45\122\40\112\117\x49\x4e\x20\x57\110\x53\x2e\111\x6e\166\x6f\x69\143\145\x20\x49\x20\12\40\x20\40\40\40\x20\40\40\40\40\x20\x20\x20\x20\x20\40\x20\x20\40\40\40\x20\x20\40\117\116\x20\x44\x2e\104\x65\154\x69\166\x65\162\x79\110\x65\141\x64\145\x72\x49\144\x20\75\40\x49\56\104\x65\154\151\166\x65\x72\171\x49\144\40\x77\150\145\x72\x65\x20\x49\56\104\x65\x6c\x69\166\x65\162\x79\116\141\155\145\x20\75\72\x44\145\154\x69\x76\145\x72\171\116\141\x6d\x65"; $result = array(); $db = static::getDBSQL(); $stmt = $db->prepare($sql); $stmt->bindValue("\72\104\145\x6c\x69\166\145\162\171\116\141\x6d\x65", $deliverName, PDO::PARAM_INT); $stmt->execute(); $result = $stmt->fetchAll(PDO::FETCH_OBJ); return $result; } catch (\PDOException $e) { echo $e->getMessage(); } } public static function deleteItems($itemId) { try { $sql = "\x44\x45\114\x45\x54\105\40\106\x52\117\115\x20\x57\110\123\56\104\x65\x6c\x69\166\x65\162\151\x65\163\40\167\150\145\162\x65\x20\x49\x64\40\75\x3a\x49\144"; $result = array(); $db = static::getDBSQL(); $stmt = $db->prepare($sql); $stmt->bindValue("\x3a\111\x64", $itemId, PDO::PARAM_STR); return $stmt->execute(); } catch (\PDOException $e) { echo $e->getMessage(); } } public function getContainer($id) { try { $sql = "\x53\105\x4c\105\103\124\x20\x2a\40\x46\x52\117\115\x20\x57\x48\x53\x2e\x54\162\141\143\153\151\x6e\x67\40\127\x48\105\122\105\40\x44\x65\x6c\151\x76\x65\x72\171\x49\x64\x20\x3d\x20\72\104\145\154\151\x76\x65\162\171\x49\144\40\101\116\x44\40\x44\151\x73\x61\142\x6c\145\104\x61\164\x65\40\151\163\x20\x6e\x75\x6c\x6c\x20"; $result = array(); $db = static::getDBSQL(); $stmt = $db->prepare($sql); $stmt->bindValue("\x3a\104\x65\154\151\x76\145\x72\x79\111\x64", $id, PDO::PARAM_STR); $stmt->execute(); $result = $stmt->fetchAll(PDO::FETCH_OBJ); return $result; } catch (\PDOException $e) { echo $e->getMessage(); } } public static function getContainerById($id) { try { $sql = "\x53\105\114\x45\103\124\40\x2a\40\106\122\117\115\40\x57\x48\123\56\124\x72\141\143\153\151\x6e\147\40\127\110\x45\122\105\x20\124\162\x61\143\153\151\x6e\x67\x49\x64\40\75\x20\72\124\162\141\x63\x6b\x69\x6e\x67\111\144\40"; $result = array(); $db = static::getDBSQL(); $stmt = $db->prepare($sql); $stmt->bindValue("\72\124\162\141\143\153\151\x6e\x67\111\x64", $id, PDO::PARAM_STR); $stmt->execute(); $stmt->setFetchMode(PDO::FETCH_CLASS, get_called_class()); $stmt->execute(); return $stmt->fetch(); } catch (\PDOException $e) { echo $e->getMessage(); } } public function createContainer($id) { try { $user = User::findByID($_SESSION["\165\x73\x65\162\137\x69\144"]); $sql = "\111\x4e\x53\x45\x52\124\40\x49\116\124\x4f\x20\127\110\x53\x2e\x54\x72\141\143\153\x69\156\147\40\x28\xa\40\x20\40\x20\x20\40\40\x20\40\40\40\x20\x20\x20\x20\40\x20\x20\x20\x20\x20\40\40\x20\x20\x20\40\40\40\104\145\x6c\x69\x76\x65\162\171\111\x64\xa\x20\x20\x20\40\x20\x20\40\x20\40\40\40\x20\x20\40\x20\x20\40\x20\40\40\x20\40\40\40\x20\x20\40\x20\54\123\151\x7a\x65\12\x20\x20\40\x20\x20\40\x20\40\40\x20\x20\x20\x20\x20\40\40\40\x20\40\40\40\x20\40\x20\40\x20\x20\40\x2c\x53\145\x61\154\12\x20\40\40\40\x20\40\40\x20\x20\40\40\x20\40\40\x20\40\x20\40\x20\40\x20\40\x20\x20\40\x20\x20\40\54\124\x72\x61\x63\x6b\x69\156\x67\116\165\x6d\xa\40\x20\x20\x20\40\x20\40\40\40\x20\x20\x20\x20\x20\40\x20\40\40\40\40\40\40\40\x20\40\x20\x20\x20\54\x43\162\145\x61\x74\151\x6f\x6e\x44\141\x74\x65\xa\40\40\x20\40\x20\x20\x20\x20\x20\40\40\x20\x20\40\x20\x20\x20\40\40\40\x20\x20\40\40\40\40\x20\x20\54\103\162\145\x61\164\145\144\102\x79\12\40\x20\40\40\x20\x20\40\x20\40\x20\40\40\40\x20\40\x20\40\40\x20\40\40\40\40\x20\51\xa\40\x20\x20\40\x20\40\40\40\x20\x20\x20\x20\40\x20\40\40\x20\40\x20\40\126\101\x4c\125\105\123\xa\40\x20\40\x20\x20\x20\x20\x20\40\x20\x20\40\x20\40\x20\40\x20\40\40\x20\x20\x20\x20\x20\x28\xa\x20\40\40\x20\40\x20\x20\x20\40\x20\x20\40\40\40\x20\40\40\x20\x20\x20\x20\40\40\40\40\x20\x20\40\x20\x3a\104\x65\x6c\151\166\x65\162\x79\x49\144\xa\x20\40\x20\x20\40\x20\x20\x20\40\x20\x20\40\40\x20\40\40\40\40\40\x20\40\x20\40\x20\x20\x20\x20\40\54\x3a\123\x69\172\145\12\40\40\40\x20\x20\40\40\x20\40\x20\40\x20\x20\x20\x20\x20\40\40\40\40\40\x20\40\40\40\x20\40\40\x2c\x3a\123\145\x61\x6c\xa\x20\x20\x20\40\40\40\x20\x20\40\40\40\40\x20\x20\40\x20\x20\x20\40\x20\40\x20\40\x20\40\x20\40\x20\x2c\x3a\124\x72\141\143\x6b\x69\x6e\x67\116\165\155\12\x20\40\x20\40\x20\40\x20\x20\40\40\40\x20\x20\40\40\40\x20\40\40\40\40\x20\x20\40\40\x20\x20\40\x2c\x47\x65\164\104\x61\164\145\x28\51\12\x20\x20\x20\40\40\x20\x20\x20\x20\40\40\40\40\x20\40\x20\x20\40\40\x20\40\40\x20\x20\x20\40\40\x20\x2c\x3a\x43\x72\x65\x61\x74\x65\x64\x42\x79\51"; $result = array(); $db = static::getDBSQL(); $stmt = $db->prepare($sql); $stmt->bindValue("\72\104\x65\154\151\x76\x65\x72\x79\111\144", $id, PDO::PARAM_STR); $stmt->bindValue("\72\x53\151\x7a\145", $this->Size, PDO::PARAM_STR); $stmt->bindValue("\x3a\123\x65\141\x6c", $this->Seal, PDO::PARAM_STR); $stmt->bindValue("\x3a\124\162\141\143\153\151\x6e\x67\116\x75\x6d", $this->TrackingNum, PDO::PARAM_STR); $stmt->bindValue("\72\x43\162\145\x61\164\x65\x64\102\x79", $user->id, PDO::PARAM_STR); return $stmt->execute(); } catch (\PDOException $e) { echo $e->getMessage(); } } public function updateContainer($id) { try { $user = User::findByID($_SESSION["\x75\x73\x65\x72\x5f\x69\144"]); $sql = "\x55\x50\x44\x41\124\105\x20\x20\127\x48\x53\x2e\x54\162\141\143\153\x69\156\x67\x20\x53\105\x54\xa\x20\40\40\40\x20\40\40\x20\40\x20\40\40\x20\x20\x20\40\x20\40\x20\x20\x20\40\x20\40\x20\x20\40\40\x20\123\x69\172\145\40\x3d\x20\x3a\x53\x69\172\145\xa\40\x20\40\40\40\40\x20\x20\x20\x20\x20\40\40\x20\x20\40\40\40\40\x20\40\40\x20\x20\x20\40\40\x20\x2c\123\x65\141\x6c\40\x3d\x20\72\123\145\141\154\12\40\40\40\40\40\x20\40\x20\x20\40\x20\x20\x20\x20\x20\40\x20\40\x20\x20\40\40\40\40\x20\40\40\x20\x2c\x54\x72\x61\x63\153\x69\x6e\x67\x4e\165\x6d\40\40\75\40\72\x54\162\141\x63\153\151\x6e\147\x4e\x75\x6d\xa\40\x20\x20\x20\x20\x20\x20\40\x20\40\x20\x20\x20\x20\x20\x20\40\x20\x20\x20\x20\x20\40\40\40\x20\40\x20\54\x44\151\x73\x61\x62\154\145\x44\x61\x74\145\40\40\75\40\x3a\104\151\x73\x61\142\x6c\x65\x44\141\164\145\xa\40\x20\x20\x20\x20\40\x20\x20\40\x20\40\x20\x20\x20\x20\x20\40\40\x20\40\40\x20\x20\40\40\40\x20\x20\x2c\x55\x70\144\141\164\x65\144\104\x61\x74\145\x20\x3d\x20\x20\107\x65\x74\x44\x61\164\145\50\x29\12\x20\40\x20\x20\x20\40\x20\x20\40\x20\40\40\40\x20\x20\x20\x20\x20\40\x20\40\40\x20\x20\40\x20\40\x20\x2c\x55\160\x64\x61\x74\x65\x64\102\171\40\x3d\40\72\125\x70\144\x61\x74\x65\x64\x42\x79\40\xa\x20\x20\x20\x20\x20\40\40\40\x20\x20\x20\x20\x20\40\x20\40\40\40\x20\x20\x77\150\145\x72\145\x20\124\x72\x61\x63\x6b\x69\x6e\x67\111\144\40\x3d\x20\x3a\124\162\x61\143\x6b\151\156\x67\111\x64"; $db = static::getDBSQL(); $stmt = $db->prepare($sql); $stmt->bindValue("\x3a\123\151\172\x65", $this->Size, PDO::PARAM_STR); $stmt->bindValue("\72\123\x65\x61\154", $this->Seal, PDO::PARAM_STR); $stmt->bindValue("\x3a\124\162\141\x63\153\151\x6e\x67\116\x75\x6d", $this->TrackingNum, PDO::PARAM_STR); $stmt->bindValue("\72\x44\151\163\141\x62\x6c\x65\x44\141\x74\145", $this->DisableDate == null ? null : $this->DisableDate, PDO::PARAM_STR); $stmt->bindValue("\72\125\160\144\141\x74\145\144\x42\171", $user->id, PDO::PARAM_STR); $stmt->bindValue("\x3a\124\162\x61\x63\153\151\x6e\x67\111\x64", $id, PDO::PARAM_STR); return $stmt->execute(); } catch (\PDOException $e) { echo $e->getMessage(); } } public function createItems($id, $headerid) { try { $sql = "\x44\x45\x4c\x45\124\105\40\x57\x48\123\56\104\145\154\x69\x76\x65\162\151\145\163\x20\127\110\x45\x52\x45\x20\104\x65\154\x69\166\x65\162\x79\x48\x65\x61\144\145\x72\111\x64\x20\40\x3d\40\x3a\x44\x65\154\151\x76\145\x72\171\x48\x65\x61\144\145\x72\x49\144"; $db = static::getDBSQL(); $stmt = $db->prepare($sql); $stmt->bindValue("\72\x44\x65\154\x69\x76\x65\x72\171\x48\x65\141\x64\145\x72\111\144", $headerid, PDO::PARAM_INT); $stmt->execute(); $db = static::getOraDB(); $con = oci_connect(Config::ORA_USER, Config::ORA_PASSWORD, $db, "\101\x4c\63\x32\125\124\x46\x38"); $func = new foo(); if ($con) { $results = array(); $mysql = array(); $stid = oci_parse($con, "\x53\105\114\105\x43\124\40\xa\40\40\40\x20\40\x20\x20\40\40\x20\40\x20\x20\x20\x20\x20\x20\40\x20\x20\x20\40\40\x20\40\x20\40\x20\40\40\40\x20\x57\123\x48\x5f\120\111\103\113\137\124\111\x43\113\x45\x54\137\115\x41\116\104\x41\122\x4f\137\x56\x2e\x44\105\114\x49\126\x45\122\x59\x5f\111\104\54\xa\40\x20\40\40\40\40\x20\40\x20\x20\x20\x20\40\x20\x20\x20\40\x20\x20\x20\40\40\x20\x20\40\x20\x20\40\40\x20\40\x20\127\123\x48\137\120\111\x43\113\x5f\x54\111\103\113\105\x54\x5f\115\101\x4e\x44\x41\x52\x4f\137\126\56\104\105\114\111\126\x45\122\131\137\104\105\124\x41\111\114\x5f\x49\104\x2c\x20\12\x20\x20\x20\40\x20\40\x20\40\x20\40\40\40\40\x20\40\x20\x20\x20\40\40\40\40\40\40\40\40\x20\x20\40\40\x20\40\127\x53\110\x5f\x50\x49\103\x4b\x5f\124\111\103\113\x45\124\137\115\101\116\x44\101\122\117\x5f\126\56\111\116\126\x45\116\x54\x4f\122\x59\137\x49\x54\105\x4d\x5f\x49\x44\x2c\12\x20\40\40\40\x20\40\40\40\40\x20\x20\40\40\x20\40\x20\x20\x20\40\x20\40\x20\x20\x20\x20\40\40\x20\40\x20\40\40\x57\x53\110\137\120\x49\103\113\x5f\124\111\x43\x4b\105\x54\x5f\115\101\x4e\x44\101\122\x4f\137\126\x2e\116\x41\115\x45\x2c\x20\xa\40\x20\x20\x20\40\40\40\x20\x20\40\x20\40\x20\x20\x20\x20\x20\40\40\40\x20\x20\40\x20\40\40\40\40\x20\40\40\40\127\x53\110\137\x50\x49\x43\x4b\x5f\124\x49\x43\x4b\105\124\x5f\x4d\101\116\104\101\122\x4f\137\126\56\x49\124\x45\115\137\104\x45\123\103\122\111\120\x54\x49\x4f\x4e\54\x20\12\40\x20\40\40\x20\40\x20\x20\40\x20\40\40\x20\40\x20\40\x20\x20\40\x20\40\40\x20\x20\40\x20\x20\40\x20\x20\40\x20\x57\x53\110\x5f\x50\x49\x43\x4b\x5f\x54\x49\x43\113\105\124\x5f\115\101\x4e\104\x41\x52\x4f\137\x56\x2e\104\x45\x4c\x49\126\x45\x52\131\x5f\x41\123\x53\x49\x47\x4e\115\x45\116\124\x5f\111\x44\x2c\40\xa\40\40\40\40\x20\40\40\40\x20\x20\x20\40\40\40\x20\40\x20\40\x20\x20\40\x20\x20\x20\40\x20\x20\40\x20\40\x20\40\x57\x53\110\x5f\120\x49\103\x4b\x5f\x54\111\103\x4b\105\x54\137\x4d\101\116\104\101\x52\x4f\137\126\56\122\x45\121\x55\105\123\x54\105\104\x5f\121\125\101\116\124\111\124\x59\54\x20\xa\x20\40\40\40\40\x20\x20\x20\x20\x20\40\40\x20\40\x20\x20\x20\x20\x20\x20\x20\40\40\x20\40\x20\x20\40\x20\x20\x20\x20\x57\123\x48\x5f\120\x49\103\113\137\124\111\103\x4b\105\124\x5f\x4d\101\x4e\x44\101\x52\x4f\x5f\x56\56\123\105\x47\115\x45\x4e\124\x31\x2c\x20\xa\x20\40\40\x20\x20\40\x20\40\x20\x20\40\x20\40\x20\40\x20\x20\40\x20\40\x20\x20\40\40\40\x20\40\40\x20\x20\x20\40\127\x53\x48\137\120\111\x43\113\x5f\124\111\103\x4b\105\124\x5f\115\101\116\x44\101\122\117\x5f\x56\56\117\122\x47\x2c\x20\xa\40\40\x20\40\40\x20\40\40\40\40\40\40\40\40\x20\x20\x20\x20\x20\x20\40\x20\x20\x20\40\40\40\x20\40\x20\x20\x20\x57\x53\110\137\120\x49\103\x4b\x5f\124\111\x43\113\x45\x54\137\115\101\116\x44\101\122\117\x5f\126\x2e\117\122\x47\101\116\x49\x5a\101\124\x49\117\116\x5f\111\104\x2c\x20\xa\40\40\x20\x20\x20\x20\40\x20\x20\40\x20\40\x20\x20\40\x20\x20\x20\40\x20\x20\40\40\x20\40\x20\x20\x20\x20\x20\x20\x20\127\x53\x48\x5f\120\x49\x43\113\137\x54\x49\103\113\105\124\137\115\101\116\104\x41\122\117\137\x56\x2e\122\x45\x51\125\105\123\124\105\104\x5f\x51\x55\101\116\124\x49\x54\131\137\x55\x4f\x4d\54\40\12\x20\x20\x20\40\x20\40\40\40\x20\x20\x20\40\x20\x20\x20\x20\40\40\40\40\40\x20\40\x20\x20\40\x20\x20\40\40\x20\40\x57\x53\110\x5f\120\111\x43\113\x5f\x54\x49\x43\113\105\124\137\x4d\x41\116\x44\101\x52\x4f\137\x56\x2e\x42\x4f\x58\x5f\121\x54\x59\x2c\40\12\40\40\x20\x20\x20\x20\x20\40\40\40\40\x20\x20\x20\x20\40\x20\x20\40\x20\40\40\40\x20\40\40\40\x20\40\40\40\40\127\x53\110\137\x50\x49\x43\x4b\x5f\124\111\x43\113\x45\124\137\x4d\101\x4e\104\101\x52\x4f\x5f\126\x2e\116\127\54\40\xa\40\40\x20\40\x20\40\x20\x20\x20\40\x20\x20\40\x20\40\40\40\40\40\x20\x20\40\40\40\40\40\x20\x20\x20\40\x20\40\127\123\110\x5f\x50\111\x43\x4b\x5f\124\111\103\113\x45\124\x5f\115\x41\x4e\104\x41\x52\117\137\126\x2e\x47\127\x2c\x20\xa\40\x20\40\40\x20\40\x20\40\x20\x20\40\40\40\40\40\40\40\x20\x20\40\40\40\40\x20\x20\x20\x20\x20\40\x20\40\40\x57\123\x48\x5f\120\x49\103\x4b\x5f\124\111\103\113\x45\x54\137\115\101\116\104\101\122\117\137\126\x2e\x43\102\x4d\54\x20\xa\x20\40\x20\x20\x20\x20\x20\x20\x20\x20\x20\40\40\40\40\40\x20\40\x20\x20\x20\x20\40\40\x20\40\x20\x20\x20\40\40\40\x57\123\x48\x5f\120\111\103\113\x5f\124\x49\x43\x4b\105\x54\137\x4d\x41\x4e\x44\101\122\117\137\126\56\123\x43\x48\105\104\125\x4c\105\x5f\123\x48\111\120\x5f\x44\x41\124\105\x2c\x20\12\40\x20\x20\40\x20\40\x20\40\x20\40\x20\40\40\x20\40\40\x20\x20\40\40\40\x20\x20\40\x20\40\40\x20\x20\x20\40\40\x57\x53\x48\x5f\120\x49\103\x4b\x5f\x54\x49\103\x4b\x45\124\137\115\x41\x4e\104\101\x52\x4f\x5f\x56\x2e\x53\x4f\125\x52\103\105\x5f\x4c\x49\116\x45\137\x49\104\54\x20\xa\x20\x20\x20\x20\40\x20\40\x20\40\x20\40\x20\x20\40\x20\40\40\x20\40\40\x20\x20\x20\x20\40\x20\40\40\40\x20\x20\x20\x57\123\x48\x5f\120\111\103\x4b\x5f\x54\x49\x43\113\105\x54\137\115\x41\116\x44\101\x52\x4f\137\126\x2e\124\122\x41\103\113\111\x4e\x47\137\x4e\x55\115\x42\105\122\54\x20\12\40\40\x20\x20\x20\x20\40\40\40\x20\40\40\x20\40\40\40\x20\x20\40\x20\40\40\x20\40\40\x20\40\40\x20\40\x20\x20\x57\123\x48\137\120\x49\103\113\137\x54\111\x43\x4b\105\124\x5f\115\x41\116\104\101\x52\x4f\x5f\126\56\123\105\x41\x4c\x5f\x43\x4f\104\x45\54\40\xa\x20\x20\40\40\x20\40\40\x20\40\40\40\x20\40\40\40\x20\40\40\40\x20\x20\40\x20\40\x20\x20\40\x20\40\x20\x20\x20\x57\x53\x48\x5f\120\x49\103\x4b\x5f\124\x49\103\x4b\105\x54\137\115\101\116\104\101\x52\x4f\137\x56\56\x43\x55\123\124\137\x50\117\137\x4e\125\x4d\x42\x45\x52\54\x20\12\x20\40\40\x20\x20\x20\x20\x20\40\40\x20\x20\x20\x20\40\40\x20\40\x20\x20\x20\40\40\x20\40\x20\40\x20\40\40\x20\40\127\x53\110\137\x50\111\103\x4b\137\124\111\x43\113\x45\x54\x5f\x4d\101\116\104\101\x52\x4f\x5f\x56\56\x43\125\x53\124\117\115\x45\x52\137\x4e\x41\x4d\105\x2c\40\12\40\40\x20\40\40\40\40\x20\40\40\40\40\40\x20\x20\40\x20\40\40\40\x20\40\40\40\40\x20\x20\40\40\x20\40\40\x57\x53\110\x5f\x50\111\x43\113\x5f\124\x49\103\x4b\x45\124\137\115\x41\116\104\101\x52\x4f\x5f\x56\x2e\101\124\x54\122\111\102\x55\x54\105\x37\54\x20\xa\x20\x20\40\40\40\40\40\x20\40\x20\40\x20\x20\40\40\40\40\40\x20\x20\40\40\x20\40\x20\40\x20\x20\40\x20\x20\x20\127\123\110\x5f\120\x49\x43\113\137\124\x49\103\x4b\105\124\137\x4d\101\116\x44\x41\x52\117\x5f\126\x2e\x41\x54\x54\x52\111\x42\x55\x54\105\x33\54\x20\xa\40\x20\40\40\40\40\x20\40\x20\x20\40\x20\40\x20\40\x20\x20\x20\x20\40\x20\x20\40\x20\x20\40\x20\x20\x20\x20\40\x20\x57\123\x48\x5f\120\x49\x43\x4b\137\124\x49\x43\x4b\105\x54\137\115\101\x4e\x44\x41\122\x4f\x5f\126\x2e\117\x52\x44\x45\x52\137\116\125\115\102\x45\x52\54\40\12\40\x20\40\x20\x20\40\40\40\40\40\x20\40\x20\x20\x20\x20\40\x20\40\x20\x20\40\40\x20\40\x20\x20\40\40\x20\40\x20\x57\123\110\x5f\120\111\x43\113\x5f\124\111\x43\x4b\105\x54\137\115\x41\x4e\x44\101\x52\117\137\126\56\112\117\x42\137\116\x41\115\x45\x20\12\x20\40\40\x20\x20\x20\x20\40\x20\x20\40\40\x20\40\40\40\40\x20\40\x20\x20\x20\40\40\40\40\x20\40\40\x20\x20\x20\x46\x52\x4f\115\x20\x50\x48\117\x4d\56\127\x53\110\x5f\x50\111\103\113\137\124\111\x43\113\105\124\x5f\115\x41\116\x44\x41\122\x4f\x5f\126\x20\xa\x20\x20\x20\40\40\40\40\x20\40\40\40\40\40\40\x20\40\x20\40\x20\x20\40\x20\x20\40\40\x20\x20\40\127\x48\105\122\105\40\x20\xa\40\x20\40\x20\x20\x20\x20\x20\40\40\40\x20\x20\40\40\40\x20\40\x20\x20\40\x20\40\40\40\40\x20\x20\40\40\x20\x20\x20\x20\40\x20\x57\123\x48\x5f\x50\x49\x43\x4b\x5f\124\111\103\113\105\124\137\115\x41\116\104\101\122\117\x5f\126\56\x4e\x41\115\105\40\40\x20\x4c\111\x4b\105\40\x27" . $id . "\45\47"); oci_execute($stid); while ($row = oci_fetch_array($stid, OCI_ASSOC + OCI_RETURN_NULLS)) { $DeliveryId = $func->mssql_escape_string($row["\x44\x45\x4c\111\x56\x45\x52\131\137\x49\x44"]); $InventoryItemId = $func->mssql_escape_string($row["\x49\116\x56\x45\x4e\x54\x4f\122\x59\137\x49\124\105\x4d\x5f\x49\x44"]); $DeliveryName = $func->mssql_escape_string($row["\116\x41\115\x45"]); $ItemDescription = $func->mssql_escape_string($row["\x49\124\x45\115\137\x44\105\123\103\122\111\120\x54\111\x4f\116"]); $DeliveryAssignmentId = $func->mssql_escape_string($row["\104\105\x4c\x49\126\x45\x52\131\137\101\x53\123\111\107\x4e\x4d\x45\116\124\137\111\x44"]); $DeliveryDetailId = $func->mssql_escape_string($row["\104\105\x4c\x49\126\x45\122\x59\137\104\x45\x54\101\111\114\137\x49\x44"]); $RequestedQuantity = $func->mssql_escape_string($row["\x52\x45\121\x55\105\123\124\x45\104\x5f\x51\x55\x41\x4e\124\x49\x54\x59"]); $Item = $func->mssql_escape_string($row["\123\x45\107\115\105\x4e\124\61"]); $OrganizationId = $func->mssql_escape_string($row["\x4f\x52\107\x41\116\111\132\x41\x54\111\117\116\137\x49\104"]); $UnitOfMeasure = $func->mssql_escape_string($row["\122\105\x51\125\105\x53\124\x45\104\137\121\x55\x41\x4e\x54\x49\124\x59\x5f\125\x4f\x4d"]); $BoxQuantity = $func->mssql_escape_string($row["\102\x4f\130\137\x51\x54\131"]); $NetWeight = $func->mssql_escape_string($row["\116\x57"]); $GrossWeight = $func->mssql_escape_string($row["\x47\x57"]); $CBM = $func->mssql_escape_string($row["\x43\102\x4d"]); $ScheduleShipDate = $func->mssql_escape_string($row["\x53\103\x48\x45\104\x55\x4c\105\137\123\110\x49\120\x5f\x44\x41\x54\105"]); $SourceLineId = $func->mssql_escape_string($row["\x53\x4f\x55\122\103\105\x5f\x4c\111\116\x45\x5f\111\104"]); $TrackingNumber = $func->mssql_escape_string($row["\x54\122\x41\x43\113\x49\116\107\137\x4e\125\115\x42\x45\122"]); $SealCode = $func->mssql_escape_string($row["\123\x45\x41\114\x5f\103\x4f\x44\x45"]); $CustomerOrderNumber = $func->mssql_escape_string($row["\x43\x55\x53\x54\x5f\x50\117\x5f\x4e\x55\115\102\105\122"]); $Attribute7 = $func->mssql_escape_string($row["\x41\124\124\122\x49\102\x55\x54\105\x37"]); $Attribute3 = $func->mssql_escape_string($row["\101\124\124\x52\111\102\x55\x54\105\63"]); $OrderNumber = $func->mssql_escape_string($row["\x4f\122\104\105\x52\137\x4e\125\115\x42\x45\122"]); $JobName = $func->mssql_escape_string($row["\x4a\x4f\102\137\x4e\x41\x4d\x45"]); $CustomerName = $func->mssql_escape_string($row["\x43\x55\x53\x54\x4f\115\105\122\x5f\116\101\x4d\x45"]); $mysql = "\x49\x4e\123\x45\122\x54\x20\111\116\x54\117\40\x57\110\123\x2e\x44\x65\x6c\x69\x76\x65\x72\x69\145\163\x20\x28\12\x20\40\40\x20\40\40\40\40\x20\x20\40\x20\x20\40\x20\x20\x20\x20\x20\x20\40\x20\40\x20\40\x20\40\x20\x20\40\40\x20\40\x20\x20\x20\104\145\x6c\x69\x76\145\162\171\111\x64\12\x20\x20\40\x20\40\40\40\x20\x20\x20\x20\40\40\40\40\x20\40\40\40\40\x20\40\40\x20\40\40\x20\40\x20\x20\x20\40\x20\x20\x20\54\x49\x6e\166\x65\156\164\157\x72\171\111\x74\x65\155\x49\x64\xa\x20\40\x20\x20\40\x20\x20\40\40\40\40\x20\x20\40\x20\x20\40\40\40\40\x20\40\x20\x20\x20\40\x20\40\40\40\40\40\40\x20\40\54\x44\145\154\x69\166\145\162\171\116\x61\155\145\xa\x20\x20\x20\x20\x20\x20\40\x20\40\x20\40\40\x20\40\40\40\x20\40\x20\40\x20\x20\x20\x20\40\40\40\40\x20\40\x20\x20\x20\x20\x20\54\x49\164\145\x6d\x44\x65\x73\143\x72\x69\x70\164\151\x6f\156\xa\40\x20\x20\x20\40\x20\40\40\x20\40\40\x20\40\40\x20\40\40\40\40\x20\40\40\40\40\x20\x20\x20\40\40\x20\40\x20\40\x20\40\x2c\104\145\x6c\x69\x76\x65\162\x79\x41\163\163\x69\x67\x6e\x6d\x65\156\164\111\144\12\40\x20\40\x20\x20\x20\40\40\40\x20\40\40\x20\x20\40\40\x20\40\40\40\x20\x20\40\x20\40\40\40\40\x20\40\40\40\40\x20\x20\54\x44\x65\x6c\x69\166\x65\x72\171\104\145\164\x61\151\x6c\111\144\xa\40\x20\x20\40\x20\40\40\40\40\x20\x20\40\x20\x20\40\40\40\x20\40\40\40\x20\x20\40\x20\x20\x20\40\x20\40\x20\40\x20\40\x20\x2c\122\145\161\165\145\163\x74\x65\x64\x51\x75\x61\x6e\164\x69\x74\x79\12\x20\40\40\40\40\40\40\40\40\x20\x20\40\40\x20\x20\40\x20\40\x20\x20\40\40\x20\40\40\x20\40\40\40\x20\x20\x20\40\x20\40\54\111\x74\x65\155\xa\40\40\x20\x20\40\x20\x20\40\40\x20\x20\x20\40\x20\x20\40\x20\x20\40\40\x20\x20\x20\x20\40\x20\x20\40\x20\40\x20\40\x20\40\40\x2c\117\162\147\141\x6e\151\x7a\141\x74\x69\x6f\x6e\111\x64\12\40\x20\x20\x20\40\40\40\40\x20\40\x20\40\40\40\40\40\40\x20\x20\40\x20\x20\x20\x20\40\40\40\40\40\40\x20\40\x20\40\x20\54\x55\156\151\x74\x4f\146\115\145\141\x73\165\162\x65\xa\x20\40\x20\x20\x20\40\x20\40\40\x20\x20\x20\40\40\x20\40\x20\40\x20\x20\x20\40\x20\40\x20\40\40\x20\x20\x20\x20\40\x20\x20\x20\54\102\157\x78\121\x75\x61\156\x74\x69\164\171\xa\x20\x20\x20\x20\40\x20\40\40\x20\40\x20\40\40\x20\40\x20\x20\40\x20\x20\x20\40\x20\40\x20\40\x20\x20\40\40\x20\x20\40\40\x20\54\116\x65\x74\x57\x65\151\x67\150\x74\xa\x20\x20\x20\x20\40\40\40\x20\x20\x20\40\x20\40\x20\40\40\x20\x20\x20\40\40\40\x20\40\40\x20\40\40\40\40\x20\x20\40\40\x20\54\x47\162\x6f\x73\163\x57\145\151\x67\150\x74\xa\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\40\x20\x20\x20\x20\x20\x20\40\x20\40\x20\40\x20\40\x20\40\x20\x20\40\x20\40\x20\x20\40\40\x2c\103\102\x4d\xa\40\x20\40\x20\40\40\x20\x20\x20\x20\x20\x20\40\40\x20\40\x20\x20\40\40\x20\x20\x20\40\x20\x20\40\x20\40\40\40\x20\40\x20\x20\x2c\x53\x63\150\145\144\x75\154\145\x53\x68\x69\x70\104\x61\164\145\xa\40\x20\40\40\40\40\40\40\x20\40\x20\x20\x20\40\40\x20\40\x20\40\x20\x20\40\40\40\40\40\x20\x20\x20\40\40\x20\x20\40\x20\54\x53\x6f\165\x72\143\145\114\x69\156\145\x49\x64\xa\40\40\40\40\40\40\40\40\x20\x20\40\40\x20\x20\x20\x20\x20\40\40\40\x20\40\x20\40\40\x20\x20\40\x20\x20\x20\x20\x20\40\x20\x2c\x54\162\x61\x63\x6b\x69\156\x67\x4e\165\155\142\x65\x72\12\x20\x20\40\40\40\x20\40\40\x20\x20\40\x20\x20\x20\40\x20\40\40\x20\40\40\x20\x20\x20\40\x20\40\40\40\x20\40\x20\x20\x20\x20\54\x53\x65\x61\154\x43\x6f\144\145\xa\x20\40\x20\40\x20\40\40\x20\x20\40\40\40\x20\40\40\x20\x20\x20\x20\40\x20\x20\x20\40\40\x20\x20\40\x20\40\x20\40\x20\40\40\x2c\103\165\x73\164\157\x6d\x65\162\x4f\x72\x64\145\162\116\x75\155\142\145\162\12\x20\x20\40\40\x20\40\x20\x20\x20\x20\40\40\40\40\40\x20\x20\x20\x20\x20\40\40\40\40\40\x20\40\40\x20\40\40\40\x20\40\40\x2c\x41\x74\164\162\151\x62\x75\164\x65\x37\xa\40\40\40\x20\x20\40\40\40\40\x20\x20\40\40\x20\40\x20\40\40\40\x20\x20\40\x20\x20\40\40\40\40\40\40\x20\40\40\40\40\x2c\x41\164\x74\162\x69\142\165\164\x65\x33\12\40\x20\x20\40\x20\x20\x20\40\x20\40\40\x20\40\x20\40\40\40\x20\x20\x20\x20\x20\40\x20\x20\x20\x20\x20\x20\40\40\x20\40\40\40\54\x4f\x72\144\145\x72\116\x75\155\x62\x65\x72\xa\x20\x20\x20\40\x20\40\x20\x20\40\x20\x20\40\40\40\40\40\40\40\x20\x20\40\x20\x20\x20\40\x20\40\40\x20\40\x20\40\x20\40\x20\54\x4a\157\x62\116\141\155\145\xa\40\40\x20\40\x20\40\40\40\40\40\x20\x20\x20\x20\40\x20\40\40\40\40\x20\40\40\40\x20\x20\40\x20\40\x20\40\40\40\x20\x20\54\x44\145\154\x69\166\x65\x72\171\x48\145\141\x64\x65\162\x49\144\xa\40\x20\x20\x20\x20\40\x20\x20\40\40\x20\x20\40\x20\x20\40\x20\x20\40\40\x20\x20\x20\x20\x20\x20\40\x20\x20\x20\x20\x20\40\x20\40\54\103\165\163\x74\157\155\x65\162\116\x61\155\145\xa\x20\x20\40\x20\x20\40\40\x20\40\40\40\x20\40\x20\x20\40\40\40\40\x20\x20\40\x20\x20\40\x20\x20\x20\40\40\x20\x20\x20\40\x20\51\xa\40\x20\40\40\x20\x20\x20\x20\x20\40\x20\40\40\x20\x20\x20\40\40\40\40\x20\40\40\x20\x20\40\40\x56\x41\x4c\x55\x45\123\x28\12\40\40\x20\x20\40\40\40\x20\x20\40\x20\40\40\x20\x20\40\40\x20\40\40\x20\x20\40\40\40\x20\40\x20\x20\x20\x20\40\x20\47" . $DeliveryId . "\x27\12\x20\x20\40\x20\x20\40\40\x20\40\40\x20\40\40\x20\40\x20\40\40\40\x20\40\x20\40\x20\x20\40\40\x20\x20\x20\40\54\116\x27" . $InventoryItemId . "\47\xa\40\40\40\40\40\40\x20\40\40\40\40\x20\40\x20\x20\x20\x20\x20\40\x20\x20\x20\40\x20\40\x20\40\40\40\x20\40\54\116\x27" . $DeliveryName . "\47\xa\40\40\40\40\40\40\40\x20\x20\x20\x20\x20\40\x20\40\x20\x20\x20\x20\40\40\x20\x20\40\x20\40\40\x20\40\40\40\54\116\47" . $ItemDescription . "\x27\12\40\40\x20\x20\x20\40\x20\x20\40\x20\x20\40\40\x20\40\40\40\40\40\40\40\x20\40\40\x20\40\40\40\40\x20\x20\54\116\47" . $DeliveryAssignmentId . "\x27\xa\40\x20\40\x20\x20\40\40\40\40\x20\40\x20\x20\40\40\40\x20\x20\40\40\x20\x20\x20\x20\40\x20\40\x20\40\40\40\54\116\47" . $DeliveryDetailId . "\x27\xa\40\x20\x20\x20\x20\40\40\x20\x20\40\40\x20\40\40\x20\40\x20\x20\x20\x20\40\x20\x20\x20\40\40\40\40\40\x20\x20\x2c\116\47" . $RequestedQuantity . "\x27\12\40\x20\x20\40\40\40\x20\x20\x20\40\40\x20\x20\40\40\40\40\x20\x20\x20\40\40\x20\x20\40\40\40\40\x20\40\40\x2c\x4e\x27" . $Item . "\x27\12\40\40\40\40\x20\40\40\40\40\40\40\x20\x20\x20\40\x20\x20\40\x20\x20\x20\40\x20\40\x20\40\x20\40\40\40\40\54\x4e\47" . $OrganizationId . "\47\xa\x20\40\40\x20\x20\40\x20\x20\40\x20\x20\x20\x20\x20\x20\x20\40\x20\x20\40\40\40\x20\x20\40\40\40\40\x20\40\x20\x2c\x4e\47" . $UnitOfMeasure . "\x27\12\40\x20\x20\x20\x20\x20\x20\x20\40\x20\40\x20\x20\x20\40\40\40\40\x20\x20\40\x20\x20\40\40\40\40\x20\x20\x20\40\54\116\47" . $BoxQuantity . "\x27\12\x20\x20\40\40\40\40\x20\x20\40\x20\x20\40\40\40\40\x20\40\x20\x20\40\40\40\x20\40\x20\40\x20\x20\x20\40\40\54\116\47" . $NetWeight . "\47\12\x20\x20\40\40\40\40\40\40\x20\40\40\x20\x20\x20\x20\x20\40\40\x20\x20\x20\40\40\x20\40\40\x20\x20\40\x20\40\x2c\x4e\47" . $GrossWeight . "\47\xa\40\40\x20\40\40\40\x20\40\40\x20\40\x20\40\x20\40\40\40\x20\40\40\x20\40\40\x20\x20\x20\40\x20\40\x20\40\x2c\116\x27" . $CBM . "\47\12\40\40\40\40\40\40\40\40\x20\40\x20\x20\x20\x20\x20\40\40\x20\x20\x20\40\x20\40\40\40\40\40\40\x20\x20\x20\54\x4e\47" . $ScheduleShipDate . "\47\12\x20\x20\40\x20\x20\x20\x20\x20\40\x20\x20\40\x20\x20\x20\40\x20\40\x20\40\x20\x20\40\x20\40\40\40\40\40\40\40\54\x4e\x27" . $SourceLineId . "\47\12\40\40\40\x20\x20\40\40\40\x20\40\40\x20\x20\40\40\40\x20\40\40\x20\40\40\x20\x20\40\40\x20\x20\40\x20\x20\x2c\116\x27" . $TrackingNumber . "\x27\xa\40\x20\x20\40\x20\40\x20\x20\x20\40\40\40\40\40\x20\x20\40\x20\40\40\x20\40\40\x20\40\x20\x20\40\40\x20\40\x2c\116\x27" . $SealCode . "\x27\12\40\40\x20\x20\x20\40\x20\x20\40\x20\x20\40\40\x20\x20\40\40\x20\40\40\x20\x20\40\40\40\x20\x20\x20\40\x20\x20\x2c\116\47" . $CustomerOrderNumber . "\x27\12\40\40\x20\40\x20\40\40\40\40\40\x20\40\40\x20\x20\40\x20\x20\x20\40\40\40\40\40\40\x20\40\x20\40\x20\x20\54\x4e\47" . $Attribute7 . "\47\xa\40\x20\40\40\x20\40\x20\40\x20\x20\40\40\x20\40\40\40\40\40\40\x20\40\x20\40\40\x20\40\40\x20\x20\40\40\54\x4e\47" . $Attribute3 . "\47\12\x20\40\x20\40\x20\x20\x20\x20\x20\x20\40\40\x20\x20\x20\x20\40\40\40\x20\40\40\40\x20\x20\x20\40\40\x20\40\x20\54\116\47" . $OrderNumber . "\47\xa\40\x20\x20\40\40\x20\x20\x20\40\40\x20\x20\x20\40\x20\x20\40\x20\40\x20\x20\x20\x20\40\40\40\x20\x20\40\40\40\x2c\116\x27" . $JobName . "\x27\xa\x20\x20\x20\40\40\40\x20\x20\x20\40\40\x20\40\40\40\40\40\x20\40\x20\40\x20\40\x20\x20\x20\40\x20\x20\x20\40\54\116\x27" . $headerid . "\47\xa\40\x20\40\40\x20\x20\40\x20\x20\40\x20\40\x20\x20\40\x20\40\x20\x20\x20\x20\x20\x20\x20\40\x20\40\x20\40\x20\40\54\x4e\47" . $CustomerName . "\47\xa\40\40\40\x20\x20\40\x20\x20\40\x20\40\40\40\x20\40\40\40\40\x20\x20\40\x20\x20\x20\40\x20\40\51"; $dbmy = static::getDBSQL(); $stmt1 = $dbmy->prepare($mysql); $stmt1->execute(); } echo "\x43\x6f\x6e\156\x65\143\164\40\163\x75\x63\143\x65\x73\x73\146\165\154\154\x79\x2e"; } else { echo "\x43\x61\x6e\156\157\164\x20\x63\157\x6e\156\x65\143\x74\40\x74\157\40\117\x72\141\143\x6c\x65\56"; } oci_close($con); } catch (\PDOException $e) { echo $e->getMessage(); } } public function updateHeader($id) { try { $user = User::findByID($_SESSION["\165\163\145\x72\137\151\144"]); $sql = "\125\120\104\101\124\x45\x20\127\110\123\56\111\x6e\x76\157\151\143\145\xa\40\x20\40\x20\x20\x20\x20\40\x20\40\40\x20\x20\x20\40\x20\x20\40\x20\x20\x53\x45\124\xa\x20\40\40\x20\x20\40\x20\x20\40\x20\40\40\40\x20\x20\x20\40\x20\x20\x20\40\x20\x20\x20\x20\x44\145\x6c\x69\166\x65\162\171\x4e\141\155\x65\40\75\x20\72\x44\145\x6c\151\x76\x65\162\171\116\x61\x6d\x65\12\x20\x20\40\x20\40\x20\40\x20\40\40\x20\40\40\40\x20\40\x20\40\x20\x20\x20\x20\40\40\x2c\117\162\x67\x61\x6e\x69\x7a\141\164\x69\x6f\156\x49\144\x20\x3d\x20\x3a\117\x72\147\x61\156\151\x7a\141\x74\x69\157\x6e\111\x64\xa\40\40\x20\x20\x20\40\40\x20\40\x20\40\x20\40\40\40\x20\40\40\40\x20\40\40\40\40\54\103\165\x73\164\x6f\155\x65\162\111\144\x20\x3d\40\x3a\x43\x75\x73\x74\x6f\155\145\x72\111\x64\xa\40\x20\x20\x20\x20\x20\x20\x20\x20\40\40\x20\40\40\40\40\x20\x20\x20\x20\x20\x20\40\x20\x2c\x49\156\x76\x6f\151\x63\145\104\141\x74\x65\x20\x3d\x20\72\x49\156\x76\x6f\x69\143\145\x44\x61\164\x65\12\40\40\40\x20\40\40\x20\x20\x20\x20\40\x20\40\40\40\40\x20\40\40\x20\40\x20\x20\40\x2c\104\x65\x70\x61\162\x74\x75\162\145\x20\x3d\40\72\x44\145\x70\141\x72\164\x75\162\145\12\40\40\40\x20\40\x20\x20\40\40\x20\x20\40\x20\x20\40\40\40\x20\40\x20\40\40\x20\x20\x2c\115\157\164\150\145\162\126\x65\x73\x73\x65\154\40\75\40\72\x4d\157\x74\150\145\162\x56\145\x73\163\145\x6c\12\40\40\x20\x20\x20\40\x20\40\40\40\40\40\40\x20\x20\40\x20\40\x20\x20\40\x20\x20\40\x2c\x43\x6f\x6e\156\145\x63\x74\151\x6e\x67\x56\x65\x73\x73\145\x6c\x20\75\40\x3a\103\x6f\156\156\x65\x63\164\x69\x6e\147\x56\145\163\163\145\x6c\12\x20\x20\40\x20\x20\x20\40\40\40\x20\x20\40\40\x20\x20\40\x20\x20\x20\40\x20\40\x20\x20\x2c\123\x68\151\x70\x70\151\156\x67\x4c\151\156\145\40\75\x20\x3a\x53\150\151\160\x70\151\156\x67\x4c\151\x6e\145\xa\40\x20\x20\40\40\x20\40\40\x20\x20\x20\x20\x20\x20\40\40\40\40\40\x20\x20\40\40\40\54\x46\x6f\162\167\x61\162\144\145\x72\x20\75\x20\x3a\x46\157\x72\167\141\162\x64\x65\x72\12\40\40\x20\x20\40\x20\40\40\x20\x20\40\x20\x20\40\40\x20\40\40\40\40\40\40\40\x20\x2c\x55\x70\x64\x61\164\x65\144\104\141\164\x65\x20\75\40\x47\145\164\x44\x61\164\145\x28\51\xa\x20\40\40\40\40\x20\x20\x20\40\40\40\x20\40\x20\x20\40\40\40\x20\40\x20\40\x20\x20\54\125\160\144\141\x74\x65\x64\x42\171\40\x3d\40\72\125\x70\x64\x61\164\145\x64\x42\x79\xa\40\x20\x20\40\40\x20\x20\x20\40\40\x20\40\40\x20\x20\x20\40\x20\x20\x20\x20\x20\40\x20\54\122\145\x6d\x61\162\x6b\x73\x20\75\x20\x3a\x52\145\155\141\x72\153\x73\12\x20\40\x20\x20\x20\x20\40\x20\40\x20\x20\40\40\x20\x20\x20\x20\x20\40\x20\40\x20\40\40\54\122\145\166\x69\163\x69\157\x6e\x20\75\40\x3a\122\145\166\151\163\151\x6f\156\xa\x20\40\x20\x20\40\40\x20\40\x20\40\40\40\x20\x20\40\40\x20\x20\40\40\x20\40\40\x20\54\120\x61\x6c\154\145\x74\x20\75\40\x3a\120\141\154\x6c\x65\x74\xa\40\x20\40\x20\x20\x20\40\40\40\x20\40\40\40\40\x20\x20\x20\x20\40\x20\40\x20\x20\x20\54\103\x6f\x6e\163\151\147\156\x65\x65\116\x61\x6d\145\x20\75\40\72\x43\x6f\x6e\163\x69\x67\156\x65\x65\116\x61\155\x65\xa\40\x20\40\40\40\x20\x20\40\40\40\40\x20\x20\x20\40\x20\x20\40\40\40\x20\x20\40\40\x2c\103\157\156\x73\x69\147\x6e\145\x65\101\x64\x64\162\x65\x73\163\40\75\40\72\103\157\156\x73\x69\147\x6e\x65\145\x41\x64\x64\x72\x65\x73\163\xa\x20\x20\40\x20\40\40\40\40\x20\40\x20\x20\x20\40\40\40\x20\40\x20\40\x57\x48\105\122\105\x20\x44\145\x6c\x69\166\x65\162\x79\x49\144\x20\75\x27" . $id . "\x27"; $db = static::getDBSQL(); $stmt = $db->prepare($sql); $stmt->bindValue("\x3a\104\145\x6c\x69\x76\x65\162\x79\x4e\141\155\x65", $this->DeliveryName, PDO::PARAM_INT); $stmt->bindValue("\x3a\117\x72\x67\141\156\x69\172\141\x74\x69\157\156\111\x64", $this->OrganizationId, PDO::PARAM_INT); $stmt->bindValue("\x3a\103\x75\x73\164\x6f\155\x65\162\111\144", $this->CustomerId, PDO::PARAM_INT); $stmt->bindValue("\x3a\111\156\166\157\x69\x63\145\x44\x61\x74\x65", $this->InvoiceDate == null ? null : $this->InvoiceDate, PDO::PARAM_STR); $stmt->bindValue("\x3a\x44\x65\160\x61\162\x74\x75\x72\145", $this->Departure == null ? null : $this->Departure, PDO::PARAM_STR); $stmt->bindValue("\x3a\x4d\x6f\164\150\x65\162\126\145\x73\x73\x65\154", $this->MotherVessel, PDO::PARAM_STR); $stmt->bindValue("\72\x43\157\x6e\156\145\x63\164\151\156\147\126\145\163\x73\145\154", $this->ConnectingVessel, PDO::PARAM_STR); $stmt->bindValue("\x3a\x53\150\151\x70\160\151\156\147\x4c\x69\156\x65", $this->ShippingLine, PDO::PARAM_STR); $stmt->bindValue("\x3a\x46\157\162\167\x61\162\144\x65\x72", $this->Forwarder, PDO::PARAM_STR); $stmt->bindValue("\72\x55\x70\144\141\164\x65\144\102\171", $user->id, PDO::PARAM_INT); $stmt->bindValue("\72\122\x65\x6d\141\x72\153\x73", $this->Remarks, PDO::PARAM_STR); $stmt->bindValue("\72\x52\x65\x76\x69\x73\x69\157\156", $this->Revision, PDO::PARAM_STR); $stmt->bindValue("\72\x50\x61\154\x6c\x65\x74", $this->Pallet, PDO::PARAM_STR); $stmt->bindValue("\72\x43\x6f\x6e\163\x69\x67\x6e\145\145\116\141\155\145", $this->ConsigneeName == NULL ? '' : $this->ConsigneeName, PDO::PARAM_STR); $stmt->bindValue("\x3a\x43\157\x6e\x73\x69\x67\x6e\145\145\101\x64\x64\x72\145\x73\163", $this->ConsigneeAddress == NULL ? '' : $this->ConsigneeAddress, PDO::PARAM_STR); return $stmt->execute(); } catch (\PDOException $e) { echo $e->getMessage(); } } public function updateItemDetail($id) { try { $user = User::findByID($_SESSION["\x75\163\x65\162\x5f\151\144"]); $sql = "\125\x50\x44\101\x54\105\40\x57\110\x53\x2e\104\145\x6c\151\166\145\162\151\x65\163\12\x20\40\40\x20\40\x20\x20\40\40\x20\x20\x20\40\x20\40\x20\x20\40\40\x20\x53\x45\x54\x20\xa\x20\40\40\40\x20\x20\40\x20\40\x20\40\40\x20\x20\40\x20\x20\x20\x20\40\55\55\40\40\111\x6e\166\x65\x6e\x74\157\x72\x79\x49\164\145\155\x49\144\x20\75\x20\x3a\111\x6e\166\x65\x6e\164\157\162\x79\111\164\x65\155\x49\144\12\x20\x20\x20\40\40\40\40\40\x20\x20\40\x20\x20\40\x20\x20\x20\x20\40\x20\40\104\145\x6c\x69\x76\145\162\171\116\x61\155\x65\40\x3d\x20\72\x44\145\x6c\x69\x76\145\x72\x79\116\x61\155\x65\xa\40\40\40\x20\x20\40\x20\x20\40\40\x20\40\x20\40\40\40\40\40\x20\40\x2c\111\156\x76\145\x6e\164\157\162\x79\x49\164\145\155\x49\x64\x20\75\40\72\x49\x6e\x76\145\x6e\164\x6f\162\171\111\164\x65\155\x49\x64\xa\40\x20\40\40\40\x20\40\40\x20\x20\40\x20\40\40\40\40\40\40\x20\40\x2c\x52\x65\161\165\145\x73\x74\145\x64\121\165\141\x6e\x74\151\x74\x79\40\x3d\40\72\122\x65\161\165\145\x73\164\145\x64\121\x75\x61\x6e\x74\x69\164\x79\xa\x20\x20\x20\40\x20\x20\40\40\x20\40\40\40\40\x20\x20\40\x20\x20\x20\x20\x2c\x55\156\151\x74\x4f\x66\115\x65\x61\163\x75\162\145\40\x3d\40\x3a\x55\156\151\164\x4f\146\115\x65\x61\163\165\x72\x65\12\x20\x20\x20\40\40\40\40\x20\x20\40\40\x20\40\x20\x20\40\x20\40\x20\x20\54\102\157\170\121\x75\141\156\x74\151\164\x79\40\75\x20\x3a\102\157\170\x51\165\141\x6e\x74\x69\x74\x79\40\12\40\x20\x20\40\x20\40\40\40\40\x20\40\x20\x20\40\40\x20\40\x20\x20\40\54\x4e\145\x74\127\x65\151\x67\x68\164\x20\x3d\40\72\x4e\145\164\127\145\x69\x67\150\164\xa\40\40\40\40\x20\40\40\40\x20\x20\40\x20\40\x20\40\40\40\x20\x20\40\x2c\107\x72\157\x73\x73\127\x65\x69\147\x68\164\40\x3d\x20\x3a\107\162\157\x73\x73\127\x65\151\147\x68\x74\xa\40\40\x20\x20\40\x20\40\40\x20\x20\40\40\x20\x20\x20\40\x20\x20\x20\40\x2c\x43\x42\115\40\x3d\x20\x3a\103\102\x4d\xa\x20\40\40\x20\40\x20\x20\x20\x20\x20\x20\40\40\x20\x20\x20\x20\x20\x20\40\127\110\105\x52\x45\x20\x49\x64\x20\x3d\40\x3a\151\144"; $db = static::getDBSQL(); $stmt = $db->prepare($sql); $stmt->bindValue("\x3a\x44\x65\x6c\151\166\145\x72\x79\x4e\x61\x6d\145", $this->DeliveryName, PDO::PARAM_INT); $stmt->bindValue("\x3a\111\x6e\x76\145\156\164\157\162\x79\x49\x74\x65\x6d\x49\x64", $this->InventoryItemId, PDO::PARAM_STR); $stmt->bindValue("\72\122\x65\x71\x75\x65\x73\x74\145\144\121\165\x61\156\164\151\164\171", $this->RequestedQuantity, PDO::PARAM_STR); $stmt->bindValue("\72\x55\x6e\x69\164\x4f\146\115\145\x61\x73\x75\x72\x65", $this->UnitOfMeasure, PDO::PARAM_STR); $stmt->bindValue("\72\x42\x6f\170\x51\165\x61\156\164\x69\x74\171", $this->BoxQuantity, PDO::PARAM_STR); $stmt->bindValue("\x3a\x4e\145\164\127\x65\151\147\x68\164", $this->NetWeight, PDO::PARAM_STR); $stmt->bindValue("\x3a\x47\x72\x6f\163\x73\x57\145\x69\x67\x68\164", $this->GrossWeight, PDO::PARAM_STR); $stmt->bindValue("\x3a\103\x42\x4d", $this->CBM, PDO::PARAM_INT); $stmt->bindValue("\72\151\144", $id, PDO::PARAM_INT); $stmt->execute(); } catch (\PDOException $e) { echo $e->getMessage(); } } private function headerOnUpdate() { try { $user = User::findByID($_SESSION["\165\x73\145\162\x5f\x69\x64"]); $id = $this->DeliveryName; $sql = "\125\120\104\x41\x54\x45\x20\x49\x4d\120\x2e\104\145\154\151\166\145\162\151\x65\163\xa\x20\x20\x20\40\x20\40\40\40\40\40\40\x20\40\40\x20\40\40\40\x20\x53\105\x54\xa\40\40\x20\40\40\40\40\x20\40\40\40\40\x20\x20\40\40\40\x20\40\x20\x20\x20\40\x20\125\x70\144\x61\164\145\x64\x44\x61\x74\145\40\75\x20\72\x55\160\x64\x61\164\145\x64\104\x61\164\x65\12\40\x20\40\x20\x20\40\x20\x20\x20\x20\x20\x20\x20\40\40\x20\x20\x20\40\40\x20\x20\x20\40\125\x70\x64\141\164\x65\x64\102\171\40\75\72\40\x55\160\x64\x61\164\x65\144\x42\x79\54\12\40\x20\40\40\x20\x20\40\x20\x20\40\x20\40\40\40\x20\40\40\40\x20\127\x48\105\122\x45\40\xa\40\40\40\40\x20\x20\x20\x20\x20\x20\x20\x20\40\x20\x20\40\x20\40\40\x20\x20\x20\x20\x20\x44\145\154\151\166\x65\162\x79\116\x61\155\x65\40\x3d\x27" . $id . "\x27"; $db = static::getDBSQL(); $stmt = $db->prepare($sql); $stmt->bindValue("\72\x55\160\x64\141\164\x65\x64\x44\141\x74\145", $this->UpdatedDate, PDO::PARAM_STR); $stmt->bindValue("\72\x55\x70\x64\x61\164\x65\144\102\x79", $user->id, PDO::PARAM_STR); $stmt->execute(); } catch (\PDOException $e) { echo $e->getMessage(); } } private function updateItems() { try { $id = $this->DeliveryName; $db = static::getOraDB(); $con = oci_connect(Config::ORA_USER, Config::ORA_PASSWORD, $db, "\101\x4c\63\x32\125\124\x46\x38"); $func = new foo(); if ($con) { $results = array(); $mysql = array(); $stid = oci_parse($con, "\x53\x45\114\105\103\124\40\52\40\40\106\x52\x4f\115\x20\120\x48\x4f\x4d\56\x53\x41\x4e\x56\x49\116\117\x20\40\127\110\x45\x52\x45\x20\x4e\101\x4d\105\40\x6c\x69\x6b\145\x20\47" . $id . "\47"); oci_execute($stid); while ($row = oci_fetch_array($stid, OCI_ASSOC + OCI_RETURN_NULLS)) { $sql = "\x73\145\x6c\x65\x63\164\40\111\104\137\111\124\x45\x4d\54\x20\111\104\137\x50\x52\x4f\107\122\101\115\101\40\x66\x72\x6f\155\40\x42\137\120\x52\117\107\x52\x41\115\x41\x5f\x45\x56\x41\x4c\125\x41\103\111\117\116\x5f\102\x49\x50\123\x20\127\x48\105\x52\x45\40\111\104\137\x49\124\x45\x4d\x3d" . $row["\111\x44\x5f\x49\x54\x45\x4d"] . "\x20\101\x4e\x44\40\x49\x44\137\120\x52\x4f\107\x52\x41\x4d\x41\x3d" . $row["\x49\104\137\120\x52\117\x47\122\101\x4d\x41"]; $stmt = $db->prepare($sql); $stmt->execute(); $result = $stmt->fetchAll(PDO::FETCH_OBJ); $DeliveryId = $func->mssql_escape_string($row["\x44\x45\114\x49\x56\105\x52\131\x5f\111\x44"]); $InventoryItemId = $func->mssql_escape_string($row["\111\116\126\x45\x4e\x54\x4f\x52\131\137\111\x54\x45\115\137\111\x44"]); $DeliveryName = $func->mssql_escape_string($row["\x4e\x41\115\105"]); $ItemDescription = $func->mssql_escape_string($row["\x49\x54\105\x4d\137\x44\x45\x53\103\x52\x49\120\x54\111\x4f\x4e"]); $DeliveryAssignmentId = $func->mssql_escape_string($row["\104\x45\114\x49\126\105\122\x59\x5f\x41\x53\x53\111\107\x4e\115\x45\116\124\x5f\111\104"]); $DeliveryDetailId = $func->mssql_escape_string($row["\104\x45\114\x49\126\105\x52\131\x5f\x44\x45\x54\101\x49\x4c\x5f\x49\104"]); $RequestedQuantity = $func->mssql_escape_string($row["\x52\105\x51\x55\x45\123\x54\x45\104\x5f\x51\125\101\x4e\124\x49\x54\x59"]); $Item = $func->mssql_escape_string($row["\123\x45\x47\x4d\105\116\124\x31"]); $OrganizationId = $func->mssql_escape_string($row["\x4f\122\x47\101\116\111\132\x41\124\111\117\x4e\137\x49\x44"]); $UnitOfMeasure = $func->mssql_escape_string($row["\x52\x45\x51\125\105\123\x54\x45\x44\x5f\121\125\101\116\x54\x49\x54\x59\x5f\125\117\115"]); $BoxQuantity = $func->mssql_escape_string($row["\x42\x4f\130\x5f\x51\124\131"]); $NetWeight = $func->mssql_escape_string($row["\116\127"]); $GrossWeight = $func->mssql_escape_string($row["\107\127"]); $CBM = $func->mssql_escape_string($row["\103\102\115"]); $ScheduleShipDate = $func->mssql_escape_string($row["\x53\103\110\105\104\x55\x4c\x45\x5f\123\110\111\x50\x5f\104\101\124\x45"]); $SourceLineId = $func->mssql_escape_string($row["\x53\117\125\x52\x43\x45\x5f\114\x49\x4e\105\137\x49\104"]); $TrackingNumber = $func->mssql_escape_string($row["\x54\x52\x41\x43\113\111\x4e\x47\x5f\116\x55\x4d\x42\105\122"]); $SealCode = $func->mssql_escape_string($row["\x53\105\101\x4c\x5f\103\117\104\x45"]); $CustomerOrderNumber = $func->mssql_escape_string($row["\x43\x55\123\124\x5f\120\117\137\x4e\x55\115\102\105\x52"]); $Attribute7 = $func->mssql_escape_string($row["\x41\124\x54\x52\x49\x42\125\124\x45\x37"]); $Attribute3 = $func->mssql_escape_string($row["\x41\124\x54\122\111\102\125\x54\105\63"]); $OrderNumber = $func->mssql_escape_string($row["\117\x52\104\x45\x52\137\116\125\x4d\x42\105\122"]); $JobName = $func->mssql_escape_string($row["\112\x4f\x42\x5f\116\101\115\105"]); if ($rows["\104\145\154\x69\166\x65\162\x79\x4e\x61\155\145"] == $row["\104\x65\x6c\151\166\145\162\x79\x4e\141\155\x65"] && $rows["\117\162\x67\141\x6e\x69\172\x61\164\151\157\x6e\x49\x64"] == $row["\x4f\162\x67\141\156\151\172\141\164\151\157\156\x49\144"]) { $sql = "\125\120\x44\x41\x54\x45\40\x42\x5f\x50\x52\117\107\122\x41\115\x41\x5f\105\126\101\x4c\x55\101\103\x49\117\x4e\137\102\111\x50\123\40\123\105\x54\40\111\104\x5f\x50\x52\x4f\107\x52\101\115\101\x3d\x27" . $row["\111\104\x5f\120\x52\117\x47\122\101\115\x41"] . "\x27\x2c\40\101\116\x4f\75\47" . $row["\101\x4e\117"] . "\47\x2c\x20\103\x4f\x50\x49\101\75\x27" . $row["\x43\x4f\x50\111\x41"] . "\x27\54\40\x54\x49\x50\x4f\137\120\122\x4f\x47\x52\x41\x4d\101\137\105\122\75\x27" . $row["\124\x49\120\117\x5f\120\122\117\107\x52\101\115\x41\x5f\x45\122"] . "\x27\54\40\x45\126\101\114\125\101\103\x49\x4f\116\x3d\47" . mysqli_real_escape_string($db, $row["\x45\126\101\114\x55\x41\103\x49\117\116"]) . "\x27\54\x20\111\104\x5f\x43\x41\x52\101\103\x54\105\122\111\x43\101\103\111\117\x4e\x3d\x27" . $row["\111\104\x5f\103\x41\122\x41\x43\124\x45\x52\x49\x43\x41\x43\111\x4f\116"] . "\47\54\12\40\40\40\40\x20\40\40\x20\x20\x20\40\x20\x20\x20\x20\40\40\x20\x20\x20\x20\40\40\x20\x20\x20\40\40\x20\x20\x20\x20\40\x20\x20\x20\x20\x4e\117\124\x41\x3d\47" . $row["\116\117\x54\101"] . "\47\40\x57\110\x45\122\x45\40\x49\x44\x5f\111\x54\x45\115\75" . $row["\111\104\x5f\111\124\105\115"]; $mysql = "\151\x6e\x73\x65\162\164\x20\151\x6e\164\x6f\40\x64\x62\x6f\56\104\145\154\x69\x76\x65\162\171\x44\145\164\141\151\154\x20\x28\12\x20\x20\x20\x20\40\40\x20\40\40\x20\x20\x20\x20\40\x20\x20\40\x20\x20\40\40\x20\40\40\x20\x20\40\40\40\40\x20\x20\x20\40\x20\40\40\x20\40\x20\104\145\x6c\151\166\145\x72\171\111\144\12\40\x20\x20\x20\x20\40\40\40\40\x20\x20\x20\x20\x20\40\40\40\x20\40\40\x20\40\40\x20\x20\x20\40\40\x20\x20\x20\x20\40\40\40\x20\x20\40\40\x2c\111\x6e\166\145\156\x74\157\162\x79\111\x74\x65\155\111\x64\12\x20\x20\x20\x20\x20\x20\40\x20\40\40\40\40\40\x20\x20\40\40\40\40\40\x20\x20\x20\x20\40\40\x20\x20\40\40\x20\40\40\40\40\x20\40\40\x20\54\104\x65\154\x69\x76\145\x72\171\116\x61\x6d\145\12\x20\x20\x20\40\x20\x20\40\40\40\40\x20\40\x20\x20\40\40\x20\40\x20\x20\40\40\x20\x20\40\x20\40\40\40\x20\40\40\x20\40\x20\40\40\x20\40\x2c\111\164\x65\155\x44\145\163\x63\x72\151\x70\164\x69\157\156\12\40\40\x20\x20\40\40\40\40\40\x20\40\40\40\40\x20\x20\40\x20\40\x20\40\x20\x20\x20\40\x20\x20\x20\x20\x20\x20\40\x20\x20\40\40\x20\x20\x20\54\104\145\154\151\166\x65\162\171\x41\x73\163\151\147\156\155\x65\x6e\x74\111\144\12\40\x20\x20\x20\x20\x20\x20\x20\40\x20\x20\x20\40\40\x20\x20\x20\40\x20\x20\40\40\x20\x20\x20\40\x20\40\40\x20\40\x20\40\40\40\40\x20\x20\40\54\104\145\154\x69\x76\x65\x72\171\x44\x65\164\141\151\154\x49\x64\12\x20\x20\x20\40\40\40\40\x20\x20\40\x20\40\x20\x20\x20\40\x20\x20\x20\x20\x20\40\x20\40\40\x20\x20\x20\40\40\x20\x20\x20\40\40\x20\40\40\40\54\122\145\x71\165\145\x73\164\x65\x64\x51\165\141\x6e\164\151\x74\171\12\x20\40\x20\40\x20\x20\x20\40\40\40\x20\40\40\40\x20\x20\40\40\40\40\40\40\40\40\40\40\x20\x20\40\40\40\40\40\40\x20\40\40\x20\40\54\111\164\x65\x6d\xa\x20\40\40\40\40\x20\x20\40\x20\x20\40\40\40\x20\x20\x20\x20\40\x20\x20\40\40\40\40\40\40\x20\40\x20\x20\40\x20\40\40\40\x20\x20\x20\40\x2c\x4f\162\147\141\x6e\x69\172\x61\x74\151\157\x6e\x49\144\xa\40\40\x20\x20\40\40\40\40\x20\40\40\40\x20\x20\x20\x20\x20\40\x20\x20\x20\40\40\40\40\x20\x20\40\x20\40\40\40\40\x20\x20\40\x20\40\x20\54\125\156\x69\x74\117\x66\115\x65\x61\x73\165\162\x65\xa\40\40\40\40\40\40\x20\40\x20\40\40\x20\x20\40\x20\x20\40\x20\x20\x20\40\40\40\x20\x20\40\40\x20\40\40\x20\x20\40\x20\x20\40\40\x20\40\54\x42\x6f\170\x51\x75\141\156\x74\151\x74\x79\12\40\x20\x20\x20\40\x20\x20\x20\x20\x20\x20\40\40\40\x20\40\x20\x20\x20\x20\x20\x20\x20\40\x20\40\40\x20\x20\40\40\40\40\x20\40\x20\40\x20\40\54\x4e\145\164\x57\145\151\147\x68\x74\xa\x20\40\40\40\40\x20\x20\x20\40\x20\x20\40\40\x20\x20\x20\x20\40\x20\40\40\x20\x20\40\x20\40\40\x20\x20\x20\x20\40\40\x20\40\40\40\x20\40\x2c\x47\162\157\163\163\127\145\x69\147\150\x74\12\x20\x20\40\40\x20\40\40\x20\x20\40\x20\40\40\40\x20\x20\x20\x20\x20\40\40\x20\40\40\40\40\40\x20\x20\40\x20\x20\40\40\40\x20\40\x20\40\x2c\103\x42\x4d\12\x20\x20\x20\40\40\x20\x20\x20\x20\40\40\40\x20\40\40\40\40\40\x20\40\x20\40\40\x20\40\x20\40\40\x20\x20\x20\x20\40\x20\x20\40\40\40\x20\54\123\x63\x68\x65\144\165\154\x65\x53\x68\151\x70\x44\141\x74\x65\12\x20\40\40\x20\40\40\40\40\x20\40\40\40\40\x20\40\x20\x20\40\40\x20\x20\40\x20\x20\x20\x20\x20\40\40\x20\x20\40\x20\40\40\x20\x20\40\x20\54\x53\x6f\x75\162\x63\145\x4c\151\x6e\x65\x49\144\12\40\40\40\x20\40\40\40\x20\40\40\40\40\x20\40\40\x20\40\x20\40\40\x20\40\40\40\40\x20\40\x20\40\x20\40\x20\40\x20\40\x20\40\x20\x20\54\124\162\x61\143\x6b\151\x6e\147\x4e\165\x6d\142\x65\x72\xa\x20\x20\x20\x20\x20\x20\x20\40\x20\x20\x20\x20\40\40\x20\x20\40\40\x20\x20\40\x20\40\x20\x20\40\x20\40\x20\x20\x20\x20\40\x20\x20\40\x20\x20\40\x2c\x53\x65\x61\x6c\x43\x6f\144\x65\12\40\x20\40\40\x20\40\40\x20\x20\x20\x20\x20\x20\x20\40\40\x20\x20\x20\40\x20\40\40\40\x20\x20\40\x20\x20\x20\x20\40\x20\40\40\40\40\40\x20\x2c\103\165\x73\164\x6f\155\145\x72\117\x72\144\x65\162\x4e\165\155\142\x65\x72\xa\x20\40\40\x20\x20\40\x20\x20\x20\x20\40\40\40\x20\x20\40\40\x20\40\40\40\x20\x20\x20\x20\x20\x20\40\x20\40\x20\40\x20\40\40\x20\x20\x20\x20\x2c\x41\x74\164\162\151\x62\x75\164\145\67\xa\x20\40\40\x20\40\x20\40\40\x20\40\x20\40\x20\40\x20\x20\40\x20\40\x20\40\x20\40\x20\x20\40\x20\40\x20\40\40\x20\40\x20\40\x20\x20\40\x20\54\x41\164\x74\162\x69\x62\165\x74\145\63\xa\40\x20\40\40\40\40\x20\x20\x20\x20\x20\x20\40\x20\40\40\x20\40\x20\x20\x20\x20\x20\x20\x20\x20\x20\40\x20\40\40\x20\x20\40\40\40\x20\40\x20\54\x4f\162\144\x65\x72\116\165\x6d\142\145\x72\xa\40\40\40\40\40\x20\x20\x20\x20\x20\x20\40\40\x20\x20\40\40\40\40\x20\40\40\x20\x20\x20\40\x20\x20\40\40\40\x20\x20\x20\40\x20\40\40\40\54\x4a\x6f\142\x4e\x61\x6d\145\xa\x20\40\40\x20\x20\x20\40\40\x20\40\x20\x20\40\40\40\x20\40\40\x20\40\40\x20\40\40\x20\x20\x20\x20\40\x20\40\x20\40\x20\40\40\40\x20\x20\51\xa\x20\40\x20\x20\40\40\40\40\40\40\x20\40\40\x20\40\40\x20\40\x20\x20\40\40\40\x20\40\40\40\40\40\40\x20\126\x41\114\125\x45\x53\50\xa\x20\x20\x20\40\x20\40\x20\40\x20\x20\40\x20\40\x20\x20\40\x20\40\40\x20\x20\x20\x20\x20\40\40\40\40\40\40\40\x20\40\x20\40\40\40\x27" . $DeliveryId . "\47\12\40\40\40\x20\40\40\40\40\x20\40\40\x20\x20\40\40\40\40\x20\40\40\x20\40\x20\40\40\x20\x20\40\x20\40\40\x20\x20\x20\x20\54\x4e\47" . $InventoryItemId . "\x27\12\40\x20\x20\x20\x20\40\x20\40\x20\x20\x20\40\40\x20\x20\40\40\x20\x20\40\40\x20\x20\40\x20\40\40\40\40\40\40\40\x20\40\40\x2c\116\x27" . $DeliveryName . "\47\xa\x20\x20\x20\x20\40\x20\40\x20\40\x20\x20\40\x20\x20\x20\x20\40\40\40\x20\40\40\40\x20\x20\x20\x20\x20\40\40\40\40\40\x20\40\54\116\x27" . $ItemDescription . "\47\xa\40\x20\40\x20\40\40\40\x20\x20\x20\40\40\x20\x20\40\40\40\40\x20\40\40\40\40\40\40\40\x20\x20\x20\40\40\x20\x20\40\x20\54\116\x27" . $DeliveryAssignmentId . "\47\xa\x20\x20\x20\40\40\40\40\40\x20\40\x20\x20\40\40\40\40\x20\40\x20\40\x20\40\40\40\40\x20\x20\40\x20\40\40\x20\x20\40\40\x2c\x4e\x27" . $DeliveryDetailId . "\x27\xa\x20\40\40\40\40\x20\40\40\x20\x20\40\x20\40\x20\x20\40\x20\x20\40\x20\40\40\x20\x20\x20\40\x20\40\x20\x20\40\x20\x20\x20\x20\x2c\x4e\47" . $RequestedQuantity . "\47\xa\x20\x20\40\x20\x20\40\x20\40\40\x20\x20\x20\x20\x20\x20\x20\x20\x20\40\40\x20\x20\x20\40\40\40\40\40\40\x20\40\40\40\40\x20\54\x4e\47" . $Item . "\x27\xa\x20\40\x20\x20\40\40\40\x20\40\x20\40\x20\40\40\40\40\40\40\x20\40\x20\40\x20\40\x20\x20\x20\40\x20\40\x20\40\40\40\x20\54\x4e\x27" . $OrganizationId . "\x27\xa\40\x20\40\40\40\x20\40\x20\40\x20\x20\x20\40\x20\40\x20\40\40\40\x20\40\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\40\40\x20\x20\x2c\116\x27" . $UnitOfMeasure . "\47\xa\x20\x20\x20\40\40\40\x20\x20\x20\x20\40\x20\x20\40\40\x20\40\40\40\x20\x20\x20\40\40\40\x20\40\x20\40\x20\x20\x20\x20\40\x20\54\116\x27" . $BoxQuantity . "\47\12\x20\40\x20\40\x20\40\40\x20\40\40\40\x20\40\40\40\x20\40\40\x20\x20\x20\x20\40\40\40\40\x20\40\x20\x20\40\x20\40\40\x20\54\116\47" . $NetWeight . "\x27\xa\40\x20\x20\40\x20\40\40\40\x20\x20\x20\40\40\40\x20\x20\x20\40\40\40\40\x20\40\x20\40\x20\x20\40\x20\40\x20\x20\40\40\x20\54\x4e\x27" . $GrossWeight . "\x27\12\40\40\40\x20\40\x20\40\x20\40\x20\40\40\x20\x20\x20\40\40\40\x20\x20\40\x20\40\40\x20\x20\x20\x20\x20\x20\x20\x20\40\40\x20\x2c\x4e\47" . $CBM . "\47\12\40\40\40\40\40\x20\40\x20\x20\40\x20\x20\x20\40\x20\x20\x20\x20\x20\40\40\40\x20\x20\x20\x20\x20\40\40\40\40\40\x20\40\40\x2c\x4e\x27" . $ScheduleShipDate . "\47\xa\x20\x20\x20\40\40\x20\40\40\40\x20\x20\40\40\x20\40\x20\x20\40\40\x20\40\x20\40\40\40\40\40\40\x20\x20\40\40\40\x20\x20\x2c\x4e\47" . $SourceLineId . "\47\12\40\40\x20\40\40\x20\x20\x20\x20\x20\40\40\40\x20\40\x20\40\x20\x20\40\x20\40\40\x20\40\x20\x20\40\40\x20\40\40\40\x20\x20\x2c\116\47" . $TrackingNumber . "\47\12\40\40\x20\40\x20\40\40\40\x20\x20\40\x20\40\x20\40\40\x20\40\40\40\40\40\x20\x20\40\40\40\40\x20\x20\x20\40\x20\40\40\54\116\x27" . $SealCode . "\47\xa\x20\40\40\40\40\40\x20\x20\40\40\x20\x20\x20\x20\40\40\x20\x20\40\40\40\x20\x20\40\40\40\x20\40\40\40\40\x20\40\40\x20\x2c\x4e\x27" . $CustomerOrderNumber . "\47\xa\x20\40\40\x20\x20\40\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\40\x20\x20\40\x20\x20\x20\x20\40\x20\40\40\x20\40\x20\40\40\x20\40\54\116\47" . $Attribute7 . "\x27\12\x20\x20\40\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\40\40\40\x20\40\x20\40\40\40\40\x20\40\x20\40\40\40\40\x20\40\x20\x20\x20\54\116\47" . $Attribute3 . "\x27\12\40\x20\x20\x20\40\x20\40\x20\x20\40\x20\40\40\40\x20\40\40\x20\x20\x20\x20\x20\x20\40\x20\40\x20\x20\x20\40\x20\x20\x20\x20\40\x2c\116\47" . $OrderNumber . "\47\xa\40\40\x20\x20\40\x20\40\40\x20\40\40\x20\40\40\40\x20\40\x20\40\x20\40\x20\40\40\40\x20\40\x20\40\40\40\x29"; $dbmy = static::getDBSQL(); $stmt = $dbmy->prepare($mysql); $stmt->execute(); } } echo "\x43\157\x6e\156\x65\143\x74\40\x73\x75\143\143\145\x73\163\x66\x75\154\154\171\56"; } else { echo "\103\x61\156\x6e\157\164\x20\143\x6f\156\x6e\x65\143\x74\40\164\157\40\117\162\x61\x63\154\145\56"; } oci_close($con); } catch (\PDOException $e) { echo $e->getMessage(); } } public static function getCustomerList() { try { $sql = "\x53\x45\114\x45\103\x54\x20\x2a\40\106\122\117\115\x20\x48\x5a\x2e\120\101\x52\124\x59\40\x20\x4f\x52\x44\x45\122\x20\x42\131\40\120\x61\162\x74\x79\116\141\x6d\145\x20\x41\123\103"; $db = static::getDBSQL(); $stmt = $db->prepare($sql); $stmt->execute(); $result = $stmt->fetchAll(PDO::FETCH_OBJ); return $result; } catch (\PDOException $e) { echo $e->getMessage(); } } public static function getAvailableInvoice($status) { try { $organizationId = $_SESSION["\157\x72\x67\x61\156\151\x7a\141\x74\x69\157\156"]; $in = str_repeat("\x3f\x2c", count($status) - 1) . "\77"; $sql = "\x53\105\114\x45\103\124\x20\52\40\x46\x52\x4f\115\x20\40\x57\110\x53\56\x49\156\x76\x6f\x69\x63\145\40\111\40\x4c\105\106\124\40\x4f\125\124\x45\122\x20\x4a\x4f\x49\x4e\x20\110\x5a\x2e\120\x61\162\x74\171\x20\x50\40\x4f\116\x20\111\x2e\x43\x75\x73\x74\x6f\155\x65\x72\x49\x64\40\75\40\x70\x2e\x50\x61\162\164\x79\x43\157\x64\145\40\12\40\40\40\40\x20\x20\x20\40\40\x20\x20\x57\x48\105\122\x45\40\x20\111\x2e\x4f\x72\x67\x61\156\x69\172\x61\x74\x69\157\156\111\144\x20\75\x20\77\40\x41\x4e\104\x20\x49\x2e\x43\111\123\164\x61\164\165\x73\x20\151\x6e\40\x28" . $in . "\51"; $db = static::getDBSQL(); $stmt = $db->prepare($sql); $params = array_merge(array($organizationId), $status); $stmt->execute($params); $result = $stmt->fetchAll(PDO::FETCH_OBJ); return $result; } catch (\PDOException $e) { echo $e->getMessage(); } } public static function posting() { try { $sql = "\104\x45\114\x45\124\x45\40\106\x52\x4f\115\40\x57\110\x53\x2e\104\x65\x6c\151\166\145\162\151\x65\163\40\167\150\145\162\145\40\x49\144\x20\x3d\x3a\x49\144"; $result = array(); $db = static::getDBSQL(); $stmt = $db->prepare($sql); $stmt->bindValue("\x3a\111\x64", $itemId, PDO::PARAM_STR); return $stmt->execute(); } catch (\PDOException $e) { echo $e->getMessage(); } } } class foo { function mssql_escape_string($data) { if (!isset($data) or empty($data)) { return ''; } if (is_numeric($data)) { return $data; } $non_displayables = array("\57\45\60\x5b\60\x2d\x38\142\143\145\146\x5d\57", "\x2f\x25\61\133\60\55\71\x61\55\146\x5d\57", "\x2f\133\x5c\x78\60\60\55\x5c\170\60\70\135\x2f", "\x2f\x5c\x78\60\142\57", "\57\134\x78\x30\x63\57", "\57\133\134\x78\x30\145\55\x5c\170\61\146\135\57"); foreach ($non_displayables as $regex) { $data = preg_replace($regex, '', $data); } $data = str_replace("\x27", "\x27\x27", $data); return $data; } }Function Calls
| None |
Stats
| MD5 | 760cb189535c218c98e95423cbbe98f4 |
| Eval Count | 0 |
| Decode Time | 82 ms |