/**
*@package AppList
*@since v0.2
*@method Render()
* */
public function Render($getCurrentUrl)
{
$this->currentUrl = $getCurrentUrl;
// Parent CurrentUrl
$rs = '';
$this->formaLimit();
// Reasignar op si viene tbl_op
$op_2 = fk_post_get($this->tableId . '_op');
if (trim($op_2) != '') {
$this->operation = decode($op_2);
}
switch ($this->operation) {
case 'add-lines':
$this->processNewLineHtml();
$rs .= $this->new_line_html;
break;
case 'save-lines':
if ($this->save_function != NULL) {
// Custom function
call_user_func_array($this->save_function['function'], $this->save_function['parrameters']);
$rs .= $this->PrintList();
} else {
// Default save function
$this->saveLines();
$rs .= fk_ok_message('Información guardada');
$rs .= $this->PrintList();
}
break;
case 'delete-line':
$this->deleteLine();
break;
default:
$rs .= $this->PrintList();
break;
}
// End switch
return $rs;
}
private function update_file_data()
{
// Guarda referencia en la db
$this->record_id = $_POST['id'];
$this->FileRecord->find($_POST['id']);
//$this->FileRecord-> fields[$this->fld_id] = $_POST['id'];
//$this->FileRecord -> fields[$this->fdl_id_user] = $_SESSION['id_usuario'];
//$this->FileRecord-> fields[$this->fld_path] = $this->Directory;
//$this->FileRecord-> fields[$this->fld_type] = $this->file_type;
//$this->FileRecord -> fields[$this->fld_file] = $this->file_name;
$this->FileRecord->fields[$this->fld_title] = $_POST['title'];
$this->FileRecord->fields[$this->fld_leyend] = $_POST['leyend'];
$this->FileRecord->fields[$this->fld_desc] = $_POST['desc'];
$this->FileRecord->fields[$this->fld_updated_date] = date('Y-m-d H:i:s');
$this->FileRecord->update();
echo fk_ok_message(__('Cambios Guardados'));
}
/**
*@package AppForm
*@since v0.1 beta
*@method PrintSearchResult()
*@desc Returns the search result
* */
private function PrintSeachResults()
{
$db = new db();
$db->connect();
$proyection_fields = $this->SearchCustomFields;
if (trim($this->SearchCustomFields) != '*') {
$proyection_fields = $this->DbRecord->id_field_name . ' as Id, ' . $this->SearchCustomFields;
}
//pa($this->DbRecord-> form_fields);
$where = '';
if ($_POST['srch-by-field'] == '0') {
$where_fields = '';
foreach ($this->DbRecord->form_fields as $f) {
$where_fields .= $f['Field'] . ' like "%' . $_POST['srch-word'] . '%" OR ';
}
$where_fields = substr($where_fields, 0, -3);
$where = ' WHERE (' . $where_fields . ')';
} else {
$where = ' WHERE (' . $_POST['srch-by-field'] . ' like "%' . $_POST['srch-word'] . '%") ';
}
$sqlSrch = 'SELECT ' . $proyection_fields . ' FROM ' . $this->model . ' ' . $where . ' ' . $this->DbRecord->SqlAnd . ' ';
$db->query_assoc($sqlSrch);
$data_rs = '';
$tot = $db->num_rows();
if ($tot == 0) {
$data_rs .= fk_alert_message($tot . ' resultados', false);
} else {
$data_rs .= fk_ok_message($tot . ' resultados', false);
}
$data_rs .= '<table class="tbl-1" style="width:100%" border="0" cellspacing="0" cellpadding="0" >';
$cnt = 0;
while ($rows = $db->next()) {
$cnt++;
//pa($rows);
if ($cnt % 2 == 0) {
$even_odd = 'even';
} else {
$even_odd = 'odd';
}
if ($cnt == 1) {
// Header
$data_rs .= '<tr><th> </th>';
foreach ($rows as $col => $val) {
$data_rs .= '<th>' . ucwords(strtolower(strtr($col, '_', ' '))) . '</th>';
}
$data_rs .= '</tr>';
}
if (trim($this->SearchCustomFields) != '*') {
$id_record = $rows['Id'];
} else {
$id_record = $rows[$this->DbRecord->id_field_name];
}
$fx_sel_rec = new ajax('url', 'pannel-1-' . $this->IdObject, 'args:op=' . encode('selec-record') . '&rec-srch=' . $id_record . ';form:' . $this->IdObject . ';url:' . $this->CurrentPage);
$data_rs .= '<tr class="' . $even_odd . '" onclick="' . $fx_sel_rec->render() . '"><td><a href="javascript:void(0)">Ver</a></td>';
foreach ($rows as $col => $val) {
$data_rs .= '<td>' . $val . '</td>';
}
$data_rs .= '</tr>';
}
$data_rs .= '</table>';
echo $data_rs;
}
