Employee

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

Database Table: employees
Extends: Result
Extends: AbstractDatabase

Employee PHP Methods

add(array $fieldValues) _v5

Adds a new record.
PARAMETERS:
$fieldValues = Array of the values for each column when adding the record (Associative array with key = field name & value = field value).
RETURN VALUE:
int = id of the new record.
0 = if fails

checkLoaded() _v5

Checks if record is loaded. throwing an error if the record failed to load successfully.
PARAMETERS:
NONE
RETURN VALUE:
VOID

convertHTML(string $htmlContent = "", string $prefix = "", bool $urlEncode = false) _v5

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.
PARAMETERS:
$htmlContent = String, HTML content body to convert.
$prefix= String, tilde code prefix if any.
$urlEncode = Bool, true if you want to apply URL encode to the content, false otherwise
RETURN VALUE:
String = Converted HTML

delete(string $restoreQuery = "") _v5

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

duplicate(array $newValues = null) _v5

Creates a duplicate record in the database of the current object
PARAMETERS:
$newValues = array, associative array with field name as key and field value as array value containing the new values if any
RETURN VALUE:
int = the id of the new record.

function load(string $queryWhere) _v5

Loads values for the record matching the criteria specified by $queryWhere. If the there is more than one record returned from the query then only the first record is loaded.
PARAMETERS:
$queryWhere = String, SQL where query.
RETURN VALUE:
Bool = true, if success, false otherwise

getDatabaseName() _v5

Returns object's database table name
PARAMETERS:
NONE
RETURN VALUE:
String = Database name

getDefaultTRHTML() _v5

Returns the default html code for a tr row with all of the fields from the database in it as ~~ vars
PARAMETERS:
NONE
RETURN VALUE:
String = the default HTML code for a tr row with all of the fields from the database in it as ~~ vars

getID() _v5

Sets object ID
PARAMETERS:
NONE
RETURN VALUE:
int = ID

getJSON(bool $returnArr = false) _v5

Get JSON array for the loaded record.
PARAMETERS:
Bool = true if want to return JSON, false otherwise
RETURN VALUE:
Object Array or JSON encoded version of the array

getValue(string $fieldName = "value") _v5

Returns the value from a specific column for this record.
PARAMETERS:
$fieldName = String, field name.
RETURN VALUE:
Field value

hasField(string $fieldName) _v5

Checks if the field shown or hidden
PARAMETERS:
$fieldName= String, Field title.
RETURN VALUE:
Bool= True if the field show is true, false otherwise

hideAllFields() _v5

hides all fields(columns)
PARAMETERS:
NONE
RETURN VALUE:
VOID

hideField($fieldTitle) _v5

Hides specific field title by its column title
PARAMETERS:
$fieldTitle = String, Field title.
RETURN VALUE:
VOID

isLoaded() _v5

Checks if an object is loaded correctly (can be used to check if ID exists).
PARAMETERS:
NONE
RETURN VALUE:
Bool = True if the object loaded successfully, false otherwise

loadFirstID() _v5

Get object's first id
PARAMETERS:
NONE
RETURN VALUE:
int = First ID

loadID(int $id) _v5

Loads values for the record with the id specified.
PARAMETERS:
$id = int, record ID.
RETURN VALUE:
Bool = true, if success, false otherwise

save(array $fieldValues) _v5

Saves the record with the new values specified in the $fieldValuesarray.
PARAMETERS:
$fieldValues = Array of the values for each column when adding the record (Associative array with key = field name & value = field value).
RETURN VALUE:
Bool = True on success, False otherwise.

setMyMemberID(int $memberID) _v5

Sets member's ID
PARAMETERS:
$memberID = int, member id
RETURN VALUE:
VOID

setRestoreID(int $id) _v5

Sets restor point ID
PARAMETERS:
$id = int, restore ID
RETURN VALUE:
VOID

settingHTTPS(bool $useHTTPS = true) _v5

Sets site to use https or http
PARAMETERS:
$useHTTPS = True if https on, false otherwise (default true).
RETURN VALUE:
VOID

settingSiteURL(string $siteURL) _v5

Sets Site Domain
PARAMETERS:
$siteURL = String, site URL
RETURN VALUE:
VOID

showAllFields() _v5

Show all fields(columns)
PARAMETERS:
NONE
RETURN VALUE:
VOID

showField($fieldTitle) _v5

Shows specific field title by its column title
PARAMETERS:
$fieldTitle = String, Field title.
RETURN VALUE:
VOID

Employee PHP Variables

🔎︎ %l4610%

Columns in the employees Database Table:

mincreditsaminute id name email password maxhours hourlrate vacationhours cashadvanced bio flexiblehours minoutsideshift getsbonus ftpaccess skype active onschedule creditsaminute lastactivity cellphone added description manager

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>mincreditsaminute<td>~mincreditsaminute~</tr>";
 $content .= "<tr><td>id<td>1214</tr>";
 $content .= "<tr><td>name<td>~name~</tr>";
 $content .= "<tr><td>email<td>~email~</tr>";
 $content .= "<tr><td>password<td>~password~</tr>";
 $content .= "<tr><td>maxhours<td>~maxhours~</tr>";
 $content .= "<tr><td>hourlrate<td>~hourlrate~</tr>";
 $content .= "<tr><td>vacationhours<td>~vacationhours~</tr>";
 $content .= "<tr><td>cashadvanced<td>~cashadvanced~</tr>";
 $content .= "<tr><td>bio<td>~bio~</tr>";
 $content .= "<tr><td>flexiblehours<td>~flexiblehours~</tr>";
 $content .= "<tr><td>minoutsideshift<td>~minoutsideshift~</tr>";
 $content .= "<tr><td>getsbonus<td>~getsbonus~</tr>";
 $content .= "<tr><td>ftpaccess<td>~ftpaccess~</tr>";
 $content .= "<tr><td>skype<td>~skype~</tr>";
 $content .= "<tr><td>active<td>~active~</tr>";
 $content .= "<tr><td>onschedule<td>~onschedule~</tr>";
 $content .= "<tr><td>creditsaminute<td>~creditsaminute~</tr>";
 $content .= "<tr><td>lastactivity<td>~lastactivity~</tr>";
 $content .= "<tr><td>cellphone<td>~cellphone~</tr>";
 $content .= "<tr><td>added<td>~added~</tr>";
 $content .= "<tr><td>description<td>~description~</tr>";
 $content .= "<tr><td>manager<td>~manager~</tr>";
 $content .= "</table>";

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


 include("admin/load/nosession.php");

 $employee = new Employee();  //Create object
 $employee->loadID($id);
 $converted = $employee->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["mincreditsaminute"] = "TINYINT UNSIGNED NOT NULL DEFAULT 0";
 $valueArray["id"] = "0";
 $valueArray["name"] = "VARCHAR(255) NOT NULL";
 $valueArray["email"] = "VARCHAR(255) NOT NULL";
 $valueArray["password"] = "VARCHAR(255) NULL";
 $valueArray["maxhours"] = "TINYINT NOT NULL";
 $valueArray["hourlrate"] = "SMALLINT UNSIGNED NOT NULL";
 $valueArray["vacationhours"] = "DECIMAL(8,2) NOT NULL";
 $valueArray["cashadvanced"] = "SMALLINT UNSIGNED NOT NULL";
 $valueArray["bio"] = "VARCHAR(255) NOT NULL";
 $valueArray["flexiblehours"] = "BIT(1) NOT NULL DEFAULT 0";
 $valueArray["minoutsideshift"] = "SMALLINT NOT NULL";
 $valueArray["getsbonus"] = "BIT(1) NOT NULL DEFAULT 1";
 $valueArray["ftpaccess"] = "BIT(1) NOT NULL DEFAULT 0";
 $valueArray["skype"] = "VARCHAR(100) NOT NULL";
 $valueArray["active"] = "BIT(1) NOT NULL DEFAULT 1";
 $valueArray["onschedule"] = "BIT(1) NOT NULL DEFAULT 1";
 $valueArray["creditsaminute"] = "TINYINT UNSIGNED NOT NULL DEFAULT 0";
 $valueArray["lastactivity"] = "INT UNSIGNED NOT NULL DEFAULT 0";
 $valueArray["cellphone"] = "VARCHAR(30) NOT NULL";
 $valueArray["added"] = "INT UNSIGNED NOT NULL";
 $valueArray["description"] = "VARCHAR(255) NOT NULL";
 $valueArray["manager"] = "BIT(1) NOT NULL DEFAULT 0";

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


 include("admin/load/nosession.php");

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

 echo $employee->getID();  // 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("admin/load/nosession.php");

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

Home | Partnership | Testimonials

Privacy/Terms | About Us | Contact Us

Employee

Employee PHP Methods

add(array $fieldValues) v5

checkLoaded() v5

convertHTML(string $htmlContent = "", string $prefix = "", bool $urlEncode = false) v5

delete(string $restoreQuery = "") v5

duplicate(array $newValues = null) v5

function load(string $queryWhere) v5

getDatabaseName() v5

getDefaultTRHTML() v5

getID() v5

getJSON(bool $returnArr = false) v5

getValue(string $fieldName = "value") v5

hasField(string $fieldName) v5

hideAllFields() v5

hideField($fieldTitle) v5

isLoaded() v5

loadFirstID() v5

loadID(int $id) v5

save(array $fieldValues) v5

setMyMemberID(int $memberID) v5

setRestoreID(int $id) v5

settingHTTPS(bool $useHTTPS = true) v5

settingSiteURL(string $siteURL) v5

showAllFields() v5

showField($fieldTitle) v5