- 20051026 * @desc save global category model */ public function save_element($p_cat_level, &$p_intOldRecStatus) { $intErrorCode = -1; // ErrorCode $l_catdata = $this->get_general_data(); $p_intOldRecStatus = $l_catdata["isys_catg_supply_list__status"]; $l_intNewRecStatus = C__RECORD_STATUS__NORMAL; if ($l_catdata['isys_catg_supply_list__id'] != "") { $l_strSql = "UPDATE isys_catg_supply_list ". "SET ". "isys_catg_supply_list__price = ". $this->convert_sql_text($_POST['C__CATG__SUPPLY_PRICE']).", ". $this->convert_sql_text($_POST['C__CATG__SUPPLY_DISTRIBUTOR']).", ". "isys_catg_supply_list__title = ". $this->convert_sql_text($_POST['C__CATG__SUPPLY_DISTRIBUTOR']).", ". //$this->convert_sql_text($_POST['C__CMDB__CAT__PRICE']).", ". //"isys_catg_price_list__description = ". //$this->convert_sql_text($_POST['C__CMDB__CAT__COMMENTARY']).", ". //"isys_catg_model_list__isys_model_manufacturer__id = ". //$this->convert_sql_id($_POST['C__CATG__MODEL_MANUFACTURER']).", ". //"isys_catg_model_list__isys_model_title__id = ". //$this->convert_sql_id($_POST['C__CATG__MODEL_TITLE_ID']).", ". //"isys_catg_model_list__serial = ". //$this->convert_sql_text($_POST['C__CATG__MODEL_SERIAL']).", ". //"isys_catg_model_list__firmware = ". //$this->convert_sql_text($_POST['C__CATG__MODEL_FIRMWARE']).", ". "isys_catg_price_list__status = ". "'".$l_intNewRecStatus."' ". "WHERE ". "isys_catg_supply_list__id = '". $l_catdata['isys_catg_supply_list__id']."'". ";"; $l_bRet = $this->update($l_strSql); if ($l_bRet) { $l_bRet = $this->apply_update(); } } return $l_bRet == ISYS_TRUE ? NULL : $intErrorCode ; } /** * @param $p_cat_level level to save, standard 0 * (usage by reason of universality) * @param &$p_new_id returns the __id of the new record * @author Oliver Steigleder - 20051026 * @desc save global category model element */ public function create_element($p_cat_level, &$p_new_id) { $p_new_id = -1; // no success $intRetCode = 3; $l_catdata = $this->get_general_data(); $l_fk_id = $l_catdata["isys_catg_supply__id"]; $l_strSql = "INSERT INTO ". "isys_catg_supply_list ". "SET ". "isys_catg_supply_list__isys_catg_supply__id = '".$l_fk_id."', ". "isys_catg_supply_list__distributor = 'Neuer Preis $l_fk_id', ". //"isys_catg_price_list__price = '1.00', ". "isys_catg_supply_list__status = '".C__RECORD_STATUS__NORMAL."' ". ";"; $l_bRet = $this->update($l_strSql); if ($l_bRet) { $l_bRet = $this->apply_update(); if($l_bRet) { $l_strSQL = "SELECT @insertID := (SELECT LAST_INSERT_ID()) as id;"; $l_result = $this->retrieve($l_strSQL); if ($l_result) { if($l_result->num_rows() > 0) { $l_data = $l_result->get_row(); $intRetCode = ISYS_NULL; // OK $p_new_id = $l_data["id"]; // last insert id } } } } return $intRetCode; } /** * @author Oliver Steigleder - 2005-10-26 * @return TRUE if posted Data is verified, FALSE if not * @desc verifiy posted data, save set_additional_rules and validation state for further usage.. */ public function is_validate_post_data() { $l_retValid = ISYS_TRUE; $l_arrTomAdditional = array(); // check conditions and write error // first condition /*if ($_POST["C__CATG__MODEL_TITLE"]==""){ $l_arrTomAdditional["C__CATG__MODEL_TITLE"]["p_strInfoIconError"] = "[eingabepflichtiges Feld]"; $l_retValid = ISYS_FALSE; } */ // add more... $this->set_additional_rules($l_retValid == ISYS_FALSE ? $l_arrTomAdditional : ISYS_NULL); $this->set_validation($l_retValid); return $l_retValid; } public function &get_ui() { global $g_comp_template; return new isys_cmdb_ui_category_g_supply($g_comp_template); } public function __construct(isys_component_database &$p_db) { parent::__construct($p_db); } } ?>