public function selectOne($object, $where_filter_id = "", $filter_as_string = false) { if ($object->document_id() !== "") { //Check if the user is giving his username and that there is a value $tableName = \Applications\PMTool\Helpers\CommonHelper::GetShortClassName($object); $sql = 'SELECT * FROM `' . $tableName . '` where `document_id` = :document_id LIMIT 0, 1;'; } else { return NULL; } $sth = $this->dao->prepare($sql); $sth->bindValue(':document_id', $object->document_id(), \PDO::PARAM_INT); $sth->execute(); $sth->setFetchMode(\PDO::FETCH_CLASS | \PDO::FETCH_PROPS_LATE, '\\Applications\\PMTool\\Models\\Dao\\Document'); $document_out = $sth->fetch(); $sth->closeCursor(); return $document_out; }
public function deleteByProjectAndFilters($object, $filters, $projectId) { $tableName = \Applications\PMTool\Helpers\CommonHelper::GetShortClassName($object); $queryArray = array(); $query = ""; foreach ($filters as $filterName => $filterValue) { $queryArray[] = "`{$filterName}` = '{$filterValue}'"; } $query = implode(" AND ", $queryArray); try { $sql = $this->dao->query("DELETE tf.* FROM `{$tableName}` tf JOIN `task` t ON t.`task_id` = tf.`task_id` WHERE {$query} AND t.`project_id` = '{$projectId}';"); $sql->closeCursor(); return true; } catch (Exception $exc) { return false; } }
public function deleteByFilters($object, $filters) { $tableName = \Applications\PMTool\Helpers\CommonHelper::GetShortClassName($object); $queryArray = array(); $deleteQuery = "DELETE FROM `{$tableName}` WHERE "; foreach ($filters as $filterName => $filterValue) { $queryArray[] = "`{$filterName}` = :{$filterName}"; } $query = implode(" AND ", $queryArray); $deleteQuery .= $query; $sth = $this->dao->prepare($deleteQuery); foreach ($filters as $filterName => $filterValue) { $sth->bindValue(":{$filterName}", $filterValue, \PDO::PARAM_STR); } try { $sth->execute(); $sth->closeCursor(); return true; } catch (Exception $exc) { return false; } }
private function GetTableName($object) { return \Applications\PMTool\Helpers\CommonHelper::GetShortClassName($object); }