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; }