Task

An object for adding, viewing, editing and deleting a specific task.

Filename: /admin/tools/WMT\SQL\Task.php
Database Table: tasks
Extends: Result
Extends: AbstractDatabase

Task PHP Methods

activeString() _v4.92

add($postVals) _v4.23

Adds a new record. The $postVals is an array of the values for each column when adding the record. Returns 0 if fails, returns the id of the new record if success.

addTask($title, $active, $tID, $tAID, $taskType, $taskTypeID, $performBy, $tUType, $complete) _v4.92

assign($uID) _v4.92

assignSkill($skillID, $order = 1) _v4.92

completeString() _v4.92

convertHTML($htmlContent = '') _v4.23

Converts ~~ variables in the $htmlContent that is provided and returns the converted content. The title of the ~~ variables are converted by the content from the column in the database with the matching title.

deleteThis($restoreQuery = '') _v4.23

Deletes the loaded record from the database. |
$restoreQuery = FOR INTERNAL USE. FOR TYPICAL USAGE LEAVE THIS BLANK. The restore query to pass along when deleting an object with dependencies.

duplicateThis($newValues = null) _v4.92

Creates a duplicate record in the database of the current object and returns the id of the new record.

getActive() _v4.92

getActiveString() _v4.92

getAdminApprove() _v4.92

getAID() _v4.92

getBonus() _v4.92

static getClientName($tAID) _v4.92

getComplete() _v4.92

getDefaultTRHTML() _v4.23

Returns the default html code for a tr row with all of the fields from the database in it as ~~ vars

static getEmployeeName($eID) _v4.92

getHasQuestion() _v4.92

getID() _v4.92

getMaxCredits() _v4.92

getMaxCreditsTitle() _v4.92

getPerformBy() _v4.92

getPresetEmails($site) _v4.92

getPrimarySkill() _v4.92

getPrimarySkillID() _v4.92

getProjectManager() _v4.92

getProjectManagerID() _v4.92

getRateType() _v4.92

getRateTypeColor() _v4.92

getRateTypeTitle() _v4.92

getSkillLevel() _v4.92

getSkillLevelHTML() _v4.92

getSkillLevelMinScore() _v4.92

getSkillLevelTitle() _v4.92

getStatusTitle() _v4.92

getTaskBefore() _v4.92

getTaskIsForLink() _v4.92

getTaskListID() _v4.92

getTID() _v4.92

getType() _v4.92

getTypeID() _v4.92

getTypeTitle() _v4.92

getUpdated() _v4.92

getUType() _v4.92

static getUTypeString($tUType) _v4.92

getValue($fieldName) _v4.23

Returns the value from a specific column for this record. |
$fieldName = The name of the column to get the value from.

hideAllFields() _v4.23

Hides all of the columns (fields) from the database table from being returned in the results.

hideField($fieldTitle) _v4.23

Hides a specific column (field) from the database table from being returned in the results.

loadInProgress() _v4.92

loadNoteCount($utID) _v4.92

loadTask($taskID) _v4.92

loadValues($id) _v4.23

Loads values for the record with the id specified. Returns 0 if not found, 1 if success

loadValuesWhere($whereString = 'id=1') _v4.23

Loads values for the record matching the criteria specified by $whereString. If the there is more than one record returned from the query then only the first record is loaded. Returns 0 if not found, 1 if success. |
$whereString = The condition to use to filter the results. Should be mysql format.

removeSkill($assignID) _v4.92

save($postVals) _v4.23

Saves the record with the new values specified in the $postVals array. |
$postVals = An array containing the values to be stored. The key of the array is used for the column name and the value of the array is the value to be stored in that column.

setAdminApprove($nAApprove) _v4.92

setHasQuestion($nHasQuestion) _v4.92

setMaxCredits($nMaxCredits) _v4.92

setRateType($tRT) _v4.92

setSkillLevel($nSkillLevel) _v4.92

setUpdated($nUpdated) _v4.92

showAllFields() _v4.23

Shows all the columns (fields) from the database table in the results that are returned.

showField($fieldTitle) _v4.23

Shows a specific column (field) from the database table in the results that are returned.

startTask($eID) _v4.92

Task PHP Variables

$added _v4.92

$descr _v4.92

$employeeName _v4.92

$inProgress _v4.92

$noteCount _v4.92

$noteType _v4.92

$priority _v4.92

$readytoapprove _v4.92

$taskIsFor _v4.92

$title _v4.92

$uType _v4.92

$uTypeString _v4.92

Columns in the tasks Database Table:

id member tasklistid tasktype tasktypeid title description complete taskbefore active added performby bonus utype readytoapprove priority aeid ratetype hasquestion updated skilllevel maxcredits adminapprove

Code Example

Use the code below to view a record in an html page:

<?php
// ###PUT YOUR CONTENT BELOW###
 $id = 1;  // The ID of the record being retrieved

// The HTML Code that we will convert the ~~ values inside of it
 $content = "<table>"; 
 $content .= "<tr><td>id<td>~id~</tr>";
 $content .= "<tr><td>member<td>~member~</tr>";
 $content .= "<tr><td>tasklistid<td>~tasklistid~</tr>";
 $content .= "<tr><td>tasktype<td>~tasktype~</tr>";
 $content .= "<tr><td>tasktypeid<td>~tasktypeid~</tr>";
 $content .= "<tr><td>title<td>~title~</tr>";
 $content .= "<tr><td>description<td>~description~</tr>";
 $content .= "<tr><td>complete<td>~complete~</tr>";
 $content .= "<tr><td>taskbefore<td>~taskbefore~</tr>";
 $content .= "<tr><td>active<td>~active~</tr>";
 $content .= "<tr><td>added<td>~added~</tr>";
 $content .= "<tr><td>performby<td>~performby~</tr>";
 $content .= "<tr><td>bonus<td>~bonus~</tr>";
 $content .= "<tr><td>utype<td>~utype~</tr>";
 $content .= "<tr><td>readytoapprove<td>~readytoapprove~</tr>";
 $content .= "<tr><td>priority<td>~priority~</tr>";
 $content .= "<tr><td>aeid<td>~aeid~</tr>";
 $content .= "<tr><td>ratetype<td>~ratetype~</tr>";
 $content .= "<tr><td>hasquestion<td>~hasquestion~</tr>";
 $content .= "<tr><td>updated<td>~updated~</tr>";
 $content .= "<tr><td>skilllevel<td>~skilllevel~</tr>";
 $content .= "<tr><td>maxcredits<td>~maxcredits~</tr>";
 $content .= "<tr><td>adminapprove<td>~adminapprove~</tr>";
 $content .= "</table>";

// ###PUT YOUR CONTENT ABOVE###


 include("dbconn.php");                // Setup database connection
 include("admin/admin-settings.php");  // Setup required core objects
 include("admin/tools/WMT\SQL\Task.php");  // Include this object

 $task = new Task();  //Create object
 $task->loadValues($id);
 $converted = $task->convertHTML($content);  //Convert ~~ Codes

 echo $converted;  // Display results

Use the code below to add a record:

// ###PUT YOUR CONTENT BELOW###
 $id = 1;  // The ID of the record being retrieved

// The values to use for creating a new record
 $valueArray = array();
 $valueArray["id"] = "INT UNSIGNED NOT NULL auto_increment";
 $valueArray["member"] = "INT UNSIGNED";
 $valueArray["tasklistid"] = "INT UNSIGNED";
 $valueArray["tasktype"] = "INT UNSIGNED";
 $valueArray["tasktypeid"] = "INT UNSIGNED";
 $valueArray["title"] = "VARCHAR(255)";
 $valueArray["description"] = "TEXT";
 $valueArray["complete"] = "INT UNSIGNED DEFAULT 0";
 $valueArray["taskbefore"] = "INT UNSIGNED DEFAULT 0";
 $valueArray["active"] = "tinyint(1)";
 $valueArray["added"] = "INT UNSIGNED";
 $valueArray["performby"] = "tinyint(4)";
 $valueArray["bonus"] = "smallint(5) unsigned DEFAULT 0";
 $valueArray["utype"] = "TINYINT UNSIGNED DEFAULT 0";
 $valueArray["readytoapprove"] = "tinyint(1) DEFAULT 0";
 $valueArray["priority"] = "tinyint(4) default '5'";
 $valueArray["aeid"] = "INT UNSIGNED DEFAULT 0";
 $valueArray["ratetype"] = "smallint(6) DEFAULT 0";
 $valueArray["hasquestion"] = "tinyint(1) DEFAULT 0";
 $valueArray["updated"] = "INT UNSIGNED DEFAULT 0";
 $valueArray["skilllevel"] = "INT UNSIGNED NOT NULL default '1'";
 $valueArray["maxcredits"] = "smallint(5) unsigned DEFAULT 0";
 $valueArray["adminapprove"] = "tinyint(1) default '1'";

// ###PUT YOUR CONTENT ABOVE###


 include("dbconn.php");                // Setup database connection
 include("admin/admin-settings.php");  // Setup required core objects
 include("admin/tools/WMT\SQL\Task.php");  // Include this object

 $task = new Task();  //Create object
 $task->add($valueArray);  // Add the record

 echo $task->getValue("id");  // Echo the id of the newly created record

Use the code below to delete a record:

// ###PUT YOUR CONTENT BELOW###
 $id = 1;  // The ID of the record being deleted
// ###PUT YOUR CONTENT ABOVE###


 include("dbconn.php");                // Setup database connection
 include("admin/admin-settings.php");  // Setup required core objects
 include("admin/tools/WMT\SQL\Task.php");  // Include this object

// Create object
 $task = new Task();
 $task->loadValues($id);
 
// Delete and echo if success or failure
 if ($task->deletThis()) echo "Success";
 else echo "Failure";

Home | Partnership | Testimonials

Privacy/Terms | About Us | Contact Us

Task

Task PHP Methods

activeString() v4.92

add($postVals) v4.23

addTask($title, $active, $tID, $tAID, $taskType, $taskTypeID, $performBy, $tUType, $complete) v4.92

assign($uID) v4.92

assignSkill($skillID, $order = 1) v4.92

completeString() v4.92

convertHTML($htmlContent = '') v4.23

deleteThis($restoreQuery = '') v4.23

duplicateThis($newValues = null) v4.92

getActive() v4.92

getActiveString() v4.92

getAdminApprove() v4.92

getAID() v4.92

getBonus() v4.92

static getClientName($tAID) v4.92

getComplete() v4.92

getDefaultTRHTML() v4.23

static getEmployeeName($eID) v4.92

getHasQuestion() v4.92

getID() v4.92

getMaxCredits() v4.92

getMaxCreditsTitle() v4.92

getPerformBy() v4.92

getPresetEmails($site) v4.92

getPrimarySkill() v4.92

getPrimarySkillID() v4.92

getProjectManager() v4.92

getProjectManagerID() v4.92

getRateType() v4.92

getRateTypeColor() v4.92

getRateTypeTitle() v4.92

getSkillLevel() v4.92

getSkillLevelHTML() v4.92

getSkillLevelMinScore() v4.92

getSkillLevelTitle() v4.92

getStatusTitle() v4.92

getTaskBefore() v4.92

getTaskIsForLink() v4.92

getTaskListID() v4.92

getTID() v4.92

getType() v4.92

getTypeID() v4.92

getTypeTitle() v4.92

getUpdated() v4.92

getUType() v4.92

static getUTypeString($tUType) v4.92

getValue($fieldName) v4.23

hideAllFields() v4.23

hideField($fieldTitle) v4.23

loadInProgress() v4.92

loadNoteCount($utID) v4.92

loadTask($taskID) v4.92

loadValues($id) v4.23

loadValuesWhere($whereString = 'id=1') v4.23

removeSkill($assignID) v4.92

save($postVals) v4.23

setAdminApprove($nAApprove) v4.92

setHasQuestion($nHasQuestion) v4.92

setMaxCredits($nMaxCredits) v4.92

setRateType($tRT) v4.92

setSkillLevel($nSkillLevel) v4.92

setUpdated($nUpdated) v4.92

showAllFields() v4.23

showField($fieldTitle) v4.23

startTask($eID) v4.92