public function map_products_vendor($vendor_name) { $security_where = $_SESSION["do_crm_action_permission"]->get_user_where_condition('vendor', 11); $qry = "select * from `vendor` where `vendor_name` = ? " . $security_where; $stmt = $this->getDbConnection()->executeQuery($qry, array($vendor_name)); if ($stmt->rowCount() > 0) { $data = $stmt->fetch(); $idvendor = $data["idvendor"]; return $idvendor; } else { if (strlen($vendor_name) > 0) { $do_vendor = new Vendor(); $data = array("vendor_name" => CommonUtils::purify_input($vendor_name), "iduser" => $_SESSION["do_user"]->iduser, "added_on" => date("Y-m-d H:i:s")); $do_vendor->insert("vendor", $data); $idvendor = $do_vendor->getInsertId(); $do_vendor->insert("vendor_address", array("idvendor" => $idvendor)); $do_vendor->insert("vendor_custom_fld", array("idvendor" => $idvendor)); $do_vendor->free(); $do_data_history = new DataHistory(); $do_data_history->add_history($idvendor, 11, 'add'); $do_data_history->free(); return $idvendor; } } }