private function newVendor($name)
{
global $FANNIE_OP_DB;
$dbc = FannieDB::get($FANNIE_OP_DB);
$id = 1;
$p = $dbc->prepare_statement("SELECT max(vendorID) FROM vendors");
$rp = $dbc->exec_statement($p);
$rw = $dbc->fetch_row($rp);
if ($rw[0] != "") {
$id = $rw[0] + 1;
}
$model = new VendorsModel($dbc);
$model->vendorID($id);
$model->vendorName($name);
$model->vendorAbbreviation(substr($name, 0, 10));
$model->save();
echo $id;
}
function AjaxCallback()
{
$db = $this->db();
$json = array();
if (FormLib::get('action') == 'addVendor') {
$name = FormLib::get('newVendorName');
if (empty($name)) {
$json['error'] = 'Name is required';
} else {
$vendor = new VendorsModel($db);
$vendor->vendorName($name);
if (count($vendor->find()) > 0) {
$json['error'] = 'Vendor "' . $name . '" already exists';
} else {
$max = $db->query('SELECT MAX(vendorID) AS max
FROM vendors');
$newID = 1;
if ($max && ($maxW = $db->fetch_row($max))) {
$newID = (int) $maxW['max'] + 1;
}
$vendor->vendorAbbreviation(substr($name, 0, 10));
$vendor->vendorID($newID);
$vendor->save();
$json['vendorID'] = $newID;
$json['vendorName'] = $name;
}
}
} elseif (FormLib::get('dept_defaults') !== '') {
$json = array('tax' => 0, 'fs' => False, 'nodisc' => False);
$dept = FormLib::get_form_value('dept_defaults', '');
$p = $db->prepare_statement('SELECT dept_tax,dept_fs,dept_discount
FROM departments WHERE dept_no=?');
$r = $db->exec_statement($p, array($dept));
if ($db->num_rows($r)) {
$w = $db->fetch_row($r);
$json['tax'] = $w['dept_tax'];
if ($w['dept_fs'] == 1) {
$json['fs'] = True;
}
if ($w['dept_discount'] == 0) {
$json['nodisc'] = True;
}
}
} elseif (FormLib::get('vendorChanged') !== '') {
$v = new VendorsModel($db);
$v->vendorName(FormLib::get('vendorChanged'));
$matches = $v->find();
$json = array('error' => false);
if (count($matches) == 1) {
$json['localID'] = $matches[0]->localOriginID();
$json['vendorID'] = $matches[0]->vendorID();
} else {
$json['error'] = true;
}
}
echo json_encode($json);
}
