public function getTableFields() { if (!isset($this->arrFields)) { $q = "DESCRIBE " . addslashes($this->Name); $r = parent::returnResultSet($q); $this->arrFields = array(); foreach ($r as $l) { $this->arrFields[] = array($l->Field, $l->Type, $l->Null, $l->Key, $l->Default, $l->Extra); } } }
public function getAllItemInfoType($orderby = "id") { // Retrieve all Item_info_type $q = "SELECT * FROM item_info_type ORDER BY " . addslashes($orderby); $r = parent::returnResultSet($q); // Array to hold ItemInfoType objects $arrItemInfoType = array(); // Create a ItemInfoType object for each row and add to array foreach ($r as $l) { $thisObj = new ItemInfoType($l->id, $l->item_info_type_name); $arrItemInfoType[] = $thisObj; } // Return array of objects return $arrItemInfoType; }
public function getAllSettingBySettingName($setting_name = null) { // Retrieve all Setting By SettingName $q = "SELECT * FROM setting WHERE setting_name = ?"; $var = addslashes($setting_name); $r = parent::returnResultSet($q, $var); // Array to hold Setting objects $arrSetting = array(); // Create a Setting object for each row and add to array foreach ($r as $l) { $thisObj = new Setting($l->id, $l->setting_name, $l->setting_value); $arrSetting[] = $thisObj; } // Return array of objects return $arrSetting; }
public function getAllSoundByCategoryId($category_id = null) { // Retrieve all Sound By CategoryId $q = "SELECT * FROM sound WHERE category_id = ?"; $var = addslashes($category_id); $r = parent::returnResultSet($q, $var); // Array to hold Sound objects $arrSound = array(); // Create a Sound object for each row and add to array foreach ($r as $l) { $thisObj = new Sound($l->id, $l->category_id, $l->overview_text); $arrSound[] = $thisObj; } // Return array of objects return $arrSound; }
public function sortValues($id, $direction) { // Get current sort value $q = "SELECT sort_order FROM homepage_image WHERE id = " . $id; $r = parent::returnResultSet($q); $l = $r[0]; $sortVal = $l->sort_order; if ($direction == 'U') { // Move item that is currently in the new position to this item's position $q = "UPDATE homepage_image SET sort_order = " . $sortVal . " WHERE sort_order = " . ($sortVal - 10); parent::updateQuery($q); // Put selected item in new position $q = "UPDATE homepage_image SET sort_order = " . ($sortVal - 10) . " WHERE id = " . $id; parent::updateQuery($q); } else { // Move item that is currently in the new position to this item's position $q = "UPDATE homepage_image SET sort_order = " . $sortVal . " WHERE sort_order = " . ($sortVal + 10); parent::updateQuery($q); // Put selected item in new position $q = "UPDATE homepage_image SET sort_order = " . ($sortVal + 10) . " WHERE id = " . $id; parent::updateQuery($q); } }
private function resetSortOrder() { $q = "SELECT id, sort_order FROM category ORDER BY sort_order "; $r = parent::returnResultSet($q); $i = 10; foreach ($r as $l) { $q = "UPDATE category SET sort_order = '" . $i . "' WHERE id = '" . $l->id . "' "; parent::updateQuery($q); $i += 10; } }
private function resetSortOrder($technology_id) { $q = "SELECT id, sort_order FROM technology_info WHERE technology_id = " . $technology_id . " ORDER BY sort_order "; $r = parent::returnResultSet($q); $i = 10; foreach ($r as $l) { $q = "UPDATE technology_info SET sort_order = '" . $i . "' WHERE id = '" . $l->id . "' "; parent::updateQuery($q); $i += 10; } }
public function GetItemVideoCountByItemId($item_id) { // Retrieve all ItemImage By ItemId $q = "SELECT COUNT(*) As NumCount FROM item_video WHERE item_id = ?"; $var = $item_id; $r = parent::returnResultSet($q, $var); return $r[0]->NumCount; }
public function getCountLightTestByLightId($light_id) { // Retrieve all ItemImage By ItemId $q = "SELECT COUNT(*) As NumCount FROM light_test WHERE light_id = ?"; $var = $light_id; $r = parent::returnResultSet($q, $var); return $r[0]->NumCount; }
public function getCountSoundImageBySoundId($sound_id) { // Retrieve all ItemImage By ItemId $q = "SELECT COUNT(*) As NumCount FROM sound_image WHERE sound_id = ?"; $var = $sound_id; $r = parent::returnResultSet($q, $var); return $r[0]->NumCount; }
public function getCountColorImageByColorId($color_id) { // Retrieve all ItemImage By ItemId $q = "SELECT COUNT(*) As NumCount FROM color_image WHERE color_id = ?"; $var = $color_id; $r = parent::returnResultSet($q, $var); return $r[0]->NumCount; }
public function getCountIbeaconImageByIbeaconId($ibeacon_id) { // Retrieve all ItemImage By ItemId $q = "SELECT COUNT(*) As NumCount FROM ibeacon_image WHERE ibeacon_id = ?"; $var = $ibeacon_id; $r = parent::returnResultSet($q, $var); return $r[0]->NumCount; }
public function getCountItemImageHighlightByItemImageId($item_image_id = null) { // Retrieve all ItemImageHighlight By ItemImageId $q = "SELECT count(*) AS cnt FROM item_image_highlight WHERE item_image_id = ?"; $var = addslashes($item_image_id); $r = parent::returnResultSet($q, $var); return $r[0]->cnt; }
public function getAllTechnologyByCategoryIdLinkUrlIsActive($category_id, $link_url) { // Retrieve all Technology By CategoryId $q = "SELECT * FROM technology WHERE category_id = ? AND link_url = ?"; $var = array(addslashes($category_id), addslashes($link_url)); $r = parent::returnResultSet($q, $var); // Array to hold Technology objects $arrTechnology = array(); // Create a Technology object for each row and add to array if ($r[0]->is_active == 1) { return true; } else { return false; } }
public function checkLogin($username, $password) { // retrieve this row $q = "SELECT * FROM system_user WHERE is_active AND username = '******' AND password = '******'"; $r = parent::returnResultSet($q); $hasRow = false; // set property values to values in result set foreach ($r as $l) { $thisObj = new SystemUser($l->id, $l->first_name, $l->last_name, $l->username, $l->password, $l->email_address, $l->date_created, $l->is_active, $l->is_admin); $hasRow = true; return $thisObj; } // make sure there was a row returned; if not, set ID to -1 to indicate a bad object if (!$hasRow) { $this->Id = -1; } return $this; }
public function getAllItemInfoByItemIdItemInfoTypeId($item_id = 0, $item_info_type_id = 0) { // Retrieve all _item_info $q = "SELECT * FROM item_info WHERE item_id = ? AND item_info_type_id = ? "; $var = array($item_id, $item_info_type_id); $r = parent::returnResultSet($q, $var); // Array to hold ItemInfo objects $arrItemInfo = array(); // Create a ItemInfo object for each row and add to array foreach ($r as $l) { $thisObj = new ItemInfo($l->id, $l->item_id, $l->item_info_type_id, $l->item_info); $arrItemInfo[] = $thisObj; } // Return array of objects return $arrItemInfo; }