<?php

session_start();

include_once ("connection.php");

if ($_GET["Command"] == "search_custom") {

    //if(isset($_GET['customername'])){
    //$letters = $_GET['customername'];
    //$letters = $_GET['letters'];
    //	$letters = preg_replace("/[^a-z0-9 ]/si","",$letters);
    //	$res = $dbinv->query("SELECT * FROM mast_family where name like '".$letters."%'") or die("Error";
    //$res = $dbinv->query("SELECT distinct trn_involved.str_name FROM trn_involved where str_name like '".$letters."%'") or die("Error";
    //SELECT * FROM occupation_details where str_first_name like 'k%'
    //echo $res;

    $ResponseXML .= "";
    //$ResponseXML .= "<invdetails>";

    $ResponseXML .= "<table width=\"735\" border=\"0\" class=\"form-matrix-table\">
                            <tr>
                              <td width=\"121\"  background=\"\" ><font color=\"#FFFFFF\">Customer No</font></td>
                              <td width=\"424\"  background=\"\"><font color=\"#FFFFFF\">Customer</font></td>
                             <td width=\"424\"  background=\"\"><font color=\"#FFFFFF\">Address</font></td>
   							</tr>";

    if ($_GET["mstatus"] == "cusno") {
        $letters = $_GET['cusno'];
        //$letters = preg_replace("/[^a-z0-9 ]/si","",$letters);
        if ($_GET["incen"] == "1") {
            $sql = $dbinv->query("SELECT * from vendor where CODE like  '$letters%' and CAT<>'Z' order by CODE limit 50") or die("Error";
        } else if ($_GET["incen"] == "2") {
            $sql = $dbinv->query("SELECT * from vendor where CODE like  '$letters%' and CAT='Z' order by CODE limit 50") or die("Error";
        } else {
            $sql = $dbinv->query("SELECT * from vendor where CODE like  '$letters%' and CAT<>'X' order by CODE limit 50") or die("Error";
        }
    } else if ($_GET["mstatus"] == "customername") {
        $letters = $_GET['customername'];
        //$letters = preg_replace("/[^a-z0-9 ]/si","",$letters);
        if ($_GET["incen"] == "1") {
            $sql = $dbinv->query("SELECT * from vendor where NAME like  '$letters%' and CAT<>'Z'  order by CODE limit 50") or die("Error";
        } else if ($_GET["incen"] == "2") {
            $sql = $dbinv->query("SELECT * from vendor where NAME like  '$letters%' and CAT='Z' order by CODE limit 50") or die("Error";
        } else {
            $sql = $dbinv->query("SELECT * from vendor where NAME like  '$letters%' and CAT<>'X' order by CODE limit 50") or die("Error";
        }
    } else {

        $letters = $_GET['customername'];
        //$letters = preg_replace("/[^a-z0-9 ]/si","",$letters);
        if ($_GET["incen"] == "1") {
            $sql = $dbinv->query("SELECT * from vendor where NAME like  '$letters%' and CAT<>'X' and CAT<>'Z' order by CODE limit 50") or die("Error";
        } else if ($_GET["incen"] == "2") {
            $sql = $dbinv->query("SELECT * from vendor where NAME like  '$letters%' and CAT='X' order by CODE limit 50") or die("Error";
        } else {
            $sql = $dbinv->query("SELECT * from vendor where NAME like  '$letters%' and CAT<>'X' order by CODE limit 50") or die("Error";
        }
    }

    while ($row = $sql->fetch()) {
        $cuscode = $row["CODE"];
        $stname = $_GET["stname"];
        $ResponseXML .= "<tr>
                              <td onclick=\"custno('$cuscode', '$stname');\">" . $row['CODE'] . "</a></td>
                              <td onclick=\"custno('$cuscode', '$stname');\">" . $row['NAME'] . "</a></td>
                              <td onclick=\"custno('$cuscode', '$stname');\">" . $row['ADD2'] . "</a></td>                          	
                            </tr>";
    }

    $ResponseXML .= "   </table>";

    echo $ResponseXML;
    //	}
}



if ($_GET["Command"] == "save_customer") {

    $txtCNAME = str_replace("~", "&", $_GET['txtCNAME']);

    $sql_data = $dbinv->query("Select * from vendor where CODE='" . $_GET['txt_cuscode'] . "'") or die("Error";
    if ($row = $sql_data->fetch()) {

        $sql_data = $dbinv->query("update vendor set province='" . $_GET['txtprovince'] . "',district='" . $_GET['txtdistrict'] . "',comtype='" . $_GET['txt_comtype'] . "',commoncode='" . $_GET['txt_commcode'] . "',vatgroup ='" . $_GET['txtvatgroup'] . "',NAME='" . $txtCNAME . "', ADD1='" . $_GET['txtBADD1'] . "', ADD2='" . $_GET['txtBADD2'] . "', TELE1='" . $_GET['txtTEL'] . "', TELE2='" . $_GET['txttel2'] . "', CONT='" . $_GET['txtcper'] . "', CUR_BAL='" . $_GET['txtbal'] . "', OPDATE='" . $_GET['DTOPDATE'] . "', cLIMIT='" . $_GET['txtcrlimt'] . "', PEN='" . $_GET['txtover'] . "', PENDA='" . $_GET[''] . "', FAX='" . $_GET['txtFAX'] . "', EMAIL='" . $_GET['TXTEMAIL'] . "', vatno='" . $_GET['txtvatno'] . "', acno='" . $_GET["txtACCno"] . "', CAT='" . $_GET['txtcat'] . "', svatno='" . $_GET['SVAT'] . "', cus_type='" . $_GET['txttype'] . "', area='" . $_GET['txtarea'] . "', incdays='" . $_GET['txtInc'] . "', chk_bangr='" . $chkgarant . "', bank_gr_date='" . $_GET["DTbankgrdate"] . "', AltMessage='" . $_GET["txtMsg"] . "', rep='" . $_GET["TXT_REP"] . "', field1='" . $_GET["txt_scat"] . "', remark='" . $_GET["remark"] . "',starget='" . $_GET["starget"] . "'  where CODE='" . $_GET['txt_cuscode'] . "'") or die("Error";
    } else {

        $sql_data = $dbinv->query("insert into vendor (CODE, NAME, ADD1, ADD2, TELE1, TELE2, CONT, CUR_BAL, OPDATE, cLIMIT, PEN, FAX, EMAIL, vatno, acno, CAT, svatno, cus_type, area, incdays, chk_bangr, bank_gr_date, AltMessage, rep, field1, remark,starget,vatgroup,comtype,district,province)
		values ('" . $_GET['txt_cuscode'] . "', '" . $txtCNAME . "', '" . $_GET['txtBADD1'] . "', '" . $_GET['txtBADD2'] . "', '" . $_GET['txtTEL'] . "', '" . $_GET['txttel2'] . "', '" . $_GET['txtcper'] . "', '" . $_GET['txtbal'] . "', '" . $_GET['DTOPDATE'] . "', '" . $_GET['txtcrlimt'] . "', '" . $_GET['txtover'] . "', '" . $_GET['txtFAX'] . "', '" . $_GET['TXTEMAIL'] . "', '" . $_GET['txtvatno'] . "', '" . $_GET["txtACCno"] . "', '" . $_GET['txtcat'] . "', '" . $_GET['SVAT'] . "', '" . $_GET['txttype'] . "', '" . $_GET['txtarea'] . "', '" . $_GET['txtInc'] . "', '" . $chkgarant . "', '" . $_GET["DTbankgrdate"] . "', '" . $_GET["txtMsg"] . "', '" . $_GET["TXT_REP"] . "', '" . $_GET["txt_scat"] . "', '" . $_GET["remark"] . "','" . $_GET["starget"] . "','" . $_GET['txtvatgroup'] . "','" . $_GET['txt_comtype'] . "','" . $_GET['txtdistrict'] . "','" . $_GET['txtprovince'] . "')") or die("Error";
    }

    echo "Successfully Saved";
}

if ($_GET["Command"] == "pass_sellimit_result") {

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

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

    $sql_data = $dbinv->query("select * from br_trn where cus_code='" . $_GET["txt_cuscode"] . "' and Rep='" . $_GET["Com_rep"] . "' and brand='" . $_GET["cmbbrand"] . "' ") or die("Error";
    //echo "select * from br_trn where cus_code='".$_GET["txt_cuscode"]."' and Rep='".$_GET["Com_rep"]."' and brand='".$_GET["cmbbrand"]."' ";
    if ($row = $sql_data->fetch()) {
        $ResponseXML .= "<credit_lim><![CDATA[" . $row["credit_lim"] . "]]></credit_lim>";
        if (is_null($row["CAT"]) == false) {
            $ResponseXML .= "<CAT><![CDATA[" . $row["CAT"] . "]]></CAT>";
        } else {
            $ResponseXML .= "<CAT><![CDATA[]]></CAT>";
        }
    }

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

if ($_GET["Command"] == "delete_customer") {

    $sql_data = $dbinv->query("delete from vendor where CODE='" . $_GET['txt_cuscode'] . "'") or die("Error";
    echo "Successfully Deleted";
}

if ($_GET["Command"] == "tmp_crelimit") {

    $crelim = 0;
    $cat = "";
    $Com_rep1 = trim($_GET["Com_rep1"]);

    //echo "Select * from br_trn where cus_code='".$_GET["txt_cuscode"]."' and Rep='".$Com_rep1."' and  brand='".$_GET["cmbbrand1"]."'";
    $sql = $dbinv->query("Select * from br_trn where cus_code='" . $_GET["txt_cuscode"] . "' and Rep='" . $Com_rep1 . "' and  brand='" . $_GET["cmbbrand1"] . "'") or die("Error";
    if ($row = $sql->fetch()) {
        $crelim = $row["credit_lim"];
        if (is_null($row["CAT"]) == false) {
            $cat = $row["CAT"];
        } else {
            $crelim = 0;
        }
    }

    $sql_data = $dbinv->query("insert into tmpcrlmt (sdate, stime, username, tmpLmt, Class, Rep, cusCode, crLmt, cat) values ('" . date("Y-m-d") . "', '" . date("H:i:s") . "', '" . $_SESSION["CURRENT_USER"] . "', " . $_GET["txt_templimit"] . ", '" . trim($_GET["cmbbrand1"]) . "', '" . $Com_rep1 . "', '" . trim($_GET["txt_cuscode"]) . "', " . $crelim . ", '" . $cat . "' )") or die("Error";

    $sql = $dbinv->query("Select * from br_trn where cus_code='" . trim($_GET["txt_cuscode"]) . "' and Rep='" . $Com_rep1 . "' and  brand='" . $_GET["cmbbrand1"] . "'") or die("Error";
    if ($row = $sql->fetch()) {
        $sql_data = $dbinv->query("update br_trn set tmpLmt= " . $_GET["txt_templimit"] . ", Day= '" . date("Y-m-d") . "' where cus_code='" . trim($_GET["txt_cuscode"]) . "' and Rep='" . $Com_rep1 . "' and brand='" . $_GET["cmbbrand1"] . "'") or die("Error";
    } else {
        $sql_data = $dbinv->query("insert into br_trn (cus_code, Rep, credit_lim, brand, tmpLmt, Day) values ('" . trim($_GET["txt_cuscode"]) . "', '" . $Com_rep1 . "', '0', '" . $_GET["cmbbrand1"] . "', '" . $_GET["txt_templimit"] . "', '" . date("Y-m-d") . "')") or die("Error";
    }

    if ($_GET["chkstop"] == 1) {
        $chkstop = 1;
    } else {
        $chkstop = 0;
    }

    if ($_GET["check1"] == 1) {
        //echo "update vendor set blacklist= '1'  where code='".trim($_GET["txt_cuscode"])."'";
        $sql_data = $dbinv->query("update vendor set blacklist= '1'  where code='" . trim($_GET["txt_cuscode"]) . "'") or die("Error";
    } else {
        //echo "update vendor set blacklist= '0'  where code='".trim($_GET["txt_cuscode"])."'";
        $sql_data = $dbinv->query("update vendor set blacklist= '0'  where code='" . trim($_GET["txt_cuscode"]) . "'") or die("Error";
    }

    echo "Updated";
}

if ($_GET["Command"] == "pass_sto_inv") {

    if ($_GET["chkstop"] == "true") {
        $sql_data = $dbinv->query("update vendor set blacklist= '1'  where code='" . trim($_GET["txt_cuscode"]) . "'") or die("Error";
        $sql = "insert into entry_log(refno, username, docname, trnType, stime, sdate) values ('" . trim($_GET["txt_cuscode"]) . "', '" . $_SESSION["CURRENT_USER"] . "', 'Stop Invoice', 'BLOCK', '" . date("Y-m-d H:i:s") . "', '" . date("Y-m-d") . "')";
        $result = $dbinv->query($sql);
    } else {
        $sql_data = $dbinv->query("update vendor set blacklist= '0'  where code='" . trim($_GET["txt_cuscode"]) . "'") or die("Error";
        $sql = "insert into entry_log(refno, username, docname, trnType, stime, sdate) values ('" . trim($_GET["txt_cuscode"]) . "', '" . $_SESSION["CURRENT_USER"] . "', 'Allow Invoice', 'BLOCK', '" . date("Y-m-d H:i:s") . "', '" . date("Y-m-d") . "')";
        $result = $dbinv->query($sql);
    }
}

if ($_GET["Command"] == "pass_quot") {

    /* 	$sql = $dbinv->query("DROP VIEW view_s_salma") or die("Error";
      $sql = mysql_query("CREATE VIEW view_s_salma
      AS
      SELECT     s_salma.*, brand_mas.class AS class
      FROM         brand_mas RIGHT OUTER JOIN
      s_salma ON brand_mas.barnd_name = s_salma.brand") or die("Error"; */

    $_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 = $dbinv->query("Select * from vendor where CODE='" . $cuscode . "'") or die("Error";
    if ($row = $sql->fetch()) {

        $ResponseXML .= "<id><![CDATA[" . $row['CODE'] . "]]></id>";
        $ResponseXML .= "<str_customername><![CDATA[" . $row['NAME'] . "]]></str_customername>";
        $address = $row['ADD1'] . ",  " . $row['ADD2'];
        $ResponseXML .= "<str_address><![CDATA[" . $address . "]]></str_address>";
        $ResponseXML .= "<str_vatno><![CDATA[" . $row["vatno"] . "]]></str_vatno>";
        $ResponseXML .= "<str_svatno><![CDATA[" . $row["svatno"] . "]]></str_svatno>";
        $ResponseXML .= "<AltMessage><![CDATA[" . $row["AltMessage"] . "]]></AltMessage>";
    }

    $cuscode = $_GET["custno"];
    $RET_AMOUNT = 0;
    $PD_AMOUNT = 0;
    $OUT_AMOUNT = 0;

    $sql = $dbinv->query("select * from vendor where CODE = '" . trim($cuscode) . "'") or die("Error";
    if ($row = $sql->fetch()) {

        $sqlchq = $dbinv->query("SELECT che_amount FROM s_invcheq WHERE che_date>'" . date("Y-m-d") . "' AND cus_code='" . $row["CODE"] . "'") or die("Error";

        while ($rowchq = $sqlchq->fetch()) {
            $PD_AMOUNT = $PD_AMOUNT + $rowchq["che_amount"];
        }

        /* if (is_null($row["AltMessage"])==false ){
          if (trim($row["AltMessage"]) != ""){
          $ResponseXML .= "<AltMessage><![CDATA[".$row['AltMessage']."]]></AltMessage>";
          }
          } */

        if ($row["chk_bangr"] == "1") {

            $dateDiff = $row["bank_gr_date"] - date("Y-m-d");
            $m_dates = floor($dateDiff / (60 * 60 * 24));
            if ($m_dates > 30 and $m_dates < 60) {
                $ResponseXML .= "<bank_message><![CDATA[Please Re-New Bank Grantee Date]]></bank_message>";
                $_SESSION["inv_status"] = 0;
            } else if ($m_dates <= 30) {
                $ResponseXML .= "<bank_message><![CDATA[No Permission For Invoice For This Customer Please Re-New Bank Grantee Date]]></bank_message>";
                $_SESSION["inv_status"] = 0;
            }
        } else {
            $ResponseXML .= "<bank_message><![CDATA[]]></bank_message>";
        }

        $sql60 = $dbinv->query("select SDATE from  s_salma where  C_CODE='" . trim($cuscode) . "' and GRAND_TOT-TOTPAY >1 and CANCELL=0  order by SDATE") or die("Error";
        if ($row60 = $sql60->fetch()) {
            //$mtmp = date("Y-m-d") - $row60["SDATE"];
            //$mdays= floor($mtmp/(60*60*24));

            $date1 = $row60["SDATE"];
            $date2 = date("Y-m-d");

            $diff = abs(strtotime($date2) - strtotime($date1));

            $years = floor($diff / (365 * 60 * 60 * 24));

            $months = floor(($diff - $years * 365 * 60 * 60 * 24) / (30 * 60 * 60 * 24));

            $mday = floor(($diff - $years * 365 * 60 * 60 * 24 - $months * 30 * 60 * 60 * 24) / (60 * 60 * 24));
            $mdays = $mday + ($months * 30) + ($years * 365);

            if ($mdays > 60) {
                $ResponseXML .= "<over60_message><![CDATA[Over 60 Outsnding Avilabale]]></over60_message>";
                $_SESSION["inv_status"] = 0;
                if (is_null($row["Over_DUE_IG_Date"]) == false) {
                    if ($row["Over_DUE_IG_Date"] == date("Y-m-d")) {
                        $ResponseXML .= "<over60_qst><![CDATA[This is Over 60 Days Customer Do you want to Proceed]]></over60_qst>";
                        $sqltmpCrLmt = $dbinv->query("insert into tmpcrlmt (sdate,username, stime, tmpLmt, Class, Rep,cuscode, crLmt,  FLAG) values ('" . date("Y-m-d") . "','" . $_SESSION["CURRENT_USER"] . "','" . date("h:i:s") . "' , " . $mdays . " ,'NB','NR','" . trim($cuscode) . "','0', 'O60')") or die("Error";
                    } else {
                        $ResponseXML .= "<over60_qst><![CDATA[]]></over60_qst>";
                    }
                } else {
                    $ResponseXML .= "<over60_qst><![CDATA[]]></over60_qst>";
                }
            } else {
                $ResponseXML .= "<over60_message><![CDATA[]]></over60_message>";
            }
        } else {
            $ResponseXML .= "<over60_message><![CDATA[]]></over60_message>";
            $ResponseXML .= "<over60_qst><![CDATA[]]></over60_qst>";
        }

        $sqls_cheq = $dbinv->query("Select * from s_cheq where CR_CHEVAL-PAID>0 and CR_FLAG='0' and CR_C_CODE='" . trim($cuscode) . "'") or die("Error";
        if ($rows_cheq = $sqls_cheq->fetch()) {
            $ResponseXML .= "<chq_message><![CDATA[Return Cheque]]></chq_message>";
            $_SESSION["inv_status"] = 0;

            if (is_null($row["Over_DUE_IG_Date"]) == false) {
                if ($row["Over_DUE_IG_Date"] == date("Y-m-d")) {
                    $ResponseXML .= "<chq_message_que><![CDATA[Do You Want To Continue with Return Cheques]]></chq_message_que>";

                    $sqltmpCrLmt = $dbinv->query("insert into tmpcrlmt (sdate,username, stime, tmpLmt, Class, Rep,cuscode, crLmt, FLAG) values ('" . date("Y-m-d") . "','" . $_SESSION["CURRENT_USER"] . "', '" . date("h:i:s") . "', '0' ,'NB','NR','" . trim($cuscode) . "','0', 'RTN'") or die("Error";
                } else {
                    $ResponseXML .= "<chq_message_que><![CDATA[]]></chq_message_que>";
                }
            }
        } else {
            $ResponseXML .= "<chq_message><![CDATA[]]></chq_message>";
            $ResponseXML .= "<chq_message_que><![CDATA[]]></chq_message_que>";
        }

        if (is_null($row["cLIMIT"]) == false) {
            $ResponseXML .= "<txt_crelimi><![CDATA[" . number_format($row['cLIMIT'] + $row['temp_limit'], 2, ".", ",") . "]]></txt_crelimi>";
        }

        if (is_null($row["CUR_BAL"]) == false) {
            $OUT_AMOUNT = $row["CUR_BAL"];
        }

        if (is_null($row["CAT"]) == false) {
            $cuscat = $row["CAT"];
        }

        $sqlretchq = $dbinv->query("Select * from s_cheq where CR_C_CODE='" . trim($cuscode) . "' and CR_CHEVAL-PAID>0 and CR_FLAG='0'") or die("Error";
        while ($rowretchq = $sqlretchq->fetch()) {
            $RET_AMOUNT = $RET_AMOUNT + $rowretchq["CR_CHEVAL"] - $rowretchq["PAID"];
        }
    }

    //Call SETLIMIT ====================================================================

    $OutpDAMT = 0;
    $OutREtAmt = 0;
    $OutInvAmt = 0;
    $InvClass = "";
    //echo "select class from brand_mas where barnd_name='".trim($_GET["brand"])."'";
    $sqlclass = $dbinv->query("select class from brand_mas where barnd_name='" . trim($_GET["brand"]) . "'") or die("Error";
    if ($rowclass = $sqlclass->fetch()) {
        if (is_null($rowclass["class"]) == false) {
            $InvClass = $rowclass["class"];
        }
    }
    //echo $InvClass;
    //echo "select sum(GRAND_TOT-TOTPAY) as totout from view_s_salma where GRAND_TOT>TOTPAY and CANCELL='0' and C_CODE='".trim($cuscode)."' and SAL_EX='".trim($_GET["salesrep"])."' and class='".$InvClass."'";
    $sqloutinv = $dbinv->query("select sum(GRAND_TOT-TOTPAY) as totout from view_s_salma where GRAND_TOT>TOTPAY and CANCELL='0' and C_CODE='" . trim($cuscode) . "' and SAL_EX='" . trim($_GET["salesrep"]) . "' and class='" . $InvClass . "'") or die("Error";
    if ($rowoutinv = $sqloutinv->fetch()) {
        if (is_null($rowoutinv["totout"]) == false) {
            $OutInvAmt = $rowoutinv["totout"];
        }
    }
    //echo $OutInvAmt;
    //echo "SELECT * FROM s_invcheq WHERE che_date>'".date("Y-m-d")."' AND cus_code='".trim($cuscode)."' and trn_type='REC' and sal_ex='".trim($_GET["salesrep"])."'";
    $sqlinvcheq = $dbinv->query("SELECT * FROM s_invcheq WHERE che_date>'" . date("Y-m-d") . "' AND cus_code='" . trim($cuscode) . "' and trn_type='REC' and sal_ex='" . trim($_GET["salesrep"]) . "'") or die("Error";
    while ($rowinvcheq = $sqlinvcheq->fetch()) {
        //echo "select * from s_sttr where ST_REFNO='".trim($rowinvcheq["refno"])."' and ST_CHNO ='".trim($rowinvcheq["cheque_no"]) ."'";
        $sqlsttr = $dbinv->query("select * from s_sttr where ST_REFNO='" . trim($rowinvcheq["refno"]) . "' and ST_CHNO ='" . trim($rowinvcheq["cheque_no"]) . "'") or die("Error";
        while ($rowsttr = $sqlsttr->fetch()) {
            //echo "select class from view_s_salma where REF_NO='".trim($rowsttr["ST_INVONO"])."'";
            $sqlview_s_salma = $dbinv->query("select class from view_s_salma where REF_NO='" . trim($rowsttr["ST_INVONO"]) . "'") or die("Error";
            if ($rowview_s_salma = $sqlview_s_salma->fetch()) {
                if (trim($rowview_s_salma["class"]) == $InvClass) {
                    $OutpDAMT = $OutpDAMT + $rowsttr["ST_PAID"];
                }
            }
        }
    }

    $pend_ret_set = 0;
    $sqlinvcheq = $dbinv->query("SELECT sum(che_amount) as  che_amount FROM S_INVCHeQ WHERE che_date >'" . date("Y-m-d") . "' AND cus_code='" . trim($cuscode) . "' and trn_type='RET'") or die("Error";
    if ($rowinvcheq = $sqlinvcheq->fetch()) {
        if (is_null($rowinvcheq["che_amount"]) == false) {
            $pend_ret_set = $rowinvcheq["che_amount"];
        }
    }
    //echo "Select sum(CR_CHEVAL-PAID) as tot from s_cheq where CR_C_CODE='".trim($cuscode)."'  and CR_CHEVAL-PAID>0 and CR_FLAG='0' and S_REF='".trim($_GET["salesrep"])."'";
    $sqlcheq = $dbinv->query("Select sum(CR_CHEVAL-PAID) as tot from s_cheq where CR_C_CODE='" . trim($cuscode) . "'  and CR_CHEVAL-PAID>0 and CR_FLAG='0' and S_REF='" . trim($_GET["salesrep"]) . "'") or die("Error";
    if ($rowcheq = $sqlcheq->fetch()) {
        if (is_null($rowcheq["tot"]) == false) {
            $OutREtAmt = $rowcheq["tot"];
            $ResponseXML .= "<msg_return><![CDATA[Return Cheques Available]]></msg_return>";
        } else {
            $OutREtAmt = 0;
            $ResponseXML .= "<msg_return><![CDATA[]]></msg_return>";
        }
    } else {
        $ResponseXML .= "<msg_return><![CDATA[]]></msg_return>";
    }

    $ResponseXML .= "<sales_table_acc><![CDATA[ <table  border=0  cellspacing=0>
						<tr><td><input type=\"text\"  class=\"text_purchase3\" value=\"Outstanding Invoice Amount\" disabled=\"disabled\"/></td><td><input type=\"text\"  class=\"\" value=\"" . number_format($OutInvAmt, 2, ".", ",") . "\" disabled=\"disabled\"/></td></tr>
						 <td><input type=\"text\"  class=\"text_purchase3\" value=\"Return Cheque Amount\" disabled=\"disabled\"/></td><td><input type=\"text\"  class=\"\" value=\"" . number_format($OutREtAmt, 2, ".", ",") . "\" disabled=\"disabled\"/></td></tr>
						 <td><input type=\"text\"  class=\"text_purchase3\" value=\"Pending Cheque Amount\" disabled=\"disabled\"/></td><td><input type=\"text\"  class=\"\" value=\"" . number_format($OutpDAMT, 2, ".", ",") . "\" disabled=\"disabled\"/></td></tr>
						 <td><input type=\"text\"  class=\"text_purchase3\" value=\"PSD Cheque Settlments\" disabled=\"disabled\"/></td><td><input type=\"text\"  class=\"\" value=\"" . number_format($pend_ret_set, 2, ".", ",") . "\" disabled=\"disabled\"/></td></tr>
						 <td><input type=\"text\"  class=\"text_purchase3\" value=\"Total\" disabled=\"disabled\"/></td><td><input type=\"text\"  class=\"\" value=\"" . number_format($OutInvAmt + $OutREtAmt + $OutpDAMT + $pend_ret_set, 2, ".", ",") . "\" disabled=\"disabled\"/></td></tr>
						 </table></table>]]></sales_table_acc>";

    $sqlbr_trn = $dbinv->query("select * from br_trn where rep='" . trim($_GET["salesrep"]) . "' and brand='" . trim($InvClass) . "' and cus_code='" . trim($cuscode) . "'") or die("Error";
    if ($rowbr_trn = $sqlbr_trn->fetch()) {
        if (is_null($rowbr_trn["credit_lim"]) == false) {
            $crLmt = $rowbr_trn["credit_lim"];
        } else {
            $crLmt = 0;
        }

        if (is_null($rowbr_trn["tmpLmt"]) == false) {
            $tmpLmt = $rowbr_trn["tmpLmt"];
        } else {
            $tmpLmt = 0;
        }

        if (is_null($rowbr_trn["CAT"]) == false) {
            $cuscat = trim($rowbr_trn["CAT"]);
            if ($cuscat == "A") {
                $m = 2.5;
            }
            if ($cuscat == "B") {
                $m = 2.5;
            }
            if ($cuscat == "C") {
                $m = 1;
            }
            if ($cuscat == "D") {
                $m = 0;
            }

            $txt_crelimi = 0;
            $txt_crebal = 0;
            $txt_crelimi = number_format($crLmt, 2, ".", ",");
            //$crebal=$crLmt * $m + $tmpLmt - $OutInvAmt - $OutREtAmt - $OutpDAMT - $pend_ret_set;
            $txt_crebal = $crLmt * $m - $OutInvAmt - $OutREtAmt - $OutpDAMT - $pend_ret_set;
            $crebal = $crLmt * $m + $tmpLmt - $OutInvAmt - $OutREtAmt - $OutpDAMT - $pend_ret_set;

            //$txt_crebal = number_format($crebal, "2", ".", ",");
        } else {
            $txt_crelimi = 0;
            $txt_crebal = 0;
        }
        $creditbalance = $OutInvAmt + $OutREtAmt + $OutpDAMT;
    }
    $ResponseXML .= "<txt_crelimi><![CDATA[" . $txt_crelimi . "]]></txt_crelimi>";
    $ResponseXML .= "<txt_crebal><![CDATA[" . number_format($txt_crebal, "2", ".", ",") . "]]></txt_crebal>";

    $ResponseXML .= "<creditbalance><![CDATA[" . $creditbalance . "]]></creditbalance>";

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

if ($_GET["Command"] == "pass_cusno") {

    /* 	$sql = $dbinv->query("DROP VIEW view_s_salma") or die("Error";
      $sql = mysql_query("CREATE VIEW view_s_salma
      AS
      SELECT     s_salma.*, brand_mas.class AS class
      FROM         brand_mas RIGHT OUTER JOIN
      s_salma ON brand_mas.barnd_name = s_salma.brand") or die("Error"; */

    $_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 = $dbinv->query("Select * from vendor where CODE='" . $cuscode . "'") or die("Error";
    if ($row = $sql->fetch()) {

        $ResponseXML .= "<id><![CDATA[" . $row['CODE'] . "]]></id>";
        $ResponseXML .= "<str_customername><![CDATA[" . trim($row['NAME']) . "]]></str_customername>";
        $address = trim($row['ADD1']) . ",  " . trim($row['ADD2']);
        $ResponseXML .= "<str_address><![CDATA[" . trim($address) . "]]></str_address>";
        $ResponseXML .= "<str_vatno><![CDATA[" . trim($row["vatno"]) . "]]></str_vatno>";
        $ResponseXML .= "<str_svatno><![CDATA[" . trim($row["svatno"]) . "]]></str_svatno>";
        $ResponseXML .= "<AltMessage><![CDATA[" . $row["AltMessage"] . "]]></AltMessage>";
        $ResponseXML .= "<blacklist><![CDATA[" . $row['blacklist'] . "]]></blacklist>";
    }

    $cuscode = $_GET["custno"];
    $RET_AMOUNT = 0;
    $PD_AMOUNT = 0;
    $OUT_AMOUNT = 0;

    $sql = $dbinv->query("select * from vendor where CODE = '" . trim($cuscode) . "'") or die("Error";
    if ($row = $sql->fetch()) {

        $sqlchq = $dbinv->query("SELECT che_amount FROM s_invcheq WHERE che_date>'" . date("Y-m-d") . "' AND cus_code='" . $row["CODE"] . "'") or die("Error";

        while ($rowchq = $sqlchq->fetch()) {
            $PD_AMOUNT = $PD_AMOUNT + $rowchq["che_amount"];
        }

        /* if (is_null($row["AltMessage"])==false ){
          if (trim($row["AltMessage"]) != ""){
          $ResponseXML .= "<AltMessage><![CDATA[".$row['AltMessage']."]]></AltMessage>";
          }
          } */

        if ($row["chk_bangr"] == "1") {

            $dateDiff = $row["bank_gr_date"] - date("Y-m-d");
            $m_dates = floor($dateDiff / (60 * 60 * 24));
            if ($m_dates > 30 and $m_dates < 60) {
                $ResponseXML .= "<bank_message><![CDATA[Please Re-New Bank Grantee Date]]></bank_message>";
                $_SESSION["inv_status"] = 0;
            } else if ($m_dates <= 30) {
                $ResponseXML .= "<bank_message><![CDATA[No Permission For Invoice For This Customer Please Re-New Bank Grantee Date]]></bank_message>";
                $_SESSION["inv_status"] = 0;
            }
        } else {
            $ResponseXML .= "<bank_message><![CDATA[]]></bank_message>";
        }

        $sql60 = $dbinv->query("select SDATE from  s_salma where  C_CODE='" . trim($cuscode) . "' and GRAND_TOT-TOTPAY >1 and CANCELL=0  order by SDATE") or die("Error";
        if ($row60 = $sql60->fetch()) {
            //$mtmp = date("Y-m-d") - $row60["SDATE"];
            //$mdays= floor($mtmp/(60*60*24));

            $date1 = $row60["SDATE"];
            $date2 = date("Y-m-d");

            $diff = abs(strtotime($date2) - strtotime($date1));

            $years = floor($diff / (365 * 60 * 60 * 24));

            $months = floor(($diff - $years * 365 * 60 * 60 * 24) / (30 * 60 * 60 * 24));

            $mday = floor(($diff - $years * 365 * 60 * 60 * 24 - $months * 30 * 60 * 60 * 24) / (60 * 60 * 24));
            $mdays = $mday + ($months * 30) + ($years * 365);

            if ($mdays > 60) {
                $ResponseXML .= "<over60_message><![CDATA[Over 60 Outsnding Avilabale]]></over60_message>";
                $ResponseXML .= "<over60_txt><![CDATA[60]]></over60_txt>";
                $_SESSION["inv_status"] = 0;
                if (is_null($row["Over_DUE_IG_Date"]) == false) {
                    if ($row["Over_DUE_IG_Date"] == date("Y-m-d")) {
                        $ResponseXML .= "<over60_qst><![CDATA[This is Over 60 Days Customer Do you want to Proceed]]></over60_qst>";

                        $sqltmpCrLmt = $dbinv->query("insert into tmpcrlmt (sdate,username, stime, tmpLmt, Class, Rep,cusCode, crLmt,  FLAG) values ('" . date("Y-m-d") . "','" . $_SESSION["CURRENT_USER"] . "','" . date("h:i:s") . "' , " . $mdays . " ,'NB','NR','" . trim($cuscode) . "','0', 'O60')") or die("Error";
                    } else {
                        $ResponseXML .= "<over60_qst><![CDATA[]]></over60_qst>";
                    }
                } else {
                    $ResponseXML .= "<over60_qst><![CDATA[]]></over60_qst>";
                }
            } else {
                $ResponseXML .= "<over60_message><![CDATA[]]></over60_message>";
                $ResponseXML .= "<over60_txt><![CDATA[0]]></over60_txt>";
                $ResponseXML .= "<over60_qst><![CDATA[]]></over60_qst>";
            }
        } else {
            $ResponseXML .= "<over60_message><![CDATA[]]></over60_message>";
            $ResponseXML .= "<over60_qst><![CDATA[]]></over60_qst>";
            $ResponseXML .= "<over60_txt><![CDATA[0]]></over60_txt>";
        }

        $sqls_cheq = $dbinv->query("Select * from s_cheq where CR_CHEVAL-PAID>0 and CR_FLAG='0' and CR_C_CODE='" . trim($cuscode) . "'") or die("Error";
        if ($rows_cheq = $sqls_cheq->fetch()) {
            $ResponseXML .= "<chq_message><![CDATA[Return Cheque]]></chq_message>";
            $_SESSION["inv_status"] = 0;

            if (is_null($row["Over_DUE_IG_Date"]) == false) {
                if ($row["Over_DUE_IG_Date"] == date("Y-m-d")) {
                    $ResponseXML .= "<chq_message_que><![CDATA[Do You Want To Continue with Return Cheques]]></chq_message_que>";

                    $sqltmpCrLmt = $dbinv->query("insert into tmpcrlmt (sdate,username, stime, tmpLmt, Class, Rep,cuscode, crLmt, FLAG) values ('" . date("Y-m-d") . "','" . $_SESSION["CURRENT_USER"] . "','" . date("h:i:s") . "', '0' ,'NB','NR','" . trim($cuscode) . "','0', 'RTN')") or die("Error";
                } else {
                    $ResponseXML .= "<chq_message_que><![CDATA[]]></chq_message_que>";
                }
            }
        } else {
            $ResponseXML .= "<chq_message><![CDATA[]]></chq_message>";
            $ResponseXML .= "<chq_message_que><![CDATA[]]></chq_message_que>";
        }

        if (is_null($row["cLIMIT"]) == false) {
            $ResponseXML .= "<txt_crelimi><![CDATA[" . number_format($row['cLIMIT'] + $row['temp_limit'], 2, ".", ",") . "]]></txt_crelimi>";
        }

        if (is_null($row["CUR_BAL"]) == false) {
            $OUT_AMOUNT = $row["CUR_BAL"];
        }

        if (is_null($row["CAT"]) == false) {
            $cuscat = $row["CAT"];
        }

        $sqlretchq = $dbinv->query("Select * from s_cheq where CR_C_CODE='" . trim($cuscode) . "' and CR_CHEVAL-PAID>0 and CR_FLAG='0'") or die("Error";
        while ($rowretchq = $sqlretchq->fetch()) {
            $RET_AMOUNT = $RET_AMOUNT + $rowretchq["CR_CHEVAL"] - $rowretchq["PAID"];
        }
    }

    //Call SETLIMIT ====================================================================

    $OutpDAMT = 0;
    $OutREtAmt = 0;
    $OutInvAmt = 0;
    $InvClass = "";
    //echo "select class from brand_mas where barnd_name='".trim($_GET["brand"])."'";
    $sqlclass = $dbinv->query("select class from brand_mas where barnd_name='" . trim($_GET["brand"]) . "'") or die("Error";
    if ($rowclass = $sqlclass->fetch()) {
        if (is_null($rowclass["class"]) == false) {
            $InvClass = $rowclass["class"];
        }
    }
    //echo $InvClass;
    //echo "select sum(GRAND_TOT-TOTPAY) as totout from view_s_salma where GRAND_TOT>TOTPAY and CANCELL='0' and C_CODE='".trim($cuscode)."' and SAL_EX='".trim($_GET["salesrep"])."' and class='".$InvClass."'";
    $sqloutinv = $dbinv->query("select sum(GRAND_TOT-TOTPAY) as totout from view_s_salma where GRAND_TOT>TOTPAY and CANCELL='0' and C_CODE='" . trim($cuscode) . "' and SAL_EX='" . trim($_GET["salesrep"]) . "' and class='" . $InvClass . "'") or die("Error";
    if ($rowoutinv = $sqloutinv->fetch()) {
        if (is_null($rowoutinv["totout"]) == false) {
            $OutInvAmt = $rowoutinv["totout"];
        }
    }
    //echo $OutInvAmt;
    //echo "SELECT * FROM s_invcheq WHERE che_date>'".date("Y-m-d")."' AND cus_code='".trim($cuscode)."' and trn_type='REC' and sal_ex='".trim($_GET["salesrep"])."'";
    $sqlinvcheq = $dbinv->query("SELECT * FROM s_invcheq WHERE che_date>'" . date("Y-m-d") . "' AND cus_code='" . trim($cuscode) . "' and trn_type='REC' and sal_ex='" . trim($_GET["salesrep"]) . "'") or die("Error";
    while ($rowinvcheq = $sqlinvcheq->fetch()) {
        //echo "select * from s_sttr where ST_REFNO='".trim($rowinvcheq["refno"])."' and ST_CHNO ='".trim($rowinvcheq["cheque_no"]) ."'";
        $sqlsttr = $dbinv->query("select * from s_sttr where ST_REFNO='" . trim($rowinvcheq["refno"]) . "' and ST_CHNO ='" . trim($rowinvcheq["cheque_no"]) . "'") or die("Error";
        while ($rowsttr = $sqlsttr->fetch()) {
            //echo "select class from view_s_salma where REF_NO='".trim($rowsttr["ST_INVONO"])."'";
            $sqlview_s_salma = $dbinv->query("select class from view_s_salma where REF_NO='" . trim($rowsttr["ST_INVONO"]) . "'") or die("Error";
            if ($rowview_s_salma = $sqlview_s_salma->fetch()) {
                if (trim($rowview_s_salma["class"]) == $InvClass) {
                    $OutpDAMT = $OutpDAMT + $rowsttr["ST_PAID"];
                }
            }
        }
    }

    $pend_ret_set = 0;
    $sqlinvcheq = $dbinv->query("SELECT sum(che_amount) as  che_amount FROM s_invcheq WHERE che_date >'" . date("Y-m-d") . "' AND cus_code='" . trim($cuscode) . "' and trn_type='RET'") or die("Error";
    if ($rowinvcheq = $sqlinvcheq->fetch()) {
        if (is_null($rowinvcheq["che_amount"]) == false) {
            $pend_ret_set = $rowinvcheq["che_amount"];
        }
    }
    //echo "Select sum(CR_CHEVAL-PAID) as tot from s_cheq where CR_C_CODE='".trim($cuscode)."'  and CR_CHEVAL-PAID>0 and CR_FLAG='0' and S_REF='".trim($_GET["salesrep"])."'";
    $sqlcheq = $dbinv->query("Select sum(CR_CHEVAL-PAID) as tot from s_cheq where CR_C_CODE='" . trim($cuscode) . "'  and CR_CHEVAL-PAID>0 and CR_FLAG='0' and S_REF='" . trim($_GET["salesrep"]) . "'") or die("Error";
    if ($rowcheq = $sqlcheq->fetch()) {
        if (is_null($rowcheq["tot"]) == false) {
            $OutREtAmt = $rowcheq["tot"];
            $ResponseXML .= "<msg_return><![CDATA[Return Cheques Available]]></msg_return>";
        } else {
            $OutREtAmt = 0;
            $ResponseXML .= "<msg_return><![CDATA[]]></msg_return>";
        }
    } else {
        $ResponseXML .= "<msg_return><![CDATA[]]></msg_return>";
    }

    $ResponseXML .= "<sales_table_acc><![CDATA[ <table  border=0  cellspacing=0>
						<tr><td><input type=\"text\"  class=\"text_purchase3\" value=\"Outstanding Invoice Amount\" disabled=\"disabled\"/></td><td><input type=\"text\"  class=\"\" value=\"" . number_format($OutInvAmt, 2, ".", ",") . "\" disabled=\"disabled\"/></td></tr>
						 <td><input type=\"text\"  class=\"text_purchase3\" value=\"Return Cheque Amount\" disabled=\"disabled\"/></td><td><input type=\"text\"  class=\"\" value=\"" . number_format($OutREtAmt, 2, ".", ",") . "\" disabled=\"disabled\"/></td></tr>
						 <td><input type=\"text\"  class=\"text_purchase3\" value=\"Pending Cheque Amount\" disabled=\"disabled\"/></td><td><input type=\"text\"  class=\"\" value=\"" . number_format($OutpDAMT, 2, ".", ",") . "\" disabled=\"disabled\"/></td></tr>
						 <td><input type=\"text\"  class=\"text_purchase3\" value=\"PSD Cheque Settlments\" disabled=\"disabled\"/></td><td><input type=\"text\"  class=\"\" value=\"" . number_format($pend_ret_set, 2, ".", ",") . "\" disabled=\"disabled\"/></td></tr>
						 <td><input type=\"text\"  class=\"text_purchase3\" value=\"Total\" disabled=\"disabled\"/></td><td><input type=\"text\"  class=\"\" value=\"" . number_format($OutInvAmt + $OutREtAmt + $OutpDAMT + $pend_ret_set, 2, ".", ",") . "\" disabled=\"disabled\"/></td></tr>
						 </table></table>]]></sales_table_acc>";

    $sqlbr_trn = $dbinv->query("select * from br_trn where rep='" . trim($_GET["salesrep"]) . "' and brand='" . trim($InvClass) . "' and cus_code='" . trim($cuscode) . "'") or die("Error";
    if ($rowbr_trn = $sqlbr_trn->fetch()) {
        if (is_null($rowbr_trn["credit_lim"]) == false) {
            $crLmt = $rowbr_trn["credit_lim"];
        } else {
            $crLmt = 0;
        }

        if (is_null($rowbr_trn["tmpLmt"]) == false) {
            $tmpLmt = $rowbr_trn["tmpLmt"];
        } else {
            $tmpLmt = 0;
        }

        if (is_null($rowbr_trn["CAT"]) == false) {
            $cuscat = trim($rowbr_trn["CAT"]);
            if ($cuscat == "A") {
                $m = 2.5;
            }
            if ($cuscat == "B") {
                $m = 2.5;
            }
            if ($cuscat == "C") {
                $m = 1;
            }
            if ($cuscat == "D") {
                $m = 0;
            }

            $txt_crelimi = 0;
            $txt_crebal = 0;
            $txt_crelimi = number_format($crLmt, 2, ".", ",");
            //$crebal=$crLmt * $m + $tmpLmt - $OutInvAmt - $OutREtAmt - $OutpDAMT - $pend_ret_set;
            $txt_crebal = $crLmt * $m - $OutInvAmt - $OutREtAmt - $OutpDAMT - $pend_ret_set;
            $crebal = $crLmt * $m + $tmpLmt - $OutInvAmt - $OutREtAmt - $OutpDAMT - $pend_ret_set;

            //$txt_crebal = number_format($crebal, "2", ".", ",");
        } else {
            $txt_crelimi = 0;
            $txt_crebal = 0;
        }
        $creditbalance = $OutInvAmt + $OutREtAmt + $OutpDAMT;
    }
    $ResponseXML .= "<txt_crelimi><![CDATA[" . $txt_crelimi . "]]></txt_crelimi>";
    $ResponseXML .= "<txt_crebal><![CDATA[" . number_format($txt_crebal, "2", ".", ",") . "]]></txt_crebal>";
    $ResponseXML .= "<crebal><![CDATA[" . number_format($crebal, "2", ".", ",") . "]]></crebal>";

    $ResponseXML .= "<creditbalance><![CDATA[" . $creditbalance . "]]></creditbalance>";

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

if ($_GET["Command"] == "pass_modify") {

    $_SESSION["custno"] = $_GET['custno'];

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

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

    $sql = $dbinv->query("Select * from vendor where CODE='" . $_GET['custno'] . "'") or die("Error";
    if ($row = $sql->fetch()) {

        $ResponseXML .= "<id><![CDATA[" . $row['CODE'] . "]]></id>";
        $ResponseXML .= "<NAME><![CDATA[" . $row['NAME'] . "]]></NAME>";
        $ResponseXML .= "<ADD1><![CDATA[" . $row['ADD1'] . "]]></ADD1>";
        $ResponseXML .= "<ADD2><![CDATA[" . $row['ADD2'] . "]]></ADD2>";
    }

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

if ($_GET["Command"] == "pass_crn") {

    $_SESSION["custno"] = $_GET['custno'];

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

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

    $sql = $dbinv->query("Select * from vendor where CODE='" . $_GET['custno'] . "'") or die("Error";
    if ($row = $sql->fetch()) {

        $ResponseXML .= "<id><![CDATA[" . $row['CODE'] . "]]></id>";
        $ResponseXML .= "<NAME><![CDATA[" . $row['NAME'] . "]]></NAME>";
        $ResponseXML .= "<ADD1><![CDATA[" . $row['ADD1'] . "]]></ADD1>";
        $ResponseXML .= "<ADD2><![CDATA[" . $row['ADD2'] . "]]></ADD2>";
    }

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

if ($_GET["Command"] == "rep_outstand_state") {

    $_SESSION["custno"] = $_GET['custno'];

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

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

    $sql = $dbinv->query("Select * from vendor where CODE='" . $_GET['custno'] . "'") or die("Error";
    if ($row = $sql->fetch()) {

        $ResponseXML .= "<id><![CDATA[" . $row['CODE'] . "]]></id>";
        $ResponseXML .= "<NAME><![CDATA[" . $row['NAME'] . "]]></NAME>";
        $ResponseXML .= "<ADD1><![CDATA[" . $row['ADD1'] . "]]></ADD1>";
        $ResponseXML .= "<ADD2><![CDATA[" . $row['ADD2'] . "]]></ADD2>";
    }

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

if ($_GET["Command"] == "rep_settlement") {

    $_SESSION["custno"] = $_GET['custno'];

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

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

    $sql = $dbinv->query("Select * from vendor where CODE='" . $_GET['custno'] . "'") or die("Error";
    if ($row = $sql->fetch()) {

        $ResponseXML .= "<id><![CDATA[" . $row['CODE'] . "]]></id>";
        $ResponseXML .= "<NAME><![CDATA[" . $row['NAME'] . "]]></NAME>";
    }

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

if ($_GET["Command"] == "defective_item") {

    $_SESSION["custno"] = $_GET['custno'];

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

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

    $sql = $dbinv->query("Select * from vendor where CODE='" . $_GET['custno'] . "'") or die("Error";
    if ($row = $sql->fetch()) {

        $ResponseXML .= "<id><![CDATA[" . $row['CODE'] . "]]></id>";
        $ResponseXML .= "<NAME><![CDATA[" . $row['NAME'] . "]]></NAME>";
        $ResponseXML .= "<ADD1><![CDATA[" . $row['ADD1'] . "]]></ADD1>";
        $ResponseXML .= "<ADD2><![CDATA[" . $row['ADD2'] . "]]></ADD2>";
        $ResponseXML .= "<str_vatno><![CDATA[" . trim($row["vatno"]) . "]]></str_vatno>";
        $ResponseXML .= "<str_svatno><![CDATA[" . trim($row["svatno"]) . "]]></str_svatno>";
    }

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

if ($_GET["Command"] == "incentive") {

    $_SESSION["custno"] = $_GET['custno'];

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

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

    $sql = $dbinv->query("Select * from vendor where CODE='" . $_GET['custno'] . "'") or die("Error";
    if ($row = $sql->fetch()) {

        $ResponseXML .= "<id><![CDATA[" . $row['CODE'] . "]]></id>";
        $ResponseXML .= "<NAME><![CDATA[" . $row['NAME'] . "]]></NAME>";
        $ResponseXML .= "<ADD1><![CDATA[" . $row['ADD1'] . "]]></ADD1>";
        $ResponseXML .= "<ADD2><![CDATA[" . $row['ADD2'] . "]]></ADD2>";
    }

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

if ($_GET["Command"] == "incentive2") {

    $_SESSION["custno"] = $_GET['custno'];

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

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

    $sql = $dbinv->query("Select * from vendor where CODE='" . $_GET['custno'] . "'") or die("Error";
    if ($row = $sql->fetch()) {

        $ResponseXML .= "<id><![CDATA[" . $row['CODE'] . "]]></id>";
        $ResponseXML .= "<NAME><![CDATA[" . $row['NAME'] . "]]></NAME>";
        $ResponseXML .= "<ADD1><![CDATA[" . $row['ADD1'] . "]]></ADD1>";
        $ResponseXML .= "<ADD2><![CDATA[" . $row['ADD2'] . "]]></ADD2>";
    }

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

if ($_GET["Command"] == "bin_card") {

    $_SESSION["custno"] = $_GET['custno'];

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

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

    $sql = $dbinv->query("Select * from vendor where CODE='" . $_GET['custno'] . "'") or die("Error";
    if ($row = $sql->fetch()) {

        $ResponseXML .= "<id><![CDATA[" . $row['CODE'] . "]]></id>";
        $ResponseXML .= "<NAME><![CDATA[" . $row['NAME'] . "]]></NAME>";
    }

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

if ($_GET["Command"] == "rep_dealercard") {

    $_SESSION["custno"] = $_GET['custno'];

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

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

    $sql = $dbinv->query("Select * from vendor where CODE='" . $_GET['custno'] . "'") or die("Error";
    if ($row = $sql->fetch()) {

        $ResponseXML .= "<id><![CDATA[" . $row['CODE'] . "]]></id>";
        $ResponseXML .= "<NAME><![CDATA[" . $row['NAME'] . "]]></NAME>";
    }

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

if ($_GET["Command"] == "weekly_ord") {

    $_SESSION["custno"] = $_GET['custno'];

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

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

    $sql = $dbinv->query("Select * from vendor where CODE='" . $_GET['custno'] . "'") or die("Error";
    if ($row = $sql->fetch()) {

        $ResponseXML .= "<id><![CDATA[" . $row['CODE'] . "]]></id>";
        $ResponseXML .= "<NAME><![CDATA[" . $row['NAME'] . "]]></NAME>";
        $ResponseXML .= "<ADD1><![CDATA[" . $row['ADD1'] . "]]></ADD1>";
        $ResponseXML .= "<ADD2><![CDATA[" . $row['ADD2'] . "]]></ADD2>";
        $ResponseXML .= "<vatno><![CDATA[" . $row['vatno'] . "]]></vatno>";
        $ResponseXML .= "<svatno><![CDATA[" . $row['svatno'] . "]]></svatno>";
    }

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

if ($_GET["Command"] == "weekly_tar") {

    $_SESSION["custno"] = $_GET['custno'];

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

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

    $sql = $dbinv->query("Select * from vendor where CODE='" . $_GET['custno'] . "'") or die("Error";
    if ($row = $sql->fetch()) {

        $ResponseXML .= "<id><![CDATA[" . $row['CODE'] . "]]></id>";
        $ResponseXML .= "<NAME><![CDATA[" . $row['NAME'] . "]]></NAME>";
        $ResponseXML .= "<ADD1><![CDATA[" . $row['ADD1'] . "]]></ADD1>";
        $ResponseXML .= "<ADD2><![CDATA[" . $row['ADD2'] . "]]></ADD2>";
        $ResponseXML .= "<vatno><![CDATA[" . $row['vatno'] . "]]></vatno>";
        $ResponseXML .= "<svatno><![CDATA[" . $row['svatno'] . "]]></svatno>";
    }

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

if ($_GET["Command"] == "pass_utilization") {

    $_SESSION["custno"] = $_GET['custno'];

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

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

    $sql = $dbinv->query("Select * from vendor where CODE='" . $_GET['custno'] . "'") or die("Error";
    if ($row = $sql->fetch()) {
        $_SESSION['uti_cus_code'] = $row['CODE'];
        $ResponseXML .= "<id><![CDATA[" . $row['CODE'] . "]]></id>";
        $ResponseXML .= "<NAME><![CDATA[" . $row['NAME'] . "]]></NAME>";
        $ResponseXML .= "<ADD1><![CDATA[" . $row['ADD1'] . "]]></ADD1>";
        $ResponseXML .= "<ADD2><![CDATA[" . $row['ADD2'] . "]]></ADD2>";
    }

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

if ($_GET["Command"] == "pass_ret_cheque_entry") {

    $_SESSION["custno"] = $_GET['custno'];

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

    $ResponseXML = "";
    $ResponseXML .= "<salesdetails>";
    $_SESSION["txt_cuscode"] = "";

    $sql = $dbinv->query("Select * from vendor where CODE='" . $_GET['custno'] . "'") or die("Error";
    if ($row = $sql->fetch()) {

        $ResponseXML .= "<id><![CDATA[" . $row['CODE'] . "]]></id>";
        $ResponseXML .= "<NAME><![CDATA[" . $row['NAME'] . "]]></NAME>";
        $ResponseXML .= "<ADD1><![CDATA[" . $row['ADD1'] . "]]></ADD1>";
        $ResponseXML .= "<ADD2><![CDATA[" . $row['ADD2'] . "]]></ADD2>";
        $_SESSION["txt_cuscode"] = $row['CODE'];
    }

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

if ($_GET["Command"] == "pass_item_claim") {

    $_SESSION["custno"] = $_GET['custno'];

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

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

    $sql = $dbinv->query("Select * from vendor where CODE='" . $_GET['custno'] . "'") or die("Error";
    if ($row = $sql->fetch()) {

        $ResponseXML .= "<id><![CDATA[" . $row['CODE'] . "]]></id>";
        $ResponseXML .= "<NAME><![CDATA[" . $row['NAME'] . "]]></NAME>";
        $ResponseXML .= "<ADD1><![CDATA[" . $row['ADD1'] . "]]></ADD1>";
        $ResponseXML .= "<ADD2><![CDATA[" . $row['ADD2'] . "]]></ADD2>";
    }

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

if ($_GET["Command"] == "pass_grn") {

    $_SESSION["custno"] = $_GET['custno'];

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

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

    $sql = $dbinv->query("Select * from vendor where CODE='" . $_GET['custno'] . "'") or die("Error";
    if ($row = $sql->fetch()) {

        $ResponseXML .= "<id><![CDATA[" . $row['CODE'] . "]]></id>";
        $ResponseXML .= "<NAME><![CDATA[" . $row['NAME'] . "]]></NAME>";
        $ResponseXML .= "<ADD1><![CDATA[" . $row['ADD1'] . "]]></ADD1>";
        $ResponseXML .= "<ADD2><![CDATA[" . $row['ADD2'] . "]]></ADD2>";
    }

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

if ($_GET["Command"] == "add_gr") {

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

    $sql = $dbinv->query("delete from guarentee_data where cus_code='" . $_GET['txt_cuscode'] . "' and gr_id='" . $_GET['gr_id'] . "' order by gr_id") or die("Error";

    if ($_GET['gr_status'] == "true") {
        $gr_status = 1;
    } else {
        $gr_status = 0;
    }
    //echo "insert into guarentee_data(cus_code, gr_type, gr_amount, gr_date, gr_status, gr_bank, gr_id) values ('".$_GET['txt_cuscode']."', '".$_GET['gr_type']."', '".$_GET['gr_amount']."', '".$_GET['gr_date']."', '".$gr_status."', '".$_GET['gr_bank']."', '".$_GET['gr_id']."')";
    $sql = $dbinv->query("insert into guarentee_data(cus_code, gr_type, gr_amount, gr_date, gr_status, gr_bank, gr_id) values ('" . $_GET['txt_cuscode'] . "', '" . $_GET['gr_type'] . "', '" . $_GET['gr_amount'] . "', '" . $_GET['gr_date'] . "', '" . $gr_status . "', '" . $_GET['gr_bank'] . "', '" . $_GET['gr_id'] . "')") or die("Error";

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

    $ResponseXML .= "<sales_table><![CDATA[ <table width=\"300\" border=\"1\" cellspacing=\"0\">
        												<tr>
          												<td background=\"\" height=\"10\">ID</td>
														<td background=\"\" height=\"15\">Guarentee</td>
         												<td background=\"\">Amount</td>
          												<td background=\"\">Exp Date</td>
          												<td background=\"\">Bank</td>
          											<td background=\"\">Status</td>
        												</tr>";

    $sql = $dbinv->query("Select * from guarentee_data where cus_code='" . $_GET['txt_cuscode'] . "'") or die("Error";
    while ($row = $sql->fetch()) {

        $ResponseXML .= "<tr>
											<td >" . $row["gr_id"] . "</td>
											<td >" . $row["gr_type"] . "</td>
											<td >" . $row["gr_amount"] . "</td>
											<td >" . $row["gr_date"] . "</td>
											<td > " . $row["gr_bank"] . "</td>
											<td > " . $row["gr_status"] . "</td>
											 <td ><img src=\"images/delete_01.png\" width=\"20\" height=\"20\" id=" . $row["gr_id"] . "  name=" . $row["gr_id"] . " onClick=\"del_gr('" . $row["cus_code"] . "', '" . $row["gr_id"] . "');\"></td>
										</tr>";
    }
    $ResponseXML .= "   </table>]]></sales_table>";

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

if ($_GET["Command"] == "del_gr") {

    header('Content-Type: text/xml');
    echo "<?xml version=\"1.0\" encoding=\"utf-8\"?>\n";
    //echo "delete from guarentee_data where cus_code='".$_GET['txt_cuscode']."' and gr_id='".$_GET['gr_id']."'";
    $sql = $dbinv->query("delete from guarentee_data where cus_code='" . $_GET['txt_cuscode'] . "' and gr_id='" . $_GET['gr_id'] . "'") or die("Error";

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

    $ResponseXML .= "<sales_table><![CDATA[ <table width=\"300\" border=\"1\" cellspacing=\"0\">
        												<tr>
          												<td background=\"\" height=\"10\">ID</td>
														<td background=\"\" height=\"15\">Guarentee</td>
         												<td background=\"\">Amount</td>
          												<td background=\"\">Exp Date</td>
          												<td background=\"\">Bank</td>
          											<td background=\"\">Status</td>
        												</tr>";

    $sql = $dbinv->query("Select * from guarentee_data where cus_code='" . $_GET['txt_cuscode'] . "'") or die("Error";
    while ($row = $sql->fetch()) {

        $ResponseXML .= "<tr>
											<td >" . $row["gr_id"] . "</td>
											<td >" . $row["gr_type"] . "</td>
											<td >" . $row["gr_amount"] . "</td>
											<td >" . $row["gr_date"] . "</td>
											<td > " . $row["gr_bank"] . "</td>
											<td > " . $row["gr_status"] . "</td>
											 <td ><img src=\"images/delete_01.png\" width=\"20\" height=\"20\" id=" . $row["gr_id"] . "  name=" . $row["gr_id"] . " onClick=\"del_gr('" . $row["cus_code"] . "', '" . $row["gr_id"] . "');\"></td>
										</tr>";
    }
    $ResponseXML .= "   </table>]]></sales_table>";

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

if ($_GET["Command"] == "del_item_rep_cat") {

    $sql1 = $dbinv->query("delete from br_trn where cus_code='" . $_GET['txt_cuscode'] . "' and Rep='" . $_GET["rep"] . "'  and brand='" . $_GET["brand"] . "'") or die("Error";

    //	echo "delete from br_trn where cus_code='".$_GET['txt_cuscode']."' and Rep='".$_GET["rep"]."' and  brand='".$_GET["brand"]."'";

    $doc_mod = $_GET["doc_mod"];

    echo "<table width=\"300\" border=\"1\" cellspacing=\"0\">
        												<tr>
          												<td background=\"\" height=\"25\">Credit Limit</td>
         												<td background=\"\">Sales Rep</td>
          												<td background=\"\">Cat</td>
          												<td background=\"\">Type</td>
														
        												</tr>";

    $cre_lim = 0;
    $sql1 = $dbinv->query("Select * from br_trn where cus_code='" . $_GET['txt_cuscode'] . "'") or die("Error";
    while ($row1 = $sql1->fetch()) {
        $credit_lim = $row1["credit_lim"];
        $credit = $row1["credit"];
        $rep = trim($row1["Rep"]);
        $cat = trim($row1["CAT"]);
        $brand = trim($row1["brand"]);
        $balance = $credit_lim - $credit;

        echo "<tr>
											<td >" . $credit_lim . "</td>
											<td >" . $row1["Rep"] . "</td>";
        /* 	<td >".$credit."</td>
          <td > ".$balance."</td> */
        echo "<td >" . $row1["CAT"] . "</td>
											<td >" . $row1["brand"] . "</td>
											<td><input type=\"button\" name=\"additem_tmp\" id=\"additem_tmp\" value=\"Select\" onClick=\"ass_lim('$credit_lim', '$rep', '$credit', '$balance', '$cat', '$brand');\"></td>
											<td ><img src=\"images/delete_01.png\" width=\"20\" height=\"20\" id=" . $row['str_code'] . "  name=" . $row['str_code'] . " onClick=\"del_item_rep_cat('$credit_lim', '$rep', '$credit', '$balance', '$cat', '$brand', '$doc_mod');\"></td>
										</tr>";
    }
    echo "</table>";
}

if ($_GET["Command"] == "pass_cusno_cust_mast") {

    $_SESSION["custno"] = $_GET['custno'];

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

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

    $doc_mod = 0;

    $sql_permission = $dbinv->query("Select * from view_userpermission where docname='Customer Master File' and username='" . $_SESSION["CURRENT_USER"] . "'") or die("Error";
    if ($row_permission = $sql_permission->fetch()) {
        if ($row_permission["doc_mod"] == "1") {
            $doc_mod = "1";
        }
    }

    $ResponseXML .= "<doc_mod><![CDATA[" . $doc_mod . "]]></doc_mod>";

    $sql = $dbinv->query("Select * from vendor where CODE='" . $_GET['custno'] . "'") or die("Error";
    if ($row = $sql->fetch()) {
        $ResponseXML .= "<blacklist><![CDATA[" . $row['blacklist'] . "]]></blacklist>";
        $ResponseXML .= "<id><![CDATA[" . $row['CODE'] . "]]></id>";
        $ResponseXML .= "<NAME><![CDATA[" . $row['NAME'] . "]]></NAME>";
        $ResponseXML .= "<ADD1><![CDATA[" . $row['ADD1'] . "]]></ADD1>";
        $ResponseXML .= "<ADD2><![CDATA[" . $row['ADD2'] . "]]></ADD2>";
        $ResponseXML .= "<OPBAL><![CDATA[" . $row['OPBAL'] . "]]></OPBAL>";
        $ResponseXML .= "<TELE1><![CDATA[" . $row['TELE1'] . "]]></TELE1>";
        $ResponseXML .= "<TELE2><![CDATA[" . $row['TELE2'] . "]]></TELE2>";
        $ResponseXML .= "<CONT><![CDATA[" . $row['CONT'] . "]]></CONT>";
        $ResponseXML .= "<CUR_BAL><![CDATA[" . $row['CUR_BAL'] . "]]></CUR_BAL>";
        $ResponseXML .= "<LIMIT><![CDATA[" . $row['cLIMIT'] . "]]></LIMIT>";
        $ResponseXML .= "<PEN><![CDATA[" . $row['PEN'] . "]]></PEN>";
        $ResponseXML .= "<FAX><![CDATA[" . $row['FAX'] . "]]></FAX>";
        $ResponseXML .= "<acno><![CDATA[" . $row['acno'] . "]]></acno>";
        $ResponseXML .= "<EMAIL><![CDATA[" . $row['EMAIL'] . "]]></EMAIL>";
        $ResponseXML .= "<CAT><![CDATA[" . $row['CAT'] . "]]></CAT>";
        $ResponseXML .= "<svatno><![CDATA[" . $row['svatno'] . "]]></svatno>";
        $ResponseXML .= "<vatno><![CDATA[" . $row['vatno'] . "]]></vatno>";
        $ResponseXML .= "<OPDATE><![CDATA[" . $row['OPDATE'] . "]]></OPDATE>";
        $ResponseXML .= "<area><![CDATA[" . $row['area'] . "]]></area>";
        $ResponseXML .= "<CUS_TYPE><![CDATA[" . $row['cus_type'] . "]]></CUS_TYPE>";
        $ResponseXML .= "<note><![CDATA[" . $row['note'] . "]]></note>";
        $ResponseXML .= "<temp_limit><![CDATA[" . $row['temp_limit'] . "]]></temp_limit>";
        $ResponseXML .= "<bank_gr_date><![CDATA[" . $row['bank_gr_date'] . "]]></bank_gr_date>";
        $ResponseXML .= "<AltMessage><![CDATA[" . $row['AltMessage'] . "]]></AltMessage>";
        $ResponseXML .= "<incdays><![CDATA[" . $row['incdays'] . "]]></incdays>";
        $ResponseXML .= "<TXT_REP><![CDATA[" . $row['rep'] . "]]></TXT_REP>";
        $ResponseXML .= "<sales_cat><![CDATA[" . $row['field1'] . "]]></sales_cat>";
        $ResponseXML .= "<remark><![CDATA[" . $row['remark'] . "]]></remark>";
        $ResponseXML .= "<starget><![CDATA[" . $row['starget'] . "]]></starget>";
        $ResponseXML .= "<txtvatgroup><![CDATA[" . $row['vatgroup'] . "]]></txtvatgroup>";
        $ResponseXML .= "<txt_commcode><![CDATA[" . $row['commoncode'] . "]]></txt_commcode>";

        $ResponseXML .= "<district><![CDATA[" . $row['district'] . "]]></district>";

        $ResponseXML .= "<province><![CDATA[" . $row['province'] . "]]></province>";

        $ResponseXML .= "<comtype><![CDATA[" . $row['comtype'] . "]]></comtype>";
        $ResponseXML .= "<TXT_REP><![CDATA[" . $row['rep'] . "]]></TXT_REP>";

        $ResponseXML .= "<gr_table><![CDATA[ <table width=\"300\" border=\"1\" cellspacing=\"0\">
        												<tr>
          												<td background=\"\" height=\"10\">ID</td>
														<td background=\"\" height=\"15\">Guarentee</td>
         												<td background=\"\">Amount</td>
          												<td background=\"\">Exp Date</td>
														<td background=\"\">Bank</td>
          												<td background=\"\">Status</td>
          											
        												</tr>";

        $sql = $dbinv->query("Select gr_id, gr_type, gr_amount, gr_date, gr_bank, gr_status, cus_code from guarentee_data where cus_code='" . $_GET['custno'] . "' order by gr_id") or die("Error";
        while ($row = $sql->fetch()) {

            $ResponseXML .= "<tr>
											<td >" . $row["gr_id"] . "</td>
											<td >" . $row["gr_type"] . "</td>
											<td >" . $row["gr_amount"] . "</td>
											<td >" . $row["gr_date"] . "</td>
											<td > " . $row["gr_bank"] . "</td>
											<td > " . $row["gr_status"] . "</td>
											 <td ><img src=\"images/delete_01.png\" width=\"20\" height=\"20\" id=" . $row["gr_id"] . "  name=" . $row["gr_id"] . " onClick=\"del_gr('" . $row["cus_code"] . "', '" . $row["gr_id"] . "');\"></td>
										</tr>";
        }
        $ResponseXML .= "   </table>]]></gr_table>";

        $ResponseXML .= "<sales_table><![CDATA[ <table width=\"300\" border=\"1\" cellspacing=\"0\">
        												<tr>
          												<td background=\"\" height=\"25\">Credit Limit</td>
         												<td background=\"\">Sales Rep</td>";
        /* <td background=\"\">Outstanding</td>
          <td background=\"\">Balance</td> */
        $ResponseXML .= "<td background=\"\">Cat</td>
          												<td background=\"\">Type</td>
														<td background=\"\">Days</td>
        												</tr>";

        $cre_lim = 0;
        $sql1 = $dbinv->query("Select credit_lim, credit, Rep, CAT, brand,days from br_trn where cus_code='" . $_GET['custno'] . "'") or die("Error";
        while ($row1 = $sql1->fetch()) {
            $credit_lim = $row1["credit_lim"];
            $credit = $row1["credit"];
            $rep = trim($row1["Rep"]);
            $cat = trim($row1["CAT"]);
            $brand = trim($row1["brand"]);
            $days = trim($row1['days']);
            $balance = $credit_lim - $credit;

            $ResponseXML .= "<tr>
											<td >" . $credit_lim . "</td>
											<td >" . $row1["Rep"] . "</td>";
            /* 	<td >".$credit."</td>
              <td > ".$balance."</td> */
            $ResponseXML .= "<td >" . $row1["CAT"] . "</td>
											<td >" . $row1["brand"] . "</td>
											<td >" . $row1["days"] . "</td>
											<td><input type=\"button\" name=\"additem_tmp\" id=\"additem_tmp\" value=\"Select\" onClick=\"ass_lim('$credit_lim', '$rep', '$credit', '$balance', '$cat', '$brand','$days');\"></td>
											<td><img src=\"images/delete_01.png\" width=\"20\" height=\"20\" id=" . $row['str_code'] . "  name=" . $row['str_code'] . " onClick=\"del_item_rep_cat('$credit_lim', '$rep', '$credit', '$balance', '$cat', '$brand', '$doc_mod');\"></td>
										</tr>";

            if (trim($row1["CAT"]) == "C") {
                $cre_lim = $cre_lim + $credit_lim;
            }
            if (trim($row1["CAT"]) == "B") {
                $cre_lim = $cre_lim + $credit_lim * 2.5;
            }
            if (trim($row1["CAT"]) == "A") {
                $cre_lim = $cre_lim + $credit_lim * 2.5;
            }
        }

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

    $Out = 0;
    $pen = 0;
    $chq_rea = 0;
    $Ca_rea = 0;
    $R_chq = 0;
    $chno = 0;
    $RTNTOT = 0;

    $date = date("Y-m-d");
    $caldays = " - 90 days";
    $tmpdate = date('Y-m-d', strtotime($caldays));

    //$sql_s_salma="insert into tmp_s_salma_cusmas select * FROM s_salma where C_CODE='".trim($_GET['custno'])."'";
    //$row_s_salma = $sql_s_salma->fetch();

    $sql_ch_rtn = $dbinv->query("SELECT CR_CHNO, CR_CHEVAL from s_cheq where  (CR_DATE>'" . $tmpdate . "'or CR_DATE='" . $tmpdate . "')and (CR_DATE<'" . date("Y-m-d") . "'or CR_DATE='" . date("Y-m-d") . "') and CR_C_CODE = '" . trim($_GET['custno']) . "' and CR_FLAG='0' ORDER BY CR_CHNO") or die("Error";
    while ($row_ch_rtn = $sql_ch_rtn->fetch()) {

        if ($row_ch_rtn["CR_CHNO"] == $chno) {
            //$row_ch_rtn=mysql_fetch_assoc($sql_ch_rtn);
        } else {
            $chno = $row_ch_rtn["CR_CHNO"];
            $RTNTOT = $RTNTOT + $row_ch_rtn["CR_CHEVAL"];
        }
    }

    $date = date("Y-m-d");
    $caldays = " -97 days";
    $tmpdate97 = date('Y-m-d', strtotime($caldays));

    $date = date("Y-m-d");
    $caldays = " -7 days";
    $tmpdate7 = date('Y-m-d', strtotime($caldays));

    $sql_ch_rea = $dbinv->query("SELECT sum(che_amount) as reatot from view_s_invcheq where cus_code='" . trim($_GET['custno']) . "'  and ( che_date>'" . $tmpdate97 . "' or che_date ='" . $tmpdate97 . "')  and ( che_date<'" . $tmpdate7 . "' or che_date ='" . $tmpdate7 . "') and trn_type != 'RET'") or die("Error";
    $row_ch_rea = $sql_ch_rea->fetch();

    $date = date("Y-m-d");
    $caldays = " -7 days";
    $tmpdate90 = date('Y-m-d', strtotime($caldays));

    $sql_cash_rea = $dbinv->query("select sum(CA_CASSH) as ca_reatot from s_crec where CA_CODE = '" . trim($_GET['custno']) . "' and ( CA_DATE>'" . $tmpdate90 . "' or CA_DATE ='" . $tmpdate90 . "')  and ( CA_DATE<'" . date("Y-m-d") . "' or CA_DATE ='" . date("Y-m-d") . "') and CANCELL = '0' and FLAG = 'REC'") or die("Error";
    $row_cash_rea = $sql_cash_rea->fetch();

    $sql_ch_pen1 = $dbinv->query("SELECT sum(che_amount) as pentot1 from view_s_invcheq where ch_count_ret='0' and cus_code='" . trim($_GET['custno']) . "'  and ( che_date>'" . date("Y-m-d") . "' or che_date ='" . date("Y-m-d") . "')  and month(che_date) = '" . date("m") . "'") or die("Error";
    $row_ch_pen1 = $sql_ch_pen1->fetch();

    $sql_ch_pen2 = $dbinv->query("SELECT sum(che_amount) as pentot2 from view_s_invcheq where ch_count_ret='0' and cus_code='" . trim($_GET['custno']) . "'  and ( che_date>'" . date("Y-m-d") . "' or che_date ='" . date("Y-m-d") . "') ") or die("Error";
    $row_ch_pen2 = $sql_ch_pen2->fetch();

    $sql_salma = $dbinv->query("Select sum(GRAND_TOT - TOTPAY) as out1 from s_salma where C_CODE='" . trim($_GET['custno']) . "' and CANCELL='0' and GRAND_TOT-TOTPAY>1") or die("Error";
    $row_salma = $sql_salma->fetch();

    $sql_c_rtn = $dbinv->query("Select sum(CR_CHEVAL - PAID) as Rtn from s_cheq where CR_C_CODE = '" . trim($_GET['custno']) . "' and CR_FLAG = '0' and CR_CHEVAL - PAID > 1") or die("Error";
    $row_c_rtn = $sql_c_rtn->fetch();

    if (is_null($row_salma["out1"]) == false) {
        $Out = $row_salma["out1"];
    }
    if (is_null($row_ch_pen2["pentot2"]) == false) {
        $pen = $row_ch_pen2["pentot2"];
    }
    if (is_null($row_ch_rea["reatot"]) == false) {
        $chq_rea = $row_ch_rea["reatot"];
    }
    if (is_null($row_cash_rea["ca_reatot"]) == false) {
        $Ca_rea = $row_cash_rea["ca_reatot"];
    }
    if (is_null($row_c_rtn["Rtn"]) == false) {
        $R_chq = $row_c_rtn["Rtn"];
    }


    $sql_c_insentive = $dbinv->query("Select sum(payment) as paid from inc_credit_payment where c_code = '" . $_GET["custno"] . " '") or die("Error";
    $row_c_insentive = $sql_c_insentive->fetch();

    $sql_c_inss = $dbinv->query("SELECT * from inc_auto_credit_note where  code='" . $_GET["custno"] . "' ") or die("Error";
    $row_c_inss = $sql_c_inss->fetch();

    $grandtot = getIns();

    $ResponseXML .= "<info_table><![CDATA[ <table width=\"200\" border=\"1\" cellspacing=\"0\">
        												<tr>
          												<td background=\"\" height=\"25\">Info Type</td>
         												<td background=\"\">Amount</td>
          												</tr>";

    $ResponseXML .= "<tr><td>Last 3 Month Rtn Chqs</td><td align=right>" . number_format($RTNTOT, 2, ".", ",") . "</td></tr>
				<tr>	<td>Last 3 Month Settlements</td><td align=right>" . number_format(($chq_rea + $Ca_rea), 2, ".", ",") . "</td></tr>
				<tr>	<td>Next 3 month Chqs to be realize</td><td align=right>" . number_format(($Out + $pen), 2, ".", ",") . "</td></tr>
				<tr>	<td>Current Rtn Chqs</td><td align=right>" . number_format($R_chq, 2, ".", ",") . "</td></tr>
				<tr>	<td>Current month Pending Chqs</td><td align=right>" . number_format($row_ch_pen1["pentot1"], 2, ".", ",") . "</td></tr>
				<tr>	<td>Current month Pending Chqs</td><td align=right>" . number_format($row_ch_pen1["pentot1"], 2, ".", ",") . "</td></tr>
    <tr> <td>Insentive</td><td align = right>" . number_format($grandtot, 2, ".", ", ") . "</td></tr>";

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

    $ResponseXML .= "<cre_lim><![CDATA[" . $cre_lim . "]]></cre_lim>";

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

if ($_GET["Command"] == "pass_repno_cust_mast") {
    header('Content-Type: text/xml');
    echo "<?xml version = \"1.0\" encoding=\"utf-8\"?>\n";

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

    $sql = $dbinv->query("Select * from vendor where CODE='" . $_GET['custno'] . "'") or die("Error";
    if ($row = $sql->fetch()) {
        $ResponseXML .= "<code><![CDATA[" . $row['CODE'] . "]]></code>";
        $ResponseXML .= "<name><![CDATA[" . $row['NAME'] . "]]></name>";
    }

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

if ($_GET["Command"] == "pass_cus_cash_rec") {
    header('Content-Type: text/xml');
    echo "<?xml version=\"1.0\" encoding=\"utf-8\"?>\n";

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

    $sql = $dbinv->query("Select * from vendor where CODE='" . $_GET['custno'] . "'") or die("Error";
    if ($row = $sql->fetch()) {
        $ResponseXML .= "<code><![CDATA[" . $row['CODE'] . "]]></code>";
        $ResponseXML .= "<name><![CDATA[" . $row['NAME'] . "]]></name>";
        $ResponseXML .= "<address><![CDATA[" . $row['ADD1'] . " " . $row['ADD2'] . "]]></address>";
    }

    $ResponseXML .= "<sales_table_acc><![CDATA[ <table  border=1  cellspacing=0>
								<tr><td width=\"80\"  background=\"\" ><font color=\"#FFFFFF\"></font></td>
								<td width=\"80\"  background=\"\" ><font color=\"#FFFFFF\">Date</font></td>
								<td width=\"200\"  background=\"\" ><font color=\"#FFFFFF\">Invoice No</font></td>
                                                                <td width=\"200\"  background=\"\" ><font color=\"#FFFFFF\">Brand</font></td>
								<td width=\"80\"  background=\"\" ><font color=\"#FFFFFF\">Value</font></td>
								<td width=\"80\"  background=\"\" ><font color=\"#FFFFFF\">Paid</font></td>
								<td width=\"80\"  background=\"\" ><font color=\"#FFFFFF\">Overdue</font></td>
								<td width=\"80\"  background=\"\" ><font color=\"#FFFFFF\">Chq Pay</font></td>
								<td width=\"80\"  background=\"\" ><font color=\"#FFFFFF\">Chq Balance</font></td>
								<td width=\"80\"  background=\"\" ><font color=\"#FFFFFF\">Cash Pay</font></td>
								<td width=\"80\"  background=\"\" ><font color=\"#FFFFFF\">Inv Balance</font></td></tr>";

    //$sql = $dbinv->query("Select C_CODE, REF_NO, deli_date, GRAND_TOT, TOTPAY, SDATE from s_salma where C_CODE='".$_GET['custno']."' and GRAND_TOT > TOTPAY and DEV='" & rsusercon!dev & "' and CANCELL='0' and SAL_EX='" & Trim(Left(Com_rep, 5)) & "' and Accname <> 'NON STOCK' ORDER BY SDATE") or die("Error";
    //	echo "Select C_CODE, REF_NO, deli_date, GRAND_TOT, TOTPAY, SDATE from s_salma where C_CODE='".$_GET['custno']."' and GRAND_TOT > TOTPAY and CANCELL='0' and SAL_EX='".$_GET["refno"]."' and Accname <> 'NON STOCK' ORDER BY SDATE";

    $i = 1;
    //	echo "Select C_CODE, REF_NO, deli_date, GRAND_TOT, TOTPAY, SDATE from s_salma where C_CODE='".$_GET['custno']."' and GRAND_TOT > TOTPAY and CANCELL='0'  ORDER BY SDATE";

    if ($_GET['refno'] == "") {
        $sql = $dbinv->query("Select C_CODE, REF_NO, deli_date, GRAND_TOT, TOTPAY, SDATE from s_salma where C_CODE='" . $_GET['custno'] . "' and GRAND_TOT > TOTPAY and (GRAND_TOT-TOTPAY)>0 and CANCELL='0' and DEV='" . $_SESSION['dev'] . "' ORDER BY SDATE") or die("Error";
    } else {

        $sql = $dbinv->query("Select C_CODE, REF_NO, deli_date, GRAND_TOT, TOTPAY, SDATE from s_salma where C_CODE='" . $_GET['custno'] . "' and GRAND_TOT > TOTPAY and (GRAND_TOT-TOTPAY)>0 and CANCELL='0' and SAL_EX='" . $_GET['refno'] . "' and DEV='" . $_SESSION['dev'] . "'  ORDER BY SDATE") or die("Error";
    }
    while ($row = $sql->fetch()) {

        $sdate = "sdate" . $i;
        $delidate = "delidate" . $i;

        $invval = "invval" . $i;

        //if (is_null($row["deli_date"]==false)){
        if (is_null($row["deli_date"] == false) or ( $row["deli_date"] != "0000-00-00")) {

            //$ResponseXML .= "<tr><td><div id=".$delidate.">".$row["REQ_DATE"]."</div></td>";
            $ResponseXML .= "<tr><td><div id=" . $delidate . ">" . $row["deli_date"] . "</div></td>";
        } else {
            $ResponseXML .= "<tr><td><div id=" . $delidate . ">" . $row["SDATE"] . "</div></td>";
        }

        $ResponseXML .= "<td><div id=" . $sdate . ">" . $row["SDATE"] . "</div></td>";

        $j = $i + 1;

        $overdue = "overdue" . $i;

        $chq_pay = "chq_pay" . $i;
        $chq_pay_next = "chq_pay" . $j;

        $chq_balance = "chq_balance" . $i;
        $chq_balance_next = "chq_balance" . $j;

        $cash_pay = "cash_pay" . $i;
        $cash_pay_next = "cash_pay" . $j;

        $inv_balance = "inv_balance" . $i;
        $overdueamt = $row["GRAND_TOT"] - $row["TOTPAY"];
        //number_format($row["GRAND_TOT"]-$row["TOTPAY"], 2, ".")

        $invno = "invno" . $i;

        $ResponseXML .= "<td><div id=" . $invno . ">" . $row["REF_NO"] . "</div></td>
            <td>" . $row["Brand"] . "</td>
									 <td><div id=" . $invval . "  align=right>" . number_format($row["GRAND_TOT"], 2, ".", ",") . "</div></td>
									 <td align=right>" . number_format($row["TOTPAY"], 2, ".", ",") . "</td>
									 <td><input type=\"text\"  class=\"text_purchase3_right\" name=" . $overdue . " id=" . $overdue . " value=" . number_format($overdueamt, 2, ".", "") . " size=\"10\" disabled  align=right/></td>
									 <td><input type=\"text\" align=\"right\"  class=\"text_purchase3_right\" name=" . $chq_pay . " id=" . $chq_pay . " onBlur=\"calc_bal('$overdue', '$chq_pay', '$inv_balance', '$chq_balance', '$chq_balance_next', '$cash_pay', '$i', event);\"  onKeyPress=\"keyset('$chq_pay_next', event);\"   size=\"10\"/></td>									
									 <td><input type=\"text\" align=\"right\"  class=\"text_purchase3_right\" name=" . $chq_balance . " disabled id=" . $chq_balance . " onKeyPress=\"keysetvalue('$chq_balance','$chq_balance_next', '$chq_pay', event);\" size=\"10\"/></td>
									 <td><input type=\"text\" align=\"right\" class=\"text_purchase3_right\" name=" . $cash_pay . " id=" . $cash_pay . " onBlur=\"calc_bal_cash('$overdue', '$cash_pay_next', '$chq_pay', '$inv_balance', '$cash_pay', event);\" onKeyPress=\"keyset('$cash_pay_next', event);\" size=\"10\"/></td>
									 <td><input type=\"text\" align=\"right\" class=\"text_purchase3_right\" name=" . $inv_balance . " id=" . $inv_balance . " disabled size=\"10\"/></td></tr>";
        $i = $i + 1;
    }

    $overdue = "overdue" . $i;

    $chq_pay = "chq_pay" . $i;
    $chq_pay_next = "chq_pay" . $j;

    $chq_balance = "chq_balance" . $i;
    $chq_balance_next = "chq_balance" . $j;

    $cash_pay = "cash_pay" . $i;
    $cash_pay_next = "cash_pay" . $j;

    $inv_balance = "inv_balance" . $i;
    $overdueamt = $row["GRAND_TOT"] - $row["TOTPAY"];
    $invno = "invno" . $i;
    $ResponseXML .= "<tr><td><td></td>
									 <td></td><div id=" . $invno . "></div></td>
									 <td></td>
									 <td></td>
									 <td><input type=\"text\" align=\"right\" class=\"text_purchase3_right\" name=" . $overdue . " id=" . $overdue . " value=" . $overdueamt . " size=\"10\"/></td>
									 <td><input type=\"text\" align=\"right\" class=\"text_purchase3_right\" name=" . $chq_pay . " id=" . $chq_pay . " onBlur=\"calc_bal('$overdue', '$chq_pay', '$inv_balance', '$chq_balance', '$chq_balance_next', '$cash_pay', '$i', event);\"  onKeyPress=\"keyset('$chq_pay_next', event);\"   size=\"10\"/></td>									
									 <td><input type=\"text\" align=\"right\" class=\"text_purchase3_right\" name=" . $chq_balance . " id=" . $chq_balance . " onKeyPress=\"keysetvalue('$chq_balance','$chq_balance_next', '$chq_pay', event);\" size=\"10\"/></td>
									 <td><input type=\"text\" align=\"right\" class=\"text_purchase3_right\" name=" . $cash_pay . " id=" . $cash_pay . " onKeyPress=\"calc_bal_cash('$overdue', '$cash_pay_next', '$chq_pay', '$inv_balance', '$cash_pay', event);\" size=\"10\"/></td>
									 <td><input type=\"text\" align=\"right\" class=\"text_purchase3_right\" name=" . $inv_balance . " id=" . $inv_balance . " disabled size=\"10\"/></td></tr>";

    $_SESSION["count"] = $i;
    $ResponseXML .= "   </table>]]></sales_table_acc>";
    $ResponseXML .= "<mcount><![CDATA[" . $_SESSION["count"] . "]]></mcount>";
    $ResponseXML .= "</salesdetails>";
    echo $ResponseXML;
}

if ($_GET["Command"] == "pass_ret_chq_settle") {
    header('Content-Type: text/xml');
    echo "<?xml version=\"1.0\" encoding=\"utf-8\"?>\n";

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

    $sql = $dbinv->query("Select * from vendor where CODE='" . $_GET['custno'] . "'") or die("Error";
    if ($row = $sql->fetch()) {
        $ResponseXML .= "<code><![CDATA[" . $row['CODE'] . "]]></code>";
        $ResponseXML .= "<name><![CDATA[" . $row['NAME'] . "]]></name>";
        $ResponseXML .= "<address><![CDATA[" . $row['ADD1'] . " " . $row['ADD2'] . "]]></address>";
    }

    $ResponseXML .= "<sales_table_acc><![CDATA[ <table  bgcolor=\"#003366\" border=1  cellspacing=0>
								<tr>
								<td width=\"80\"  background=\"\" ><font color=\"#FFFFFF\">Rtn Count</font></td>
								<td width=\"80\"  background=\"\" ><font color=\"#FFFFFF\">Doc.Date</font></td>
								<td width=\"80\"  background=\"\" ><font color=\"#FFFFFF\">Doc.No</font></td>
								<td width=\"80\"  background=\"\" ><font color=\"#FFFFFF\">Chq.No</font></td>
								<td width=\"80\"  background=\"\" ><font color=\"#FFFFFF\">Chq.Date</font></td>
								<td width=\"80\"  background=\"\" ><font color=\"#FFFFFF\">Chq.Val</font></td>
								<td width=\"80\"  background=\"\" ><font color=\"#FFFFFF\">Chq.Paid</font></td>
								<td width=\"80\"  background=\"\" ><font color=\"#FFFFFF\">Chq.Bal</font></td>
								<td width=\"80\"  background=\"\" ><font color=\"#FFFFFF\">Set.Amount</font></td>
								<td width=\"80\"  background=\"\" ><font color=\"#FFFFFF\">Balance</font></td>
								<td width=\"80\"  background=\"\" ><font color=\"#FFFFFF\">Cash</font></td>
								<td width=\"80\"  background=\"\" ><font color=\"#FFFFFF\">Ret.Chq.bal</font></td></tr>";

    //$sql = $dbinv->query("Select C_CODE, REF_NO, deli_date, GRAND_TOT, TOTPAY, SDATE from s_salma where C_CODE='".$_GET['custno']."' and GRAND_TOT > TOTPAY and DEV='" & rsusercon!dev & "' and CANCELL='0' and SAL_EX='" & Trim(Left(Com_rep, 5)) & "' and Accname <> 'NON STOCK' ORDER BY SDATE") or die("Error";
    //	echo "Select C_CODE, REF_NO, deli_date, GRAND_TOT, TOTPAY, SDATE from s_salma where C_CODE='".$_GET['custno']."' and GRAND_TOT > TOTPAY and CANCELL='0' and SAL_EX='".$_GET["refno"]."' and Accname <> 'NON STOCK' ORDER BY SDATE";

    $i = 1;
    //	echo "Select C_CODE, REF_NO, deli_date, GRAND_TOT, TOTPAY, SDATE from s_salma where C_CODE='".$_GET['custno']."' and GRAND_TOT > TOTPAY and CANCELL='0'  ORDER BY SDATE";

    $sql = $dbinv->query("select * from s_cheq where CR_C_CODE='" . trim($row['CODE']) . "' and CR_CHEVAL+CR_REPAY>PAID and CR_FLAG='0'") or die("Error";

    while ($row = $sql->fetch()) {

        $j = $i + 1;

        $docdate = "docdate" . $i;
        $docno = "docno" . $i;
        $chqval = "chqval" . $i;
        $chqno = "chqno" . $i;
        $chqdate = "chqdate" . $i;

        $chqbal = "chqbal" . $i;
        $chqbal_next = "chqbal" . $j;
        $chq_bal_val = $row["CR_CHEVAL"] - $row["PAID"] + $row["CR_REPAY"];

        $setamount = "setamount" . $i;
        $setamount_next = "setamount" . $j;

        $balance = "balance" . $i;
        $balance_next = "balance" . $j;

        $cash = "cash" . $i;
        $cash_next = "cash" . $j;

        $retchqbal = "retchqbal" . $i;
        $retchqbal_next = "retchqbal" . $j;

        $inv_balance = "inv_balance" . $i;
        $overdueamt = $row["GRAND_TOT"] - $row["TOTPAY"];
        //number_format($row["GRAND_TOT"]-$row["TOTPAY"], 2, ".")

        $invno = "invno" . $i;

        $ResponseXML .= "<tr><td><font color=\"#FFFFFF\">" . $row['retcout'] . "</font></td><td><font color=\"#FFFFFF\"><div id=" . $docdate . ">" . $row["CR_DATE"] . "</div></font></td>
										<td><font color=\"#FFFFFF\"><div id=" . $docno . ">" . $row["CR_REFNO"] . "</div></font></td>
										<td><font color=\"#FFFFFF\"><div id=" . $chqno . ">" . $row["CR_CHNO"] . "</div></font></td>
										<td><font color=\"#FFFFFF\"><div id=" . $chqdate . ">" . $row["CR_CHDATE"] . "</div></font></td>
										<td><font color=\"#FFFFFF\"><div id=" . $chqval . ">" . number_format($row["CR_CHEVAL"] + $row["CR_REPAY"], 2, ".", ",") . "</div></font></td>
									 	<td><font color=\"#FFFFFF\">" . number_format($row["PAID"], 2, ".", ",") . "</font></td>
									 	<td><input type=\"text\" align=\"right\" class=\"text_purchase3_right\" name=" . $chqbal . " id=" . $chqbal . " value=" . number_format($chq_bal_val, 2, ".", ",") . " size=\"10\"/></td>
									 <td><input type=\"text\" align=\"right\" class=\"text_purchase3_right\" name=" . $setamount . " id=" . $setamount . " onBlur=\"calc_bal('$chqbal', '$setamount', '$retchqbal', '$balance', '$balance_next', '$cash', '$i', event);\"  onKeyPress=\"keyset('$setamount_next', event);\"   size=\"10\"/></td>									
									 <td><input type=\"text\" align=\"right\" class=\"text_purchase3_right\" name=" . $balance . " id=" . $balance . " onKeyPress=\"keysetvalue('$balance','$balance_next', '$setamount', event);\" size=\"10\"/></td>
									 <td><input type=\"text\" align=\"right\" class=\"text_purchase3_right\" name=" . $cash . " id=" . $cash . " onBlur=\"calc_bal_cash('$chqbal', '$cash_next', '$setamount', '$retchqbal', '$cash', event);\" size=\"10\"/></td>
									 <td><input type=\"text\" align=\"right\" class=\"text_purchase3_right\" name=" . $retchqbal . " id=" . $retchqbal . " disabled size=\"10\"/></td></tr>";

        $i = $i + 1;
    }

    $j = $i + 1;

    $docdate = "docdate" . $i;
    $docno = "docno" . $i;
    $chqval = "chqval" . $i;
    $chqno = "chqno" . $i;
    $chqdate = "chqdate" . $i;

    $chqbal = "chqbal" . $i;
    $chqbal_next = "chqbal" . $j;
    $chq_bal_val = $row["CR_CHEVAL"] - $row["PAID"];

    $setamount = "setamount" . $i;
    $setamount_next = "setamount" . $j;

    $balance = "balance" . $i;
    $balance_next = "balance" . $j;

    $cash = "cash" . $i;
    $cash_next = "cash" . $j;

    $retchqbal = "retchqbal" . $i;
    $retchqbal_next = "retchqbal" . $j;

    $inv_balance = "inv_balance" . $i;
    $overdueamt = $row["GRAND_TOT"] - $row["TOTPAY"];
    //number_format($row["GRAND_TOT"]-$row["TOTPAY"], 2, ".")

    $invno = "invno" . $i;

    $ResponseXML .= "<tr><td><font color=\"#FFFFFF\"><div id=" . $docdate . ">" . $row["CR_DATE"] . "</div></font></td>
										<td><font color=\"#FFFFFF\"><div id=" . $docno . ">" . $row["CR_REFNO"] . "</div></font></td>
										<td><font color=\"#FFFFFF\"><div id=" . $chqno . ">" . $row["CR_CHNO"] . "</div></font></td>
										<td><font color=\"#FFFFFF\"><div id=" . $chqdate . ">" . $row["CR_CHDATE"] . "</div></font></td>
										<td><font color=\"#FFFFFF\"><div id=" . $chqval . ">" . number_format($row["CR_CHEVAL"], 2, ".", ",") . "</div></font></td>
									 	<td><font color=\"#FFFFFF\">" . number_format($row["PAID"], 2, ".", ",") . "</font></td>
									 	<td><input type=\"text\" align=\"right\" class=\"text_purchase3_right\" name=" . $chqbal . " id=" . $chqbal . " value=" . number_format($chq_bal_val, 2, ".", ",") . " size=\"10\"/></td>
									 <td><input type=\"text\" align=\"right\" class=\"text_purchase3_right\" name=" . $setamount . " id=" . $setamount . " onBlur=\"calc_bal('$chqbal', '$setamount', '$retchqbal', '$balance', '$balance_next', '$cash', '$i', event);\"  onKeyPress=\"keyset('$setamount_next', event);\"   size=\"10\"/></td>									
									 <td><input type=\"text\" align=\"right\" class=\"text_purchase3_right\" name=" . $balance . " id=" . $balance . " onBlur=\"keysetvalue('$balance','$balance_next', '$setamount', event);\" size=\"10\"/></td>
									 <td><input type=\"text\" align=\"right\" class=\"text_purchase3_right\" name=" . $cash . " id=" . $cash . " onBlur=\"calc_bal_cash('$chqbal', '$cash_next', '$setamount', '$retchqbal', '$cash', event);\" size=\"10\"/></td>
									 <td><input type=\"text\" align=\"right\" class=\"text_purchase3_right\" name=" . $retchqbal . " id=" . $retchqbal . " disabled size=\"10\"/></td></tr>";

    $_SESSION["ret_count"] = $i;
    $ResponseXML .= "   </table>]]></sales_table_acc>";
    $ResponseXML .= "<mcount><![CDATA[" . $i . "]]></mcount>";
    $ResponseXML .= "</salesdetails>";
    echo $ResponseXML;
}

if ($_GET["Command"] == "pass_save_limit") {
    $sql = "update  br_trn set credit_lim=" . $_GET['credit_lim'] . ", CAT='" . $_GET['cat'] . "' where cus_code='" . $_GET['cuscode'] . "' and Rep='" . $_GET['Com_rep'] . "' and brand='" . $_GET['cmbbrand'] . "'";
    //echo $sql;
    $result = $dbinv->query($sql) or die("Error";
    echo "Saved";
}

if ($_GET["Command"] == "pass_displimit_result") {
    $i = 1;
    $xml = "<table>";
    $xml .= "<tr><td>Customer Code</td><td>Customer Name</td><td>Category</td><td>Credit Limit</td></tr>";
    $sql = "Select * from br_trn where Rep='" . $_GET['Com_rep'] . "' and brand='" . $_GET['cmbbrand'] . "'";
    //echo $sql;
    $result = $dbinv->query($sql) or die("Error";
    while ($row = $result->fetch()) {

        $cuscode = "cuscode_" . $i;
        $cat = "cat_" . $i;
        $credit_lim = "credit_lim_" . $i;

        $sql1 = $dbinv->query("Select * from vendor where CODE='" . $row["cus_code"] . "' ") or die("Error";
        $row1 = $sql1->fetch();
        $xml .= "<tr><td><div id=" . $cuscode . " name=" . $cuscode . ">" . $row["cus_code"] . "</div></td>
		<td>" . $row1["NAME"] . "</td>
		<td><div id=" . $cat . " name=" . $cat . ">" . $row["CAT"] . "</div></td>
		<td><input type=\"text\" name=\"" . $credit_lim . "\" id=\"" . $credit_lim . "\" value=\"" . $row["credit_lim"] . "\" /></td>
		<td><input type=\"button\" name=\"button\" id=\"button\" value=\"Save\" onclick=\"save_limit('$i');\" /></td>
		</tr>";

        $i = $i + 1;
    }
    $xml .= "</table>";
    echo $xml;
}

if ($_GET["Command"] == "update_limit") {
    $sql = $dbinv->query("Select * from br_trn where cus_code='" . $_GET['txt_cuscode'] . "' and Rep='" . $_GET['rep'] . "' and brand='" . $_GET['brand'] . "'") or die("Error";
    if ($row = $sql->fetch()) {
        $sql1 = $dbinv->query("update  br_trn set credit_lim=" . $_GET['txtlimit'] . ", CAT='" . $_GET['cmbCAt'] . "',days='" . $_GET['days'] . "' where cus_code='" . $_GET['txt_cuscode'] . "' and Rep='" . $_GET['rep'] . "' and brand='" . $_GET['brand'] . "'") or die("Error";
    } else {
        $sqlq = "insert into br_trn (cus_code, Rep, credit_lim, brand, CAT,days) values ('" . $_GET['txt_cuscode'] . "', '" . $_GET['rep'] . "', " . $_GET['txtlimit'] . ", '" . $_GET['brand'] . "', '" . $_GET['cmbCAt'] . "','" . $_GET['days'] . "') ";
        // echo $sqlq;
        $sql1 = $dbinv->query($sqlq) or die("Error";
    }

    if ($_GET["stopinv"] == "true") {
        $sql1 = $dbinv->query("update  vendor set blacklist='1' where CODE='" . $_GET['txt_cuscode'] . "'") or die("Error";
    } else {
        $sql1 = $dbinv->query("update  vendor set blacklist='0' where CODE='" . $_GET['txt_cuscode'] . "'") or die("Error";
    }

    $sql = $dbinv->query("Select sum(credit_lim) as tot from br_trn where cus_code='" . $_GET['txt_cuscode'] . "'") or die("Error";
    if ($row = $sql->fetch()) {
        $totcr = $row["tot"];
    } else {
        $totcr = 0;
    }

    $sql1 = $dbinv->query("update vendor set cLIMIT=" . $totcr . " where CODE='" . $_GET['txt_cuscode'] . "'") or die("Error";

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

    $ResponseXML = "";
    $ResponseXML .= "<salesdetails>";
    $ResponseXML .= "<totcr><![CDATA[" . $totcr . "]]></totcr>";
    $ResponseXML .= "<cre_table><![CDATA[ <table width=\"300\" border=\"1\" cellspacing=\"0\">
        												<tr>
          												<td background=\"\" height=\"25\">Credit Limit</td>
         												<td background=\"\">Sales Rep</td>
          												<td background=\"\">Outstanding</td>
          												<td background=\"\">Balance</td>
          												<td background=\"\">Cat</td>
          												<td background=\"\">Type</td>
														<td background=\"\">Days</td>
        												</tr>";

    $cre_lim = 0;
    $sql1 = $dbinv->query("Select * from br_trn where cus_code='" . $_GET['txt_cuscode'] . "'") or die("Error";
    while ($row1 = $sql1->fetch()) {
        $credit_lim = $row1["credit_lim"];
        $credit = $row1["credit"];
        $rep = $row1["Rep"];
        $cat = $row1["CAT"];
        $brand = $row1["brand"];
        $days = $row1['days'];
        $balance = $credit_lim - $credit;

        $ResponseXML .= "<tr>
											<td >" . $credit_lim . "</td>
											<td >" . $row1["Rep"] . "</td>
											<td >" . $credit . "</td>
											<td > " . $balance . "</td>
											<td >" . $row1["CAT"] . "</td>
											<td >" . $row1["brand"] . "</td>
											<td >" . $row1["days"] . "</td>
											<td><input type=\"button\" name=\"additem_tmp\" id=\"additem_tmp\" value=\"Select\" onClick=\"ass_lim('$credit_lim', '$rep', '$credit', '$balance', '$cat', '$brand','$days');\"></td>
										</tr>";

        if ($row1["CAT"] == "C") {
            $cre_lim = $cre_lim + $credit_lim;
        }
        if ($row1["CAT"] == "B") {
            $cre_lim = $cre_lim + $credit_lim * 2.5;
        }
        if ($row1["CAT"] == "A") {
            $cre_lim = $cre_lim + $credit_lim * 2.5;
        }
    }

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

if ($_GET["Command"] == "delete_limit") {
    $sql = $dbinv->query("delete from br_trn where cus_code='" . $_GET['txt_cuscode'] . "' and Rep='" . $_GET['rep'] . "' and brand='" . $_GET['brand'] . "'") or die("Error";

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

    $ResponseXML = "";
    $ResponseXML .= "<salesdetails>";
    $ResponseXML .= "<totcr><![CDATA[" . $totcr . "]]></totcr>";
    $ResponseXML .= "<cre_table><![CDATA[ <table width=\"300\" border=\"1\" cellspacing=\"0\">
        												<tr>
          												<td background=\"\" height=\"25\">Credit Limit</td>
         												<td background=\"\">Sales Rep</td>
          												<td background=\"\">Outstanding</td>
          												<td background=\"\">Balance</td>
          												<td background=\"\">Cat</td>
          												<td background=\"\">Type</td>
														<td background=\"\">Days</td>
        												</tr>";

    $cre_lim = 0;
    $sql1 = $dbinv->query("Select * from br_trn where cus_code='" . $_GET['txt_cuscode'] . "'") or die("Error";
    while ($row1 = $sql1->fetch()) {
        $credit_lim = $row1["credit_lim"];
        $credit = $row1["credit"];
        $rep = $row1["Rep"];
        $cat = $row1["CAT"];
        $brand = $row1["brand"];
        $days = $row1['days'];
        $balance = $credit_lim - $credit;

        $ResponseXML .= "<tr>
											<td >" . $credit_lim . "</td>
											<td >" . $row1["Rep"] . "</td>
											<td >" . $credit . "</td>
											<td > " . $balance . "</td>
											<td >" . $row1["CAT"] . "</td>
											<td >" . $row1["brand"] . "</td>
											<td >" . $row1["days"] . "</td>
											<td><input type=\"button\" name=\"additem_tmp\" id=\"additem_tmp\" value=\"Select\" onClick=\"ass_lim('$credit_lim', '$rep', '$credit', '$balance', '$cat', '$brand','$days');\"></td>
										</tr>";

        if ($row1["CAT"] == "C") {
            $cre_lim = $cre_lim + $credit_lim;
        }
        if ($row1["CAT"] == "B") {
            $cre_lim = $cre_lim + $credit_lim * 2.5;
        }
        if ($row1["CAT"] == "A") {
            $cre_lim = $cre_lim + $credit_lim * 2.5;
        }
    }

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

if ($_GET["Command"] == "note_update") {
    //echo "update vendor set note= '".trim($_GET["txtnote"])."' where code='".trim($_GET["txt_cuscode"])."'";
    $sql = $dbinv->query("update vendor set note= '" . trim($_GET["txtnote"]) . "' where code='" . trim($_GET["txt_cuscode"]) . "'") or die("Error";
}

if ($_GET["Command"] == "app_only_for") {
    //echo "update vendor set note= '".trim($_GET["txtnote"])."' where code='".trim($_GET["txt_cuscode"])."'";
    $sql = $dbinv->query("insert into tmpcrlmt (sdate, stime, username, tmpLmt, Class, Rep, cusCode, crLmt, cat, FLAG) values ('" . date("Y-m-d") . "','" . date("H:m:s") . "', '" . $_SESSION["CURRENT_USER"] . "', '0', 'NB', 'NR', '" . trim($_GET["txt_cuscode"]) . "', '0','','PER' )") or die("Error";

    $sql = $dbinv->query("update vendor set Over_DUE_IG_Date='" . $_GET["DT_Over_DUE_IG"] . "'  where CODE='" . trim($_GET["txt_cuscode"]) . "'") or die("Error";
    echo "Over 60 Outstanding and Return Cheque Ignore for the billing ";
}


function getIns() {

	$totamt_1=0;
	$totamt_2=0;
	$totamt_3=0;
	$totamt_4=0;
	$totamt_5=0;
	$totamt_6=0;
	$totamt_7=0;
	$totamt_8=0;
	$totamt_9=0;
	$totamt_10=0;
	$totamt_11=0;
	$totamt_12=0;
	
					
   
	$sql = "SELECT distinct code from inc_auto_credit_note where year(txndate) = '".date("Y", strtotime($_GET["dte_dor"]))."'  order by code";
	
	$result_sql=$db->RunQuery($sql);
	while ($row_sql = $result_sql->fetch()){	
		
		$amount=0;
		
		
		$sql_v = "SELECT * from vendor where CODE = '".$row_sql["code"]."' ";
		$result_sql_v=$db->RunQuery($sql_v);
		$row_sql_v = $result_sql_v->fetch();
		
   		
		$sql1 = "SELECT * from inc_auto_credit_note where code='".$row_sql["code"]."'  and sal_ex <> '' order by  myear_mon desc ";
		$result_sql1=$db->RunQuery($sql1);
		$row_sql1 = $result_sql1->fetch();
			
		
		$mon=1;
		while ($mon<=12){
			$month="00".$mon;
			$len=strlen($month);
			$month=	substr($month, ($len-2));
			$ym=date("Y", strtotime($_GET["dte_dor"]))."-".$month;
			
			$sql1 = "SELECT * from inc_auto_credit_note where myear_mon = '".$ym."' and code='".$row_sql["code"]."' ";
			$result_sql1=$db->RunQuery($sql1);
			if ($row_sql1 = $result_sql1->fetch()){
				
				$amount=$amount+$row_sql1["amount"];
				
				if ($mon==1){
					$totamt_1=$totamt_1+$row_sql1["amount"];
				} else if ($mon==2){
					$totamt_2=$totamt_2+$row_sql1["amount"];
				}else if ($mon==3){
					$totamt_3=$totamt_3+$row_sql1["amount"];
				}else if ($mon==4){
					$totamt_4=$totamt_4+$row_sql1["amount"];
				}else if ($mon==5){
					$totamt_5=$totamt_5+$row_sql1["amount"];
				}else if ($mon==6){
					$totamt_6=$totamt_6+$row_sql1["amount"];
				}else if ($mon==7){
					$totamt_7=$totamt_7+$row_sql1["amount"];
				}else if ($mon==8){
					$totamt_8=$totamt_8+$row_sql1["amount"];
				}else if ($mon==9){
					$totamt_9=$totamt_9+$row_sql1["amount"];
				}else if ($mon==10){
					$totamt_10=$totamt_10+$row_sql1["amount"];
				}else if ($mon==11){
					$totamt_11=$totamt_11+$row_sql1["amount"];
				}else if ($mon==12){
					$totamt_12=$totamt_12+$row_sql1["amount"];
				}
				
			} else {
				if (date("Y", strtotime($_GET["dte_dor"]))!=2015){
					
				} else {
					if ($mon>5){
					}	
				}	
			}
			
			$mon=$mon+1;	
		}		
		
		$sql1="Select sum(payment) as paid from inc_credit_payment where c_code = '" . trim($row_sql["code"]) . "' and cyear = '" . date("Y", strtotime($_GET["dte_dor"])) . "'";
		$result1=$db->RunQuery($sql1);
		$row1 = $result1->fetch();
		$mpaid =0;
		if (!is_null($row1['paid'])) {
			$mpaid = $row1['paid'];
			$mtotpay = $mtotpay +  $row1['paid'];
		}
		
	}
	
	if (date("Y", strtotime($_GET["dte_dor"]))!=2015){	
	
	$grand_tot=$totamt_1+$totamt_2+$totamt_3+$totamt_4+$totamt_5+$totamt_6+$totamt_7+$totamt_8+$totamt_9+$totamt_10+$totamt_11+$totamt_12;
 
			   
	} else {
		$grand_tot=$totamt_6+$totamt_7+$totamt_8+$totamt_9+$totamt_10+$totamt_11+$totamt_12;
	
	}
    
        return 7;
    
}



?>

