Service-individual

<?php
if (!defined('BASEPATH'))
    exit('No direct script access allowed');
class Service extends CI_Controller {

    public function __construct() {
        parent::__construct();
        $this->load->model('Mservice');
    }
    function index(){
        $data['title'] = 'Data Service Mobil';
        $data['content'] = 'v_service';
        // $data['datatables'] = $this->Mservice->service();
        $this->load->view('template',$data);
    }

    //fungsi untuk pencarian data.
     public function create()
     {
        // load model dan form helper
        $this->load->model('Mservice');
        $this->load->helper('form_helper');

        $data1 = array(
            'button' => 'Create',
            'action' => site_url('service/create_action'),
            'dd_pencarian' => $this->Mservice->dd_pencarian(),
            'model_selected' => $this->input->post('model') ? $this->input->post('model') : '$row->service', // untuk edit ganti '' menjadi data dari database misalnya $row->provinsi
    );

        $this->load->view('v_service', $data1);
    }


    function get_data_user_old()
    {
        $list = $this->Mservice->get_datatables();
        $data = array();
        $no = $_POST['start'];
        foreach ($list as $field) {
            $no++;
            $row = array();
            $row[] = $no;
            $row[] = $field->no_rangka;
            $row[] = $field->no_polisi;
            $row[] = $field->model;
            $row[] = $field->type;
            $row[] = $field->transmission;
            $row[] = $field->warna;
            $row[] = $field->tahun;
            $row[] = $field->km;
            $row[] = $field->customer;
            $row[] = $field->telephone;
            $row[] = $field->handphone;
            $row[] = $field->contact_person;
            $row[] = $field->telephone_cp;
            $row[] = $field->cabang_penjual;
            $row[] = $field->cabang_service;
            $row[] = $field->salesman;
            $row[] = $field->last_service;
            $row[] = $field->job;
            $row[] = $field->pekerjaan_utama;
            $row[] = $field->program_promo;
            $row[] = $field->status_aktif;
            $row[] = $field->hasil_fu1;
            $row[] = $field->hasil_fu2;
            $row[] = $field->hasil_fu3;
            $row[]="<button  type='button' class='btn btn-primary btn-xs' onclick=edit('".$field->no_rangka."')><i class='fa fa-edit'></i> Ubah</button>
                    <button  type='button' class='btn btn-warning btn-xs' onclick=del('".$field->no_rangka."')><i class='fa fa-trash'></i> Hapus</button>";

            // $row[] = '<td>
            // <button type="button" class="btn btn-primary btn-xs" onclick=edit("'.$row->no_rangka.'") ><i class="fa fa-edit"></i></button>&nbsp;
            // </td>';

            $data[] = $row;
        }

        $output = array(
            "draw" => $_POST['draw'],
            "recordsTotal" => $this->Mservice->count_all(),
            "recordsFiltered" => $this->Mservice->count_filtered(),
            "data" => $data,
        );
        //output dalam format JSON
        echo json_encode($output);
    }






    ///pisahkan saja datanya...



    //function untuk tambah data service, abaikan dahulu karena fokus ke edit data.
    function addService(){
        $add = array(
            'no_rangka' => $this->input->post('no_rangka'),
            'no_polisi' => $this->input->post('no_polisi'),
            'model' => $this->input->post('model'),
            'type' => $this->input->post('type'),
            'transmission' => $this->input->post('transmission'),
            'warna' => $this->input->post('warna'),
            'tahun' => $this->input->post('tahun'),
            'km' => $this->input->post('km'),
            'customer' => $this->input->post('customer'),
            'telephone' => $this->input->post('telephone'),
            'handphone' => $this->input->post('handphone'),
            'contact_person' => $this->input->post('contact_person'),
            'telephone_cp' => $this->input->post('telephone_cp'),
            'cabang_penjual' => $this->input->post('cabang_penjual'),
            'cabang_service' => $this->input->post('cabang_service'),
            'salesman' => $this->input->post('salesman'),
            'last_service' => $this->input->post('last_service'),
            'job' => $this->input->post('job'),
            'pekerjaan_utama' => $this->input->post('pekerjaan_utama'),
            'program_promo' => $this->input->post('program_promo'),
            'status_aktif' => $this->input->post('status_aktif'),
            'hasil_fu1' => $this->input->post('hasil_fu1'),
            'hasil_fu2' => $this->input->post('hasil_fu2'),
            'hasil_fu3' => $this->input->post('hasil_fu3'),

            //'model' => 0
        );
        $this->Mservice->addService($add);
    }
    //funsi edit data, data yang ada di dalam database.
    function editService($id){
        $flag  = array('no_rangka'=>$id);
        $get = $this->Mservice->getService($flag)->row();
        echo json_encode($get);
    }
    //fungsi
    function newService(){
        $flag  = array('no_rangka'=>$this->input->post('oid'));
        $edit = array(
            'no_rangka' => $this->input->post('nno_rangka'),
            'no_polisi' => $this->input->post('nno_polisi'),
            'model' => $this->input->post('nmodel'),
            'type' => $this->input->post('ntype'),
            'transmission' => $this->input->post('ntransmission'),
            'warna' => $this->input->post('nwarna'),
            'tahun' => $this->input->post('ntahun'),
            'km' => $this->input->post('nkm'),
            'customer' => $this->input->post('ncustomer'),
            'telephone' => $this->input->post('ntelephone'),
            'handphone' => $this->input->post('nhandphone'),
            'contact_person' => $this->input->post('ncontact_person'),
            'telephone_cp' => $this->input->post('ntelephone_cp'),
            'cabang_penjual' => $this->input->post('ncabang_penjual'),
            'cabang_service' => $this->input->post('ncabang_service'),
            'salesman' => $this->input->post('nsalesman'),
            'last_service' => $this->input->post('nlast_service'),
            'job' => $this->input->post('njob'),
            'pekerjaan_utama' => $this->input->post('npekerjaan_utama'),
            'program_promo' => $this->input->post('nprogram_promo'),
            'status_aktif' => $this->input->post('nstatus_aktif'),
            'hasil_fu1' => $this->input->post('nhasil_fu1'),
            'hasil_fu2' => $this->input->post('nhasil_fu2'),
            'hasil_fu3' => $this->input->post('nhasil_fu3')
        );
        $this->Mservice->editService($flag,$edit);
    }

    function deleteService($id){
        $flag  = array('no_rangka'=>$id);
        $this->Mservice->deleteService($flag);
    }

}