_model

<?php
if($action == 'import') {
    if(!isset($_FILES['excel']['name']) || $_FILES['excel']['name']=='') {
        echo "Anda belum memilih file.";
    } else {
        $file = $_FILES['excel']['name'];
        $temp = $_FILES['excel']['tmp_name'];

        $ext = explode('.',$file);
        $ext = end($ext);

        if($ext<>'xls') {
            echo "Gunakan file Ms. Excel 93-2007 Workbook (.xls)";
        } else {
            $data = new Spreadsheet_Excel_Reader($temp);
            $hasildata = $data->rowcount($sheet_index=0);
            $sukses = $gagal = 0;
            $log = '';

            for ($i=2; $i<=$hasildata; $i++) {
                if($data->val($i,1) != '') {

                    {
                        $importdata = array(
                                ':npp' =>  $data->val($i,2),
                                ':field1' => $data->val($i,3),
                                ':field2' => $data->val($i,4),
                                ':field3' => $data->val($i,5),
                                ':field4' => $data->val($i,6),
                                ':field5' => $data->val($i,7),
                                ':field6' => $data->val($i,8),
                                ':field7' => $data->val($i,9),
                                ':field8' => $data->val($i,10),
                                ':field9' => $data->val($i,11),
                                ':field10' => $data->val($i,12),
                                ':field11' => $data->val($i,13),
                                ':field12' => $data->val($i,14),
                                ':field13' => $data->val($i,15),
                                ':field14' => $data->val($i,16),
                                ':field15' => $data->val($i,17),
                                ':field16' => $data->val($i,18),
                                ':field17' => $data->val($i,19),
                                ':field18' => $data->val($i,20),
                                ':field19' => $data->val($i,21),
                                ':field20' => $data->val($i,22),
                                ':field21' => $data->val($i,23),
                                ':field22' => $data->val($i,24),
                                ':field23' => $data->val($i,25),
                                ':field24' => $data->val($i,26),
                                ':field25' => $data->val($i,27),
                                ':field26' => $data->val($i,28),
                                ':field27' => $data->val($i,29),
                                ':field28' => $data->val($i,30),
                                ':field29' => $data->val($i,31),
                                ':field30' => $data->val($i,32),
                                ':field31' => $data->val($i,33),
                                ':job' => $data->val($i,34),
                                ':bulan_jadwal' => $data->val($i,35),
                                ':kode_outlet' => $data->val($i,36)
                            );
                            $sql->insertUPLOAD('tb_jadwal', $importdata);

                            if($sql->response() == 1) {
                                $sukses++;
                            } else {
                                $gagal++;
                                $log .= "[$npp] ".$sql->response();
                            }
                        }
                    }
                }

                $log = "Sukses: $sukses | Gagal: $gagal \n\n".$log;

                file_put_contents($global['page_directory'].'/'.$page.'/src/import.log', $log);
                echo 1;
            }
        }
    }
    elseif($action == 'tambah') {
        $data = array(
            ':npp' => $_POST['npp'],
            ':field1' => $_POST['field1'],
            ':field2' => $_POST['field2'],
            ':field3' => $_POST['field3'],
            ':field4' => $_POST['field4'],
            ':field5' => $_POST['field5'],
            ':field6' => $_POST['field6'],
            ':field7' => $_POST['field7'],
            ':field8' => $_POST['field8'],
            ':field9' => $_POST['field9'],
            ':field10' => $_POST['field10'],
            ':field11' => $_POST['field11'],
            ':field12' => $_POST['field12'],
            ':field13' => $_POST['field13'],
            ':field14' => $_POST['field14'],
            ':field15' => $_POST['field15'],
            ':field16' => $_POST['field16'],
            ':field17' => $_POST['field17'],
            ':field18' => $_POST['field18'],
            ':field19' => $_POST['field19'],
            ':field20' => $_POST['field20'],
            ':field21' => $_POST['field21'],
            ':field22' => $_POST['field22'],
            ':field23' => $_POST['field23'],
            ':field24' => $_POST['field24'],
            ':field25' => $_POST['field25'],
            ':field26' => $_POST['field26'],
            ':field27' => $_POST['field27'],
            ':field28' => $_POST['field28'],
            ':field29' => $_POST['field29'],
            ':field30' => $_POST['field30'],
            ':field31' => $_POST['field31'],
            ':job' => $_POST['job'],
            ':bulan_jadwal' => $_POST['bulan_jadwal'],
            ':kode_outlet' => $_POST['kode_outlet']


        );
        $sql->insert('tb_jadwal',$data);
        echo $sql->response();
    }
    elseif($action == 'edit') {
        $id = $uri[3];
        $data = array(
            ':npp' => $_POST['npp'],
            ':field1' => $_POST['field1'],
            ':field2' => $_POST['field2'],
            ':field3' => $_POST['field3'],
            ':field4' => $_POST['field4'],
            ':field5' => $_POST['field5'],
            ':field6' => $_POST['field6'],
            ':field7' => $_POST['field7'],
            ':field8' => $_POST['field8'],
            ':field9' => $_POST['field9'],
            ':field10' => $_POST['field10'],
            ':field11' => $_POST['field11'],
            ':field12' => $_POST['field12'],
            ':field13' => $_POST['field13'],
            ':field14' => $_POST['field14'],
            ':field15' => $_POST['field15'],
            ':field16' => $_POST['field16'],
            ':field17' => $_POST['field17'],
            ':field18' => $_POST['field18'],
            ':field19' => $_POST['field19'],
            ':field20' => $_POST['field20'],
            ':field21' => $_POST['field21'],
            ':field22' => $_POST['field22'],
            ':field23' => $_POST['field23'],
            ':field24' => $_POST['field24'],
            ':field25' => $_POST['field25'],
            ':field26' => $_POST['field26'],
            ':field27' => $_POST['field27'],
            ':field28' => $_POST['field28'],
            ':field29' => $_POST['field29'],
            ':field30' => $_POST['field30'],
            ':field31' => $_POST['field31'],
            ':job' => $_POST['job'],
            ':bulan_jadwal' => $_POST['bulan_jadwal'],
            ':kode_outlet' => $_POST['kode_outlet']
        );
        $sql->update('tb_jadwal',$data,array(':id_jadwal'=>$id));
        echo $sql->response();
    }
    elseif($action == 'hapus') {
        $id = $uri[3];
        $sql->delete('tb_jadwal',array(':id_jadwal'=>$id));
        echo $sql->response();
    }
    else {
        print_r($_POST);
    }
?>