<?php
include_once 'conf/config.php';
include_once CLASS_PATH . 'grp.class.php';
globalizePost();
$obj = new grp();
$rows = MAX_PAGE_RECORDS;
/**
* WHERE clause building
*/
$gr_title = trim($gr_title);
$gr_brief = trim($gr_brief);
$whereClause = " WHERE UPPER(IFNULL(gr_title, '')) LIKE UPPER(CONCAT('%', IFNULL(" . $obj->getSqlColValue('gr_title', $gr_title) . ", ''), '%'))\n AND UPPER(IFNULL(gr_brief, '')) LIKE UPPER(CONCAT('%', IFNULL(" . $obj->getSqlColValue('gr_brief', $gr_brief) . ", ''), '%'))\n";
/**
* Get query data
*/
$obj->Select(array('gr_title', 'gr_brief', 'gr_id'), '', $whereClause . ' ORDER BY ' . ($_POST['sort'] - 2) . ' ' . $_POST['dir'], $_POST['page'], $rows, false);
while (!$obj->EOF()) {
$row = $obj->Row();
print ' <td><input type="checkbox" name="chkRecord" id="chkRecord_' . $row->gr_id . '" value="' . $row->gr_id . '"/></td>';
print ' <td>' . $row->gr_title . '</td>';
print ' <td>' . $row->gr_brief . '</td>';
print ' <td>
<div class="action-group btn-group pull-right mtm mbm">
<button type="button" class="btn btn-default" onclick="javascript:window.location.assign(\'grp.form.php?recordId=' . $row->gr_id . '&in2Action=editRecord\');"><i class="fa fa-edit"></i></button>
<button type="button" class="btn btn-default" onclick="javascript:deleteRecord(\'gr_id\', ' . $row->gr_id . ');"><i class="fa fa-trash-o"></i></button>
</div>
</td>';
print '</tr>';
}
$fileObj->manipImageUpload('mr_slideshow', $_REQUEST['sl_id'], FEATURED_PHOTO_SML, FEATURED_PHOTO_MED, FEATURED_PHOTO_BIG, true, false, FEATURED_PHOTO_MEDBIG, FEATURED_PHOTO_LRG, FEATURED_PHOTO_BO);
$fileObj = null;
}*/
$in2Action = 'edit';
$frmAction = 'edit';
goToURL($actScript . "?recordId=" . $_REQUEST['gr_id'] . "&in2Action=editRecord&frmAction=edit{$error}");
case 'editRecord':
if ($recordId) {
$id = $recordId;
} elseif ($gr_id) {
$id = $gr_id;
} else {
$id = null;
}
if ($id) {
$where = "WHERE gr_id = " . $obj->getSqlColValue('gr_id', $id);
$record = $obj->SelectRecord(null, $where, MYSQL_ASSOC, false);
if (is_array($record)) {
globalizeArray($record);
} else {
$_SESSION['errorMsgs'] = array('erroneousParam' => 'Erroneous parameter passed.');
$error = '&error=1';
goToURL($actScript . $error);
}
} else {
goToURL($actScript);
}
$buttons = '<a href="#" class="btn btn-info btn-circle btn-block"><i class="icon-eye"></i> Preview</a>';
$buttons .= '<hr/>';
$buttons .= '<button type="submit" class="btn btn-block btn-success btn-circle" onclick="document.getElementById(\'in2Action\').value=\'edit\'"><i class="fa fa-check"></i> ' . $arrLang[$_SESSION['lang']]['update'] . '</button>';
$buttons .= '<button type="button" class="btn btn-block btn-danger btn-circle" onclick="jQuery(\'#btnReset\').click(); deleteFrmRecord()"><i class="fa fa-trash-o"></i> ' . $arrLang[$_SESSION['lang']]['delete'] . '</button>';
