function _gets($args = array())
{
$return = array();
$default_args = array('Name' => '', 'GroupID' => -1, 'exclude' => array(), 'conditions' => '', 'orderby' => $this->field_id, 'order' => 'DESC', 'number' => 10, 'offset' => 0);
$list_args = sync_default_params($default_args, $args);
$query = 'SELECT ' . $this->table_name . '.*';
$query .= ', ' . $this->table_grup . '.Name as GroupName';
$query .= ' FROM ' . $this->table_name;
$query .= ' LEFT JOIN ' . $this->table_grup . ' ON ' . $this->table_grup . '.ID = ' . $this->table_name . '.GroupID';
$query .= ' WHERE 1';
if (!empty($list_args['Name'])) {
$query .= ' AND ';
$post_title_arr = explode(' ', $list_args['Name']);
foreach ($post_title_arr as $key => $title) {
$query .= ($key > 0 ? ' OR' : '') . ' ' . $this->table_name . '.`Name` LIKE "%' . $title . '%"';
}
}
if ($list_args['GroupID'] >= 0) {
$query .= ' AND GroupID = "' . $list_args['GroupID'] . '"';
}
/**
* exclude
*/
if (!empty($list_args['exclude'])) {
foreach ($list_args['exclude'] as $ex) {
$query .= ' AND `kode` <> ' . $ex;
}
}
/**
* untuk custom query pada conditions
*/
if (!empty($list_args['conditions'])) {
foreach ($list_args['conditions'] as $conditions) {
$query .= ' AND ' . $list_args . '.' . $conditions['field'] . ' ' . $conditions['operator'] . ' ' . $conditions['comparison'];
}
}
$this->count_query = $query;
/**
* orderby dan jenis order
*/
$query .= ' ORDER BY `' . $list_args['orderby'] . '` ' . $list_args['order'];
/**
* limit
*/
if ($list_args['number'] >= 0) {
$query .= ' LIMIT ' . $list_args['offset'] . ', ' . $list_args['number'];
}
$resource = mysql_query($query);
//echo $query . ' : ' . mysql_error();
while ($row = mysql_fetch_object($resource, $this->class_name)) {
$return[] = $row;
}
return $return;
}
$obj_people = Sessions::get_instance()->_retrieve()->getObjPeople();
$this_day = date('Y-m-d');
$obj_absen = Absents::get_instance()->_get($this_day, $obj_people->getId());
!is_null($obj_absen->getStatus()) || $obj_absen->setStatus(Absents::status_tidak_masuk);
if ($is_absen_mulai) {
$obj_absen->setDate($this_day)->setPeopleId($obj_people->getId())->setWorktimeStart(date('H:i:s'))->setStatus(Absents::status_masuk);
lrs_redirect(LRS_URI_PATH . DS . $tingkat1 . DS . $tingkat2 . '?status=' . (Absents::get_instance()->_update($obj_absen) ? 1 : 999));
} elseif ($is_absen_berhenti) {
$obj_absen->setWorktimeEnd(date('H:i:s'))->setStatus(Absents::status_selesai);
lrs_redirect(LRS_URI_PATH . DS . $tingkat1 . DS . $tingkat2 . '?status=' . (Absents::get_instance()->_update($obj_absen) ? 2 : 999));
} elseif ($is_absen_berhenti_sebelum_waktunya) {
$obj_absen->setWorktimeEnd(date('H:i:s'))->setStatus(Absents::status_izin_pulang)->setNote($_REQUEST['note']);
lrs_redirect(LRS_URI_PATH . DS . $tingkat1 . DS . $tingkat2 . '?status=' . (Absents::get_instance()->_update($obj_absen) ? 3 : 999));
}
$default_params = array('range_date_start' => '', 'range_date_end' => '', 'number' => 10, 'page' => 1);
$list_params = sync_default_params($default_params, $_GET);
$hari_libur = json_decode(Options::get_instance()->get_option('hari_libur', array()), true);
Headers::get_instance()->set_page_title('Absen')->set_page_name('Absen')->set_page_sub_name($is_absen_histori ? 'Histori' : 'Absen');
Contents::get_instance()->get_header();
?>
<div class="container-fluid">
<div class="row">
<div class="col-xs-3 col-sm-2 sidebar">
<?php
Contents::get_instance()->get_sidebar();
?>
</div>
<div class="col-xs-9 col-sm-10 main">
<?php
function _gets($args = array())
{
$return = array();
$default_args = array('Text' => '', 'exclude' => array(), 'conditions' => '', 'orderby' => $this->field_id, 'order' => 'DESC', 'number' => 10, 'offset' => 0);
$list_args = sync_default_params($default_args, $args);
$query = 'SELECT ' . $this->table_name . '.*';
$query .= ', ' . $this->table_pbk . '.Name as ContactName';
$query .= ' FROM ' . $this->table_name;
$query .= ' LEFT JOIN ' . $this->table_pbk . ' ON ' . $this->table_pbk . '.Number = REPLACE(' . $this->table_name . '.DestinationNumber, "+", "")';
$query .= ' WHERE 1';
if (!empty($list_args['Text'])) {
$query .= ' AND ';
$post_title_arr = explode(' ', $list_args['Text']);
foreach ($post_title_arr as $key => $title) {
$query .= ($key > 0 ? ' OR' : '') . '`Text` LIKE "%' . $title . '%"';
}
}
/**
* exclude
*/
if (!empty($list_args['exclude'])) {
foreach ($list_args['exclude'] as $ex) {
$query .= ' AND `kode` <> ' . $ex;
}
}
/**
* untuk custom query pada conditions
*/
if (!empty($list_args['conditions'])) {
foreach ($list_args['conditions'] as $conditions) {
$query .= ' AND ' . $list_args . '.' . $conditions['field'] . ' ' . $conditions['operator'] . ' ' . $conditions['comparison'];
}
}
$this->count_query = $query;
/**
* orderby dan jenis order
*/
$query .= ' ORDER BY `' . $list_args['orderby'] . '` ' . $list_args['order'];
/**
* limit
*/
if ($list_args['number'] >= 0) {
$query .= ' LIMIT ' . $list_args['offset'] . ', ' . $list_args['number'];
}
$resource = mysql_query($query);
//echo $query . ' : ' . mysql_error();
/** @var PesanTerkirim $row */
while ($row = mysql_fetch_object($resource, $this->class_name)) {
if ($row->hasUDH()) {
$return[$row->getUDH()] = $row;
} else {
$return[] = $row;
}
}
/** @var $pesan PesanTerkirim */
foreach ($return as $UDH => $pesan) {
if ($pesan->hasUDH()) {
$udh = new UDH($UDH);
if ($udh->getPart(true) == 1) {
for ($i = 2; $i <= $udh->getCount(true); $i++) {
$tmp = $udh->setPart($i, true)->_get_build();
$pesan->addParts($return[$tmp]);
unset($return[$tmp]);
}
}
}
}
return $return;
}
function _gets($args = array())
{
$return = array();
$default_args = array('range_date_start' => '', 'range_date_end' => '', 'people_id' => -1, 'status' => -1, 'note' => '', 'exclude' => array(), 'conditions' => '', 'orderby' => $this->field_id, 'order' => 'DESC', 'number' => 10, 'offset' => 0);
$list_args = sync_default_params($default_args, $args);
$query = 'SELECT *';
$query .= ', ' . $this->table_name . '.status AS status_kerja';
$query .= ' FROM ' . $this->table_name;
$query .= ' LEFT JOIN ' . $this->table_people . ' ON ' . $this->table_name . '.people_id = ' . $this->table_people . '.id';
$query .= ' WHERE 1';
/**
* range date start and end
*/
if (!empty($list_args['range_date_start'])) {
$query .= ' AND transfer_date >= "' . $list_args['range_date_start'] . '"';
}
if (!empty($list_args['range_date_end'])) {
$query .= ' AND transfer_date <= "' . $list_args['range_date_end'] . '"';
}
/**
* people
*/
if ($list_args['people_id'] >= 0) {
$query .= ' AND people_id = "' . $list_args['people_id'] . '"';
}
/**
* status
*/
if ($list_args['status'] >= 0) {
$query .= ' AND status = "' . $list_args['status'] . '"';
}
/**
* note
*/
if (!empty($list_args['note'])) {
$query .= ' AND ';
$name_arr = explode(' ', $list_args['note']);
foreach ($name_arr as $key => $name) {
$query .= ($key > 0 ? ' OR' : '') . $this->table_name . '.`note` LIKE "%' . $name . '%"';
}
}
/**
* exclude
*/
if (!empty($list_args['exclude'])) {
foreach ($list_args['exclude'] as $ex) {
$query .= ' AND `' . $this->field_id . '` <> ' . $ex;
}
}
/**
* untuk custom query pada conditions
*/
if (!empty($list_args['conditions'])) {
foreach ($list_args['conditions'] as $conditions) {
$query .= ' AND ' . $conditions['field'] . ' ' . $conditions['operator'] . ' ' . $conditions['comparison'];
}
}
$this->count_query = $query;
/**
* orderby dan jenis order
*/
$query .= ' ORDER BY `' . $list_args['orderby'] . '` ' . $list_args['order'];
/**
* limit
*/
if ($list_args['number'] >= 0) {
$query .= ' LIMIT ' . $list_args['offset'] . ', ' . $list_args['number'];
}
$resource = mysql_query($query);
//echo $query . ' : ' . mysql_error();
while ($row = mysql_fetch_object($resource, $this->class_name)) {
$return[] = $row;
}
return $return;
}
function _gets($args = array())
{
$return = array();
$default_args = array('full_name' => '', 'username' => '', 'status' => -1, 'exclude' => array(), 'conditions' => '', 'orderby' => $this->field_id, 'order' => 'DESC', 'number' => 10, 'offset' => 0);
$list_args = sync_default_params($default_args, $args);
$query = 'SELECT * FROM ' . $this->table_name . ' WHERE 1';
/**
* full name
*/
if (!empty($list_args['full_name'])) {
$query .= ' AND ( ';
$name_arr = explode(' ', $list_args['full_name']);
foreach ($name_arr as $key => $name) {
$query .= ($key > 0 ? ' OR' : '') . $this->table_name . '.`first_name` LIKE "%' . $name . '%"';
}
$query .= ' OR ';
foreach ($name_arr as $key => $name) {
$query .= ($key > 0 ? ' OR' : '') . $this->table_name . '.`last_name` LIKE "%' . $name . '%"';
}
$query .= ' )';
}
/**
* username
*/
if (!empty($list_args['username'])) {
$query .= ' AND username = "******"';
}
/**
* status
*/
if ($list_args['status'] >= 0) {
$query .= ' AND status = "' . $list_args['status'] . '"';
}
/**
* exclude
*/
if (!empty($list_args['exclude'])) {
foreach ($list_args['exclude'] as $ex) {
$query .= ' AND `' . $this->field_id . '` <> ' . $ex;
}
}
/**
* untuk custom query pada conditions
*/
if (!empty($list_args['conditions'])) {
foreach ($list_args['conditions'] as $conditions) {
$query .= ' AND ' . $conditions['field'] . ' ' . $conditions['operator'] . ' ' . $conditions['comparison'];
}
}
$this->count_query = $query;
/**
* orderby dan jenis order
*/
$query .= ' ORDER BY `' . $list_args['orderby'] . '` ' . $list_args['order'];
/**
* limit
*/
if ($list_args['number'] >= 0) {
$query .= ' LIMIT ' . $list_args['offset'] . ', ' . $list_args['number'];
}
$resource = mysql_query($query);
//echo $query . ' : ' . mysql_error();
while ($row = mysql_fetch_object($resource, $this->class_name)) {
$return[] = $row;
}
return $return;
}
function _gets($args = array())
{
$return = array();
$default_args = array('Text' => '', 'exclude' => array(), 'conditions' => '', 'orderby' => $this->field_id, 'order' => 'DESC', 'number' => 10, 'offset' => 0);
$list_args = sync_default_params($default_args, $args);
$query = 'SELECT ' . $this->table_name . '.*';
$query .= ', ' . $this->table_pbk . '.Name as ContactName';
$query .= ' FROM ' . $this->table_name;
$query .= ' LEFT JOIN ' . $this->table_pbk . ' ON ' . $this->table_pbk . '.Number = REPLACE(' . $this->table_name . '.DestinationNumber, "+", "")';
$query .= ' WHERE 1';
if (!empty($list_args['Text'])) {
$query .= ' AND ';
$post_title_arr = explode(' ', $list_args['Text']);
foreach ($post_title_arr as $key => $title) {
$query .= ($key > 0 ? ' OR' : '') . '`Text` LIKE "%' . $title . '%"';
}
}
/**
* exclude
*/
if (!empty($list_args['exclude'])) {
foreach ($list_args['exclude'] as $ex) {
$query .= ' AND `kode` <> ' . $ex;
}
}
/**
* untuk custom query pada conditions
*/
if (!empty($list_args['conditions'])) {
foreach ($list_args['conditions'] as $conditions) {
$query .= ' AND ' . $list_args . '.' . $conditions['field'] . ' ' . $conditions['operator'] . ' ' . $conditions['comparison'];
}
}
$this->count_query = $query;
/**
* orderby dan jenis order
*/
$query .= ' ORDER BY `' . $list_args['orderby'] . '` ' . $list_args['order'];
/**
* limit
*/
if ($list_args['number'] >= 0) {
$query .= ' LIMIT ' . $list_args['offset'] . ', ' . $list_args['number'];
}
$resource = mysql_query($query);
//echo $query . ' : ' . mysql_error();
while ($row = mysql_fetch_object($resource, $this->class_name)) {
$return[] = $row;
}
/** @var $pesan PesanKeluar */
foreach ($return as $UDH => $pesan) {
if ($pesan->isMultiPart()) {
$parts = $this->_gets_part($pesan->getID());
/** @var $part PesanKeluarBagian */
foreach ($parts as $part) {
$pesan->appendTextDecoded($part->getTextDecoded());
}
}
}
return $return;
}
