<?php

session_start();


require_once ("connection_sql.php");

header('Content-Type: text/xml');

date_default_timezone_set('Asia/Colombo');

if ($_POST["Command"] == "getdt") {
    echo "<?xml version=\"1.0\" encoding=\"utf-8\"?>\n";

    $ResponseXML = "";
    $ResponseXML .= "<new>";
    
         $sql = "select DAG from invpara where flag='".$_SESSION['company']."'"; 
        $result = $conn->query($sql);
        $row = $result->fetch();
        
        $sql1 = "select * from s_stomas where CODE='".$_POST['department']."'"; 
        $result1 = $conn->query($sql1);
        $row1 = $result1->fetch();
        
        
        $tmpinvno = "000000" . $row["DAG"] ;
        $lenth = strlen($tmpinvno);
        //  . "/" . $_GET["salesrep"]
        $refno = trim("".$_SESSION['company']."/D/") . substr($tmpinvno, $lenth - 6);
        
     
     
    $shcode="";
     
    $ResponseXML .= "<scode><![CDATA[".$row1['short']."]]></scode>";
    
    
    $sql3 = "delete from dag_item_tmp   where tmp_no='".$_POST['uniq']."'   "; 
    $result3 = $conn->query($sql3);
    
    $sql3 = "delete from dag_item_tmp   where user='".$_SESSION["CURRENT_USER"]."'   "; 
    $result3 = $conn->query($sql3);
    
    
    $uniq = uniqid();
    $ResponseXML .= "<id><![CDATA[$refno]]></id>";
    $ResponseXML .= "<jobno><![CDATA[".$shcode."]]></jobno>";
    $ResponseXML .= "<uniq><![CDATA[$uniq]]></uniq>";
    $ResponseXML .= "<sdate><![CDATA[" . date('Y-m-d') . "]]></sdate>";

    $ResponseXML .= "</new>";

    echo $ResponseXML;
}

if ($_POST["Command"] == "setjobno") {
    echo "<?xml version=\"1.0\" encoding=\"utf-8\"?>\n";

    $ResponseXML = "";
    $ResponseXML .= "<new>";

      $sql = "select DAG from invpara where flag='".$_SESSION['company']."'"; 
        $result = $conn->query($sql);
        $row = $result->fetch();
        
        $sql1 = "select * from s_stomas where CODE='".$_POST['department']."'"; 
        $result1 = $conn->query($sql1);
        $row1 = $result1->fetch();
        
        
        $tmpinvno = "000000" . $row["DAG"] ;
        $lenth = strlen($tmpinvno);
        //  . "/" . $_GET["salesrep"]
        $refno = trim("".$row1['SCODE']."/D/") . substr($tmpinvno, $lenth - 6);
   
    
    $shcode="";
    
     
     $ResponseXML .= "<scode><![CDATA[".$row1['short']."]]></scode>";
    $ResponseXML .= "<jobno><![CDATA[".$shcode."]]></jobno>"; 
    $ResponseXML .= "<refno><![CDATA[".$refno."]]></refno>"; 

    $ResponseXML .= "</new>";

    echo $ResponseXML;
}

if ($_POST["Command"] == "add_tmp") {

  try {
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $conn->beginTransaction();

    header('Content-Type: text/xml'); 
    
    $ResponseXML = "";
    $ResponseXML .= "<salesdetails>";
    
    if ($_POST['Command1'] == "add") {
        
        $sql = "SELECT * from dag_item_tmp where  jobno='".$_POST['jobno']."' and cancel='0'  "; 
        $result = $conn->query($sql);
        if ($row = $result->fetch()) {
            exit("Already Added Job No.!!!");
        }
        
        $sql = "SELECT * from dag_item where  jobno='".$_POST['jobno']."'  and cancel='0'  "; 
        $result = $conn->query($sql);
        if ($row = $result->fetch()) {
            exit("Already Saved Job No. Please Added New  One!!!");
        }
        
        $sql3 = "delete from dag_item_tmp   where refno='".$_POST['refno']."' and serialno='".$_POST['serialno']."'  "; 
        $result3 = $conn->query($sql3);



        $sql2 = "insert into dag_item_tmp(refno,cuscode,cusname,size,marker,adpayment,serialno,warrenty,remark,tmp_no,jobno,belt,cascost,cost,user,dagtype,STK_NO) values 
        ('" . $_POST['refno'] . "', '" . $_POST['cuscode']  . "', '" . $_POST['cusname'] . "', '" . $_POST['size'] . "', '" . $_POST['marker'] . "', '" . $_POST['adpayment'] . "', '" . $_POST['serialno'] . "', '" . $_POST['warranty'] . "', '" . $_POST['remark'] . "', '" . $_POST['uniq'] . "', '" . $_POST['jobno'] . "', '" . $_POST['belt'] . "', '" . $_POST['cascost'] . "', '" . $_POST['cascost'] . "', '" . $_SESSION["CURRENT_USER"] . "', '" . $_POST['dagtype'] . "', 'DAG')"; 
        $result2 = $conn->query($sql2);

        //  $sql = "update s_stomas set shortcode = shortcode+ 1 where CODE = '".$_POST['department']."'";
        //  $result = $conn->query($sql);

    }
    if ($_POST['Command1'] == "del") {

        $sql = "delete from dag_item_tmp   where id='".$_POST['id']."'";  
        $result = $conn->query($sql);
    }

    $ResponseXML .= "<sales_table><![CDATA[<table class=\"table\">  ";
    $ResponseXML .= " <tr>
    <th>#</th>
    <th>JOBNO</th>
    <th>SIZE</th>
    <th>BELT</th>
    <th>MARKER</th>
    <th>SERIAL NO</th>
    <th>WARRENTY</th>
    <th>TYPE</th> 
    <th>REMARK</th> 
    <th>#</th> 
    </tr>";
    
$i=1;
    $sql = "Select * from dag_item_tmp where  tmp_no='".$_POST['uniq']."'";
    foreach ($conn->query($sql) as $row) {

         
        $ResponseXML .= "<tr> 
        <td style=\"width:10px;\">" . $i."</td> 
        <td style=\"width:200px;\">" . $row['jobno']."</td> 
        <td style=\"width:200px;\">" . $row['size']."</td> 
        <td style=\"width:200px;\">" . $row['belt']."</td> 
        <td style=\"width:200px;\">" . $row['marker'] . "</td> 
        <td style=\"width:200px;\">" . $row['serialno'] . "</td> 
        <td style=\"width:200px;\">" . $row['warrenty'] . "</td>
        <td style=\"width:200px;\">" . $row['dagtype'] . "</td>   
        <td style=\"width:200px;\">" . $row['remark'] . "</td>  
        <td><button   onClick=\"del_item('" . $row['id'] . "')\" type=\"button\" class=\"btn btn-danger btnDelete btn-sm\">Remove</button>
        </td>
        </tr>";  

    $i=$i+1;
    }
    
    
    
    
   
    $ResponseXML .= "</table>]]></sales_table>";   
    
    
    
    $shcode="";
     
      
    $ResponseXML .= "<jobno><![CDATA[".$shcode."]]></jobno>"; 
      
      
    $ResponseXML .= "</salesdetails>";

    echo $ResponseXML;
    $conn->commit();
    // echo "ADDED";
} catch (Exception $e) {
    $conn->rollBack();
    echo $e;
}
}


if ($_POST["Command"] == "save_item") {


    try {
        $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        $conn->beginTransaction();
        
        $sql = "SELECT * from dag where  refno='".$_POST['refno']."'  and cancel='0'";
        $result = $conn->query($sql);
        if ($row = $result->fetch()) {
            exit("Already Saved DAG No...!!!");
        }
        
         $sql = "SELECT * from dag where  refno='".$_POST['refno']."' and cancel='1'";
        $result = $conn->query($sql);
        if ($row = $result->fetch()) {
            exit("Already Cancel DAG No...!!!");
        }
        
        $sql = "select DAG from invpara where flag='".$_SESSION['company']."'"; 
        $result = $conn->query($sql);
        $row = $result->fetch();
        
        $sql1 = "select * from s_stomas where CODE='".$_POST['department']."'"; 
        $result1 = $conn->query($sql1);
        $row1 = $result1->fetch();
        
        
        $tmpinvno = "000000" . $row["DAG"] ;
        $lenth = strlen($tmpinvno);
        //  . "/" . $_GET["salesrep"]
        $refno = trim("".$_SESSION['company']."/D/") . substr($tmpinvno, $lenth - 6);
    

        $sql1 = "insert into dag(refno,cuscode,cusname,sdate,tmp_no,flag,department,TYPE1,company,invno) values
        ('" .$refno . "', '" . $_POST['cuscode']  . "', '" . $_POST['cusname'] . "', '" . $_POST['sdate'] . "', '" . $_POST['uniq'] . "','0', '" . $_POST['department'] . "','DAG','".$_SESSION['company']."', '" . $_POST['invno'] . "')"; 
        $result1 = $conn->query($sql1);

         
    
        $i=1;
        $sqltmp= "select * from dag_item_tmp where  tmp_no='".$_POST['uniq']."'";
        foreach ($conn->query($sqltmp) as $rowtmp) {
            $sql3 = "SELECT * FROM vendor where CODE='".$rowtmp['cuscode']."'";
             $result3 = $conn->query($sql3); 
             $row3 = $result3->fetch();
             
            $qty =1;
            
            $sql2 = "insert into dag_item(refno,cuscode,cusname,size,marker,adpayment,serialno,warrenty,remark,tmp_no,flag,sdate,jobno,belt,cascost,cost,total,department,cus_type,TYPE1,dagtype,company,STK_NO) values
            ('" . $refno . "', '" . $rowtmp['cuscode']  . "', '" . $rowtmp['cusname'] . "', '" . $rowtmp['size'] . "', '" . $rowtmp['marker'] . "', '" . $rowtmp['adpayment'] . "', '" . $rowtmp['serialno'] . "', '" . $rowtmp['warrenty'] . "', '" . $rowtmp['remark'] . "', '" . $_POST['uniq'] . "' ,'5', '" . $_POST['sdate'] . "', '" . $rowtmp['jobno'] . "', '" . $rowtmp['belt'] . "', '" . $rowtmp['cascost'] . "', '" . $rowtmp['cascost'] . "', '" . $rowtmp['cascost'] . "', '" . $_POST['department'] . "','".$row3['cus_type']."','DAG', '" . $rowtmp['dagtype'] . "','".$_SESSION['company']."','".$rowtmp['STK_NO']."') ";
            $result2 = $conn->query($sql2);
            
            $sqls_trn = "Insert into s_trn (STK_NO,JOBNO, SDATE, REFNO, QTY, LEDINDI, DEPARTMENT, Dev, seri_no, SAL_EX, ACTIVE, DONO,sdate1,cost,SERIALNO,selling,TYPE,company) values
            ('".$rowtmp['STK_NO']."','" . $rowtmp['jobno'] . "','" . $_POST['sdate'] . "','" . trim($refno) . "', " . $qty . ", 'DAG_IN', '" . $_POST['department'] . "', '" . $_SESSION['dev'] . "', '', '', '1', 'DAG_IN','" . $_POST['sdate'] . "','" . $rowtmp['cascost'] . "', '" . $rowtmp['serialno'] . "','" . $rowtmp['cascost'] . "','DAG_IN','".$_SESSION['company']."')";
            $results_trn = $conn->query($sqls_trn);
           
            $sql1 = "update s_mas set QTYINHAND=QTYINHAND+1 where STK_NO='".$rowtmp['STK_NO']."'"; 
            $result1 = $conn->query($sql1);

            $sql2 = "update s_submas set QTYINHAND=QTYINHAND+1 where STO_CODE='" . $_POST['department'] . "' and STK_NO='" . $rowtmp['STK_NO'] . "'";
            $resul2 = $conn->query($sql2);
           $i= $i+1;
       }


        $sql3 = "delete from dag_item_tmp   where tmp_no='".$_POST['uniq']."'   "; 
        $result3 = $conn->query($sql3);
        
        $sql3 = "delete from dag_item_tmp   where user='".$_SESSION["CURRENT_USER"]."'   "; 
        $result3 = $conn->query($sql3);

        
       $sql1 = "update invpara set dag=dag+1 where flag='".$_SESSION['company']."'"; 
        $result1 = $conn->query($sql1);
        
        $sqllog = "insert into entry_log(refno, username, docname, trnType, stime, sdate,company) values 
        ('" . $refno . "', '" . $_SESSION["CURRENT_USER"] . "', 'DAG', 'Save', '" . date("Y-m-d H:i:s") . "', '" . date("Y-m-d") . "','".$_POST['department']."')";
        $resultlog = $conn->query($sqllog);
        
        
       echo "Saved";
       
       $conn->commit();
   } catch (Exception $e) {
    $conn->rollBack();
    echo $e;
}
}



if ($_GET["Command"] == "pass_quot") {
    $_SESSION["custno"] = $_GET['custno'];

    header('Content-Type: text/xml');
    echo "<?xml version=\"1.0\" encoding=\"utf-8\"?>\n";

    $ResponseXML = "";
    $ResponseXML .= "<salesdetails>";

    $cuscode = $_GET["custno"];

    $sql = "Select * from dag where   refno ='" . $cuscode . "'";
    $result = $conn->query($sql);

    if ($rowM = $result->fetch()) {
        $ResponseXML .= "<id><![CDATA[" . json_encode($rowM) .  "]]></id>";
    }

    $ResponseXML .= "<sales_table><![CDATA[ <table class=\"table\">    ";

    $ResponseXML .= " <tr>
    <th>#</th>
    <th>JOBNO</th>
    <th>SIZE</th>
    <th>BELT</th>
    <th>MARKER</th>
    <th>SERIAL NO</th>
    <th>WARRENTY</th>
    <th>AD PAY</th>
    <th>CASING COST</th>
    <th>TYPE</th>  
    <th>REMARK</th>  
    </tr>";

$i=1;
    $sql1 = "Select * from dag_item where refno ='" . $cuscode . "'"; 
    foreach ($conn->query($sql1) as $row) {

       $ResponseXML .= "<tr>
       <td style=\"width:10px;\">" . $i . "</td>
       <td style=\"width:200px;\">" . $row['jobno'] . "</td>
        <td style=\"width:200px;\">" . $row['size'] . "</td>
        <td style=\"width:200px;\">" . $row['belt'] . "</td>
       <td style=\"width:200px;\">" . $row['marker'] . "</td> 
       <td style=\"width:200px;\">" . $row['serialno'] . "</td> 
       <td style=\"width:200px;\">" . $row['warrenty'] . "</td> 
       <td style=\"width:200px;\">" . $row['adpayment'] . "</td> 
       <td style=\"width:200px;\">" . $row['cascost'] . "</td> 
       <td style=\"width:200px;\">" . $row['dagtype'] . "</td> 
       <td style=\"width:200px;\">" . $row['remark'] . "</td>    
       </tr>";  
       $i=$i+1;
   }

   $ResponseXML .= "   </table>]]></sales_table>"; 

   $ResponseXML .= "</salesdetails>";
   echo $ResponseXML;
}



if ($_POST["Command"] == "cancel_inv") {


    try {
        $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        $conn->beginTransaction();
        
        $sql = "SELECT * from dag where  refno='".$_POST['refno']."' and cancel='1'";
        $result = $conn->query($sql);
        if ($row = $result->fetch()) {
            exit("Already Cancel DAG No...!!!");
        }
        
        $sql = "SELECT * from dag_item where  refno='".$_POST['refno']."' and invno!='' ";
        $result = $conn->query($sql);
        if ($row = $result->fetch()) {
            exit("Already Invoiced DAG No.Please Cancel Invoice First...!!!");
        }
        
        $sql = "SELECT * from dag where  refno='".$_POST['refno']."'  ";
        $result = $conn->query($sql);
        if ($row = $result->fetch()) {
            $sql = "update dag set cancel = '1' where  refno='".$_POST['refno']."' ";
            $result = $conn->query($sql);
            
            $sqltmp= "select * from dag_item where  refno='".$_POST['refno']."'";
            foreach ($conn->query($sqltmp) as $rowtmp) {
                
                $sql1 = "update s_mas set QTYINHAND=QTYINHAND-1 where STK_NO='".$rowtmp['STK_NO']."'"; 
                $result1 = $conn->query($sql1);
                
                $sql2 = "update s_submas set QTYINHAND=QTYINHAND-1 where STO_CODE='" . $rowtmp['department'] . "' and STK_NO='" . $rowtmp['STK_NO'] . "'";
                $resul2 = $conn->query($sql2);
            }
            
            // $sql = "update produ_builders set cancel = '1' where  refno='".$_POST['refno']."' ";
            // $result = $conn->query($sql);
            
            // $sql1 = "update produ_spareitem set cancel = '1' where  refno='".$_POST['refno']."' ";
            // $result1 = $conn->query($sql1);
            
            // $sql2 = "update produ_workers set cancel = '1' where  refno='".$_POST['refno']."' ";
            // $result2 = $conn->query($sql2);
             
            $sql = "update dag_item set cancel = '1' where  refno='".$_POST['refno']."' ";
            $result = $conn->query($sql);
            
            $sql2 = "delete from s_trn where REFNO='" . $_POST['refno'] . "'";
            $resul2 = $conn->query($sql2);
         
            $sqllog = "insert into entry_log(refno, username, docname, trnType, stime, sdate,company) values
            ('" . trim($_POST['refno']) . "', '" . $_SESSION["CURRENT_USER"] . "', 'DAG', 'CANCEL', '" . date("Y-m-d H:i:s") . "', '" . date("Y-m-d") . "','".$row['department']."')";
            $resultlog = $conn->query($sqllog);
            
            
            echo "Cancel";
            
            
        }

        
        $conn->commit();


    } catch (Exception $e) {
        $conn->rollBack();
        echo $e;
    }
}


?>