";print_r($postData);die; //$logFile="log.txt"; //$data=json_encode($_FILES); //$file_name=$_FILES['file']['name']; //file_put_contents("/var/www/html/yty-xml-files/" .$logFile ,"Date:".Date('Y-m-d')." & Value:".$data . "\n", FILE_APPEND); /* $querySeqId= "select meaning username, description password from ytycustom.xxyty_edi_portal_pass"; $suppliersDet = oci_parse($dbcon, $querySeqId); oci_execute($suppliersDet); $row=oci_fetch_array($suppliersDet); $username=$row['USERNAME']; $password_tbl=$row['PASSWORD']; $user=$requestArr['username']; $password=$requestArr['password']; if($user=='' or $user!=$username){ echo "Invalid Username"; die; } if($password=='' or $password!=$password_tbl){ echo "Invalid Password"; die; } */ if(isset($_POST['image'])) $image=$_POST['image']; if($postData) { $page = 'received_file'.date('dmYhis').'.xml'; file_put_contents('/var/www/html/yty-xml-files/upload_files/'.$page, $postData); $xml = simplexml_load_file('/var/www/html/yty-xml-files/upload_files/'.$page); if (empty($xml->SENDER) || empty($xml->RECEIVER)) { die("Invalid xml file"); } if ($xml->TRANSACTIONTYPE == 850) { foreach($xml->PURCHASEORDER->POLINEDETAIL as $lineObject) { doInsert($xml, $xml->PURCHASEORDER->POHEADER, $lineObject, $page, 1); } } else { foreach ($xml->PURCHASEORDERCHANGE->POLINEDETAIL as $lineObject) { doInsert($xml, $xml->PURCHASEORDERCHANGE->POHEADER, $lineObject, $page, 2); } } $body = ''; $body .= '
Dear All,
'; $body .= 'Ansell customer has uploaded XML file in EDI system.
'; $body .= 'Thanks,
'; $body .= 'YTY
'; (new Email())->sendMail([ 'subject' => 'Received XML - ANSELL', 'body' => $body, 'document' => 'upload_files/'.$page, 'recipients' => [ 'brijlal.sharma@ytygroup.com.my' => 'Brij', 'reyndo.frenliedo@ytygroup.com.my' => 'Reyndo' ], ]); die('File has been received successfully.'); } else if($image!="") { $link_array = explode('/',$image); $page = end($link_array); $file_value=file_get_contents($image); file_put_contents("/var/www/html/yty-xml-files/upload_files/".$page,$file_value); echo "File has been received successfully.";die; } else if($_FILES['file']['name']!="") { $file_name=$_FILES['file']['name']; $ext = pathinfo($file_name, PATHINFO_EXTENSION); $tmp_name=$_FILES['file']['tmp_name']; $fileName=date('Ymdhis').'.'.$ext; if(move_uploaded_file($tmp_name,"upload_files/".$fileName)){ echo "File has been received successfully.";die; } else{ echo "Error while uploading.". $_FILES["file"]["error"];die; } } else{ echo "No file found";die; } function doInsert($xml, $headerObj, $lineObject, $page, $type) { global $dbcon; $temp = [ '\''.$xml->SENDER.'\'', '\''.$xml->RECEIVER.'\'', '\''.$xml->TRANSACTIONTYPE.'\'', '\''.$xml->DATE.'\'', '\''.$xml->CONTROLNUMBER.'\'', '\''.$headerObj->PONUMBER.'\'', '\''.$headerObj->PODATE.'\'', '\''.$headerObj->POCATEGORY.'\'', '\''.$headerObj->POREVISION.'\'', '\''.$headerObj->CURRENCYCODE.'\'', '\''.$lineObject->LINENUMBER.'\'', '\''.$lineObject->ITEMNUMBER.'\'', '\''.$lineObject->ITEMDESCRIPTION.'\'', '\''.$lineObject->QUANTITYORDERED.'\'', '\''.$lineObject->UNITOFMEASURE.'\'', '\''.$lineObject->UNITPRICE.'\'', '\''.$lineObject->REQUESTEDDATE.'\'', '\''.$page.'\'', '\''.$headerObj->SHIPTOADDRESS1.'\'', '\''.$headerObj->SHIPTOADDRESS2.'\'', '\''.$headerObj->SHIPTOADDRESS3.'\'', '\''.$headerObj->SHIPTOCITY.'\'', '\''.$headerObj->SHIPTOSTATE.'\'', '\''.$headerObj->BILLTOCODE.'\'', '\''.$headerObj->BILLTONAME.'\'', '\''.$headerObj->BILLTOADDRESS1.'\'', '\''.$headerObj->BILLTOADDRESS2.'\'', '\''.$headerObj->BILLTOADDRESS3.'\'', '\''.$headerObj->BILLTOCITY.'\'', '\''.$headerObj->BILLTOSTATE.'\'', '\''.$headerObj->BILLTOZIP.'\'', '\''.$headerObj->BILLTOCOUNTRY.'\'', '\''.$headerObj->SHIPPINGINSTRUCTION.'\'', '\''.$headerObj->SHIPTOCODE.'\'', ]; $table = ($type == 1) ? 'XXYTYCPORT.XXYTY_EDI_XML_TBL_1' : 'XXYTYCPORT.XXYTY_EDI_XML_TBL_2'; $sql = 'INSERT INTO '.$table.'(SENDER,RECEIVER,TRANSACTIONTYPE,CREATIONDATE,CONTROLNUMBER,PONUMBER,PODATE,POCATEGORY,POREVISION,CURRENCYCODE,LINENUMBER,ITEMNUMBER,ITEMDESCRIPTION,QUANTITYORDERED,UNITOFMEASURE,UNITPRICE,REQUESTEDDATE,FILE_NAME,SHIPTOADDRESS1,SHIPTOADDRESS2,SHIPTOADDRESS3,SHIPTOCITY ,SHIPTOSTATE,BILLTOCODE,BILLTONAME,BILLTOADDRESS1,BILLTOADDRESS2,BILLTOADDRESS3,BILLTOCITY,BILLTOSTATE,BILLTOZIP,BILLTOCOUNTRY,SHIPPINGINSTRUCTION,SHIPTOCODE) VALUES ('.implode(',', $temp).')'; $manage_query = oci_parse($dbcon, $sql); return oci_execute($manage_query); } ?>