///User_drop_down// $sql = "SELECT * FROM users WHERE event_id=$event_id ORDER BY users.number ASC"; $db->query($sql); while ($db->next_record()) { $u_names[] = $db->f("number")." - ".$db->f("full_name"); $u_values[] = $db->f("id_user"); } $u_drop = html_drop_down_arrays_multiple('users',$u_names,$u_values,$selected,10); //tekma drop down// $sql = "Select * from tekma"; $db->query($sql); while ($db->next_record()) { $t_names[] = $db->f("name"); $t_values[] = $db->f("tekma_id"); } $t_drop = html_drop_down_arrays('tekma',$t_names,$t_values,$selected); //replace template variables// $tem = str_replace("##TITLE##",$title,$tem); $tem = str_replace("##USER_DROP##",$u_drop,$tem);
//dropdown ocene $qrating = range(1, 5); //dropdown pause hour $qpause_hour_time = range(0, 23); //dropdown pause minutes $qpause_min_time = range(0, 59); //multi drop down //$sql = "SELECT * FROM persons where id_role<11 and unit<>0 order by unit, letter ASC"; $sql = "select * from persons\r\nwhere\r\nid_person not in \r\n(\r\nSELECT person_id\r\nFROM work_log \r\nWHERE \r\n end=0 and\r\n start=0\r\n)\r\nand id_role<11\r\nand unit<>0\r\norder by unit, letter ASC\r\n"; $result = $db->fetchAll($sql); foreach ($result as $res) { $names[] .= $res["last"] . " " . $res["first"]; $values[] .= $res["id_person"]; } /////////// $multiname_dropdown = html_drop_down_arrays_multiple(multiname_drop, $names, $values, $selected, $size = FALSE, $style = true); $countMultiName = count($multiname_drop); // // //activity drop down $sql = "SELECT * FROM `work` WHERE `group`<'11'"; $result = $db->fetchAll($sql); foreach ($result as $res) { if (!is_array($ActivityName)) { $ActivityName[] = "izberi aktivnost..."; $ActivityValue[] = ""; } $ActivityName[] .= $res["applic"] . " --> " . $res["name"]; $ActivityValue[] .= $res["work_id"]; } ///////////
} /////////// $person_dropdown = html_drop_down_arrays("person_drop", $PersonName, $PersonValue, $last_add_user_id); //activity drop down $sql = "SELECT * FROM `work` WHERE `group`<'11' order by applic"; $result = $db->fetchAll($sql); foreach ($result as $res) { if (!is_array($ActivityName)) { $ActivityName[] = "izberi aktivnost..."; $ActivityValue[] = ""; } $ActivityName[] .= $res["applic"] . " --> " . $res["name"]; $ActivityValue[] .= $res["work_id"]; } /////////// $activity_dropdown = html_drop_down_arrays_multiple("activity_drop", $ActivityName, $ActivityValue, $ActivityName, 10); $aim_name_textbox = html_input_text("aim_name_text", $aim_name_textbox, 25, "default"); $aim_duration_textbox = html_input_text("aim_duration_text", $aim_duration_textbox, 5, '$aim_duration_text'); $aim_description_textbox = html_text_area("aim_description_text", $aim_description_textbox, 20, 50, "htmltextarea"); if ($expireDurationDate == "") { $expireDurationDate = '3000-01-01'; } ///////////////// //For geting from html // if ($_REQUEST['add'] == " Vstavi ") { $data = array('persons_id' => $_REQUEST[ime], 'name' => $_REQUEST[aim_name_text], 'created_by' => $person_id, 'description' => $_REQUEST[aim_description_text], 'expired_at' => $expireDurationDate, 'duration' => $aim_duration_text); $db->insert('aim', $data); //@todo Če slučajno še en vpiše takoj za tem bo prišlo do napake!!!!!!!!!! Popravi!! $getLastAimId = $dal->get_data_from_aim_order_by_id_desc(); $getLastAimIdLast = $getLastAimId[0];