public function markAsComplete($params) { $db = new Dbase(); $project_name = $params['identifier']['project_name']; $q = "UPDATE projects SET completed = '1' WHERE name = '{$project_name}'"; logger("COMPLETED Query is : " . print_r($q, true)); $db->executeQuery($q); }
public function update($fields) { //logger( print_r( $fields, true ) ); logger("RiskMitigationPlan update function called.\nFields : " . print_r($fields, true)); $db = new Dbase(); $updateString = $db->createUpdateString($fields['result']); $q = "UPDATE RiskMitigationPlan SET " . $updateString . " WHERE id = {$this->id}"; logger("Update query : " . print_r($q, true)); $success = $db->executeQuery($q); return $success; // return status code, message instead of the above statement }
function getActiveProjects() { require_once 'utils/Dbase.php'; $q = "SELECT * FROM projects WHERE is_active = 1 ORDER BY id DESC"; $db = new Dbase(); $res = $db->executeQuery($q); $activeProjects = array(); while ($row = $res->fetch_assoc()) { $activeProjects[] = $row; } return $activeProjects; }
public function getLineItemIds() { $q = "SELECT * FROM projects_lineitems_mapping WHERE project_id = {$this->id}"; $db = new Dbase(); $res = $db->executeQuery($q); $lineItemIDsArray = array(); if ($res && $res->num_rows > 0) { while ($row = $res->fetch_assoc()) { $lineItemIDsArray[] = $row['lineitem_id']; } } $res->free(); $this->lineItemIDs = $lineItemIDsArray; }
public function __construct($id = -1) { parent::__construct(); $q = "SELECT * FROM lineitems WHERE id = {$id}"; $db = new Dbase(); $res = $db->executeQuery($q); if ($res && $res->num_rows > 0) { while ($row = $res->fetch_assoc()) { $this->id = $row['id']; // put the not NULL checks on $row[<members>] before initializing the classes // $this->name = $row['name']; $this->name = $row['name'] == "_PROJECT_" ? "OVERALL PROJECT" : $row['name']; $this->BRDRequirementObject = new BRDRequirement($row['brdrequirements_id']); $this->TechDevNeedObject = new TechDevNeed($row['techdevneed_id']); $this->ContentNeedObject = new ContentNeed($row['contentneed_id']); $this->TrainingNCommunicationPlanObject = new TrainingNCommunicationPlan($row['trainingncommunicationplan_id']); $this->CapabilitiesEnhancementObject = new CapabilitiesEnhancement($row['capabilitiesenhancement_id']); $this->CostBenefitObject = new CostBenefit($row['costbenefit_id']); $this->RiskMitigationPlanObject = new RiskMitigationPlan($row['riskmitigationplan_id']); $this->GoLivePlanObject = new GoLivePlan($row['goliveplan_id']); $this->ClosureModelObject = new ClosureModel($row['closure_id']); } } }