query($deleteOptionSql); $deleteSql = "delete from `projects` where `project_id`=".$deleteId; $deleteExec = $dbUtil->query($deleteSql); $u = "projects.php"; redirect($u); } } $userId = $_SESSION['login_id']; $sqlSelect = "select *from `users` where `user_id`='$userId'"; $userSelect = $dbUtil->query($sqlSelect); $rowNum = $dbUtil->numRows($userSelect); $userText=""; $userType=""; if ($rowNum > 0) { while($user = mysql_fetch_array($userSelect)) { $userText = $user['firstname']. " ".$user['lastname']; $userType = $user['TYPE']; } } //projects $filterDatumProvedbe = $_REQUEST['filterDatumProvedbe']; $filterSektor = $_REQUEST['filterSektor']; $filterProracun = $_REQUEST['filterProracun']; $filterPodrucjeProjekta = $_REQUEST['filterPodrucjeProjekta']; $filterPrioritet = $_REQUEST['filterPrioritet']; $filterPodnositeljPrijave = $_REQUEST['filterPodnositeljPrijave']; $filterVrstaPredlagatelja = $_REQUEST['filterVrstaPredlagatelja']; $filterMjera = $_REQUEST['filterMjera']; $filterPrijavljen = $_REQUEST['filterPrijavljen']; $linkBuild = ""; if ($filterDatumProvedbe != "" || $filterSektor != "" || $filterProracun != "" || $filterPodrucjeProjekta != "" || $filterPrioritet != "" || $filterPodnositeljPrijave != "" || $filterVrstaPredlagatelja != "" || $filterMjera != "" || $filterPrijavljen != "") { $linkBuild="filterDatumProvedbe=$filterDatumProvedbe&filterSektor=$filterSektor&filterProracun=$filterProracun&filterPodrucjeProjekta=$filterPodrucjeProjekta&filterPrioritet=$filterPrioritet&filterPodnositeljPrijave=$filterPodnositeljPrijave&filterVrstaPredlagatelja=$filterVrstaPredlagatelja&filterMjera=$filterMjera&filterPrijavljen=$filterPrijavljen&"; $selectAllProjects = "select *from `projects` p inner join `project_options` o on o.project_id = p.project_id where"; $andChar = false; if ($filterDatumProvedbe != "") { $selectAllProjects .= " p.date_preparation='$filterDatumProvedbe' "; if ($filterSektor != "" || $filterProracun != "" || $filterPodrucjeProjekta != "" || $filterPrioritet != "" || $filterPodnositeljPrijave != "" || $filterVrstaPredlagatelja != "" || $filterMjera != "" || $filterPrijavljen != "") { $andChar = true; } } if ($filterSektor != "") { if ($andChar) { $selectAllProjects .="and"; $andChar = false; } $selectAllProjects .= " o.option_id=$filterSektor "; if ($filterProracun != "" || $filterPodrucjeProjekta != "" || $filterPrioritet != "" || $filterPodnositeljPrijave != "" || $filterVrstaPredlagatelja != "" || $filterMjera != "" || $filterPrijavljen != "") { $andChar = true; } } if ($filterProracun != "") { if ($andChar) { $selectAllProjects .="and"; $andChar = false; } $selectAllProjects .= " o.option_id=96 and o.values like '%$filterProracun%' "; if ($filterPodrucjeProjekta != "" || $filterPrioritet != "" || $filterPodnositeljPrijave != "" || $filterVrstaPredlagatelja != "" || $filterMjera != "" || $filterPrijavljen != "") { $andChar = true; } } if ($filterPodrucjeProjekta != "") { if ($andChar) { $selectAllProjects .="and"; $andChar = false; } $selectAllProjects .= " o.option_id=77 and o.values like '%$filterPodrucjeProjekta%' "; if ($filterPrioritet != "" || $filterPodnositeljPrijave != "" || $filterVrstaPredlagatelja != "" || $filterMjera != "" || $filterPrijavljen != "") { $andChar = true; } } if ($filterPrioritet != "") { if ($andChar) { $selectAllProjects .="and"; $andChar = false; } $selectAllProjects .= " o.option_id=$filterPrioritet "; if ($filterPodnositeljPrijave != "" || $filterVrstaPredlagatelja != "" || $filterMjera != "" || $filterPrijavljen != "") { $andChar = true; } } if ($filterPodnositeljPrijave != "") { if ($andChar) { $selectAllProjects .="and"; $andChar = false; } $selectAllProjects .= " p.applicant_name='$filterPodnositeljPrijave' "; if ($filterVrstaPredlagatelja != "" || $filterMjera != "" || $filterPrijavljen != "") { $andChar = true; } } if ($filterVrstaPredlagatelja != "") { if ($andChar) { $selectAllProjects .="and"; $andChar = false; } $selectAllProjects .= " o.option_id=$filterVrstaPredlagatelja "; if ($filterMjera != "" || $filterPrijavljen != "") { $andChar = true; } } if ($filterMjera != "") { if ($andChar) { $selectAllProjects .="and"; $andChar = false; } $selectAllProjects .= " o.option_id=$filterMjera "; if ($filterPrijavljen != "") { $andChar = true; } } if ($filterPrijavljen != "") { if ($andChar) { $selectAllProjects .="and"; $andChar = false; } $selectAllProjects .= " o.option_id=$filterPrijavljen "; } } else { $selectAllProjects="select *from `projects`"; } $selectAllProjects = $selectAllProjects . " group by 1 "; $rowNumbers=$_REQUEST['rowNumbers'];//page number if(!isset($rowNumbers)){ $rowNumbers="1"; } $allProjects=$dbUtil->query($selectAllProjects); $allProjectsRows=$dbUtil->numRows($allProjects); $limit=10; //10 rezultata po stranici if ($allProjectsRows == $limit) { $pages = 1; } else { $pages=floor($allProjectsRows/$limit)+1; //broj stranica } $results=($rowNumbers-1)*$limit;//od kojeg reda se pocinje if ($filterDatumProvedbe != "" || $filterSektor != "" || $filterProracun != "" || $filterPodrucjeProjekta != "" || $filterPrioritet != "" || $filterPodnositeljPrijave != "" || $filterVrstaPredlagatelja != "" || $filterMjera != "" || $filterPrijavljen != "") { $sqlProjectsSelect = $selectAllProjects." limit $results,$limit"; } else { $sqlProjectsSelect = "select *from `projects` group by 1 limit $results,$limit"; } $projectsSelect = $dbUtil->query($sqlProjectsSelect); ?>