function ModifyBranch($BranchDetails, $user, $password) { $Errors = array(); $db = db($user, $password); if (gettype($db) == 'integer') { $Errors[0] = NoAuthorisation; return $Errors; } foreach ($BranchDetails as $key => $value) { $BranchDetails[$key] = DB_escape_string($value); } $Errors = VerifyBranchNoExists($BranchDetails['debtorno'], $BranchDetails['branchcode'], sizeof($Errors), $Errors, $db); $Errors = VerifyBranchName($BranchDetails['brname'], sizeof($Errors), $Errors, $db); if (isset($BranchDetails['address1'])) { $Errors = VerifyBranchAddressLine($BranchDetails['address1'], 40, sizeof($Errors), $Errors, $db); } if (isset($BranchDetails['address2'])) { $Errors = VerifyBranchAddressLine($BranchDetails['address2'], 40, sizeof($Errors), $Errors, $db); } if (isset($BranchDetails['address3'])) { $Errors = VerifyBranchAddressLine($BranchDetails['address3'], 40, sizeof($Errors), $Errors, $db); } if (isset($BranchDetails['address4'])) { $Errors = VerifyBranchAddressLine($BranchDetails['address4'], 50, sizeof($Errors), $Errors, $db); } if (isset($BranchDetails['address5'])) { $Errors = VerifyBranchAddressLine($BranchDetails['address5'], 20, sizeof($Errors), $Errors, $db); } if (isset($BranchDetails['address6'])) { $Errors = VerifyBranchAddressLine($BranchDetails['address6'], 15, sizeof($Errors), $Errors, $db); } if (isset($BranchDetails['lat'])) { $Errors = VerifyLatitude($BranchDetails['lat'], sizeof($Errors), $Errors); } if (isset($BranchDetails['lng'])) { $Errors = VerifyLongitude($BranchDetails['lng'], sizeof($Errors), $Errors); } if (isset($BranchDetails['estdeliverydays'])) { $Errors = VerifyEstDeliveryDays($BranchDetails['estdeliverydays'], sizeof($Errors), $Errors); } if (isset($BranchDetails['area'])) { $Errors = VerifyAreaCode($BranchDetails['area'], sizeof($Errors), $Errors, $db); } if (isset($BranchDetails['salesman'])) { $Errors = VerifySalesmanCode($BranchDetails['salesman'], sizeof($Errors), $Errors, $db); } if (isset($BranchDetails['fwddate'])) { $Errors = VerifyFwdDate($BranchDetails['fwddate'], sizeof($Errors), $Errors); } if (isset($BranchDetails['phoneno'])) { $Errors = VerifyPhoneNumber($BranchDetails['phoneno'], sizeof($Errors), $Errors); } if (isset($BranchDetails['faxno'])) { $Errors = VerifyFaxNumber($BranchDetails['faxno'], sizeof($Errors), $Errors); } if (isset($BranchDetails['contactname'])) { $Errors = VerifyContactName($BranchDetails['contactname'], sizeof($Errors), $Errors); } if (isset($BranchDetails['email'])) { $Errors = VerifyEmailAddress($BranchDetails['email'], sizeof($Errors), $Errors); } if (isset($BranchDetails['defaultlocation'])) { $Errors = VerifyDefaultLocation($BranchDetails['defaultlocation'], sizeof($Errors), $Errors, $db); } if (isset($BranchDetails['taxgroupid'])) { $Errors = VerifyTaxGroupId($BranchDetails['taxgroupid'], sizeof($Errors), $Errors, $db); } if (isset($BranchDetails['defaultshipvia'])) { $Errors = VerifyDefaultShipVia($BranchDetails['defaultshipvia'], sizeof($Errors), $Errors, $db); } if (isset($BranchDetails['deliverblind'])) { $Errors = VerifyDeliverBlind($BranchDetails['deliverblind'], sizeof($Errors), $Errors); } if (isset($BranchDetails['disabletrans'])) { $Errors = VerifyDisableTrans($BranchDetails['disabletrans'], sizeof($Errors), $Errors); } if (isset($BranchDetails['brpostaddr1'])) { $Errors = VerifyBranchAddressLine($BranchDetails['brpostaddr1'], 40, sizeof($Errors), $Errors, $db); } if (isset($BranchDetails['brpostaddr2'])) { $Errors = VerifyBranchAddressLine($BranchDetails['brpostaddr2'], 40, sizeof($Errors), $Errors, $db); } if (isset($BranchDetails['brpostaddr3'])) { $Errors = VerifyBranchAddressLine($BranchDetails['brpostaddr3'], 30, sizeof($Errors), $Errors, $db); } if (isset($BranchDetails['brpostaddr4'])) { $Errors = VerifyBranchAddressLine($BranchDetails['brpostaddr4'], 20, sizeof($Errors), $Errors, $db); } if (isset($BranchDetails['brpostaddr5'])) { $Errors = VerifyBranchAddressLine($BranchDetails['brpostaddr5'], 20, sizeof($Errors), $Errors, $db); } if (isset($BranchDetails['brpostaddr6'])) { $Errors = VerifyBranchAddressLine($BranchDetails['brpostaddr6'], 15, sizeof($Errors), $Errors, $db); } if (isset($BranchDetails['specialinstructions'])) { $Errors = VerifySpecialInstructions($BranchDetails['specialinstructions'], sizeof($Errors), $Errors); } if (isset($BranchDetails['custbranchcode'])) { $Errors = VerifyCustBranchCode($BranchDetails['custbranchcode'], sizeof($Errors), $Errors); } $FieldNames = ''; $FieldValues = ''; foreach ($BranchDetails as $key => $value) { $FieldNames .= $key . ', '; $FieldValues .= '"' . $value . '", '; } $sql = 'UPDATE custbranch SET '; foreach ($BranchDetails as $key => $value) { $sql .= $key . '="' . $value . '", '; } $sql = mb_substr($sql, 0, -2) . " WHERE debtorno='" . $BranchDetails['debtorno'] . "'\n AND branchcode='" . $BranchDetails['branchcode'] . "'"; if (sizeof($Errors) == 0) { $result = DB_Query($sql, $db); if (DB_error_no() != 0) { $Errors[0] = DatabaseUpdateFailed; } else { $Errors[0] = 0; } } return $Errors; }
function ModifyLocation($Location, $user, $password) { $Errors = array(); $db = db($user, $password); if (gettype($db) == 'integer') { $Errors[0] = NoAuthorisation; return $Errors; } foreach ($Location as $key => $value) { $Location[$key] = DB_escape_string($value); } $Errors = VerifyLocationExists($Location['loccode'], sizeof($Errors), $Errors, $db); $Errors = VerifyLocationName($Location['locationname'], sizeof($Errors), $Errors, $db); $Errors = VerifyTaxProvinceId($Location['taxprovinceid'], sizeof($Errors), $Errors, $db); if (isset($Location['deladd1'])) { $Errors = VerifyAddressLine($Location['deladd1'], 40, sizeof($Errors), $Errors); } if (isset($Location['deladd2'])) { $Errors = VerifyAddressLine($Location['deladd2'], 40, sizeof($Errors), $Errors); } if (isset($Location['deladd3'])) { $Errors = VerifyAddressLine($Location['deladd3'], 40, sizeof($Errors), $Errors); } if (isset($Location['deladd4'])) { $Errors = VerifyAddressLine($Location['deladd4'], 40, sizeof($Errors), $Errors); } if (isset($Location['deladd5'])) { $Errors = VerifyAddressLine($Location['deladd5'], 20, sizeof($Errors), $Errors); } if (isset($Location['deladd6'])) { $Errors = VerifyAddressLine($Location['deladd6'], 15, sizeof($Errors), $Errors); } if (isset($Location['tel'])) { $Errors = VerifyPhoneNumber($Location['tel'], sizeof($Errors), $Errors); } if (isset($Location['fax'])) { $Errors = VerifyFaxNumber($Location['fax'], sizeof($Errors), $Errors); } if (isset($Location['email'])) { $Errors = VerifyEmailAddress($Location['email'], sizeof($Errors), $Errors); } if (isset($Location['contact'])) { $Errors = VerifyContactName($Location['contact'], sizeof($Errors), $Errors); } $sql = 'UPDATE locations SET '; foreach ($Location as $key => $value) { $sql .= $key . '="' . $value . '", '; } $sql = substr($sql, 0, -2) . ' WHERE loccode="' . $Location['loccode'] . '"'; if (sizeof($Errors) == 0) { $result = DB_Query($sql, $db); if (DB_error_no($db) != 0) { $Errors[0] = DatabaseUpdateFailed; } else { $Errors[0] = 0; } } return $Errors; }