fetch_data(); } protected function fetch_data(){ $this->scan_request_priorities = array(); $rqt = "select * from scan_request_priorities order by scan_request_priority_weight, scan_request_priority_label asc"; $res = pmb_mysql_query($rqt); if(pmb_mysql_num_rows($res)){ while($row = pmb_mysql_fetch_object($res)){ $this->scan_request_priorities[] =array( 'id' => $row->id_scan_request_priority, 'label' => $row->scan_request_priority_label, 'weight' => $row->scan_request_priority_weight ); } } } public function get_scan_request_priorities(){ return $this->scan_request_priorities; } public function get_selector_options($selected=0){ global $charset; global $deflt_scan_request_priorities; if(!$selected){ $selected=$deflt_scan_request_priorities; } $options = ""; for($i=0 ; $iscan_request_priorities) ; $i++){ $options.= " "; } return $options; } static function get_options($selected=0){ global $charset; $options = ''; $query = "select * from scan_request_priorities order by scan_request_priority_weight, scan_request_priority_label asc"; $result = pmb_mysql_query($query); if(pmb_mysql_num_rows($result)){ while($row = pmb_mysql_fetch_object($result)){ $options.= " "; } } return $options; } public function get_list($form_link="./admin.php?categ=scan_request&sub=priorities&action=edit"){ global $msg,$charset; $table = " "; for($i=0 ; $iscan_request_priorities) ; $i++){ $class = ($i%2 ? "odd":"even"); $table.= " "; } $table.= "

".$msg['scan_request_priorities_label']."	".$msg['scan_request_priority_weight']."
".htmlentities($this->scan_request_priorities[$i]['label'],ENT_QUOTES,$charset)."	".htmlentities($this->scan_request_priorities[$i]['weight'],ENT_QUOTES,$charset)."

"; return $table; } public function get_form($id=0,$url="./admin.php?categ=scan_request&sub=priorities"){ global $msg,$charset; global $scan_request_priority_form; $form =str_replace("!!action!!",$url,$scan_request_priority_form); if($id){ for($i=0 ; $iscan_request_priorities) ; $i++){ if($this->scan_request_priorities[$i]['id'] == $id){ $priority = $this->scan_request_priorities[$i]; break; } } } if($priority['id']){ $form = str_replace("!!form_title!!",$msg['scan_request_priorities_add'],$form); $form = str_replace("!!label!!",htmlentities($priority['label'],ENT_QUOTES,$charset),$form); $form = str_replace("!!weight!!",htmlentities($priority['weight'],ENT_QUOTES,$charset),$form); $form = str_replace("!!id!!",$priority['id'],$form); $form = str_replace("!!bouton_supprimer!!","",$form); $form.= confirmation_delete($url); }else{ $form = str_replace("!!form_title!!",$msg['scan_request_priorities_update'],$form); $form = str_replace("!!label!!","",$form); $form = str_replace("!!weight!!","1",$form); $form = str_replace("!!id!!",0,$form); $form = str_replace("!!bouton_supprimer!!","",$form); } return $form; } public function save(){ global $dbh; global $scan_request_priority_label, $scan_request_priority_id, $scan_request_priority_weight; if($scan_request_priority_id){ $scan_request_priority_id+=0; $scan_request_priority_weight+=0; $query = "update scan_request_priorities set "; $clause = "where id_scan_request_priority = ".$scan_request_priority_id; }else{ $query = "insert into scan_request_priorities set "; $clause = ""; } $query.= " scan_request_priority_label = '".$scan_request_priority_label."', scan_request_priority_weight = '".$scan_request_priority_weight."' "; $query.= " ".$clause; pmb_mysql_query($query); $this->fetch_data(); } public function delete($id){ global $msg,$charset; $id+=0; if(!$id){ return; } if($error){ print " "; }else{ $query = "delete from scan_request_priorities where id_scan_request_priority = ".$id; pmb_mysql_query($query); } $this->fetch_data(); } }