Change Supplier Code Missing Fields - SOLVED?

[VortecCPI]

Z_ChangeSupplierCode.php

This script is missing the following fields:

+ url
+ defaultshipper
+ defaultgl

I think this should do it:

PHP Code:

$sql = "INSERT INTO suppliers (`supplierid`,
        `suppname`,  `address1`, `address2`, `address3`,
        `address4`,  `address5`,  `address6`, `supptype`, `lat`, `lng`,
        `currcode`,  `suppliersince`, `paymentterms`, `lastpaid`,
        `lastpaiddate`, `bankact`, `bankref`, `bankpartics`,
        `remittance`, `taxgroupid`, `factorcompanyid`, `taxref`,
        `phn`, `port`, `email`, `fax`, `telephone`, `url`,
        `defaultshipper`, `defaultgl`)
    SELECT '" . $newCode . "',
        `suppname`,  `address1`, `address2`, `address3`,
        `address4`,  `address5`,  `address6`, `supptype`, `lat`, `lng`,
        `currcode`,  `suppliersince`, `paymentterms`, `lastpaid`,
        `lastpaiddate`, `bankact`, `bankref`, `bankpartics`,
        `remittance`, `taxgroupid`, `factorcompanyid`, `taxref`,
        `phn`, `port`, `email`, `fax`, `telephone`, `url`,
        `defaultshipper`, `defaultgl`
        FROM suppliers WHERE supplierid='" . $oldCode . "'"; 


[TimSchofield]

Why don't we do something like:

PHP Code:

DB_IgnoreForeignKeys()
$Result = DB_query("UPDATE suppliers SET supplierid='" . $NewCode . "' WHERE supplierid='" . $OldCode . "'");

.....

DB_ReinstateForeignKeys() 


Gets rid of the need for developers to remember this script when adding a new field to the suppliers table.

Tim

[VortecCPI]

Agreed. Very simple and elegant solution in my opinion. Also eliminates any maintenance issues due to extensions.