Exemplo n.º 1
0


///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);
Exemplo n.º 2
0
//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"];
}
///////////
Exemplo n.º 3
0
}
///////////
$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];