Search options (Page 2 of 2)

?> <script> document.getElementByName('ref').value='001/2018'; </script><?php  // just testing  

?> document.getElementByName('ref').value= '<?php echo $ref . "';"; // I added this line

$sql = "SELECT a.*, 
        SUM(IF(ISNULL(g.amount), NULL, IF(g.amount > 0, g.amount, 0))) AS amount,
        u.user_id, a.description, 
        UNIX_TIMESTAMP(a.stamp) as unix_stamp ...

    //$cols = array(0, 60, 120, 180, 240, 340, 400, 460, 520);
    $cols = array(-10, 40, 80, 120, 170, 250, 280, 500, 560);

        if (!$myrow['description']){
        if ($myrow['gl_seq'] == null)
            $action = _('Updated');
        else
            $action = _('Created');     
        } else {
            $action = $myrow['description'];   
        }
        $rep->TextCol(6, 7, $action);

    //add_audit_trail($type, $type_no, $date_, _("Voided.")."\n".$memo_);
    add_audit_trail($type, $type_no, $date_, _("Voided.")." ".$memo_);

<?php

$path_to_root = "..";
$page_security = 'SA_CUSTOMER';

include_once($path_to_root . "/sales/includes/cart_class.inc");
include_once($path_to_root . "/includes/session.inc");
include_once($path_to_root . "/sales/includes/sales_ui.inc");
include_once($path_to_root . "/sales/includes/ui/sales_order_ui.inc");
include_once($path_to_root . "/sales/includes/sales_db.inc");
include_once($path_to_root . "/sales/includes/db/sales_types_db.inc");
include_once($path_to_root . "/reporting/includes/reporting.inc");
include_once($path_to_root . "/includes/ui/ui_controls.inc");
include_once($path_to_root . "/includes/date_functions.inc");
include_once($path_to_root . "/includes/data_checks.inc");
include_once($path_to_root . "/gl/includes/gl_db.inc");
include_once($path_to_root . "/sales/includes/db/customers_db.inc");

$js = '';

page("Merge Customers", false, false, "", $js);

        $deletecustomer = $_POST['deletecustomer'];
        $keepcustomer = $_POST['keepcustomer'];
        
        
        if ($keepcustomer  && $deletecustomer){                
        
        if ($keepcustomer == $deletecustomer) 
            die("<center>You chose the same customer in both selections. Cannot merge a customer with himself/herself. <br /><br /><a href=\"merge.php\">Reload</a><br /><br /><br />");
        $sql = "UPDATE 0_debtor_trans SET `debtor_no` = $keepcustomer, branch_code = (select branch_code from 0_cust_branch where debtor_no = $keepcustomer limit 1) WHERE `debtor_no` = $deletecustomer";
        $result = db_query($sql, "An error occured");

        $sql = "UPDATE 0_sales_orders SET `debtor_no` = $keepcustomer, delivery_address = '', contact_phone = '', deliver_to = '', branch_code = (select branch_code from 0_cust_branch where debtor_no = $keepcustomer limit 1) WHERE `debtor_no` = $deletecustomer";
        $result = db_query($sql, "An error occured");

        $sql = "UPDATE 0_cust_allocations SET `person_id` = $keepcustomer WHERE `person_id` = $deletecustomer";
        $result = db_query($sql, "An error occured");

        $sql = "DELETE FROM 0_debtors_master where debtor_no = $deletecustomer"; 
        $result = db_query($sql, "An error occured");

        $sql = "DELETE FROM 0_cust_branch where debtor_no = $deletecustomer"; 
        $result = db_query($sql, "An error occured");

        $sql = "DELETE FROM 0_crm_contacts where type = 'customer' AND entity_id = $deletecustomer"; 
        $result = db_query($sql, "An error occured");

        $sql = "DELETE FROM 0_crm_contacts where type = 'cust_branch' AND entity_id = (select branch_code from 0_cust_branch where debtor_no = $deletecustomer)"; 
        $result = db_query($sql, "An error occured");

        $sql = "DELETE FROM 0_crm_persons where type = 'customer' AND id = (select person_id from 0_crm_contacts where type = 'customer' AND entity_id = $deletecustomer limit 1)"; 
        $result = db_query($sql, "An error occured");
        
    header("Location: ..");
        }

    $sql = "SELECT  debtor_no,  name FROM  `0_debtors_master`  ORDER BY 'name' ASC ";
    $result = db_query($sql, "An error occured");
echo "<form method=\"post\">";
echo "<center><br /><br /><b class=\"headingtext\">NOTE: THIS ACTION IS IRREVOCABLE</b><br /><br /><table style= \"width:70% \">  <tr>  <td colspan= \"6 \">Merge & Delete this customer</td>  <th> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  </th>  <td colspan= \"6 \">Keep this customer</td>   </tr>  <tr>  <td colspan= \"6 \"><select id= \"deletecustomer\" name= \"deletecustomer\" class= \"combo2 \" title= \"Merge & Delete customer \" _last= \"14 \">";

    while ($myrow = db_fetch($result))
    {
        echo "<option value= \"" . $myrow['debtor_no'] . " \">" . $myrow['name'] . " </option>"; 
    }

    echo "</select></td>  <td colspan= \"2 \"><font size= \"6 \"> &nbsp; &nbsp; &rArr; &nbsp; &nbsp; &nbsp; </font> </td><td colspan= \"6 \"><select id= \"keepcustomer\" name= \"keepcustomer\" class= \"combo2 \" title= \"Merge & keep customer \" _last= \"14 \">";
    
    
    $sql = "SELECT  debtor_no,  name FROM  `0_debtors_master`  ORDER BY 'name' ASC ";
    $result = db_query($sql, "An error occured");
        while ($myrow = db_fetch($result))
    {
        //echo $myrow['debtor_no'] . " " . $myrow['name'] . "<br />";
        echo "<option value= \"" . $myrow['debtor_no'] . " \">" . $myrow['name'] . " </option>"; 
    }
    
    echo "</select></td>  </tr>";


echo "</table>";

echo "<br /><br /><br /><input type=\"submit\" value=\" Merge Customers \"> &nbsp; &nbsp; <input type=\"submit\" formaction=\"..\" value=\" Cancel \" > </center>";
//&nbsp; &nbsp; <input type=\"submit\" formaction=\"..\" value=\" Cancel \" >
echo "</form><br /><br /><br />";

end_page();