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); }