示例#1
0
    getPageN($page, $db);
}
if ($type == "hot") {
    getHot($db);
}
if ($type == "detail") {
    $id = $_GET['id'];
    getActivity($id, $db);
}
if ($type == "join") {
    $id = $_GET['id'];
    joinActivity($id, $db);
}
if ($type == "getjoin") {
    $id = $_GET['id'];
    getJoin($id, $db);
}
function getJoin($acid, $db)
{
    $searchsql = "Select * from user where userid in (Select userid from ActivityParticipation where activityid='{$acid}' order by createTime desc)";
    $result = $db->query($searchsql);
    $joinlist = '[';
    $count = 0;
    while ($row = $result->fetchArray(SQLITE3_ASSOC)) {
        $nickname = $row['nickname'];
        $userid = $row['userid'];
        $joinnode = array("userid" => $userid, "nickname" => $nickname);
        foreach ($joinnode as $key => $value) {
            $joinnode[$key] = urlencode($value);
        }
        if ($count > 0) {
示例#2
0
 public function print_slip($id, $period_id)
 {
     $this->data['employee_id'] = $id;
     //render employee detail
     $this->data['employee_detail'] = $this->payroll->get_employee_detail($id);
     //lastq();
     $this->data['monthly_income'] = $this->payroll->get_by_id($id, $period_id);
     $monthly_income_id = getValue('id', 'payroll_monthly_income', array('employee_id' => 'where/' . $id, 'payroll_period_id' => 'where/' . $period_id));
     $this->data['period'] = getValue('title', 'payroll_period', array('id' => 'where/' . $period_id));
     $table = 'payroll_monthly_income_component';
     $table_join = 'payroll_component';
     $condition = 'payroll_monthly_income_component.payroll_component_id = payroll_component.id';
     $select = "{$table}.value as value,{$table_join}.title as component,{$table_join}.component_type_id as type";
     $this->data['income'] = getJoin($table, $table_join, $condition, 'left', $select, array('payroll_monthly_income_id' => 'where/' . $monthly_income_id, 'component_type_id' => 'where/1'))->result();
     $this->data['deduction'] = getJoin($table, $table_join, $condition, 'left', $select, array('payroll_monthly_income_id' => 'where/' . $monthly_income_id, 'component_type_id' => 'where/2'))->result();
     //print_mz($this->data['component']);
     //UcapanSelamat
     $this->data['dob'] = getValue('birth_dttm', 'hris_persons', array('person_id' => 'where/' . $id));
     $this->data['family_dob'] = getAll('hris_employee_family', array('employee_id' => 'where/' . $id));
     $this->load->library('mpdf60/mpdf');
     $html = $this->load->view('payroll/monthly_income/payroll_slip', $this->data, true);
     $stylesheet = file_get_contents('assets/modules/css/payroll/mpdfstyletables.css');
     $mpdf = new mPDF();
     $mpdf = new mPDF('A4');
     $mpdf->WriteHTML($stylesheet, 1);
     // The parameter 1 tells that this is css/style only and no body/html/text
     $mpdf->WriteHTML($html, 2);
     $mpdf->Output('payroll_slip_' . $id . '.pdf', 'I');
 }
示例#3
0
 function detail_email_submit($id)
 {
     if (!$this->ion_auth->logged_in()) {
         //redirect them to the login page
         redirect('auth/login', 'refresh');
     } else {
         $sess_id = $this->data['sess_id'] = $this->session->userdata('user_id');
         $sess_nik = get_nik($sess_id);
         $data_result = $this->data['task_detail'] = $this->form_spd_luar_model->where('users_spd_luar.id', $id)->form_spd_luar($id)->result();
         $this->data['td_num_rows'] = $this->form_spd_luar_model->where('users_spd_luar.id', $id)->form_spd_luar($id)->num_rows();
         $this->data['tc_id'] = $task_receiver_id = getValue('task_receiver', 'users_spd_luar', array('id' => 'where/' . $id));
         $this->data['biaya_pjd'] = getJoin('users_spd_luar_biaya', 'pjd_biaya', 'users_spd_luar_biaya.pjd_biaya_id = pjd_biaya.id', 'left', 'users_spd_luar_biaya.*, pjd_biaya.title as jenis_biaya', array('user_spd_luar_id' => 'where/' . $id));
         return $this->load->view('form_spd_luar/spd_luar_email', $this->data, TRUE);
     }
 }
示例#4
0
 function getUserGroup($id)
 {
     //$group = getAll('users_groups', array('user_id'=>'where/'.$id))->result();
     $group = getJoin('users_groups', 'groups', 'users_groups.group_id = groups.id', 'left', 'groups.name as group_name, users_groups.*', array('users_groups.user_id' => 'where/' . $id), array('!=groups.id' => '2'));
     $groups = '';
     if (!empty($group)) {
         foreach ($group->result() as $key) {
             $groups = ucwords($key->group_name);
         }
         return $groups;
     }
 }
示例#5
0
 function do_approve($id)
 {
     if (!$this->ion_auth->logged_in()) {
         redirect('auth/login', 'refresh');
     } else {
         $user = getJoin('users', 'users_edit_approval', 'users.id = users_edit_approval.user_id', 'left', 'users.*,users_edit_approval.*', array('users_edit_approval.id' => 'where/' . $id))->row();
         $user_id = get_nik($this->session->userdata('user_id'));
         $date_now = date('Y-m-d');
         $data = array('is_app' => 1, 'app_status_id' => $this->input->post('app_status'), 'user_app' => $user_id, 'date_app' => $date_now, 'note' => $this->input->post('note'));
         $this->db->where('id', $id);
         $this->db->update('users_edit_approval', $data);
         $data_n = array('first_name_new' => !empty($user->first_name_new) ? $user->first_name_new : '', 'last_name_new' => !empty($user->last_name_new) ? $user->last_name_new : '', 'bod_new' => !empty($user->bod_new) ? $user->bod_new : '', 'marital_id_new' => $user->marital_id_new, 'phone_new' => !empty($user->phone_new) ? $user->phone_new : '', 'previous_email_new' => !empty($user->previous_email_new) ? $user->previous_email_new : '', 'bb_pin_new' => !empty($user->bb_pin_new) ? $user->bb_pin_new : '');
         $approval_status = $this->input->post('app_status');
         $this->approval->approve('edit_user', $id, $approval_status, '');
         if ($approval_status == 1) {
             print_mz($this->update_employeetable($user->user_id, $data_n));
         }
     }
 }
示例#6
0
<?php

include_once '../../config/config.php';
include_once $serverPath . 'utils/db/db_get.php';
$table = "villain";
if (!empty($_GET["id"])) {
    $joinOn = ["npc_id" => "id"];
    $t1_constraints = ["id" => $_GET["id"]];
    $t2_constraints = [];
    $query = getJoin("villain", "npc", $joinOn, $t1_constraints, $t2_constraints);
    print json_encode(runQuery($query)[0]);
} else {
    if (!empty($_GET['column'])) {
        $column = $_GET['column'];
        if ($column == "stats") {
            $query = " SELECT villain.id, villain.method_type, villain.scheme_type, villain.weakness_type, npc.first_name,\n\t\t\t\t\t\tnpc.last_name FROM `villain` INNER JOIN `npc` ON villain.npc_id = npc.id;";
            print json_encode(runQuery($query));
        } else {
            if ($column == "ids") {
                $query = "SELECT npc_id AS id FROM `villain`;";
                $results = runQuery($query);
                $ids = [];
                foreach ($results as $result) {
                    array_push($ids, $result['id']);
                }
                print json_encode($ids);
            }
        }
    }
}