Beispiel #1
1
 private function create_ex_coupon($vendor_id)
 {
     $pdf = new PDF_Code128();
     // เพิ่มฟอนต์ภาษาไทยเข้ามา ตัวธรรมดา กำหนด ชื่อ เป็น angsana
     $pdf->AddFont('angsana', '', 'angsa.php');
     // เพิ่มฟอนต์ภาษาไทยเข้ามา ตัวหนา  กำหนด ชื่อ เป็น angsana
     $pdf->AddFont('angsana', 'B', 'angsab.php');
     $pdf->AddFont('angsana', 'I', 'angsai.php');
     $pdf->AddFont('angsana', 'BI', 'angsaz.php');
     //สร้างหน้าเอกสาร
     $pdf->AddPage();
     $sql = "\tSELECT sc.deal_start,\n\t\t\t\t\t\t\t\t\tsc.deal_expile,\n\t\t\t\t\t\t\t\t\tsc.round_start,\n\t\t\t\t\t\t\t\t\tsc.round_end,\n\t\t\t\t\t\t\t\t\tsc.deal_name,\n\t\t\t\t\t\t\t\t\tp.product_name,\n\t\t\t\t\t\t\t\t\tp.product_detail,\n\t\t\t\t\t\t\t\t\tv.vendor_id,\n\t\t\t\t\t\t\t\t\tv.vendor_name,\n\t\t\t\t\t\t\t\t\tv.vendor_contact_fname,\n\t\t\t\t\t\t\t\t\tv.vendor_contact_sname,\n\t\t\t\t\t\t\t\t\tv.vendor_email,\n\t\t\t\t\t\t\t\t\tv.vendor_address,\n\t\t\t\t\t\t\t\t\tv.vendor_website,\n\t\t\t\t\t\t\t\t\tv.vendor_logo,\n\t\t\t\t\t\t\t\t\tv.vendor_map,\n\t\t\t\t\t\t\t\t\tv.vendor_about_us,\n\t\t\t\t\t\t\t\t\tv.vendor_pay_type,\n\t\t\t\t\t\t\t\t\td.deal_main_detail,\n\t\t\t\t\t\t\t\t\td.deal_main_condition\n\t\t\t\t\t\tFROM view_sell_coupon sc\n\t\t\t\t\t\tLEFT JOIN tbl_vendor_profile v ON sc.vendor_id\t=\tv.vendor_id\n\t\t\t\t\t\tLEFT JOIN tbl_deal_product p ON p.deal_id = sc.deal_id\n\t\t\t\t\t\tLEFT JOIN tbl_deal_main d ON sc.deal_id = d.deal_id\n\t\t\t\t\t\tWHERE v.vendor_id = '" . $vendor_id . "'\n\t\t\t\t\t\tORDER BY sc.round_id DESC\n\t\t\t\t\t\tLIMIT 0,1";
     $query = $this->db->query($sql);
     $data = $query->row_array();
     $year = date("Y", time()) + 543;
     $year = substr($year, 2);
     $deal_name = $data["deal_name"];
     $vendor_logo = $data["vendor_logo"];
     $location = $data["vendor_address"];
     $fine_print = $data["deal_main_detail"];
     $deal_main_condition = $data["deal_main_condition"];
     $vendor_email = $data["vendor_email"];
     $vendor_website = $data["vendor_website"];
     $mem_name = "คุณ xxxxxxxxxxx xxxxxxxxxxxxx";
     $member_id = $year . "0000xx";
     $coupon = "1";
     $coupon_c = "0000" . rand("1000", "9999");
     $coupon_price = "00" . rand("1000", "9999") . "00";
     $barcode = $coupon_c . $coupon_price;
     $voucher_number = $vendor_id . "-0000xx";
     $order_id = $year . date("m", time()) . "0000xx";
     $redemption_code = rand("1111", "9999");
     $product_name = $data["product_name"];
     $product_detail = $data["product_detail"];
     $coupon_can_use = $data["deal_start"];
     $coupon_expire = $data["deal_expile"];
     $coupon_can_use_full = $this->thai_date(strtotime(date_format(date_create($coupon_can_use), "Y-m-d")));
     $coupon_expire_full = $this->thai_date(strtotime(date_format(date_create($coupon_expire), "Y-m-d")));
     unset($coupon_data);
     $image1 = " ../../assets/images/company_logo.png";
     $pdf->Image($image1, $pdf->GetX(), $pdf->GetY(), 30);
     $Line_V = " ../../assets/images/Line_Vertical.png";
     $pdf->Image($Line_V, 100, 0, 1.6);
     $Line_H = " ../../assets/images/Line_H.png";
     $pdf->Image($Line_H, 0, 105, 180);
     // กำหนดฟอนต์
     $pdf->SetFont('angsana', '', 11);
     // พิมพ์ข้อความลงเอกสาร
     $pdf->setXY(10, 33);
     //$pdf->MultiCell( 70  , 4 , iconv( 'UTF-8','cp874' , $product_detail),0,'L' );
     $pdf->SetFont('angsana', '', 9);
     $pdf->Ln(3);
     $pdf->MultiCell(70, 4, iconv('UTF-8', 'cp874', $deal_name . "   # " . $product_name));
     $pdf->setXY(10, 59);
     $pdf->MultiCell(0, 0, iconv('UTF-8', 'cp874', 'PURCHASED BY:'));
     $pdf->setXY(10, 69);
     $pdf->MultiCell(0, 0, iconv('UTF-8', 'cp874', 'VOUCHER NUMBER:'));
     $pdf->setXY(40, 69);
     $pdf->MultiCell(0, 0, iconv('UTF-8', 'cp874', 'ORDER ID:'));
     $pdf->SetFont('angsana', '', 11);
     $pdf->setXY(10, 81);
     $pdf->MultiCell(0, 0, iconv('UTF-8', 'cp874', 'CUSTOMER ID:'));
     $pdf->setXY(40, 81);
     $pdf->MultiCell(0, 0, iconv('UTF-8', 'cp874', 'REDEMPTION CODE:'));
     $pdf->SetFont('angsana', '', 11);
     $pdf->setXY(10, 63);
     $pdf->MultiCell(0, 0, iconv('UTF-8', 'cp874', $mem_name));
     $pdf->SetFont('angsana', '', 15);
     $pdf->setXY(10, 73);
     $pdf->MultiCell(0, 0, iconv('UTF-8', 'cp874', $voucher_number));
     $pdf->setXY(40, 73);
     $pdf->MultiCell(0, 0, iconv('UTF-8', 'cp874', $order_id));
     $pdf->SetFont('angsana', '', 13);
     $pdf->setXY(10, 85);
     $pdf->MultiCell(0, 0, iconv('UTF-8', 'cp874', $member_id));
     $pdf->setXY(40, 85);
     $pdf->MultiCell(0, 0, iconv('UTF-8', 'cp874', $redemption_code));
     // วาดรูปกรอกสี่เหลี่ยม
     $pdf->SetDrawColor(195, 195, 195);
     $pdf->SetLineWidth(0.2835);
     $pdf->Rect(107, 19, 70, 23, 'D');
     if (!empty($barcode)) {
         $pdf->Code128(116, 22, $barcode, 52, 11);
         $pdf->SetFont('angsana', '', 10);
         $pdf->setXY(156, 35);
         $pdf->MultiCell(0, 0, iconv('UTF-8', 'cp874', 'BARCODE'));
         $pdf->setXY(148, 38);
         $pdf->MultiCell(0, 0, iconv('UTF-8', 'cp874', $barcode));
     }
     $pdf->SetFont('angsana', '', 10);
     $pdf->setXY(110, 48);
     $pdf->MultiCell(0, 0, iconv('UTF-8', 'cp874', 'สงวนสิทธิ์ไม่คืนเงินสำหรับคูปองที่ไม่ได้ใช้งานในระยะเวลา'));
     $pdf->SetFont('angsana', '', 11);
     $pdf->setXY(110, 55);
     $pdf->MultiCell(0, 0, iconv('UTF-8', 'cp874', 'VALID FROM:'));
     $pdf->SetFont('angsana', '', 20);
     $pdf->SetTextColor(255, 0, 0);
     $pdf->setXY(109, 60);
     $pdf->MultiCell(0, 0, iconv('UTF-8', 'cp874', $coupon_can_use_full . ' to ' . $coupon_expire_full));
     // วาดรูปกรอกสี่เหลี่ยม
     $pdf->SetDrawColor(195, 195, 195);
     $pdf->SetLineWidth(0.2835);
     $pdf->Rect(107, 68, 70, 31, 'D');
     $pdf->SetFont('angsana', '', 14);
     $pdf->SetTextColor(0, 0, 0);
     $pdf->setXY(130, 71);
     $pdf->MultiCell(0, 0, iconv('UTF-8', 'cp874', 'Need Assistance?'));
     $pdf->SetFont('angsana', '', 9);
     $pdf->setXY(116, 76);
     $pdf->MultiCell(0, 0, iconv('UTF-8', 'cp874', 'Call Thebestdeal1 : 02 938 4399 | Email : info@thebestdeal1.com'));
     $image2 = " ../../assets/images/thebestdeal1.png";
     $pdf->Image($image2, 123, 79, 15);
     $image3 = " ../../assets/images/facebook.png";
     $pdf->Image($image3, 147, 79, 15);
     $pdf->SetFont('angsana', '', 10);
     $pdf->setXY(121, 95);
     $pdf->MultiCell(0, 0, iconv('UTF-8', 'cp874', 'Thebestdeal1.com'));
     $pdf->SetFont('angsana', '', 10);
     $pdf->setXY(149, 95);
     $pdf->MultiCell(0, 0, iconv('UTF-8', 'cp874', 'Facebook'));
     /*	
     				 	$pdf->SetFont('angsana','',10);
     					$pdf->setXY( 10, 100  );
     					$pdf->MultiCell( 0  , 0 , iconv( 'UTF-8','cp874' , '--------------------------------------------------------------------------------------------------------------------------------------------') ); 
     */
     $pdf->SetFont('angsana', 'B', 14);
     $pdf->setXY(8, 110);
     $pdf->MultiCell(0, 0, iconv('UTF-8', 'cp874', 'Fine Print:'));
     $pdf->SetFont('angsana', 'B', 14);
     $pdf->setXY(105, 110);
     $pdf->MultiCell(0, 0, iconv('UTF-8', 'cp874', 'Location:'));
     $pdf->SetFont('angsana', '', 12);
     $pdf->setXY(105, 140);
     $pdf->MultiCell(0, 0, iconv('UTF-8', 'cp874', 'Email :'));
     $pdf->SetFont('angsana', '', 12);
     $pdf->setXY(115, 140);
     $pdf->MultiCell(0, 0, iconv('UTF-8', 'cp874', $vendor_email));
     $pdf->SetFont('angsana', '', 12);
     $pdf->setXY(105, 145);
     $pdf->MultiCell(0, 0, iconv('UTF-8', 'cp874', 'Website :'));
     $pdf->SetFont('angsana', '', 12);
     $pdf->setXY(118, 145);
     $pdf->MultiCell(0, 0, iconv('UTF-8', 'cp874', $vendor_website));
     $fine_print = $this->clear_text_editor($fine_print);
     $pdf->SetFont('angsana', '', 11);
     $pdf->setXY(8, 115);
     $pdf->MultiCell(90, 5, iconv('UTF-8', 'cp874//TRANSLIT//IGNORE', $fine_print), 0, 'L');
     $location = $this->clear_text_editor($location);
     $pdf->SetFont('angsana', '', 11);
     $pdf->setXY(105, 113);
     $pdf->MultiCell(90, 5, iconv('UTF-8', 'cp874//TRANSLIT//IGNORE', $location), 0, 'L');
     $pdf->SetFont('angsana', 'B', 14);
     $pdf->setXY(105, 161);
     $pdf->MultiCell(0, 0, iconv('UTF-8', 'cp874', 'Other:'));
     $deal_main_condition = $this->clear_text_editor($deal_main_condition);
     $pdf->SetFont('angsana', '', 11);
     $pdf->setXY(105, 165);
     $pdf->MultiCell(90, 5, iconv('UTF-8', 'cp874//TRANSLIT//IGNORE', $deal_main_condition), 0, 'L');
     unlink($_SERVER["DOCUMENT_ROOT"] . "/assets/media/vendor_pdf/" . $vendor_id . ".pdf");
     $pdf->Output($_SERVER["DOCUMENT_ROOT"] . "/assets/media/vendor_pdf/" . $vendor_id . ".pdf", "F");
     chmod($_SERVER["DOCUMENT_ROOT"] . "/assets/media/vendor_pdf/" . $vendor_id . ".pdf", 0777);
 }
Beispiel #2
0
 function printPDF($member_id = "", $deal_id = "", $coupon_id = "")
 {
     $pdf = new PDF_Code128();
     // เพิ่มฟอนต์ภาษาไทยเข้ามา ตัวธรรมดา กำหนด ชื่อ เป็น angsana
     $pdf->AddFont('angsana', '', 'angsa.php');
     // เพิ่มฟอนต์ภาษาไทยเข้ามา ตัวหนา  กำหนด ชื่อ เป็น angsana
     $pdf->AddFont('angsana', 'B', 'angsab.php');
     $pdf->AddFont('angsana', 'I', 'angsai.php');
     $pdf->AddFont('angsana', 'BI', 'angsaz.php');
     //สร้างหน้าเอกสาร
     $pdf->AddPage();
     if ($coupon_id != "") {
         $coupon_data = $this->coupon_main->get_coupon($member_id, $deal_id, $coupon_id);
         $deal_name = $coupon_data["deal_main"]["deal_name"];
         $vendor_logo = $coupon_data["deal_main"]["vendor_logo"];
         $location = $coupon_data["deal_main"]["location"];
         $fine_print = $coupon_data["deal_main"]["deal_main_detail"];
         $deal_main_condition = $coupon_data["deal_main"]["deal_main_condition"];
         $mem_name = $coupon_data["member"]["member_name"] . "   " . $coupon_data["member"]["member_sname"];
         $member_id = $coupon_data["member"]["member_id"];
         $coupon = $coupon_data["coupon"]["coupon_id"];
         $barcode = $coupon_data["coupon"]["barcode"];
         $voucher_number = $coupon_data["coupon"]["voucher_number"];
         $order_id = $coupon_data["coupon"]["order_id"];
         $redemption_code = $coupon_data["coupon"]["redemption_code"];
         $product_name = $coupon_data["coupon"]["product_name"];
         $product_detail = $coupon_data["coupon"]["product_detail"];
         $coupon_can_use = $coupon_data["coupon"]["coupon_can_use"];
         $coupon_expire = $coupon_data["coupon"]["coupon_expire"];
         $coupon_can_use_full = $this->thai_date(strtotime(date_format(date_create($coupon_can_use), "Y-m-d")));
         $coupon_expire_full = $this->thai_date(strtotime(date_format(date_create($coupon_expire), "Y-m-d")));
         unset($coupon_data);
         $image1 = " ../../assets/images/company_logo.png";
         $pdf->Image($image1, $pdf->GetX(), $pdf->GetY(), 30);
         $Line_V = " ../../assets/images/Line_Vertical.png";
         $pdf->Image($Line_V, 100, 0, 1.6);
         $Line_H = " ../../assets/images/Line_H.png";
         $pdf->Image($Line_H, 0, 105, 180);
         // กำหนดฟอนต์
         $pdf->SetFont('angsana', '', 11);
         // พิมพ์ข้อความลงเอกสาร
         $pdf->setXY(10, 33);
         $pdf->MultiCell(90, 4, iconv('UTF-8', 'cp874', $product_detail), 0, 'L');
         $pdf->SetFont('angsana', '', 9);
         $pdf->Ln(2);
         $pdf->MultiCell(0, 0, iconv('UTF-8', 'cp874', $product_name));
         $pdf->setXY(10, 51);
         $pdf->MultiCell(0, 0, iconv('UTF-8', 'cp874', 'PURCHASED BY:'));
         $pdf->setXY(10, 61);
         $pdf->MultiCell(0, 0, iconv('UTF-8', 'cp874', 'VOUCHER NUMBER:'));
         $pdf->setXY(40, 61);
         $pdf->MultiCell(0, 0, iconv('UTF-8', 'cp874', 'ORDER ID:'));
         $pdf->SetFont('angsana', '', 11);
         $pdf->setXY(10, 73);
         $pdf->MultiCell(0, 0, iconv('UTF-8', 'cp874', 'CUSTOMER ID:'));
         $pdf->setXY(40, 73);
         $pdf->MultiCell(0, 0, iconv('UTF-8', 'cp874', 'REDEMPTION CODE:'));
         $pdf->SetFont('angsana', '', 11);
         $pdf->setXY(10, 55);
         $pdf->MultiCell(0, 0, iconv('UTF-8', 'cp874', $mem_name));
         $pdf->SetFont('angsana', '', 15);
         $pdf->setXY(10, 65);
         $pdf->MultiCell(0, 0, iconv('UTF-8', 'cp874', $voucher_number));
         $pdf->setXY(40, 65);
         $pdf->MultiCell(0, 0, iconv('UTF-8', 'cp874', $order_id));
         $pdf->SetFont('angsana', '', 13);
         $pdf->setXY(10, 77);
         $pdf->MultiCell(0, 0, iconv('UTF-8', 'cp874', $member_id));
         $pdf->setXY(40, 77);
         $pdf->MultiCell(0, 0, iconv('UTF-8', 'cp874', $redemption_code));
         // วาดรูปกรอกสี่เหลี่ยม
         $pdf->SetDrawColor(195, 195, 195);
         $pdf->SetLineWidth(0.2835);
         $pdf->Rect(107, 19, 70, 23, 'D');
         if (!empty($barcode)) {
             $pdf->Code128(116, 22, $barcode, 52, 11);
             $pdf->SetFont('angsana', '', 10);
             $pdf->setXY(156, 35);
             $pdf->MultiCell(0, 0, iconv('UTF-8', 'cp874', 'BARCODE'));
             $pdf->setXY(148, 38);
             $pdf->MultiCell(0, 0, iconv('UTF-8', 'cp874', $barcode));
         }
         $pdf->SetFont('angsana', '', 10);
         $pdf->setXY(110, 48);
         $pdf->MultiCell(0, 0, iconv('UTF-8', 'cp874', 'สงวนสิทธิ์ไม่คืนเงินสำหรับคูปองที่ไม่ได้ใช้งานในระยะเวลา'));
         $pdf->SetFont('angsana', '', 11);
         $pdf->setXY(110, 55);
         $pdf->MultiCell(0, 0, iconv('UTF-8', 'cp874', 'VALID FROM:'));
         $pdf->SetFont('angsana', '', 20);
         $pdf->SetTextColor(255, 0, 0);
         $pdf->setXY(109, 60);
         $pdf->MultiCell(0, 0, iconv('UTF-8', 'cp874', $coupon_can_use_full . ' to ' . $coupon_expire_full));
         // วาดรูปกรอกสี่เหลี่ยม
         $pdf->SetDrawColor(195, 195, 195);
         $pdf->SetLineWidth(0.2835);
         $pdf->Rect(107, 68, 70, 31, 'D');
         $pdf->SetFont('angsana', '', 14);
         $pdf->SetTextColor(0, 0, 0);
         $pdf->setXY(130, 71);
         $pdf->MultiCell(0, 0, iconv('UTF-8', 'cp874', 'Need Assistance?'));
         $pdf->SetFont('angsana', '', 9);
         $pdf->setXY(116, 76);
         $pdf->MultiCell(0, 0, iconv('UTF-8', 'cp874', 'Call Thebestdeal1 : 02 938 4399 | Email : info@thebestdeal1.com'));
         $image2 = " ../../assets/images/thebestdeal1.png";
         $pdf->Image($image2, 123, 79, 15);
         $image3 = " ../../assets/images/facebook.png";
         $pdf->Image($image3, 147, 79, 15);
         $pdf->SetFont('angsana', '', 10);
         $pdf->setXY(121, 95);
         $pdf->MultiCell(0, 0, iconv('UTF-8', 'cp874', 'Thebestdeal1.com'));
         $pdf->SetFont('angsana', '', 10);
         $pdf->setXY(149, 95);
         $pdf->MultiCell(0, 0, iconv('UTF-8', 'cp874', 'Facebook'));
         /*	$pdf->SetFont('angsana','',10);
         			$pdf->setXY( 10, 100  );
         			$pdf->MultiCell( 0  , 0 , iconv( 'UTF-8','cp874' , '--------------------------------------------------------------------------------------------------------------------------------------------') ); */
         $pdf->SetFont('angsana', 'B', 14);
         $pdf->setXY(8, 110);
         $pdf->MultiCell(0, 0, iconv('UTF-8', 'cp874', 'Fine Print:'));
         $pdf->SetFont('angsana', 'B', 14);
         $pdf->setXY(105, 110);
         $pdf->MultiCell(0, 0, iconv('UTF-8', 'cp874', 'Location:'));
         $fine_print = str_replace(' ', ' ', $fine_print);
         $fine_print = str_replace('•', ' ', $fine_print);
         $pdf->SetFont('angsana', '', 11);
         $pdf->setXY(8, 115);
         $pdf->MultiCell(90, 5, iconv('UTF-8', 'cp874//TRANSLIT//IGNORE', strip_tags($fine_print)), 0, 'L');
         $pdf->SetFont('angsana', '', 11);
         $pdf->setXY(105, 113);
         $pdf->MultiCell(90, 5, iconv('UTF-8', 'cp874', strip_tags($location)), 0, 'L');
         $pdf->SetFont('angsana', 'B', 14);
         $pdf->setXY(105, 161);
         $pdf->MultiCell(0, 0, iconv('UTF-8', 'cp874', 'Other:'));
         $pdf->SetFont('angsana', '', 11);
         $pdf->setXY(105, 165);
         $pdf->MultiCell(90, 5, iconv('UTF-8', 'cp874', strip_tags($deal_main_condition)), 0, 'L');
         $pdf->Output();
     }
 }