AAAAcomponents/com_chronoforms/form_actions/db_multi_record_loader/cfaction_db_multi_record_loader.php 0000604 00000010600 15140062331 0036566 0 ustar 00 home/academiac/www/administrator params);
$output = '';
if((bool)$params->get('enable_data_displayer', 0) === true && $params->get('load_type', 'all') == 'all'){
//find the model data
$table_name = $params->get('table_name', '');
$model_id_sub = preg_replace('/(?:^|_)(.?)/e', "strtoupper('$1')", $table_name);
$model_id = $params->get('model_id', '');
if(empty($model_id)){
$model_id = $model_id_sub;
}
//pre output creation
$fields_names = array();
$fields_headings = array();
$order_fields = array();
//get order fields
$order_str = trim($params->get('data_order_fields', ''));
if(!empty($order_str)){
$order_fields = explode(",", trim($params->get('data_order_fields', '')));
}
//get display fields
$fields_data = trim($params->get('data_display_fields', ''));
if(!empty($fields_data)){
$fields_data = explode(",", $fields_data);
foreach($fields_data as $field_data){
$field_data = explode(":", trim($field_data));
$fields_names[] = $field_name = $field_data[0];
if(!isset($field_data[1])){
$field_data[1] = strtoupper($field_data[0]);
}
$fields_headings[] = $field_heading = $field_data[1];
}
}
//create the table code
$output .= '
';
$output .= '';
$output .= '';
$form->loadActionHelper('show_html');
$showHTMLHelper = new CfactionShowHtmlHelper();
foreach($fields_headings as $k => $field_heading){
if(in_array($fields_names[$k], $order_fields)){
$direction = 'asc';
if(isset($form->data['order']) && ($form->data['order'] == $fields_names[$k]) && isset($form->data['direction'])){
if($form->data['direction'] == 'asc'){
$direction = 'desc';
}else{
$direction = 'asc';
}
}
$class = '';
if(isset($form->data['order']) && ($form->data['order'] == $fields_names[$k])){
$class = ' direction_'.(isset($form->data['direction']) ? $form->data['direction']: 'asc');
}
$field_heading = ''.$field_heading.'';
}else{
$field_heading = $field_heading;
}
$output .= '| '.$field_heading.' | ';
}
$output .= '
';
$output .= '';
$output .= '';
$i = 0;
if(!empty($form->data[$model_id])){
foreach($form->data[$model_id] as $r => $record){
$output .= '';
foreach($fields_names as $k => $field_name){
if(strpos($field_name, '.') !== false){
$record[$field_name] = $form->get_array_value($record, explode('.', $field_name));
}
$output .= '| '.$record[$field_name].' | ';
}
$output .= '
';
$i = 1 - $i;
}
}
$output .= '';
$output .= '
';
}
if((bool)$params->get('enable_pagination', 0) === true && isset($form->paginatior_footer)){
//check the position of the pagination
if((int)$params->get('enable_pagination', 0) == 1){
$output = $form->paginatior_footer.$output;
}else if((int)$params->get('enable_pagination', 0) == 2){
$output = $output.$form->paginatior_footer;
}
}
//add CSS
$this->_addCSS($form, $actiondata);
//end
echo $output;
}
function _addCSS($form, $actiondata){
$document = JFactory::getDocument();
//add some CSS formatting for pagination
ob_start();
?>
.list-footer ul li {
display: inline;
}
#db_multi_record_loader_id; ?> {
width: 100%;
margin: 0px 0px;
}
#db_multi_record_loader_id; ?> .cell {
padding: 2px;
}
#db_multi_record_loader_id; ?> .cell {
padding: 2px;
}
#db_multi_record_loader_id; ?> thead {
background-color: #dedede;
}
addStyleDeclaration($script);
}
}
?>