Postingan lainnya
blank page tanpa pesan error Codeigniter fpdf
master kenapa halaman ini tiidak bisa tampil hanya mncul blank page kemarin2 masih bisa
<?php
class PDF extends FPDF {
var $cust;
var $tgl;
var $tgl1;
var $tgl2;
var $tgl3;
function Header() {
$this->SetFont('Arial','B',11);
$this->SetFillColor(255,255,255);
$this->SetTextColor(80,80,80);
$this->Image(base_url() . "asset/images/logo_pasaco.jpg", 0.5,0.5);
$this->setXY(2.3,0.7);
$this->Cell('16','0.5',"SCHEDULE DELIVERY",'','0','L',1);
$this->Cell('','0.5',"PPIC DEPT.",'','0','L',1);
$this->ln(0.7);
$this->SetFont('Arial','B',8);
$this->setXY(2.3,1.2);
$this->Cell('2','0.5',"CUSTOMER",'','0','L',1);
$this->Cell('0.5','0.5',":",'','0','L',1);
$this->Cell('1.5','0.5',$this->cust,'','0','L',1);
$this->Cell('9.5','0.5',"",'','0','L',1);
$this->Cell('2.5','0.5',"DELIVERY DATE",'','0','L',1);
$this->Cell('0.5','0.5',":",'','0','L',1);
$this->Cell('1.5','0.5',$this->tgl,'','0','L',1);
$this->ln(0.5);
$this->setXY(0.5,2);
$this->SetFont('Arial','B',7);
$this->Cell('0.5','0.5',"No",'LTR','0','C',1);
$this->Cell('2.1','0.5',"No PART",'LTR','0','C',1);
$this->Cell('4','0.5',"NAMA PART",'LTR','0','C',1);
$this->Cell('0.9','0.5',"STOCK",'LTR','0','C',1);
$this->Cell('1.8','0.5',"PENDING SCH",'LTR','0','C',1);
$this->Cell('4','0.5',"SCHEDULE DELIVERY",'LTRB','0','C',1);
$this->Cell('0.7','0.5',"No.",'LTR','0','C',1);
$this->Cell('4.5','0.5',"DELIVERY",'LTRB','0','C',1);
$this->Cell('1','0.5',"STOCK",'LTR','0','C',1);
$this->Cell('0.7','0.5',"QTY/",'LTR','0','C',1);
$this->ln(0.5);
$this->setX(0.5);
$this->Cell('0.5','0.5',"",'LRB','0','C',1);
$this->Cell('2.1','0.5',"",'LRB','0','C',1);
$this->Cell('4','0.5',"",'LRB','0','C',1);
$this->Cell('0.9','0.5',"AWAL",'LRB','0','C',1);
$this->Cell('1','0.5',"QTY",'LTRB','0','C',1);
$this->Cell('0.8','0.5',"SAT",'LTRB','0','C',1);
$this->Cell('1','0.5',date("d-M",strtotime($this->tgl)),'LTRB','0','C',1);
$this->Cell('1','0.5',date("d-M",strtotime($this->tgl1)),'LTRB','0','C',1);
$this->Cell('1','0.5',date("d-M",strtotime($this->tgl2)),'LTRB','0','C',1);
$this->Cell('1','0.5',date("d-M",strtotime($this->tgl3)),'LTRB','0','C',1);
$this->Cell('0.7','0.5',"Palet",'LRB','0','C',1);
$this->Cell('1.5','0.5',"1",'LTRB','0','L',1);
$this->Cell('1.5','0.5',"2",'LTRB','0','L',1);
$this->Cell('1.5','0.5',"3",'LTRB','0','L',1);
$this->Cell('1','0.5',"AKHIR",'LRB','0','C',1);
$this->Cell('0.7','0.5',"BOX",'LRB','0','C',1);
$this->ln(0.5);
} //end function header
function Footer() {
$this->SetXY(0.5,-1.5);
$this->SetFont('Arial','I',8);
$this->Cell(10,0.5,date("d-M-Y h:i:s a"),'','0','L',1);
//$this->Cell(9.8,1,'Page '.$this->PageNo().' of {nb}',0,0,'R');
$this->ln(0.5);
$this->setX(0.5);
$this->setfont("Arial",'I',8);
$this->cell(8,0.5,"Rev00/issued 250515_rev. Date:__",'','0','L',1);
$this->Cell(8,0.5,'Page '.$this->PageNo().' of {nb}','','0','L',1);
$this->cell(4.8,0.5,"PSC_FM_PPC_027",'','0','L',1);
} //end function footer
} //end function
$tgl1=date('Y-m-d',strtotime($tgl.'+1 day'));
$tgl2=date('Y-m-d',strtotime($tgl.'+2 day'));
$tgl3=date('Y-m-d',strtotime($tgl.'+3 day'));
$pdf = new PDF('P','cm','A4');
$pdf->AliasNbPages();
$pdf->SetTitle('Schedule Delivery');
$pdf->Open();
$pdf->AddPage();
$pdf->SetFont('Arial','B',11);
$pdf->SetFillColor(255,255,255);
$pdf->SetTextColor(80,80,80);
$pdf->Image(base_url() . "asset/images/logo_pasaco.jpg", 0.5,0.5);
$pdf->setXY(2.3,0.7);
$pdf->Cell('16','0.5',"SCHEDULE DELIVERY",'','0','L',1);
$pdf->Cell('','0.5',"PPIC DEPT.",'','0','L',1);
$pdf->ln(0.7);
$pdf->SetFont('Arial','B',8);
$pdf->setXY(2.3,1.2);
$pdf->Cell('2','0.5',"CUSTOMER",'','0','L',1);
$pdf->Cell('0.5','0.5',":",'','0','L',1);
$pdf->Cell('1.5','0.5',"$cust",'','0','L',1);
$pdf->Cell('9.5','0.5',"",'','0','L',1);
$pdf->Cell('2.5','0.5',"DELIVERY DATE",'','0','L',1);
$pdf->Cell('0.5','0.5',":",'','0','L',1);
$pdf->Cell('1.5','0.5',$tgl,'','0','L',1);
$pdf->ln(0.5);
$pdf->setXY(0.5,2);
$pdf->SetFont('Arial','B',7);
$pdf->Cell('0.5','0.5',"No",'LTR','0','C',1);
$pdf->Cell('2.1','0.5',"No PART",'LTR','0','C',1);
$pdf->Cell('4','0.5',"NAMA PART",'LTR','0','C',1);
$pdf->Cell('0.9','0.5',"STOCK",'LTR','0','C',1);
$pdf->Cell('1.8','0.5',"PENDING SCH",'LTR','0','C',1);
$pdf->Cell('4','0.5',"SCHEDULE DELIVERY",'LTRB','0','C',1);
$pdf->Cell('0.7','0.5',"No.",'LTR','0','C',1);
$pdf->Cell('4.5','0.5',"DELIVERY",'LTRB','0','C',1);
$pdf->Cell('1','0.5',"STOCK",'LTR','0','C',1);
$pdf->Cell('0.7','0.5',"QTY/",'LTR','0','C',1);
$pdf->ln(0.5);
$pdf->setX(0.5);
$pdf->Cell('0.5','0.5',"",'LRB','0','C',1);
$pdf->Cell('2.1','0.5',"",'LRB','0','C',1);
$pdf->Cell('4','0.5',"",'LRB','0','C',1);
$pdf->Cell('0.9','0.5',"AWAL",'LRB','0','C',1);
$pdf->Cell('1','0.5',"QTY",'LTRB','0','C',1);
$pdf->Cell('0.8','0.5',"SAT",'LTRB','0','C',1);
$pdf->Cell('1','0.5',date("d-M",strtotime($tgl)),'LTRB','0','C',1);
$pdf->Cell('1','0.5',date("d-M",strtotime($tgl1)),'LTRB','0','C',1);
$pdf->Cell('1','0.5',date("d-M",strtotime($tgl2)),'LTRB','0','C',1);
$pdf->Cell('1','0.5',date("d-M",strtotime($tgl3)),'LTRB','0','C',1);
$pdf->Cell('0.7','0.5',"Palet",'LRB','0','C',1);
$pdf->Cell('1.5','0.5',"1",'LTRB','0','L',1);
$pdf->Cell('1.5','0.5',"2",'LTRB','0','L',1);
$pdf->Cell('1.5','0.5',"3",'LTRB','0','L',1);
$pdf->Cell('1','0.5',"AKHIR",'LRB','0','C',1);
$pdf->Cell('0.7','0.5',"BOX",'LRB','0','C',1);
$this->db->select('a.idpart,a.idcust,a.partname,a.partno,a.jenis,a.satcust,a.qtybox,b.ids,b.id,b.sched,sum(b.qtyscpend)totalqtyscpend,c.id,c.idpart,c.idnopo,d.idcust,d.nick');
$this->db->from('tbl_partcustomer a');
$this->db->join('tbl_customer d','a.idcust=d.idcust');
$this->db->join('tbl_partpo c','c.idpart=a.idpart');
$this->db->join('tbl_schedpo b','b.id=c.id');
$this->db->where('qtyscpend >',0);
$this->db->where('sched <=',date('Y-m-d',strtotime($tgl3)));
$this->db->where('nick',$cust);
$this->db->group_by('partno');
$this->db->order_by('qtybox desc,partname asc');
$query= $this->db->get();
// return $query->result();
// $query=
// $this->db->query("Select b.idpart,b.idcust,b.partname,b.partno,b.jenis,b.satcust,b.qtybox,
// c.ids,c.id,c.sched,sum(c.qtyscpend)totalqtyscpend,
// d.id,d.idpart,d.idnopo,
// e.idcust,nick
// from tbl_partcustomer b, tbl_schedpo c, tbl_partpo d, tbl_customer e
// where b.idpart=d.idpart and c.id=d.id and b.idcust=e.idcust and qtyscpend>0 and c.sched<='".date('Y-m-d',strtotime($tgl3))."' and nick='".$cust."' group by partno order by qtybox desc,partname asc");
$pdf->cust=$cust;
$pdf->tgl=$tgl;
$pdf->tgl1=date('Y-m-d',strtotime($tgl.'+1 day'));
$pdf->tgl2=date('Y-m-d',strtotime($tgl.'+2 day'));
$pdf->tgl3=date('Y-m-d',strtotime($tgl.'+3 day'));
$no=1;
$stock=0;
$total=0;
foreach($query->result() as $row) {
$this->db->select('sum(a.qtyscpend)totalqtyscpendtgl');
$this->db->from('tbl_schedpo a');
$this->db->join('tbl_partpo b','a.id=b.id');
$this->db->where('idpart',$row->idpart);
$this->db->where('sched =',date('Y-m-d',strtotime($tgl)));
$qtyscpendtgl=$this->db->get();
$data= $qtyscpendtgl ->result_array(0);
$this->db->select('sum(a.qtyscpend)totalqtyscpendtgl');
$this->db->from('tbl_schedpo a');
$this->db->join('tbl_partpo b','a.id=b.id');
$this->db->where('idpart',$row->idpart);
$this->db->where('sched =',date('Y-m-d',strtotime($tgl1)));
$qtyscpendtgl1=$this->db->get();
$data1= $qtyscpendtgl1 ->result_array(0);
$this->db->select('sum(a.qtyscpend)totalqtyscpendtgl');
$this->db->from('tbl_schedpo a');
$this->db->join('tbl_partpo b','a.id=b.id');
$this->db->where('idpart',$row->idpart);
$this->db->where('sched =',date('Y-m-d',strtotime($tgl2)));
$qtyscpendtgl2=$this->db->get();
$data2= $qtyscpendtgl2 ->result_array(0);
$this->db->select('sum(a.qtyscpend)totalqtyscpendtgl');
$this->db->from('tbl_schedpo a');
$this->db->join('tbl_partpo b','a.id=b.id');
$this->db->where('idpart',$row->idpart);
$this->db->where('sched =',date('Y-m-d',strtotime($tgl3)));
$qtyscpendtgl3=$this->db->get();
$data3= $qtyscpendtgl3 ->result_array(0);
// $qtyscpendtgl=
// $this->db->query("select sum(a.qtyscpend)totalqtyscpendtgl from tbl_schedpo a, tbl_partpo b where a.id=b.id and b.idpart='".$row->idpart."' and a.sched='".date('Y-m-d',strtotime($tgl))."'");
// $data = $qtyscpendtgl ->result_array(0);
// $qtyscpendtgl1=
// $this->db->query("select sum(a.qtyscpend)totalqtyscpendtgl from tbl_schedpo a, tbl_partpo b where a.id=b.id and b.idpart='".$row->idpart."' and a.sched='".date('Y-m-d',strtotime($tgl1))."'");
// $data1 = $qtyscpendtgl1 ->result_array(0);
// $qtyscpendtgl2=
// $this->db->query("select sum(a.qtyscpend)totalqtyscpendtgl from tbl_schedpo a, tbl_partpo b where a.id=b.id and b.idpart='".$row->idpart."' and a.sched='".date('Y-m-d',strtotime($tgl2))."'");
// $data2 = $qtyscpendtgl2 ->result_array(0);
// $qtyscpendtgl3=
// $this->db->query("select sum(a.qtyscpend)totalqtyscpendtgl from tbl_schedpo a, tbl_partpo b where a.id=b.id and b.idpart='".$row->idpart."' and a.sched='".date('Y-m-d',strtotime($tgl3))."'");
// $data3 = $qtyscpendtgl3 ->result_array(0);
if($row->qtybox>1)
{
$qtyboxpend = ceil($row->totalqtyscpend/$row->qtybox);
$satuan = "BOX" ;
$qtyboxpendtgl = ceil($data[0]["totalqtyscpendtgl"]/$row->qtybox);
$qtyboxpendtgl1 = ceil($data1[0]["totalqtyscpendtgl"]/$row->qtybox);
$qtyboxpendtgl2 = ceil($data2[0]["totalqtyscpendtgl"]/$row->qtybox);
$qtyboxpendtgl3 = ceil($data3[0]["totalqtyscpendtgl"]/$row->qtybox);
$qtyboxpendhasil=$qtyboxpend-$qtyboxpendtgl-$qtyboxpendtgl1-$qtyboxpendtgl2-$qtyboxpendtgl3;
}
else
{
$qtyboxpend = $row->totalqtyscpend;
$satuan = $row->satcust;
$qtyboxpendtgl = $data[0]["totalqtyscpendtgl"];
$qtyboxpendtgl1 = $data1[0]["totalqtyscpendtgl"];
$qtyboxpendtgl2 = $data2[0]["totalqtyscpendtgl"];
$qtyboxpendtgl3 = $data3[0]["totalqtyscpendtgl"];
$qtyboxpendhasil=$qtyboxpend-$qtyboxpendtgl-$qtyboxpendtgl1-$qtyboxpendtgl2-$qtyboxpendtgl3;
}
$total = $stock-($qtyboxpend);
$pdf->ln(0.5);
$pdf->setX(0.5);
$pdf->SetFont('Arial','B',6);
$pdf->Cell('0.5','0.5',$no,'LTRB','0','L',1);
$pdf->Cell('1.6','0.5',$row->partno,'LTRB','0','L',1);
$pdf->Cell('0.5','0.5',$row->jenis,'LTRB','0','C',1);
$pdf->Cell('4','0.5',$row->partname,'LTRB','0','L',1);
$pdf->Cell('0.9','0.5',"0",'LTRB','0','R',1);
$pdf->Cell('1','0.5',$qtyboxpendhasil,'LTRB','0','R',1);
$pdf->Cell('0.8','0.5',$satuan,'LTRB','0','L',1);
$pdf->Cell('1','0.5',$qtyboxpendtgl,'LTRB','0','R',1);
$pdf->Cell('1','0.5',$qtyboxpendtgl1,'LTRB','0','R',1);
$pdf->Cell('1','0.5',$qtyboxpendtgl2,'LTRB','0','R',1);
$pdf->Cell('1','0.5',$qtyboxpendtgl3,'LTRB','0','R',1);
$pdf->Cell('0.7','0.5',"",'LTRB','0','L',1);
$pdf->Cell('1.5','0.5',"",'LTRB','0','L',1);
$pdf->Cell('1.5','0.5',"",'LTRB','0','L',1);
$pdf->Cell('1.5','0.5',"",'LTRB','0','L',1);
$pdf->Cell('1','0.5',$total,'LTRB','0','R',1);
$pdf->Cell('0.7','0.5',$row->qtybox,'LTRB','0','R',1);
$no++;
}
$pdf->Output("Instruksi_Delivery.pdf","I");
?>
0
5 Jawaban:
udah coba di echo gan?
mungkin routernya salah
0
@abyanjksatu hari sabtu masih bisa tampil pdf nya sekarang muter2 doang trus blank putih
0
coba di clear browser cache & cookies nya gan
0