Lines Matching refs:project_id
129 $project_id = (int) $sqlite->res2single($res);
132 if(!$project_id) {
137 …("UPDATE project SET name = ?, `from` = ?, `to` = ? WHERE id = ?", $name, $from, $to, $project_id);
139 $task_id = $this->updateTask($project_id,$abbr,$name);
141 return $project_id;
149 * @param integer $project_id
154 public function updateTask($project_id,$abbr,$name) { argument
157 …ite->query('INSERT OR IGNORE INTO task (project_id,abbr,active) VALUES (?,?,1)',$project_id,$abbr);
159 $res = $sqlite->query("SELECT id FROM task WHERE project_id = ? AND abbr = ?", $project_id,$abbr);
180 public function setActiveTasks($project_id,$task_abbrs = array()) { argument
188 abbr NOT IN (".$task_abbrs.")",$project_id);
247 $project_id = (int) $sqlite->res2single($res);
250 if(!$project_id) {
254 return $project_id;
257 public function getPageByProjectId($project_id) { argument
266 $project_id);
308 public function getProjectDetails($project_id) { argument
316 $project_id);
629 * @param unknown $project_id
631 public function getProjectSumByWeek($project_id) { argument
647 $project_id);
657 public function getMinMaxDayByProject($project_id) { argument
668 $project_id);
857 $project_id = $task['project_id'];
858 $projectDetails = $this->getProjectDetails($project_id);
862 if($old_project_id != $project_id) {
864 'rowspan' => $project_counts[$project_id]
875 $dateValue = $dbUserValues[$project_id][$task_id][$dateText]['value'];
879 if(isset($dbUserValues[$project_id][$task_id][$dateText]['value_db'])) {
880 $date_sum_db[$dateText] += $dbUserValues[$project_id][$task_id][$dateText]['value_db'];
889 $el = $form->addTextInput("UserTime[$project_id][$task_id][$dateText]",'')
905 $old_project_id = $project_id;
956 public function canAccessProject($project_id) { argument
958 $pageid = $this->getPageByProjectId($project_id);