. if (!defined('EG')) die('Direct access not allowed!'); //class to create the HTML of a list of records class Helper_List extends Helper_Html { //table attributes static public $tableAttributes = array('class'=>'listTable','cellspacing'=>'0'); private $__rowArray = array(); //the current associative array representing the database record protected $_itemsList = array(); //2-dimensional associative array containing the list items //keys: type,table:field,controller/action,value protected $_head = array(); //2-dimensional array containing the head of the table protected $_identifierName; protected $_recordNumber = null; //number of records from the table protected $_allowedItems = array('simpleLink','simpleText','delForm','editForm','associateForm','moveupForm','movedownForm','Form','ledit','link','text','checkbox','input'); //type of items allowed //it can be: both, top, bottom, none protected $_boundaries = 'none'; //array of filters protected $_filters = array(); //array of bulk actions protected $_bulkActions = array(); //set to false if you don't want that the filters are created inside the table public $showFilters = true; //set if the submit buttons have to be images or not (it can be yse or not) public $submitImageType = 'yes'; //set the files of the images public $submitImages = array(); //set the titles of the input:submit public $submitTitles = array(); //properties of columns public $colProperties = array(); //$position: array. First element: page number, second element: number of pages public $position = array(); //instance of Lang_{language}_Generic public $strings = null; //the url (controller/action) of the current page public $url = null; public $pageArg = null; //the key of the viewArgs array representing the page number. $this->viewArgs[$this->pageArg] is set to 1 if $this->pageArg !== null //if the filter forms have to be aggregated in a unique form or if they have to be left separated public $aggregateFilters = false; public function __construct() { //get the generic language class $this->strings = Factory_Strings::generic(Params::$language); $baseUrl = Url::getRoot().'Public/Img/Icons/elementary_2_5/'; //set the files of the images $this->submitImages = array( 'up' => $baseUrl.'up.png', 'down' => $baseUrl.'down.png', 'edit' => $baseUrl.'edit.png', 'del' => $baseUrl.'delete.png', 'link' => $baseUrl.'link.png', ); $this->submitTitles = array( 'edit' => $this->strings->gtext('edit'), 'del' => $this->strings->gtext('delete'), 'up' => $this->strings->gtext('move up'), 'down' => $this->strings->gtext('move down'), 'link' => $this->strings->gtext('associate') ); } public function build($identifierName = 'identifier', $url = null, $pageArg = null) { $this->_identifierName = $identifierName; $this->url = $url; $this->pageArg = $pageArg; } public function setIdentifierName($identifierName) { $this->_identifierName = $identifierName; } //add a list Item. $type: the type of the item, $field: the table.field to exctract (use colon to separate the table and the field),$action: controller/action,$value=if type == link->the value of the link public function addItem($type, $action = '', $field = '', $name = '', $value = '', $title = '') { if (!in_array($type,$this->_allowedItems)) { throw new Exception('"'.$type. '" argument not allowed in '.__METHOD__.' method'); } $temp=array(); $temp['type'] = $type; $temp['action'] = $action; $temp['field'] = $field; $temp['name'] = $name; $temp['value'] = $value; $temp['title'] = $title; $this->_itemsList[] = $temp; //set the $this->_head array $head = array(); $head['type'] = $type; if ($type === 'simpleText') { $head['action'] = $this->extractFieldName($action); } else { $head['action'] = ' '; } $this->_head[] = $head; } //set the head of the table //$columnsName: name of the columns. It has to be a comma-separated list of strings public function setHead($columnsName = '') { //get the array from the list $columnsArray = explode(',',$columnsName); for ($i = 0; $i < count($columnsArray); $i++) { if ($i < count($this->_itemsList)) $this->_head[$i]['action'] = $columnsArray[$i]; } } //set the filters //$filters: array whose elements are the viewArgs to be used for the filters forms //or null public function setFilters($filters) { $this->_filters = $filters; } //set $this->aggregateFilters equal to true public function aggregateFilters() { $this->aggregateFilters = true; } //set the bulk actions //$bulkActions: associative array. //key: class of the inputs whose elements have to be selected and serialized by javascript in the following way: data-primary-key:value_attribute|data-primary-key:value_attribute|data-primary-key:value_attribute|... //value: array with two elements whose first element is the bulk action to be sent as a key of $_POST, second element is the human readable name of the action, third element can be the string "confirm" (if the user has to confirm the action) or undefined //example: // $bulkActions = array( // "input_category_id_order" => array("sortAction","Sort elements"), // "checkbox_category_id" => array("deleteAction","Delete elements","confirm"), // ); public function setBulkActions($bulkActions) { $this->_bulkActions = $bulkActions; } //check that the ViewArgs array is complete public function checkViewArgs() { foreach ($this->_filters as $field) { $key = !is_array($field) ? $field : $field[0]; if (!array_key_exists($key,$this->viewArgs) and strcmp($key,null) !== 0) return false; } return true; } //$method to extract the field name from the $action string (;table:field;). Used for the head public function extractFieldName($string) { $string = str_replace(';','',$string); return $string; } //replace the strings wrapped by ; with their correspondent value taken by the $recordArray associative array (a row of the select query) public function replaceFields($string,$rowArray) { $this->__rowArray = $rowArray; //used by the replaceField method $string = preg_replace_callback('/(\;)(.*?)(\;)/', array($this, 'replaceField') ,$string); return $string; } //get : or . as char used to separate table and field public function getChar($string) { return strstr($string,':') ? ':' : '.'; } //replace a single string wrapped by ; with its correspondent value taken by the $recordArray associative array (a row of the select query) public function replaceField($match) { $string = $match[2]; //check if a function has been indicated if (strstr($string,'|')) { //get the function $firstArray = explode('|',$string); if (strstr($firstArray[1],':') or strstr($firstArray[1],'.')) { $func = $firstArray[0]; //replace the fields $char = $this->getChar($firstArray[1]); $temp = explode($char,$firstArray[1]); $string = $this->__rowArray[$temp[0]][$temp[1]]; $string = callFunction($func,$string,__METHOD__); } } else { if (strstr($string,':') or strstr($string,'.')) { $char = $this->getChar($string); $temp = explode($char,$string); $string = $this->__rowArray[$temp[0]][$temp[1]]; } } return $string; } //call the method replaceFields upon the $items array using the associative array $rowArray public function replaceAll($item,$rowArray) { $item['action'] = $this->replaceFields($item['action'],$rowArray); $item['field'] = $this->replaceFields($item['field'],$rowArray); $item['name'] = $this->replaceFields($item['name'],$rowArray); $item['value'] = $this->replaceFields($item['value'],$rowArray); $item['title'] = $this->replaceFields($item['title'],$rowArray); return $item; } //wrap the column with the tag td public function wrapColumn($string, $className = null, $tag = "td") { return wrap($string,array($tag=>$className)); } //wrap the row with the tag tr public function wrapRow($string,$className = null) { return wrap($string,array('tr'=>$className)); } public function wrapList($string) { return wrap($string,array('table'=>self::$tableAttributes)); } //method to create the HTML of the head of the table public function createHead() { $htmlHead = null; $count = 0; foreach ($this->_head as $item) { $temp = $item['action']; if (preg_match('/\[\[bulkselect:(.*?)\]\]/',$temp,$matches)) { $temp = Html_Form::checkbox("bulkselect_".$matches[1],"","BS","bulk_select_checkbox",null,"data-class='".$matches[1]."'"); } $prop = $item['type']; if (isset($this->colProperties[$count])) { $prop = $this->colProperties[$count]; } $htmlHead .= $this->wrapColumn($temp, $prop, "th"); $count++; } return $htmlHead; } //return an array with all the filters in a 1-dimensional array public function getFiltersList() { $filterList = array(); foreach ($this->_filters as $f) { if (is_array($f)) { $filterList[] = $f[0]; } else { $filterList[] = $f; } } return $filterList; } //method to create the HTML of the filters input public function createFilters() { $htmlFilters = null; if (count($this->_filters) > 0) { if ($this->checkViewArgs()) { $count = 0; foreach ($this->_head as $item) { $prop = $item['type']; if (isset($this->colProperties[$count])) { $prop = $this->colProperties[$count]; } $html = ' '; if (isset($this->_filters[$count])) { if (!is_array($this->_filters[$count])) { $html = $this->filterForm($this->_filters[$count]); } else { $html = call_user_func_array(array($this,"filterForm"),$this->_filters[$count]); // $html = $this->filterForm($this->_filters[$count][0],$this->_filters[$count][1]); } } //wrap single cell if filters doesn't have to be aggregate if (!$this->aggregateFilters) { $htmlFilters .= !$this->showFilters ? $html : $this->wrapColumn($html,$prop); } else { $htmlFilters .= $html; } $count++; } //wrap an aggregate cell if filters have to be aggregate if ($this->aggregateFilters) { $colspan = count($this->_itemsList); $formTop = "
\n"; $imgSrc = Url::getRoot('Public/Img/Icons/elementary_2_5/find.png'); $formBottom = ""; $emptyFilterStatusArray = array(); $filtersList = $this->getFiltersList(); foreach ($this->viewArgs as $k => $v) { if (!in_array($k,$filtersList)) { $emptyFilterStatusArray[] = "$k=$v"; $formBottom .= ""; } } $emptyFilterStatus = implode("&",$emptyFilterStatusArray); $formBottom .= ""; $formBottom .= "\n"; $formBottom .= "
"; $htmlFilters = !$this->showFilters ? $formTop.$htmlFilters.$formBottom : $this->wrapColumn($formTop.$htmlFilters.$formBottom,array("class"=>"aggregate_filters_td","colspan"=>$colspan)); } } } return $htmlFilters; } //create the HTML of the select of the bulk actions public function createBulkActionsSelect() { $htmlBulkSelect = null; $colspan = count($this->_itemsList); if (count($this->_bulkActions) > 0) { $htmlBulkSelect .= "".$this->strings->gtext('Actions').": "; $htmlBulkSelect = $this->wrapColumn($htmlBulkSelect,array("class"=>"bulk_actions_td","colspan"=>$colspan)); } return $htmlBulkSelect; } //create the HTML of a single row (values taken from the associative array $rowArray) public function getRowList($rowArray) { $htmlList = null; $count = 0; foreach ($this->_itemsList as $item) { $item = $this->replaceAll($item,$rowArray); $prop = $item['type']; if (isset($this->colProperties[$count])) { $prop = $this->colProperties[$count]; } if (($this->_boundaries === 'top' and $item['type'] === 'moveupForm') or ($this->_boundaries === 'bottom' and $item['type'] === 'movedownForm') or ($this->_boundaries === 'both' and ($item['type'] === 'moveupForm' or $item['type'] === 'movedownForm'))) { $htmlList .= $this->wrapColumn(' ',$prop); } else { $temp = call_user_func_array(array($this,$item['type']),array($item)); $htmlList .= $this->wrapColumn($temp,$prop); } $count++; } return $htmlList; } //$index: record number public function ifInBoundaries($index) { $this->_boundaries = 'none'; if (!empty($this->position)) { if ($this->_recordNumber === 1 and strcmp($this->position[0],1) === 0) { $this->_boundaries = 'both'; } else if ($index === 0 and strcmp($this->position[0],1) === 0) { $this->_boundaries = 'top'; } else if ($index === ($this->_recordNumber-1) and strcmp($this->position[0],$this->position[1]) === 0) { $this->_boundaries = 'bottom'; } } } //create the HTML of the entire list. $queryResult: the array coming from the select query public function render($queryResult) { //set the number of records $this->_recordNumber = count($queryResult); $htmlList = null; //create the HTML of the head of the record list $htmlList .= "\n".$this->wrapRow($this->createHead(),'listHead')."\n"; //create the HTML of the filters $htmlList .= "\n"; $bulkActionsHtml = $this->createBulkActionsSelect(); if (isset($bulkActionsHtml)) { $htmlList .= $this->wrapRow($bulkActionsHtml,'bulk_actions_tr'); } if ($this->showFilters) { $filtersHtml = $this->createFilters(); if (isset($filtersHtml)) { $htmlList .= $this->wrapRow($filtersHtml,'listFilters'); } } for ($i = 0; $i < count($queryResult); $i++) { $this->ifInBoundaries($i); $temp = $this->getRowList($queryResult[$i]); $htmlList .= $this->wrapRow($temp,'listRow'); } return $this->wrapList($htmlList."\n"); } public function generalForm($itemArray, $submitName, $submitValue) { $string = "
viewStatus."' method='POST'>\n"; $name = (strcmp($itemArray['name'],'') !== 0) ? $itemArray['name'] : $submitName; $value = (strcmp($itemArray['value'],'') !== 0) ? $itemArray['value'] : $submitValue; $oldValue = $value; $value = $this->strings->gtext($value); if (strcmp($itemArray['title'],'') !== 0) { $title = "title='".$itemArray['title']."'"; } else { $title = isset($this->submitTitles[$oldValue]) ? "title='".$this->submitTitles[$oldValue]."'" : null; } if (strcmp($this->submitImageType,'yes') === 0 and isset($this->submitImages[$oldValue])) { $imgSrc = $this->submitImages[$oldValue]; $string .= "\n"; $string .= "\n"; } else { $string .= "\n"; } $string .= "\n"; $string .= "
\n"; return $string; } public function Form($itemArray) { return $this->generalForm($itemArray, 'name_missing', 'value_missing'); } public function moveupForm($itemArray) { return $this->generalForm($itemArray, 'moveupAction', 'up'); } public function movedownForm($itemArray) { return $this->generalForm($itemArray, 'movedownAction', 'down'); } public function editForm($itemArray) { return $this->generalForm($itemArray, 'generalAction', 'edit'); } public function delForm($itemArray) { return $this->generalForm($itemArray, 'delAction', 'del'); } public function associateForm($itemArray) { return $this->generalForm($itemArray, 'generalAction', 'link'); } public function simpleText($itemArray) { $text = strcmp($itemArray['action'],'') !== 0 ? $itemArray['action'] : ' '; $string = "".$text."\n"; return $string; } public function text($itemArray) { return $this->simpleText($itemArray); } public function simpleLink($itemArray) { $string = "viewStatus."'>".$itemArray['name']."\n"; return $string; } public function link($itemArray) { return $this->simpleLink($itemArray); } public function ledit($itemArray) { $text = isset($this->submitImages['edit']) ? "" : $itemArray['name']; $title = isset($this->submitTitles['edit']) ? $this->submitTitles['edit'] : $itemArray['field']; $string = "viewStatus."'>$text\n"; return $string; } //create the HTML of a checkbox public function checkbox($itemArray) { return Html_Form::checkbox($itemArray['action'],$itemArray['field'],$itemArray['name'],"checkbox_".encode($itemArray['action']),null,"data-primary-key='".$itemArray['value']."'"); } //create the HTML of an input text public function input($itemArray) { return Html_Form::input($itemArray['action'],$itemArray['field'],"input_".encode($itemArray['action']),null,"data-primary-key='".$itemArray['name']."'"); } //create the HTML of the filter public function filterForm($viewArgsName, $filterString = null, $filterValues = null) { $cleanName = str_replace('n!',null,$viewArgsName); $cleanName = str_replace('-',null,$cleanName); if (isset($this->viewArgs[$this->pageArg])) { $this->viewArgs[$this->pageArg] = 1; } $temp = $value = $this->viewArgs[$viewArgsName]; //set the viewArg to the null query value if (Params::$nullQueryValue) { $this->viewArgs[$viewArgsName] = Params::$nullQueryValue; $viewStatus = Url::createUrl($this->viewArgs); if (strcmp($value,Params::$nullQueryValue) === 0 and !isset($filterValues)) { $value = ''; } } else { $viewStatus = $this->viewStatus; } $this->viewArgs[$viewArgsName] = $temp; $action = Url::getRoot($this->url).$viewStatus; $imgSrc = Url::getRoot('Public/Img/Icons/elementary_2_5/find.png'); $title = $this->strings->gtext('filter'); $clearLinkTitle = $this->strings->gtext('clear the filter'); $html = null; if (!$this->aggregateFilters) { $html .= "
\n"; } $html .= isset($filterString) ? " ".$filterString." " : null; if (!isset($filterValues)) { $html .= ""; } else { $filterValues = array_merge(array(Params::$nullQueryValue => $this->strings->gtext('All')),$filterValues); $html .= Html_Form::select($viewArgsName,$value,$filterValues,"list_filter_input list_filter_input_$cleanName",null,"yes"); } if (!$this->aggregateFilters) { $html .= ""; $html .= "\n"; if (!Params::$rewriteStatusVariables) { foreach ($this->viewArgs as $k => $v) { if (strcmp($k,"$viewArgsName") !== 0) { $html .= ""; } } } $html .= "
\n"; } return $html; } }