aboutsummaryrefslogtreecommitdiff
path: root/h-source/admin/Library/Model/Base.php
diff options
context:
space:
mode:
Diffstat (limited to 'h-source/admin/Library/Model/Base.php')
-rwxr-xr-xh-source/admin/Library/Model/Base.php1140
1 files changed, 0 insertions, 1140 deletions
diff --git a/h-source/admin/Library/Model/Base.php b/h-source/admin/Library/Model/Base.php
deleted file mode 100755
index 1aaadca..0000000
--- a/h-source/admin/Library/Model/Base.php
+++ /dev/null
@@ -1,1140 +0,0 @@
-<?php
-
-// All EasyGiant code is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version.
-// See COPYRIGHT.txt and LICENSE.txt.
-
-if (!defined('EG')) die('Direct access not allowed!');
-
-abstract class Model_Base
-{
-
- public $fields = ''; //the fields that have to be manipulated by the update and insert query
- public $values = array(); //the values that corresponding to the $this->fields fields
- public $form = null; //reference to a Form_Form object
- public $formStruct = null; //the form structure
-
- public $submitName = null; //the current submitName (from the form)
- public $identifierName = 'identifier';
-
- public $notice = null; //a string explaining the result of the query applied (or not if an error occured): executed, error, etc
- public $result = true; //the result of validate conditions, database conditions and query. It can be 'true' or 'false'
- public $queryResult = false; //the result of the query
-
- //conditions that have to be satisfied before applying the query
- //Ex: 'update'=>'checkEmpty:titolo,autore','submitName'=>'conditions'
- public $strongConditions = array();
-
- //conditions that have to be satisfied before applying the query
- //Ex: 'update'=>'checkEmpty:titolo,autore','submitName'=>'conditions'
- //do not return error if a value is equal to '' or null
- public $softConditions = array();
-
- //conditions that have to be satisfied before applying the query
- //check that the new values inserted satisfy some conditions
- //Ex: 'update'=>'checkUniqueCompl:titolo,autore;checkUnique:titolo','insert'=>'checkUnique:titolo'
- public $databaseConditions = array();
-
- public $popupArray = array(); //array of popup objects (see popup.php)
-
- public $supplInsertValues = array(); //associative array defining supplementary values to be inserted on each insert query. It has to have the following form: array(field1 => value1,field2 => value2, ...)
-
- public $supplUpdateValues = array(); //associative array defining supplementary values to be inserted on each update query. It has to have the following form: array(field1 => value1,field2 => value2, ...)
-
- public $select = null; //fields that have to be selected in select queries
- public $where = array(); //associative array containing all the where clauses ($field => $value)
- //group by, order by and limit clauses
- public $groupBy = null;
- public $orderBy = null;
- public $limit = null;
-
- public $from = null; //from clause of the select queries
- public $on = null; //join part of the where clause of the select queries
- public $using = null; //using clause
-
- public $toList = false; //if the result have to be given in a list format
- public $listArray = array(); //array containing the $key and the $value to be used to extract a list from a resultSet
-
- //logic operator between statements in the where clause of select queries
- public $logicalOperators = array('AND');
-
- protected $_tables='itemTable,boxTable,item_boxTable';
- protected $_idFields='id_item,id_box';
- protected $_tablesArray=array();
- protected $_idFieldsArray=array();
- protected $_where = array();
-
- //the name of the field that has to be used to order the rows of the main table of the model
- protected $_idOrder = null;
-
- protected $_onDelete = 'check'; //can be 'nocheck' or 'check'. check: referential integrity check. nocheck: no referential integrity check
- protected $_reference = null; //array containing the child table that have a reference to this table and the foreign key of the child table-> array($childTable,$foreignKey)
-
- protected $_popupItemNames = array(); //the fields to be used as names in the popupArray elements. Associative array ($itemNameField1 => $itemNameValue1, ...)
-
- //the labels of the pop-up menus
- protected $_popupLabels = array();
-
- //functions that have to be applied upon the label fields of the popup menu
- protected $_popupFunctions = array();
-
- protected $_popupWhere = array(); //where clause for the pupup menu
-
- protected $_resultString; //reference to the class containing all the result strings of the db queries
- protected $_dbCondString; //reference to the class containing all the result strings of the database conditions
-
- protected $_backupFields = ''; //field saved after the delFields method has been applied
- protected $_backupValues = array(); //values saved after the delFields method has been applied
- protected $_allowedDbMethods = array('update','insert','del','moveup','movedown'); //methods that can be called by the updateTable method
-
- protected $submitNames = array(
- 'update' => 'updateAction',
- 'insert' => 'insertAction',
- 'del' =>'delAction',
- 'moveup' =>'moveupAction',
- 'movedown' =>'movedownAction'
- );
-
- protected $identifierValue = null; //the value of the identifier ($_POST[$this->identifier])
- protected $arrayExt; //arrayExt object (see library/arrayExt.php)
-
- protected $_arrayStrongCheck; //Array_Validate_Strong object
- protected $_arraySoftCheck; //Array_Validate_Soft object
-
- public $db; //reference to the database layer class
- protected $_lang = 'Eng'; //language of notices
-
-
- public function __construct() {
- $this->_tablesArray = explode(',',$this->_tables);
- $this->_idFieldsArray = explode(',',$this->_idFields);
- $this->_where[$this->_idFieldsArray[0]] = $this->_tablesArray[0];
- $this->arrayExt = new ArrayExt();
-
- //initialize the validate objects
- $this->_arrayStrongCheck = new Array_Validate_Strong($this->_lang);
- $this->_arraySoftCheck = new Array_Validate_Soft($this->_lang);
-
- $this->identifierName = $this->_idFieldsArray[0];
-
- //create the $_resultString object (result strings of the db queries)
- $modelStringClass = 'Lang_'.$this->_lang.'_ModelStrings';
- if (!class_exists($modelStringClass))
- {
- $modelStringClass = 'Lang_Eng_ModelStrings';
- }
- $this->_resultString = new $modelStringClass();
-
- //create the $_dbCondString object (result strings of the database conditions)
- $dbCondStringClass = 'Lang_'.$this->_lang.'_DbCondStrings';
- if (!class_exists($dbCondStringClass))
- {
- $dbCondStringClass = 'Lang_Eng_DbCondStrings';
- }
- $this->_dbCondString = new $dbCondStringClass();
-
- //instantiate the database class
- $this->db = Factory_Db::getInstance(DATABASE_TYPE);
- }
-
- //set the submitNames property (array)
- //$methodName : the method name, $submitName: the submit name of the submit action of the form
- public function setSubmitNames($methodName,$submitName)
- {
- if (!in_array($methodName,$this->_allowedDbMethods))
- {
- throw new Exception('query type <b>"'.$methodName. '"</b> not allowed in '. __METHOD__);
- }
- $this->submitNames[$methodName] = $submitName;
- }
-
- //get the last query executed
- public function getQuery()
- {
- return $this->db->query;
- }
-
- //get the where clause of the select query
- public function getWhereQueryClause()
- {
- return $this->where;
- }
-
- //set the where clause of the select query
- //whereArray = array ($table_field => $value)
- public function setWhereQueryClause($whereArray)
- {
- $this->where = $whereArray;
- }
-
- //append the whereArray clause to $this_->whereClause
- //whereArray = array ($table_field => $value)
- public function appendWhereQueryClause($whereArray)
- {
- $this->where = array_merge($this->where,$whereArray);
- }
-
- //drop the char $char from the beginning of the string $string
- public function dropStartChar($string,$char)
- {
- while(strcmp($string[0],$char) === 0)
- {
- $string = substr($string,1);
- }
- return $string;
- }
-
- //get the table name from $this->_where. If the table is not present then return $this->_tablesArray[0]
- public function getTableName($field)
- {
- return isset($this->_where[$field]) ? $this->_where[$field] : $this->_tablesArray[0];
- }
-
- //method to create the where clause of the select query from the $this->where array
- //$level: level of the ricorsion
- //$whereClauseLevel: array containing the field=>value statements of the where clause. If $whereClause = null than $this->where is considered
- public function createWhereClause($level = 0, $whereClauseLevel = null)
- {
- $whereClause = null;
- $whereClauseArray = array();
-
- $whereClause = isset($whereClauseLevel) ? $whereClauseLevel : $this->where;
-
- foreach ($whereClause as $field => $value)
- {
- if (is_array($value))
- {
- $newValue = $this->createWhereClause($level+1, $value);
- if (isset($newValue)) $whereClauseArray[] = $newValue;
- }
- else
- {
- $flag = 0; //equal where clause
- if (isset($field))
- {
- //drop the 'n:' and '-' chars from $field
- $fieldClean = str_replace('n!',null,$field);
- $fieldClean = $this->dropStartChar($fieldClean,'-');
- if (strcmp($value,Params::$nullQueryValue) !== 0 or (Params::$nullQueryValue === false))
- {
- foreach (params::$whereClauseSymbolArray as $symbol)
- {
- if (strstr($value,$symbol))
- {
- //check if write or not the table name
- $tableName = strstr($field,'n!') ? null : $this->getTableName($field).'.';
- $whereClauseArray[] = $tableName.$fieldClean.' '.$value;
- $flag = 1; //not equal where clause
- break;
- }
- }
- if ($flag === 0)
- {
- $value = '"'.$value.'"';
- //check if write or not the table name
- $tableName = strstr($field,'n!') ? null : $this->getTableName($field).'.';
- $whereClauseArray[] = $tableName.$fieldClean.'='.$value;
- }
- }
- }
- }
- }
- //get the logic operator at the current level
- $logicOper = isset($this->logicalOperators[$level]) ? ' '.$this->logicalOperators[$level].' ' : ' AND ';
- $whereClause = !empty($whereClauseArray) ? implode($logicOper,$whereClauseArray) : null;
- $whereClause = (isset($whereClause) and $level>0) ? '('.$whereClause.')' : $whereClause;
- return $whereClause;
- }
-
-
- //get the submitName having its key (the method name)
- public function getSubmitName($key)
- {
- if (!array_key_exists($key,$this->submitNames))
- {
- return 'generalAction';
-// throw new Exception('query type <b>"'.$key. '"</b> not allowed in '.__METHOD__);
- }
- return $this->submitNames[$key];
-
- }
-
-
- //return the values, taken from the $_POST array, to be inserted inside the forms
- //$queryType: insert or update
- //$func: sanitize function to apply upon each value
- //$id: if $queryType='update' that the values are taken from the record (of the main table of this model) having the primary key equal to $id
- //$defaultValues = associative array of the form: array($entry=>$defaultValue)
- //$functionsIfFromDb = associative array of the form: array($entry=>$function_to_be_applied)
- public function getFormValues($queryType = 'insert', $func = 'sanitizeHtml',$id = null,$defaultValues = array(),$functionsIfFromDb = array())
- {
- $arrayType = array('update','insert');
- $values = array();
- $idName = $this->identifierName;
- if (in_array($queryType,$arrayType))
- {
- $ident = null;
- if (isset($id))
- {
- $ident = (int)$id;
- }
- else if (isset($_POST[$idName]))
- {
- $ident = (int)$_POST[$idName];
- }
- if ($this->result)
- {
- if ($queryType === 'update')
- {
- if (isset($ident))
- {
- $recordArray = $this->selectId($ident);
-
- $fieldsArray = explode(',',$this->fields);
-
- foreach ($fieldsArray as $field)
- {
- $values[$field] = array_key_exists($field,$recordArray) ? $recordArray[$field] : '';
- }
-
- $values[$idName] = $ident;
-
- //apply the functions upon entries
- foreach ($functionsIfFromDb as $entry => $funcUponEntry)
- {
- if (array_key_exists($entry,$values))
- {
- if (!function_exists($funcUponEntry)) {
- throw new Exception('Error in <b>'.__METHOD__.'</b>: function <b>'.$funcUponEntry. '</b> does not exists');
- }
-
- $values[$entry] = call_user_func($funcUponEntry,$values[$entry]);
- }
- }
-
- }
- }
- else if ($queryType === 'insert')
- {
-
- $tempArray = is_array($defaultValues) ? $defaultValues : array();
-
- $values = $this->arrayExt->subset($tempArray,$this->fields,$func);
-
- }
- }
- else
- {
- $values = $this->arrayExt->subset($_POST,$this->fields,$func);
-
- if ($queryType === 'update')
- {
- $values[$idName] = $ident;
- }
- }
- }
- return $values;
- }
-
-
- //method to set the properties $this->fields and $this->values
- public function setFields($fields,$func = 'sanitizeAll')
- {
- $this->values = $this->arrayExt->subset($_POST,$fields,$func);
- $this->fields = $this->extractFields($fields);
-
- //set the backup variables
- $this->_backupFields = $this->fields;
- $this->_backupValues = $this->values;
- }
-
-
- //clear the fields list
- public function clearFields()
- {
- $this->_backupFields = $this->fields;
- $this->_backupValues = $this->values;
- $this->fields = '';
- $this->values = array();
- }
-
- //del the fields written in the $list argument. The $list argument has to be of the type: field1,field2,...
- public function delFields($list)
- {
- $this->_backupFields = $this->fields;
- $this->_backupValues = $this->values;
- $this->values = $this->arrayExt->subsetComplementary($this->values,$list);
- $this->fields = implode(',',array_keys($this->values));
- }
-
- //restore the fields and values saved in $_backupFields and $_backupValues
- public function restoreFields()
- {
- $this->fields = $this->_backupFields;
- $this->values = $this->_backupValues;
- }
-
- //method to clean the $fields string deleting the colons (and the word after the colon)
- public function extractFields($fields) {
- $fieldsArray = explode(',',$fields);
- $resultString = array();
- foreach ($fieldsArray as $field) {
- if (strstr($field,':')) {
- $temp = explode(':',$field);
- $resultString[] = $temp[0];
- } else {
- $resultString[] = $field;
- }
- }
- return implode(',',$resultString);
- }
-
- //add the supplementary value on insert and update queries
- //$queryType: insert or update
- public function setSupplValues($queryType)
- {
- if ($queryType === 'insert')
- {
- $supplValues = $this->supplInsertValues;
- }
- else if ($queryType === 'update')
- {
- $supplValues = $this->supplUpdateValues;
- }
-
- $baseFields = implode(',',array_keys($this->values));
-
- $supplFields = implode(',',array_keys($supplValues));
- $supplFields = (strcmp($supplFields,'') === 0) ? $supplFields : ',' . $supplFields;
-
- $fields = $baseFields . $supplFields;
- $values = array_merge(array_values($this->values),array_values($supplValues));
-
- return array($fields,$values);
- }
-
-
- //method to call the update query (overriding of the base_db del method)
- //update the record with the primary key equal to $id (default)
- //if $whereClause is set then use $whereClause as where clause of the update query
- public function update($id = null, $whereClause = null)
- {
- if (!is_array($this->supplUpdateValues))
- {
- throw new Exception('error in <b>' . __METHOD__ . '</b>: the <b>supplUpdateValues</b> property has to be an array.');
- }
- $el = $this->setSupplValues('update');
- $this->queryResult = false;
-
- if (isset($whereClause))
- {
- $result = $this->db->update($this->_tablesArray[0],$el[0],$el[1],$whereClause);
- $this->setNotice($result);
- return $result;
- }
- else
- {
- if (isset($id))
- {
- $where = $this->_idFieldsArray[0].'='.(int)($id);
- $result = $this->db->update($this->_tablesArray[0],$el[0],$el[1],$where);
- $this->setNotice($result);
- return $result;
- }
- else
- {
- $this->notice = $this->_resultString->getString('no-id');
- $this->result = false;
- $this->identifierValue = null;
- return false;
- }
- }
- }
-
- //method to call the insert query (overriding of the base_db del method)
- public function insert() {
-
- $this->queryResult = false;
- if (!is_array($this->supplInsertValues)) {
- throw new Exception('error in <b>' . __METHOD__ . '</b>: the <b>supplInsertValues</b> property has to be an array.');
- }
-
- if (isset($this->_idOrder))
- {
- $maxValue = $this->db->getMax($this->_tablesArray[0],$this->_idOrder);
- $this->supplInsertValues[$this->_idOrder] = (int)$maxValue + 1;
- }
-
- $el = $this->setSupplValues('insert');
-
- $result = $this->db->insert($this->_tablesArray[0],$el[0],$el[1]);
- $this->setNotice($result);
- return $result;
- }
-
- //method to call the delete query (overriding of the base_db del method)
- public function del($id = null, $whereClause = null) {
-
- $this->queryResult = false;
-
- if (isset($whereClause))
- {
- $result = $this->db->del($this->_tablesArray[0],$whereClause);
- $this->setNotice($result);
- return $result;
- }
- else
- {
- if (isset($id)) {
- $where = $this->_idFieldsArray[0].'='.(int)$id;
- $result = $this->db->del($this->_tablesArray[0],$where);
- $this->setNotice($result);
- return $result;
- } else {
- $this->notice = $this->_resultString->getString('no-id');
- $this->result = false;
- $this->identifierValue = null;
- return false;
- }
- }
- }
-
- //move to the top the record having $this->_idOrder = $id
- //where clause
- public function moveup($id)
- {
- return $this->move($id,'up');
- }
-
- //move to the top the record having $this->_idOrder = $id
- //where clause
- public function movedown($id)
- {
- return $this->move($id,'down');
- }
-
- //move the record having $this->_tablesArray[0] = $id
- //$par: 'up' or 'down'
- //where clause
- public function move($id,$par = 'up')
- {
- $this->queryResult = false;
- if (isset($id))
- {
- $increm = ($par === 'up') ? 1 : -1;
-
- $backupLimit = $this->limit;
- $this->limit = null;
-
- $data = $this->getFields($this->_tablesArray[0].'.'.$this->_idFieldsArray[0].','.$this->_tablesArray[0].'.'.$this->_idOrder);
-
- for($i = 0; $i < count($data); $i++)
- {
- if (strcmp($data[$i][$this->_tablesArray[0]][$this->_idFieldsArray[0]],$id) === 0)
- {
- if (($par === 'up' and $i !== 0) or ($par === 'down' and $i !== (count($data)-1)))
- {
- $prevOrder = $data[$i-$increm][$this->_tablesArray[0]][$this->_idOrder];
- $prevId = $data[$i-$increm][$this->_tablesArray[0]][$this->_idFieldsArray[0]];
- $currentOrder = $data[$i][$this->_tablesArray[0]][$this->_idOrder];
- $currentId = $data[$i][$this->_tablesArray[0]][$this->_idFieldsArray[0]];
-
- //exchange the id_order of the two record
- $res1 = $this->db->update($this->_tablesArray[0],$this->_idOrder,array($prevOrder),$this->_idFieldsArray[0]."='$currentId'");
- $res2 = $this->db->update($this->_tablesArray[0],$this->_idOrder,array($currentOrder),$this->_idFieldsArray[0]."='$prevId'");
- $result = ($res1 and $res2);
- $this->setNotice($result);
- return $result;
- }
- }
- }
-
- $this->limit = $backupLimit;
- }
- else
- {
- $this->notice = $this->_resultString->getString('no-id');
- $this->result = false;
- $this->identifierValue = null;
- return false;
- }
- return false;
- }
-
- public function setNotice($result) {
- if ($result) {
- $this->notice = $this->_resultString->getString('executed');
- $this->result = true;
- $this->queryResult = true;
- } else {
- $this->notice = $this->_resultString->getString('error');
- $this->result = false;
- $this->queryResult = false;
- }
- }
-
- //method used to verify that the value of a field is not duplicated
- //$fieldsList: list of fields to check. Ex: field1,field2,...
- //$where: the where clause
- public function checkUnique($fieldsList,$where = null)
- {
- $errorString = null;
- $numb = 0;
- $fieldsArray = explode(',',$fieldsList);
- $queryFieldsArray = explode(',',$this->fields);
- foreach ($fieldsArray as $field)
- {
- if (in_array($field,$queryFieldsArray))
- {
- if ($this->db->recordExists($this->_tablesArray[0],$field,$this->values[$field],$where))
- {
- $errorString .= $this->_dbCondString->getNotUniqueString($field);
- $numb++;
- }
- }
- }
- $this->notice = $errorString;
- return $numb === 0 ? true : false;
- }
-
- //like checkUnique: check all the records of the table apart from the record that has to be modified
- public function checkUniqueCompl($fieldsList,$id = null)
- {
- if (isset($id))
- {
- $where = $this->_idFieldsArray[0].'!='.(int)($id);
- return $this->checkUnique($fieldsList,$where);
- } else {
- $this->notice = $this->_resultString->getString('no-id');
- return false;
- }
- }
-
- //method to apply the database conditions listed in the $this->databaseConditions associative array
- //$queryType: indicates what set of validate conditions has to be considered (it's the key of the associative array)
- public function applyDatabaseConditions($queryType,$id = null)
- {
- if (array_key_exists($queryType,$this->databaseConditions))
- {
- if (!is_array($this->databaseConditions[$queryType]))
- {
- throw new Exception('error in method <b>'.__METHOD__.'</b> : <b>databaseConditions['.$queryType.']</b> has to be an associative array');
- }
-
- foreach ($this->databaseConditions[$queryType] as $key => $values)
- {
-
- //personalized error string
- $altErrorString = null;
-
- //delete all the '+' chars
- $key = $this->dropStartChar($key,'+');
-
- if (strcmp($values,'all') === 0 or strstr($values,'all|'))
- {
- if (strstr($values,'all|'))
- {
- $values = str_replace('all|',$this->fields.'|',$values);
- }
- else
- {
- $values = $this->fields;
- }
- }
-
- if (strstr($values,'|'))
- {
- $temp = explode('|',$values);
- $altErrorString = "<div class='".Params::$errorStringClassName."'>".$temp[1]."</div>\n";
- $values = $temp[0];
- }
-
- $allowedMethod = array('checkUnique','checkUniqueCompl');
- if (!in_array($key,$allowedMethod))
- {
- throw new Exception('error in method '.__METHOD__.' : method "'.$key. '" not allowed in the property named databaseConditions');
- }
- if (!call_user_func_array(array($this,$key),array($values,$id)))
- {
- if (isset($altErrorString)) $this->notice = $altErrorString;
- $this->result = false;
- $this->queryResult = false;
- return false;
- }
- }
- return true;
- } else {
- return true;
- }
- }
-
-
- //method to apply the validate conditions listed in the $this->strongConditions associative array
- //$queryType: indicates what set of validate conditions has to be considered (it's the key of the associative array)
- //$strength: 'strong' or 'soft'
- public function applyValidateConditions($queryType,$strength = 'strong')
- {
- if ($strength === 'strong')
- {
- $validateObj = $this->_arrayStrongCheck;
- $conditions = $this->strongConditions;
- $errString = 'strongConditions';
- }
- else
- {
- $validateObj = $this->_arraySoftCheck;
- $conditions = $this->softConditions;
- $errString = 'softConditions';
-
- if (Params::$nullQueryValue !== false)
- {
- $conditions['insert']['+++++checkIsNotStrings|'.Params::$nullQueryValue] = 'all';
- $conditions['update']['+++++checkIsNotStrings|'.Params::$nullQueryValue] = 'all';
- }
- }
-
- if (array_key_exists($queryType,$conditions))
- {
- if (!is_array($conditions[$queryType]))
- {
- throw new Exception('error in method <b>'.__METHOD__.'</b> : <b>'.$errString.'['.$queryType.']</b> has to be an associative array');
- }
-
- foreach ($conditions[$queryType] as $key => $values)
- {
-
- //personalized error string
- $altErrorString = null;
-
- //delete all the '+' chars
- $key = $this->dropStartChar($key,'+');
-
- if (strcmp($values,'all') === 0 or strstr($values,'all|'))
- {
- if (strstr($values,'all|'))
- {
- $values = str_replace('all|',$this->fields.'|',$values);
- }
- else
- {
- $values = $this->fields;
- }
- }
-
- if (strstr($values,'|'))
- {
- $temp = explode('|',$values);
- $altErrorString = "<div class='".Params::$errorStringClassName."'>".$temp[1]."</div>\n";
- $values = $temp[0];
- }
-
- $baseArgs = array($_POST,$values);
-
- if (strstr($key,'|'))
- {
- $funcArray = explode('|',$key);
- $funcName = $funcArray[0];
- array_shift($funcArray);
- $funcArgs = array_merge($baseArgs,$funcArray);
- }
- else
- {
- $funcName = $key;
- $funcArgs = $baseArgs;
- }
-
- if (!method_exists($validateObj,$funcName) or $funcName === 'checkGeneric')
- {
- throw new Exception('error in method '.__METHOD__.' :method "'.$funcName. '" not allowed in '.$errString);
- }
- if (!call_user_func_array(array($validateObj,$funcName),$funcArgs))
- {
- $this->notice .= (isset($altErrorString)) ? $altErrorString : $validateObj->errorString;
- $this->result = false;
- $this->queryResult = false;
- return false;
- }
- }
- return true;
- } else {
- return true;
- }
- }
-
-
- //apply, in sequence, the strong,soft and database conditions
- //$methodName: insert,update
- //$id: the id of the record. It is necessary for database conditions
- public function checkConditions($methodName,$id = null)
- {
- if ($this->applyValidateConditions($methodName,'strong'))
- {
- if ($this->applyValidateConditions($methodName,'soft'))
- {
- if ($this->applyDatabaseConditions($methodName,$id))
- {
- return true;
- }
- }
- }
- return false;
- }
-
- //method that calls the function indicated in $this->submitNames. Ex: if $_POST['delAction'] is found, then the "del" method is called.
- public function updateTable($methodsList = '',$id = null) {
-
- $allowedMethodsArray = explode(',',$methodsList);
- $resultArray = array();
- $this->identifierValue = null;
- if (isset($id))
- {
- $this->identifierValue = (int)$id;
- }
- else if (isset($_POST[$this->identifierName]))
- {
- $this->identifierValue = (int)$_POST[$this->identifierName];
- }
- foreach ($this->submitNames as $methodName => $submitName)
- {
- if (array_key_exists($submitName,$_POST))
- {
- $this->submitName = $submitName;
- if (method_exists($this,$methodName))
- {
- //if the method is allowed
- if (in_array($methodName,$allowedMethodsArray))
- {
- if ($this->checkConditions($methodName,$this->identifierValue))
- {
- $this->notice = null;
- call_user_func_array(array($this,$methodName),array($this->identifierValue));
- }
- }
- }
- else
- {
- throw new Exception('method <b>'.$methodName.'</b> not defined in class <b>'.__CLASS__.'</b>; error in method <b>'.__METHOD__.'</b>');
- }
- return; //only one cycle!
- }
- }
- }
-
- //method to build the array of popup objects
- public function popupBuild()
- {
- foreach ($this->_popupItemNames as $field => $itemName)
- {
-// if (array_key_exists($field,$this->_where))
-// {
- $fieldClean = str_replace('n!',null,$field);
- $itemNameClean = str_replace('n!',null,$itemName);
- $fieldClean = $this->dropStartChar($fieldClean,'-');
- $itemNameClean = $this->dropStartChar($itemNameClean,'-');
-
- //fields that have to be extracted
- $queryFields = ($fieldClean === $itemNameClean) ? $fieldClean : $fieldClean.','.$itemNameClean;
-
- $table = $this->getTableName($field);
- $this->popupArray[$field] = new Popup();
-
- $popupWhereClause = array_key_exists($field,$this->_popupWhere) ? $this->_popupWhere[$field] : null;
-
- $result = $this->db->select($table,$queryFields,$popupWhereClause,$fieldClean);
-
- if ($result and $result !== false)
- {
- //get the label of the popup menu
- $label = array_key_exists($field,$this->_popupLabels) ? $this->_popupLabels[$field] : $table.' : '.$itemNameClean;
- $this->popupArray[$field]->name = $label;
-
- //get the table name
- $fieldTable = isset($result[0][$table][$fieldClean]) ? $table : Params::$aggregateKey;
- $itemNameTable = isset($result[0][$table][$itemNameClean]) ? $table : Params::$aggregateKey;
-
- foreach ($result as $row)
- {
- $this->popupArray[$field]->itemsValue[] = $row[$fieldTable][$fieldClean];
-
- if (array_key_exists($field,$this->_popupFunctions))
- {
- if (!function_exists($this->_popupFunctions[$field]))
- {
- throw new Exception('Error in <b>'.__METHOD__.'</b>: function <b>'.$this->_popupFunctions[$field]. '</b> does not exists');
- }
-
- $tempName = call_user_func($this->_popupFunctions[$field],$row[$itemNameTable][$itemNameClean]);
- }
- else
- {
- $tempName = $row[$itemNameTable][$itemNameClean];
- }
-
- $this->popupArray[$field]->itemsName[] = $tempName;
- }
- }
-// }
- }
- }
-
-
- //get the element before and after the current one
- //$key: the key of the self::$where array that indicates the field to be used in order to find out the records before and after
- //$fields: the fields that have to be extracted
- public function getNeighbours($key,$fields = '')
- {
- //backup of the values
- $tempWhere = $this->where;
- $tempLimit = $this->limit;
- $tempOrderBy = $this->orderBy;
- $this->limit = 1;
- //before
- $this->where[$key] = '<'.$tempWhere[$key];
- $this->orderBy = $this->getTableName($key).'.'.$key.' DESC';
- $dataAfter = $this->getFields($fields);
- //after
- $this->where[$key] = '>'.$tempWhere[$key];
- $this->orderBy = $this->getTableName($key).'.'.$key;
- $dataBefore = $this->getFields($fields);
- //restore the previous values
- $this->where = $tempWhere;
- $this->limit = $tempLimit;
- $this->orderBy = $tempOrderBy;
- $result[0] = isset($dataBefore[0]) ? $dataBefore[0] : null;
- $result[1] = isset($dataAfter[0]) ? $dataAfter[0] : null;
- return $result;
- }
-
- //set the $select property and return the current object
- public function select($fields = null)
- {
- $this->select = $fields;
- return $this;
- }
-
- //set the $from property and return the current object
- public function from($tables = null)
- {
- $this->from = isset($tables) ? $tables : $this->_tables;
- return $this;
- }
-
- //set the $on property and return the current object
- public function on($joinClause = '-')
- {
- $this->on = $joinClause;
- return $this;
- }
-
- //set the $using property and return the current object
- public function using($using = null)
- {
- $this->using = $using;
- return $this;
- }
-
- //set the $where property and return the current object
- public function where($where = array())
- {
- $this->where = $where;
- return $this;
- }
-
- //append the $where array to the ::where property and return the current object
- public function aWhere($where = array())
- {
- $this->appendWhereQueryClause($where);
- return $this;
- }
-
- //set the $groupBy property and return the current object
- public function groupBy($groupBy = null)
- {
- $this->groupBy = $groupBy;
- return $this;
- }
-
- //set the $orderBy property and return the current object
- public function orderBy($orderBy = null)
- {
- $this->orderBy = $orderBy;
- return $this;
- }
-
- //set the $limit property and return the current object
- public function limit($limit = null)
- {
- $this->limit = $limit;
- return $this;
- }
-
- //set the $listArray property
- public function toList($key, $value = null)
- {
- $this->listArray = array($key,$value);
- $this->toList = true;
- return $this;
- }
-
- //reset all the clauses of the select query
- public function clear()
- {
- $this->select = null;
- $this->where = array();
- $this->groupBy = null;
- $this->orderBy = null;
- $this->limit = null;
- $this->from = null;
- $this->on = null;
- $this->using = null;
- $this->toList = false;
- return $this;
- }
-
- //initialize and populate the ::form property (reference to a Form_Form object)
- public function setForm($defAction = null, $defSubmit = array(), $defMethod = 'POST')
- {
- if (isset($this->formStruct))
- {
- $action = array_key_exists('action',$this->formStruct) ? $this->formStruct['action'] : $defAction;
- $submit = array_key_exists('submit',$this->formStruct) ? $this->formStruct['submit'] : $defSubmit;
- $entries = array_key_exists('entries',$this->formStruct) ? $this->formStruct['entries'] : null;
- $method = array_key_exists('post',$this->formStruct) ? $this->formStruct['post'] : $defMethod;
-
- $this->form = new Form_Form($action,$submit,$method);
-
- if (isset($entries))
- {
- $this->form->setEntries($entries);
- }
-
- $copy = $this->form->entry;
-
- foreach ($copy as $name => $entry)
- {
- if (strcmp($entry->type,'Select') === 0 and isset($entry->options))
- {
- if (!is_array($entry->options))
- {
- if (strstr($entry->options,'foreign::'))
- {
- $elements = explode('::',$entry->options);
-
- for ($i = 0; $i < count($elements); $i++)
- {
- if (strcmp($elements[$i],'--') === 0) $elements[$i] = null;
- }
- //send the query
- array_shift($elements);
- $resultSet = call_user_func_array(array($this->db,'select'),$elements);
-
- $single = true;
-
- if (strstr($elements[1],','))
- {
- $args = explode(',',$elements[1]);
- //add the table name
- $args[0] = $elements[0].'.'.$args[0];
- $args[1] = $elements[0].'.'.$args[1];
- //associative array
- $single = false;
- }
- else
- {
- $args[0] = $elements[0].'.'.$elements[1];
- $args[1] = null;
- }
-
- $list = $this->getList($resultSet,$args[0],$args[1]);
-
- $this->form->entry[$name]->options = ($single) ? implode(',',array_values($list)) : $list;
- }
- }
- }
- }
-
- }
- else
- {
- $this->form = new Form_Form($defAction,$defSubmit,$defMethod);
- }
- }
-
- //get a list from a result set
- //$resultSet: the result set coming from a select query
- public function getList($resultSet, $key, $value = null)
- {
- $list = array();
-
- if (strstr($key,'.'))
- {
- $arr = explode('.',$key);
- $keyTable = $arr[0];
- $keyField = $arr[1];
- }
- else
- {
- $keyTable = $this->_tablesArray[0];
- $keyField = $key;
- }
-
- if (!isset($value))
- {
- foreach ($resultSet as $row)
- {
- $list[] = $row[$keyTable][$keyField];
- }
- }
- else
- {
- if (strstr($value,'.'))
- {
- $arr = explode('.',$value);
- $valueTable = $arr[0];
- $valueField = $arr[1];
- }
- else
- {
- $valueTable = $this->_tablesArray[0];
- $valueField = $value;
- }
-
- foreach ($resultSet as $row)
- {
- $list[$row[$keyTable][$keyField]] = $row[$valueTable][$valueField];
- }
-
- }
- return $list;
- }
-
- // Retrieves the ID generated for an AUTO_INCREMENT column by the previous query (usually INSERT).
- public function lastId()
- {
- return $this->db->lastId();
- }
-
- //send a free query
- public function query($query)
- {
- return $this->db->query($query);
- }
-
- //the text of the error message from previous MySQL operation
- public function getError()
- {
- return $this->db->getError();
- }
-
- //the numerical value of the error message from previous MySQL operation
- public function getErrno()
- {
- return $this->db->getErrno();
- }
-
- //define the abstract method to get the value of the record $id of the main table
- abstract public function selectId($id);
-
- //define the abstract method to get the fields from the tables
- abstract public function getFields();
-
-} \ No newline at end of file