<?php
session_start();
include 'konek.php';

//paging
$page = isset($_POST['page']) ? intval($_POST['page']) : 1;
$rows = isset($_POST['rows']) ? intval($_POST['rows']) : 10;
//$itemid = isset($_POST['awal_insert']) ? mysql_real_escape_string($_POST['awal_insert']) : '';
//$productid = isset($_POST['akhir_insert']) ? mysql_real_escape_string($_POST['akhir_insert']) : '';
//perjanjian_tgl_awal like '$itemid%' and perjanjian_tgl_akhir like '$productid%' and
$offset = ($page-1)*$rows;
$result = array();
$bagian=$_SESSION['bagian'];
if($bagian!=68){
    $where="perjanjian.bagian_id=bagian.bagian_id  AND perjanjian.bagian_id='$bagian'";
    }else{
    $where="perjanjian.bagian_id=bagian.bagian_id";
}
$rs = mysql_query("select count(*) from perjanjian,bagian where perjanjian.bagian_id=bagian.bagian_id");
$row = mysql_fetch_row($rs);
$result["total"] = $row[0];

//query select tabel perjanjian,bagian,image
$qry="SELECT perjanjian.perjanjian_id,
                  perjanjian_code as codesurat_insert,
                  perjanjian_judul as judul_insert,
                  perjanjian_mitra as mitra_insert,
                  perjanjian_nomor_sk as nokuasa_insert,
                  perjanjian_range as waktu_insert,
                  perjanjian_tgl_awal as awal_insert,
                  perjanjian_tgl_akhir as akhir_insert,
                  perjanjian_keterangan as ket_insert,
                  perjanjian_tahun as tahunsurat,
                  perjanjian_nomor as nomersurat,
                  perjanjian_format_lengkap,
                  perjanjian_bagian as kodebagian,
                  bagian_nama,
                  datediff(perjanjian_tgl_akhir,current_date()) as selisih,
                  datediff(DATE_SUB(perjanjian_tgl_akhir, INTERVAL 60 DAY),current_date()) as selisih_kurang
                  from perjanjian,bagian  where $where GROUP BY perjanjian.perjanjian_id limit $offset,$rows";
$rs = mysql_query($qry);
    $items = array();
     //var_dump($qry);
        while($row=mysql_fetch_object($rs)){
            //  $row->ttd = date('d F Y', strtotime($row->ttd));
            //  $row->akh = date('d F Y', strtotime($row->akh));
                $perjanjian_tgl_akhir=$row->akhir_insert;
                if ($row->selisih<=0) {
                    $row->file='<center><img src=../image/merah.png /></center>';
                }elseif ($row->selisih>0) {
                                if ($row->selisih_kurang<=0) {
                                    $row->file='<center><img src=../image/kuning.png /></center>';
                                } else {
                                    $row->file='<center><img src=../image/ijau.png /></center>';
                                }

                }
                //$perjanjian_status_upload=$row->perjanjian_status_upload;
//              $rs=mysql_query("select perjanjian_id as perjanjian_status_upload from image group by perjanjian_id");
//              $row=mysql_num_rows($rs);
                            //if($row->perjanjian_status_upload>0){
//                  $row->perjanjian_status_upload='<center><img src="../image/centang.png"/></center>';
//              }else{
//                  $row->perjanjian_status_upload='<label style="background-color:#FBF9F9"></label>';
//                  }
                array_push($items, $row);
        }
$result["rows"] = $items;
echo json_encode($result);

    //  $qry2="select perjanjian_id as perjanjian_status_upload from image group by perjanjian_id";
//              $rs1=mysql_query($qry2);
//                  if($rowe=mysql_num_rows($rs1)>0){
//                  $rowe->perjanjian_status_upload='<center><img src="../image/centang.png"/></center>';
//              }else{
//                  $rowe->perjanjian_status_upload='<label style="background-color:#FBF9F9"></label>';
//                  }
?>