PHP getAll函数代码示例

 function add_row($id)
 {
     $data['id'] = $id;
     $data['barang'] = getAll('barang')->result_array();
     $data['satuan'] = getAll('satuan')->result_array();
     $this->load->view('penyesuaian/row', $data);
 }

 function update_component()
 {
     $comp = GetAllSelect('payroll_component', 'id')->result();
     foreach ($comp as $c) {
         $data = array('session_id' => $this->new_session, 'payroll_component_id' => $c->id);
         $filter = array('session_id' => 'where/' . $this->new_session, 'payroll_component_id' => 'where/' . $c->id);
         $num_rows = GetAllSelect('payroll_component_session', 'id', $filter)->num_rows();
         if ($num_rows > 0) {
             $this->db->where('session_id', $this->new_session)->where('payroll_component_id', $c->id)->update('payroll_component_session', $data);
         } else {
             $this->db->insert('payroll_component_session', $data);
         }
         $filter2 = array('session_id' => 'where/' . $this->old_session, 'payroll_component_id' => 'where/' . $c->id);
         $comp_sess_before = getValue('id', 'payroll_component_session', $filter2);
         print_ag($comp_sess_before);
         $comp_value = getAll('payroll_component_value', array('payroll_component_session_id' => 'where/' . $comp_sess_before))->row();
         print_ag($comp_value);
         $comp_sess_new = getValue('id', 'payroll_component_session', $filter);
         $num_rows_new = GetAllSelect('payroll_component_value', 'id', array('payroll_component_session_id' => 'where/' . $comp_sess_new))->num_rows();
         if (!empty($comp_value)) {
             $data2 = array('payroll_component_session_id' => $comp_sess_new, 'from' => $comp_value->from, 'to' => $comp_value->to, 'formula' => $comp_value->formula, 'is_condition' => $comp_value->is_condition, 'min' => $comp_value->min, 'max' => $comp_value->max, 'created_by' => sessId(), 'created_on' => dateNow());
             if ($num_rows_new > 0) {
                 $this->db->where('payroll_component_session_id', $comp_sess_new)->update('payroll_component_value', $data2);
             } else {
                 $this->db->insert('payroll_component_value', $data2);
             }
         }
         print_ag($this->db->last_query());
     }
 }

 function load_msg_header()
 {
     //CHAT
     $data['users'] = getAll('users', array('username' => 'order/asc'), array('!=id' => sessId()));
     $data['unread_all'] = GetAllSelect('chat', 'is_read', array('is_read' => 'where/0', 'receiver_id' => 'where/' . sessId()))->num_rows();
     $data['messages'] = getAll('chat', array('receiver_id' => 'where/' . sessId(), 'limit' => 'limit/3', 'id' => 'order/desc'))->result();
     $this->load->view('chat/header', $data);
 }

 function index()
 {
     $this->data['title'] = ucfirst($this->title);
     $this->data['page_title'] = $this->page_title;
     $this->data['period'] = getAll('payroll_period');
     permission();
     $this->_render_page($this->filename, $this->data);
 }

 function detail($id)
 {
     permissionUser();
     $notif = $this->data['notif'] = getAll($this->table_name, array('receiver_id' => 'where/' . sessId(), 'id' => 'where/' . $id))->row();
     $photo_link = getValue('photo', 'users', array('id' => 'where/' . $notif->sender_id));
     $photo_link = base_url() . 'uploads/' . $notif->sender_id . '/' . $photo_link;
     $file_headers = @get_headers($photo_link);
     $this->data['sender_photo'] = $file_headers[0] != 'HTTP/1.1 404 Not Found' ? $photo_link : assets_url('assets/images/no-image-mid.png');
     $this->load->view('notification/detail', $this->data);
 }

function artikel()
{
    $sql = "SELECT P.partnumber,P.description,P.unit,P.weight,t.rate,P.sellprice,P.listprice,P.priceupdate,";
    $sql .= "PG.partsgroup,P.notes,P.image,P.onhand,P.buchungsgruppen_id as bugru FROM ";
    $sql .= "chart c left join tax t on c.taxkey_id=t.taxkey, parts P left join partsgroup PG on ";
    $sql .= "PG.id=P.partsgroup_id left join buchungsgruppen B  on P.buchungsgruppen_id = B.id ";
    $sql .= "WHERE P.shop='t'  and c.id=B.income_accno_id_0";
    $rs = getAll("erp", $sql, "artikel");
    return $rs;
}

function get_all_url()
{
    //从数据库中查处所有已经有的数据，进行对比，如果有，则不插入
    $mysql_str = "SELECT cn_thinkphp_tuijian.title_url from cn_thinkphp_tuijian ORDER BY id ;";
    $res_datas = getAll($mysql_str);
    $arr_exit = array();
    foreach ($res_datas as $res_data) {
        $arr_exit[] = $res_data[0];
    }
    return $arr_exit;
}

 function index()
 {
     $this->data['title'] = ucfirst($this->title);
     $this->data['page_title'] = $this->page_title;
     $filter = array('is_deleted' => 'where/0', 'is_active' => 'where/1', 'component_type_id' => 'order/asc', 'code' => 'order/asc');
     $this->data['p_component'] = $list_component = getAll('payroll_component', $filter)->result_array();
     $filter = array('status_cd' => 'where/normal');
     $this->data['job_class'] = $this->all_model->GetAll('hris_job_class', $filter, 'job_class_level');
     //lastq();
     permission();
     $this->_render_page($this->filename, $this->data);
 }

 function get_dari_so($id)
 {
     permissionUser();
     $num_rows = getAll($this->table_name)->num_rows();
     $last_id = $num_rows > 0 ? $this->db->select('id')->order_by('id', 'asc')->get($this->table_name)->last_row()->id : 0;
     $this->data['last_id'] = $num_rows > 0 ? $last_id + 1 : 1;
     $order_id = getValue('ref', 'stok_pengeluaran', array('id' => 'where/' . $id));
     $so = $this->db->where('id', $order_id)->get('sales_order')->row()->so;
     $this->data['tgl_terima'] = getValue('tgl', 'stok_pengeluaran', array('id' => 'where/' . $id));
     $this->data['order'] = $this->main->get_detail_po($so);
     $this->data['order_list'] = getAll('stok_pengeluaran_list', array('pengeluaran_id' => 'where/' . $id));
     $this->load->view($this->module . '/' . $this->file_name . '/dari_so', $this->data);
 }

function getAllCats()
{
    $result = json_decode(getAll('category'));
    if (!empty($result->category)) {
        $result->category = array_map(function ($t) {
            if (!empty($t->icon)) {
                $t->icon_url = SITEURL . 'category_icons/' . $t->icon;
            }
            return $t;
        }, $result->category);
    }
    echo json_encode($result);
}

 function get_dari_po($id)
 {
     permissionUser();
     $num_rows = getAll($this->table_name)->num_rows();
     $last_id = $num_rows > 0 ? $this->db->select('id')->order_by('id', 'asc')->get($this->table_name)->last_row()->id : 0;
     $this->data['last_id'] = $num_rows > 0 ? $last_id + 1 : 1;
     $order_id = getValue('ref_id', 'stok_penerimaan', array('id' => 'where/' . $id));
     $this->data['tgl_terima'] = getValue('tgl', 'stok_penerimaan', array('ref_id' => 'where/' . $id));
     $this->data['order'] = $this->main->get_detail_po($id);
     $this->data['order_list'] = getAll('purchase_order_list', array('order_id' => 'where/' . $id));
     //print_mz($this->data['order_list']->result());
     $this->load->view($this->module . '/' . $this->file_name . '/dari_po', $this->data);
 }

 function input()
 {
     permissionUser();
     $num_rows = getAll('order')->num_rows();
     $last_id = $num_rows > 0 ? $this->db->select('id')->order_by('id', 'asc')->get('order')->last_row()->id : 0;
     $this->data['last_id'] = $num_rows > 0 ? $last_id + 1 : 1;
     $this->data['barang'] = getAll('barang')->result_array();
     $this->data['satuan'] = getAll('satuan')->result_array();
     $this->data['kurensi'] = getAll('kurensi')->result();
     $this->data['metode'] = getAll('metode_pembayaran')->result();
     $this->data['gudang'] = getAll('gudang')->result();
     $this->data['options_supplier'] = options_row($this->model_name, 'get_supplier', 'id', 'title', '-- Pilih Supplier --');
     $this->_render_page('transaksi/order/input', $this->data);
 }

 function input()
 {
     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');
         $this->get_bu();
         $this->data['all_users'] = getAll('users', array('active' => 'where/1', 'username' => 'order/asc'), array('!=id' => '1'));
         $this->get_user_atasan();
         $this->data['subordinate'] = getAll('users', array('superior_id' => 'where/' . get_nik($sess_id)));
         $this->_render_page('form_promosi/input', $this->data);
     }
 }

 function edit()
 {
     $session_id = $this->input->post('session_id');
     permission();
     $filter = array('session_id' => 'where/' . $session_id);
     $num_rows = getAll('payroll_umk', $filter)->num_rows();
     //lastq();
     $data = array('value' => str_replace(',', '', $this->input->post('value')), 'session_id' => $session_id);
     if ($num_rows > 0) {
         $this->db->where('session_id', $session_id)->update('payroll_umk', $data);
     } else {
         $this->db->insert('payroll_umk', $data);
     }
     return true;
 }

 function get_chart()
 {
     $tanggal = array();
     $num_data = array();
     for ($i = 7; $i > 0; $i--) {
         $d = new dateTime("{$i} days ago");
         $tanggal[] = $d->format('d M');
         $num_data_po[] = getAll('purchase_order', array('created_on' => 'where/' . $d->format('Y-m-d')))->num_rows();
         $num_data_so[] = getAll('sales_order', array('created_on' => 'where/' . $d->format('Y-m-d')))->num_rows();
         $num_data_penerimaan[] = getAll('stok_penerimaan', array('created_on' => 'where/' . $d->format('Y-m-d')))->num_rows();
         $num_data_pengeluaran[] = getAll('stok_pengeluaran', array('created_on' => 'where/' . $d->format('Y-m-d')))->num_rows();
         $num_data_pembelian[] = getAll('pembelian', array('created_on' => 'where/' . $d->format('Y-m-d')))->num_rows();
         $num_data_penjualan[] = getAll('penjualan', array('created_on' => 'where/' . $d->format('Y-m-d')))->num_rows();
     }
     echo json_encode(array('tanggal' => $tanggal, 'num_data_po' => $num_data_po, 'num_data_pembelian' => $num_data_pembelian, 'num_data_so' => $num_data_so, 'num_data_penjualan' => $num_data_penjualan, 'num_data_penerimaan' => $num_data_penerimaan, 'num_data_pengeluaran' => $num_data_pengeluaran));
 }