function json()
{
//carico X class database
$this->load->database();
$this->load->model('objects');
$this->load->helper('ft_date_helper');
$objects = $this->objects->get_all();
$rows = array();
foreach ($objects as $obj) {
$_edit_button = '<a href="' . site_url('objectmanager/edit/' . $obj->id) . '" class="btn btn-default btn-xs"><i class="fa fa-pencil"></i></a>';
$_delete_button = '<a href="javascript:ask_delete(' . $obj->id . ', \'' . $obj->obj_name . '\');" file-id="' . $obj->id . '" file-name="' . $obj->obj_name . '" class="btn btn-default btn-xs file-delete txt-color-red"><i class="fa fa-times"></i></a>';
$icon_file = $obj->num_files > 1 ? 'fa-files-o' : ' fa-file-o';
$_files = $obj->num_files . ' <i class="fa ' . $icon_file . '"></i>';
$rows[] = array($obj->obj_name, $obj->obj_description, mysql_to_human($obj->date_insert), $_files, $_edit_button . ' ' . $_delete_button);
}
echo json_encode(array('aaData' => $rows));
}
<?php
foreach ($lasts as $task) {
?>
<tr>
<td><?php
echo $task['type'];
?>
</td>
<td><?php
echo $task['status'];
?>
</td>
<td><?php
echo mysql_to_human($task['start_date']);
?>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
<?php
} else {
</div>
</fieldset>
<fieldset>
<legend>Summary</legend>
<div>
<label>Rata-rata</label>
<input type="text" value="<?php
echo $data['average'];
?>
" name="average" id="average" class="number" />
</div>
<div>
<label>Catatan</label>
<textarea rows="" cols="" name="notes">
<?php
echo $data['notes'];
?>
</textarea>
</div>
<div>
<label>Tanggal Penilaian</label>
<input type="text" value="<?php
echo mysql_to_human($data['judge_date']);
?>
" class="ac_hidden" />
</div>
</fieldset>
<div class="action-buttons">
<input type="submit" />
</div>
</form>
<?php
$id = uniqid('date_');
?>
<div id="<?php
echo $id;
?>
" style="display: inline">
<input type="text" class="date <?php
echo @$options['class'];
?>
"
<?php
echo !empty($_POST[$name]) ? 'value="' . mysql_to_human($_POST[$name]) . '" data-value="' . @$_POST[$name] . '"' : '';
?>
<?php
echo $extra;
?>
/>
<input type="hidden" class="hidden-val" value="<?php
echo @$_POST[$name];
?>
" name="<?php
echo $name;
?>
" />
</div>
?>
" /></td>
<td class="left"><?php
echo $user['id'];
?>
</td>
<td class="left"><?php
echo $all_pages[$user['page_parent_id']];
?>
</td>
<td class="left"><?php
echo $user['page_name'];
?>
</td>
<td class="left"><?php
echo mysql_to_human($user['created'], 'Y-m-d');
?>
</td>
<td align="right" valign="middle">
<?php
echo $user['rank'];
?>
</td><td align="left">
<img src="<?php
echo base_url();
?>
images/backend/save_file.jpg" onclick="change_rank('<?php
echo $user['id'];
?>
','<?php
echo $user['rank'];
<th class="hidden-xs">Description</th>
<th class="hidden-xs">Date</th>
</tr>
</thead>
<tbody>
<?php
foreach ($objects as $_obj) {
?>
<tr class="obj" data-id="<?php
echo $_obj['id'];
?>
">
<td><label class="radio"> <input type="radio" name="checkbox-inline"><i></i></label></td>
<td><strong><?php
echo $_obj['obj_name'];
?>
</strong></td>
<td class="hidden-xs"><i><?php
echo $_obj['obj_description'];
?>
</i></td>
<td style="width: 200px;" class="hidden-xs"><?php
echo mysql_to_human($_obj['date_insert']);
?>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
<th class="hidden-xs">Description</th>
<th class="hidden-xs">Date</th>
</tr>
</thead>
<tbody>
<?php
foreach ($objects as $_obj) {
?>
<tr class="obj" data-id="<?php
echo $_obj->id;
?>
">
<td><label class="radio"> <input type="radio" name="checkbox-inline"><i></i></label></td>
<td><strong><?php
echo $_obj->obj_name;
?>
</strong></td>
<td class="hidden-xs"><i><?php
echo $_obj->obj_description;
?>
</i></td>
<td style="width: 200px;" class="hidden-xs"><?php
echo mysql_to_human($_obj->date_insert);
?>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
require_once $_SERVER['DOCUMENT_ROOT'] . '/lib/database.php';
require_once $_SERVER['DOCUMENT_ROOT'] . '/lib/utilities.php';
/** SAVE POST PARAMETERS */
$_object_id = $_POST["id_object"];
$_printable = $_POST["printable"];
/** UTIL PARAMS */
$_printable_files[] = '.gc';
$_printable_files[] = '.gcode';
$_printable_files[] = '.nc';
/** LOAD DB */
$db = new Database();
/** LOAD OBJECE FROM DB */
$_object = $db->query("select * from sys_objects where id=" . $_object_id);
//$_object = $_object[0];
$_object['date_insert'] = mysql_to_human($_object['date_insert']);
$_object['date_updated'] = mysql_to_human($_object['date_updated']);
/** LOAD OBJECT'S FILES FROM DB */
$_object_files = $db->query("select * from sys_obj_files where id_obj=" . $_object_id);
if ($db->get_num_rows() == 1) {
$temp = $_object_files;
$_object_files = array();
$_object_files[] = $temp;
}
$_files = array();
foreach ($_object_files as $_obj) {
$_temp = $db->query("select * from sys_files where id=" . $_obj['id_file']);
if (isset($_temp)) {
$_files[$_temp['id']] = $_temp;
}
}
$db->close();
GROUP BY `sys_objects`.`id`
ORDER BY `date_insert` desc';
$_objects = $db->query($query_objects);
$db->close();
$_rows = array();
foreach ($_objects as $obj) {
$_edit_button = '<a href="' . site_url('objectmanager/edit/' . $obj['id']) . '" ><i class="fa fa-file fa-lg fa-fw txt-color-blue"></i> <u>E</u>dit</a>';
$_delete_button = '<a href="javascript:ask_delete(' . $obj['id'] . ', \'' . $obj['obj_name'] . '\');" file-id="' . $obj['id'] . '" file-name="' . $obj['obj_name'] . '" class="file-delete"><i class="fa fa-times fa-lg fa-fw txt-color-red"></i> <u>D</u>elete</a>';
$icon_file = $obj['num_files'] > 1 ? 'fa-files-o' : ' fa-file-o';
$_files = $obj['num_files'] . ' <i class="fa ' . $icon_file . '"></i>';
$_link_edit = '<a class="link" href="' . site_url('objectmanager/edit/' . $obj['id']) . '">' . $obj['obj_name'] . '</a>';
$_private_icon = $obj['private'] == 1 ? 'fa-user' : 'fa-users';
$_private_title = $obj['private'] == 1 ? 'Private' : 'Public';
$_action_buttons = '<i rel="tooltip" data-placement="top" title="' . $_private_title . '" class="fa ' . $_private_icon . '"></i>';
$_action_buttons .= '<div class="btn-group display-inline pull-right text-align-left ">';
$_action_buttons .= '<button class="btn btn-xs btn-default dropdown-toggle" data-toggle="dropdown"><i class="fa fa-cog fa-lg"></i></button>';
$_action_buttons .= '<ul class="dropdown-menu dropdown-menu-xs pull-right">';
$_action_buttons .= '<li>' . $_edit_button . '</li>';
if ($_SESSION['user']['id'] == $obj['user']) {
$_action_buttons .= '<li>' . $_delete_button . '</li>';
}
$_action_buttons .= '<li class="divider"></li><li class="text-align-center"><a href="javascript:void(0);">Cancel</a></li>';
$_action_buttons .= '</ul>';
$_action_buttons .= '</div>';
$checkbox = '<label class="checkbox-inline"><input type="checkbox" id="check_' . $obj['id'] . '" name="checkbox-inline" class="checkbox style-0"><span></span> </label>';
$_detail_button = '<td class="center" width="20px"><a href="#" > <i class="fa fa-chevron-right fa-lg" data-toggle="row-detail" title="Show Details"></i> </a></td>';
$_info_td = $obj['id'] . '-' . $obj['obj_name'];
$_rows[] = array($_info_td, $_detail_button, $checkbox, $_link_edit, $obj['obj_description'], mysql_to_human($obj['date_insert']), $_files);
}
header('Content-Type: application/json; charset=utf-8');
echo minify(json_encode(array('aaData' => $_rows)));
echo $row['id'];
?>
"> <?php
echo $row['nama'];
?>
</td>
<td><?php
echo $row['penilai'];
?>
</td>
<td><?php
echo $row['manager'];
?>
</td>
<td><?php
echo mysql_to_human($row['judge_date']);
?>
</td>
<td><?php
echo $row['average'];
?>
</td>
</tr>
<?php
}
?>
</table>
<?php
}
?>
</div>
} else {
if ($_public_objects) {
$_objects = array_merge($_public_objects);
}
}
$db->close();
$_rows = array();
foreach ($_objects as $obj) {
$_edit_button = '<a href="' . site_url('objectmanager/edit/' . $obj['id']) . '" ><i class="fa fa-file fa-lg fa-fw txt-color-blue"></i> <u>E</u>dit</a>';
$_delete_button = '<a href="javascript:ask_delete(' . $obj['id'] . ', \'' . $obj['obj_name'] . '\');" file-id="' . $obj['id'] . '" file-name="' . $obj['obj_name'] . '" class="file-delete"><i class="fa fa-times fa-lg fa-fw txt-color-red"></i> <u>D</u>elete</a>';
$icon_file = $obj['num_files'] > 1 ? 'fa-files-o' : ' fa-file-o';
$_files = $obj['num_files'] . ' <i class="fa ' . $icon_file . '"></i>';
$_link_edit = '<a href="' . site_url('objectmanager/edit/' . $obj['id']) . '">' . $obj['obj_name'] . '</a>';
$_private_icon = $obj['private'] == 1 ? 'fa-user' : 'fa-users';
$_private_title = $obj['private'] == 1 ? 'Private' : 'Public';
$_action_buttons = '<i rel="tooltip" data-placement="top" title="' . $_private_title . '" class="fa ' . $_private_icon . '"></i>';
$_action_buttons .= '<div class="btn-group display-inline pull-right text-align-left ">';
$_action_buttons .= '<button class="btn btn-xs btn-default dropdown-toggle" data-toggle="dropdown"><i class="fa fa-cog fa-lg"></i></button>';
$_action_buttons .= '<ul class="dropdown-menu dropdown-menu-xs pull-right">';
$_action_buttons .= '<li>' . $_edit_button . '</li>';
if ($_SESSION['user']['id'] == $obj['user']) {
$_action_buttons .= '<li>' . $_delete_button . '</li>';
}
$_action_buttons .= '<li class="divider"></li><li class="text-align-center"><a href="javascript:void(0);">Cancel</a></li>';
$_action_buttons .= '</ul>';
$_action_buttons .= '</div>';
$checkbox = '<label class="checkbox"><input type="checkbox" id="check_' . $obj['id'] . '" name="checkbox-inline"><i></i> </label>';
$_rows[] = array($checkbox, $_link_edit, $obj['obj_description'], mysql_to_human($obj['date_insert']), $_files, $_action_buttons);
}
header('Content-Type: application/json; charset=utf-8');
echo minify(json_encode(array('aaData' => $_rows)));
echo $_file->raw_name;
?>
</td>
<td class="hidden-xs"><?php
echo str_replace('.', '', $_file->file_ext);
?>
<?php
echo $_file->print_type != '' ? '(' . $_file->print_type . ')' : '';
?>
</td>
<td class="hidden-xs"><?php
echo $_file->note;
?>
</td>
<td class="hidden-xs"><?php
echo mysql_to_human($_file->insert_date);
?>
</td>
<td class="hidden-xs"><?php
echo roundsize($_file->file_size);
?>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
function recursion($user, $all_pages, $dpcs_data, $modify_style = 40)
{
foreach ($user as $child_key => $child_value) {
if ($modify_style == 40) {
unset($dpcs_data['new_class']);
$dpcs_data['new_class'] = '';
$style = '';
} else {
$style = 'style="display:none;"';
}
?>
<tr onclick="lockRowUsingCheckbox();lockRow();" class="pane <?php
echo $dpcs_data['css_class'];
?>
<?php
echo $child_value['class'];
?>
" <?php
echo $style;
?>
>
<td width="5%" align="left">
<input type="checkbox" name="tablechoice[]" value="<?php
echo $child_value['id'];
?>
" />
</td>
<td class="left" align="left" width="5%"><?php
echo $child_value['id'];
?>
</td>
<td class="left" align="left" width="15%"><?php
echo $all_pages[$child_value['page_parent_id']];
?>
</td>
<?php
if (isset($child_value['children']) && is_array($child_value['children'])) {
$modify_style_1 = round($modify_style / 2);
} else {
$modify_style_1 = $modify_style;
}
?>
<td class="left" align="left" width="20%" style="padding-left:<?php
echo $modify_style_1;
?>
px">
<?php
if (isset($child_value['children']) && is_array($child_value['children'])) {
?>
<img src="<?php
echo base_url();
?>
/images/backend/crm_add.gif" alt="<?php
echo $child_value['page_name'];
?>
" title="<?php
echo $child_value['page_name'];
?>
" style="position:relative;top:-4px;cursor:pointer;" id="<?php
echo $child_value['page_name'];
?>
_<?php
echo $child_value['id'];
?>
" onclick="dpcs_show_hide('<?php
echo $child_value['page_name'];
?>
_<?php
echo $child_value['id'];
?>
');"/>
<?php
}
echo $child_value['page_name'];
?>
</td>
<td class="left" align="left" width="5%"><?php
echo mysql_to_human($child_value['created'], 'Y-m-d');
?>
</td>
<td align="left" width="2%">
<?php
echo $child_value['rank'];
?>
</td>
<?php
if (isset($dpcs_data['page_rank_count'][$child_value['page_parent_id']])) {
$count_rows = $dpcs_data['page_rank_count'][$child_value['page_parent_id']];
} else {
$count_rows = 0;
}
?>
<td align="left" width="3%">
<img src="<?php
echo base_url();
?>
images/backend/save_file.jpg" onclick="change_rank_customized('<?php
echo $child_value['id'];
?>
','<?php
echo $child_value['rank'];
?>
','<?php
echo $count_rows;
?>
','<?php
echo $dpcs_data['form_name'];
?>
','<?php
echo site_url($dpcs_data['page_name'] . '/change_rank');
?>
','<?php
echo $child_value['page_parent_id'];
?>
');" style="cursor:pointer;" title="Click to Change Rank" alt="Click to Change Rank" />
</td>
<?php
if ($dpcs_data['session_user'] == '*****@*****.**') {
?>
<td align="center" valign="middle" width="4%"><label class="status_label"><?php
echo $child_value['hide_client'];
?>
</label>
<?php
if ($child_value['hide_client'] == 1) {
?>
<img src="<?php
echo base_url();
?>
images/backend/page_right.jpg" alt="Click here to make this record visible to client" title="Click here to make this record visible to client" border="0" width="18" height="18" class="cursor_pointer" onclick="change_hide_client('<?php
echo site_url($dpcs_data['page_name'] . '/inactive_hide_client/' . $child_value['id']);
?>
','0');"/>
<?php
} else {
?>
<img src="<?php
echo base_url();
?>
images/backend/page_wrong.jpg" alt="Click here to make this record hidden to client" title="Click here to make this record hidden to client" border="0" width="18" height="18" class="cursor_pointer" onclick="change_hide_client('<?php
echo site_url($dpcs_data['page_name'] . '/active_hide_client/' . $child_value['id']);
?>
','1');"/>
<?php
}
?>
</td><?php
}
?>
<td align="centre" width="4%"><label class="status_label"><?php
echo $child_value['menu_frontend'];
?>
</label>
<?php
if ($child_value['menu_frontend'] == 1) {
?>
<img src="<?php
echo base_url();
?>
images/backend/page_right.jpg" alt="Click here to hide footer" title="Click here to hide from Front End Menu" border="0" width="18" height="18" class="cursor_pointer" onclick="display_footer('<?php
echo site_url($dpcs_data['page_name'] . '/inactive_frontend_menu/' . $child_value['id']);
?>
','0');"/>
<?php
} else {
?>
<img src="<?php
echo base_url();
?>
images/backend/page_wrong.jpg" alt="Click here to display footer" title="Click here to Show on Front End Menu" border="0" width="18" height="18" class="cursor_pointer" onclick="display_footer('<?php
echo site_url($dpcs_data['page_name'] . '/active_frontend_menu/' . $child_value['id']);
?>
','1');"/>
<?php
}
?>
</td>
<td align="center" valign="middle" width="6%"><label class="status_label"><?php
echo $child_value['display_footer'];
?>
</label>
<?php
if ($child_value['display_footer'] == 1) {
?>
<img src="<?php
echo base_url();
?>
images/backend/page_right.jpg" alt="Click here to hide footer" title="Click here to hide footer" border="0" width="18" height="18" class="cursor_pointer" onclick="display_footer('<?php
echo site_url($dpcs_data['page_name'] . '/hide_footer/' . $child_value['id']);
?>
','0');"/>
<?php
} else {
?>
<img src="<?php
echo base_url();
?>
images/backend/page_wrong.jpg" alt="Click here to display footer" title="Click here to display footer" border="0" width="18" height="18" class="cursor_pointer" onclick="display_footer('<?php
echo site_url($dpcs_data['page_name'] . '/show_footer/' . $child_value['id']);
?>
','1');"/>
<?php
}
?>
</td>
<td align="left" width="4%"><label class="status_label"><?php
echo $child_value['status'];
?>
</label>
<?php
if ($child_value['status'] == 1) {
?>
<img src="<?php
echo base_url();
?>
images/backend/page_right.jpg" alt="Click here to make this record inactive" title="Click here to make this record inactive" border="0" width="18" height="18" class="cursor_pointer" onclick="change_active('<?php
echo site_url($dpcs_data['page_name'] . '/inactive/' . $child_value['id']);
?>
','0');"/>
<?php
} else {
?>
<img src="<?php
echo base_url();
?>
images/backend/page_wrong.jpg" alt="Click here to make this record active" title="Click here to make this record active" border="0" width="18" height="18" class="cursor_pointer" onclick="change_active('<?php
echo site_url($dpcs_data['page_name'] . '/active/' . $child_value['id']);
?>
','1');"/>
<?php
}
?>
</td>
<td align="right" width="10%">
<?php
if ($dpcs_data['session_user'] == '*****@*****.**') {
$edit_preview_indicator = 1;
} else {
if ($child_value['hide_client'] == 1) {
$edit_preview_indicator = 0;
} else {
$edit_preview_indicator = 1;
}
}
if ($edit_preview_indicator == 1) {
?>
<a href="<?php
echo site_url($dpcs_data['page_name'] . "/edit/" . $child_value['id']);
?>
" title="Edit record with id: <?php
echo $child_value['id'];
?>
">
<img src="<?php
echo base_url();
?>
images/backend/page_edit.jpg" title="Edit record with id: <?php
echo $child_value['id'];
?>
" alt="Edit record with id: <?php
echo $child_value['id'];
?>
" border="0" class="cursor_pointer" width="18" height="18" />
</a>
<img src="<?php
echo base_url();
?>
images/backend/page_delete.jpg" title="Delete record with id: <?php
echo $child_value['id'];
?>
" alt="Delete record with id: <?php
echo $child_value['id'];
?>
" border="0" onclick="javascript:confirm_delete('<?php
echo site_url($dpcs_data['page_name'] . '/delete/' . $child_value['id']);
?>
');" class="cursor_pointer" width="18" height="18" />
<?php
}
?>
<a target="_blank" href="<?php
echo site_url($child_value['page_name']);
?>
" title="Preview record with id: <?php
echo $child_value['id'];
?>
">
<img src="<?php
echo base_url();
?>
images/backend/page_preview.jpg" alt="Preview user with id: <?php
echo $child_value['id'];
?>
" title="Preview user with id: <?php
echo $child_value['id'];
?>
" border="0" class="cursor_pointer" width="18" height="18" />
</a>
<?php
if ($child_value['history_id'] != 0) {
?>
<a target="_blank" href="<?php
echo site_url($dpcs_data['page_name'] . "/history/" . $child_value['id']);
?>
" title="Preview history record with id: <?php
echo $child_value['id'];
?>
">
<img src="<?php
echo base_url();
?>
images/backend/history.jpg" alt="Preview history record with id: <?php
echo $child_value['id'];
?>
" title="Preview history record with id: <?php
echo $child_value['id'];
?>
" border="0" class="cursor_pointer" width="18" height="18" />
</a>
<?php
}
?>
</td>
</tr>
<?php
if (isset($child_value['children']) && is_array($child_value['children'])) {
//$dpcs_data['new_class'] .= ' '.$child_value['page_name'].'_'.$child_value['id'];
$dpcs_data['new_class'] = $child_value['page_name'] . '_' . $child_value['id'];
recursion($child_value['children'], $all_pages, $dpcs_data, $modify_style + 25);
}
}
}
