public function actionDownload()
{
parent::actionDownload();
$pdf = new PDF();
$pdf->title = 'Material Status List';
$pdf->AddPage('P');
$pdf->setFont('Arial', 'B', 12);
// definisi font
$pdf->setFont('Arial', 'B', 8);
// menuliskan tabel
$connection = Yii::app()->db;
$sql = "select a.materialstatusname\r\n from materialstatus a";
$command = $connection->createCommand($sql);
$dataReader = $command->queryAll();
$pdf->setaligns(array('C', 'C'));
$pdf->setwidths(array(50, 70));
$pdf->Row(array('Material Status Name'));
$pdf->setaligns(array('L', 'L'));
foreach ($dataReader as $row1) {
$pdf->row(array($row1['materialstatusname']));
}
// me-render ke browser
$pdf->Output('materialstatus.pdf', 'D');
}
public function actionDownload()
{
parent::actionDownload();
$pdf = new PDF();
$pdf->title = 'Unit of Measure List';
$pdf->AddPage('P');
$pdf->setFont('Arial', 'B', 12);
// definisi font
$pdf->setFont('Arial', 'B', 8);
// menuliskan tabel
$connection = Yii::app()->db;
$sql = "select a.uomcode,a.description\r\n from unitofmeasure a";
$command = $connection->createCommand($sql);
$dataReader = $command->queryAll();
$pdf->setaligns(array('C', 'C', 'C', 'C'));
$pdf->setwidths(array(50, 90));
$pdf->Row(array('Unit of Measure', 'Description'));
$pdf->setaligns(array('L', 'L'));
foreach ($dataReader as $row1) {
$pdf->row(array($row1['uomcode'], $row1['description']));
}
// me-render ke browser
$pdf->Output('unitofmeasure.pdf', 'D');
}
public function actionDownload()
{
parent::actionDownload();
$pdf = new PDF();
$pdf->title = 'Employee Informal List';
$pdf->AddPage('P');
$sql1 = "select splettername, description, validperiod\r\n from splettertype a";
$pdf->setFont('Arial', 'B', 8);
$connection = Yii::app()->db;
$command1 = $connection->createCommand($sql1);
$dataReader1 = $command1->queryAll();
$pdf->text(10, 40, 'Course / Trainig / skill List');
$pdf->SetY(45);
$pdf->setaligns(array('C', 'C', 'C'));
$pdf->setwidths(array(50, 40, 30));
$pdf->Row(array('SP Letter Name', 'Description', 'Period'));
$pdf->setaligns(array('L', 'L', 'L'));
foreach ($dataReader1 as $row1) {
$pdf->row(array($row1['splettername'], $row1['description'], $row1['validperiod']));
}
// me-render ke browser
$pdf->Output('splettertype.pdf', 'D');
}
public function actionDownload()
{
parent::actionDownload();
$pdf = new PDF();
$pdf->title = 'Schedule Master List';
$pdf->AddPage('P');
$pdf->setFont('Arial', 'B', 12);
// definisi font
$pdf->setFont('Arial', 'B', 8);
// menuliskan tabel
$connection = Yii::app()->db;
$sql = "select a.onleavename, a.cutimax,a.cutistart,b.formatdoc,c.shortstat\r\n from onleavetype a\r\n left join snro b on b.snroid = a.snroid\r\n left join absstatus c on c.absstatusid = a.absstatusid";
$command = $connection->createCommand($sql);
$dataReader = $command->queryAll();
$pdf->setaligns(array('C', 'C', 'C', 'C', 'C'));
$pdf->setwidths(array(50, 20, 20, 50, 20));
$pdf->Row(array('Onleave', 'Cuti Max', 'Cuti Start', 'Format Doc', 'Cuti Status'));
$pdf->setaligns(array('L', 'L', 'L', 'L', 'L'));
foreach ($dataReader as $row1) {
$pdf->row(array($row1['onleavename'], $row1['cutimax'], $row1['cutistart'], $row1['formatdoc'], $row1['shortstat']));
}
// me-render ke browser
$pdf->Output('onleavetype.pdf', 'D');
}
public function actionDownload()
{
parent::actionDownload();
$pdf = new PDF();
$pdf->title = 'Storage Location List';
$pdf->AddPage('P');
$pdf->setFont('Arial', 'B', 12);
// definisi font
$pdf->setFont('Arial', 'B', 8);
// menuliskan tabel
$connection = Yii::app()->db;
$sql = "select b.plantcode, a.sloccode, a.description\r\n from sloc a\r\n left join plant b on b.plantid = a.plantid";
$command = $connection->createCommand($sql);
$dataReader = $command->queryAll();
$pdf->setaligns(array('C', 'C', 'C', 'C'));
$pdf->setwidths(array(30, 30, 70));
$pdf->Row(array('Plant', 'Sloc Code', 'Description'));
$pdf->setaligns(array('L', 'L', 'L'));
foreach ($dataReader as $row1) {
$pdf->row(array($row1['plantcode'], $row1['sloccode'], $row1['description']));
}
// me-render ke browser
$pdf->Output('sloc.pdf', 'D');
}
public function actionDownload()
{
parent::actionDownload();
$pdf = new PDF();
$pdf->title = 'Schedule Master List';
$pdf->AddPage('P');
$pdf->setFont('Arial', 'B', 12);
// definisi font
$pdf->setFont('Arial', 'B', 8);
// menuliskan tabel
$connection = Yii::app()->db;
$sql = "select a.employeestatusname, a.taxvalue\r\n from employeestatus a";
$command = $connection->createCommand($sql);
$dataReader = $command->queryAll();
$pdf->setaligns(array('C', 'C', 'C', 'C'));
$pdf->setwidths(array(50, 30, 30, 30));
$pdf->Row(array('Employee Status', 'Tax Value'));
$pdf->setaligns(array('L', 'R', 'C', 'C'));
foreach ($dataReader as $row1) {
$pdf->row(array($row1['employeestatusname'], $row1['taxvalue']));
}
// me-render ke browser
$pdf->Output('employeestatus.pdf', 'D');
}
public function actionDownload()
{
parent::actionDownload();
$pdf = new PDF();
$pdf->title = 'Asset List';
$pdf->AddPage('L');
$pdf->setFont('Arial', 'B', 12);
// definisi font
$pdf->setFont('Arial', 'B', 8);
// menuliskan tabel
$connection = Yii::app()->db;
$sql = "select b.productname,c.sloccode,a.expiredate,a.serialno,a.qty,d.uomcode,a.buydate,\r\n a.buyprice,e.currencyname,a.picproduct,a.location,a.locationdate\r\n from productdetail a\r\n left join product b on b.productid = a.productid\r\n left join sloc c on c.slocid = a.slocid\r\n left join unitofmeasure d on d.unitofmeasureid = a.unitofmeasureid\r\n left join currency e on e.currencyid = a.currencyid";
$command = $connection->createCommand($sql);
$dataReader = $command->queryAll();
$pdf->setaligns(array('C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C'));
$pdf->setwidths(array(50, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20));
$pdf->Row(array('Material Name', 'Sloc', 'Expire Date', 'Serial No', 'Qty', 'UOM Code', 'Buy Date', 'Buy Price', 'Currency', 'PIC Product', 'Location', 'Loc Date'));
$pdf->setaligns(array('L', 'L', 'L', 'L', 'L', 'L', 'L', 'L', 'L', 'L', 'L', 'L'));
foreach ($dataReader as $row1) {
$pdf->row(array($row1['productname'], $row1['sloccode'], $row1['expiredate'], $row1['serialno'], $row1['qty'], $row1['uomcode'], $row1['buydate'], $row1['buyprice'], $row1['currencyname'], $row1['picproduct'], $row1['location'], $row1['locationdate']));
}
// me-render ke browser
$pdf->Output('productdetail.pdf', 'D');
}
public function actionDownload()
{
parent::actionDownload();
$pdf = new PDF();
$pdf->title = 'Material Group List';
$pdf->AddPage('P');
$pdf->setFont('Arial', 'B', 12);
// definisi font
$pdf->setFont('Arial', 'B', 8);
// menuliskan tabel
$connection = Yii::app()->db;
$sql = "select a.materialgroupcode, a.description,\r\n b.materialgroupcode as parentgroupcode,c.materialtypecode as materialtype\r\n from materialgroup a\r\n left join materialgroup b on b.materialgroupid = a.parentmatgroupid \r\n left join materialtype c on c.materialtypeid = a.materialtypeid";
$command = $connection->createCommand($sql);
$dataReader = $command->queryAll();
$pdf->setaligns(array('C', 'C', 'C', 'C'));
$pdf->setwidths(array(30, 50, 30, 30));
$pdf->Row(array('Code', 'Material Type', 'Description', 'Parent Group Code'));
$pdf->setaligns(array('L', 'L', 'L', 'L'));
foreach ($dataReader as $row1) {
$pdf->row(array($row1['materialgroupcode'], $row1['description'], $row1['materialtype'], $row1['parentgroupcode']));
}
// me-render ke browser
$pdf->Output('materialgroup.pdf', 'D');
}
public function actionDownload()
{
parent::actionDownload();
$pdf = new PDF();
$pdf->title = 'Form Permintaan (Barang/Jasa)';
$pdf->AddPage('P');
$pdf->setFont('Arial', 'B', 12);
// definisi font
$pdf->setFont('Arial', 'B', 8);
// menuliskan tabel
$connection = Yii::app()->db;
$sql = "select a.dano,a.dadate,a.headernote,a.deliveryadviceid\n from deliveryadvice a\n where deliveryadviceid = " . $_GET['id'];
$command = $connection->createCommand($sql);
$dataReader = $command->queryAll();
foreach ($dataReader as $row) {
$pdf->setFont('Arial', 'B', 8);
$pdf->text(10, 30, 'No ');
$pdf->text(50, 30, ': ' . $row['dano']);
$pdf->text(10, 35, 'Date ');
$pdf->text(50, 35, ': ' . $row['dadate']);
$pdf->text(10, 40, 'Note ');
$pdf->text(50, 40, ': ' . $row['headernote']);
$sql1 = "select b.productname, a.qty, c.uomcode, a.itemtext\n from deliveryadvicedetail a\n left join product b on b.productid = a.productid\n left join unitofmeasure c on c.unitofmeasureid = a.unitofmeasureid\n where deliveryadviceid = " . $row['deliveryadviceid'];
$command1 = $connection->createCommand($sql1);
$dataReader1 = $command1->queryAll();
$pdf->text(10, 50, 'Items');
$pdf->SetY(55);
$pdf->setFont('Arial', 'B', 6);
$pdf->setaligns(array('C', 'C', 'C', 'C', 'C'));
$pdf->setwidths(array(10, 90, 25, 25, 40));
$pdf->setFont('Arial', '', 6);
$pdf->Row(array('No', 'Items', 'Qty', 'Unit', 'Remark'));
$pdf->setaligns(array('L', 'L', 'L', 'L', 'L'));
$i = 0;
foreach ($dataReader1 as $row1) {
$i = $i + 1;
$pdf->row(array($i, $row1['productname'], Yii::app()->numberFormatter->format(Yii::app()->params["defaultnumberqty"], $row1['qty']), $row1['uomcode'], $row1['itemtext']));
}
$pdf->text(100, $pdf->gety() + 5, 'Jakarta, ' . $row['dadate']);
$pdf->text(10, $pdf->gety() + 10, 'Approved By');
$pdf->text(100, $pdf->gety() + 10, 'Proposed By');
$pdf->text(10, $pdf->gety() + 20, '------------ ');
$pdf->text(100, $pdf->gety() + 20, '------------');
$pdf->AddPage('P');
}
$pdf->Output();
}