sgunn

New Members

View Profile See their activity

Posts
4
Joined
September 28, 2015
Last visited
October 1, 2015

sgunn's Achievements

Newbie (1/5)

Reputation

Help Please

sgunn replied to sgunn's topic in PHP Coding Help

I don't believe so. the fields are never more than 12 characters long anyway. It just works perfectly if only numbers are used. But as soon as you add a Letter to any of the fields it fails.
- September 28, 2015
- 8 replies
Help Please

sgunn replied to sgunn's topic in PHP Coding Help

Maybe it's this one? <?php include('config.php'); extract($_GET); $sql = mysql_query("SELECT * FROM custom_doc WHERE invoice = '$invoice' "); $row = mysql_fetch_object($sql); ?> <html> <head></head> <body> <div style="border:2px solid black;padding:10px"> <form method="post" action="index.php"> <table style="line-height:35px"> <tr> <td>Invoice Date</td> <td><input type="date" name="inv_date" value="<?php echo date('Y-m-d',strtotime($row->inv_date)); ?>" /></td> <td>Sail Date</td> <td><input type="date" name="sail_date" value="<?php echo date('Y-m-d',strtotime($row->sail_date)); ?>" /></td> <td>B/L Number</td> <td><input type="text" name="bl_number" size="10" value="<?php echo $row->bl_number; ?>" /></td> </tr> <tr> <td>Vessel Name</td> <td><input type="text" name="vessel_name" required="required" value="<?php echo $row->vessel_name; ?>" /></td> <td>Port Name</td> <td><input type="text" name="port_name" required="required" size="15" value="<?php echo $row->port_name; ?>" /></td> <td>PL number</td> <td><input type="text" name="pl_number" required="required" size="10" value="<?php echo $row->pl_number; ?>" /></td> </tr> <tr> <td>Container number 1</td> <td><input type="text" name="container_number_1" size="10" value="<?php echo $row->container_number_1; ?>" /></td> <td>Container number 2</td> <td><input type="text" name="container_number_2" size="10" value="<?php echo $row->container_number_2; ?>" /></td> <td>Container number 3</td> <td><input type="text" name="container_number_3" size="10" value="<?php echo $row->container_number_3; ?>" /></td> </tr> <tr> <td>Container number 4</td> <td><input type="text" name="container_number_4" size="10" value="<?php echo $row->container_number_4; ?>" /></td> <td>Container number 5</td> <td><input type="text" name="container_number_5" size="10" value="<?php echo $row->container_number_5; ?>" /></td> <td>Container number 6</td> <td><input type="text" name="container_number_6" size="10" value="<?php echo $row->container_number_6; ?>" /></td> </tr> <tr> <td>Container number 7</td> <td><input type="text" name="container_number_7" size="10" value="<?php echo $row->container_number_7; ?>" /></td> <td>Container number 8</td> <td><input type="text" name="container_number_8" size="10" value="<?php echo $row->container_number_8; ?>" /></td> <td>Container number 9</td> <td><input type="text" name="container_number_9" size="10" value="<?php echo $row->container_number_9; ?>" /></td> </tr> <tr> <td>Container number 10</td> <td><input type="text" name="container_number_10" size="10" value="<?php echo $row->container_number_10; ?>" /></td> <td>Container number 11</td> <td><input type="text" name="container_number_11" size="10" value="<?php echo $row->container_number_11; ?>" /></td> <td>Container number 12</td> <td><input type="text" name="container_number_12" size="10" value="<?php echo $row->container_number_12; ?>" /></td> </tr> <tr> <td>Container number 13</td> <td><input type="text" name="container_number_13" size="10" value="<?php echo $row->container_number_13; ?>" /></td> <td>Container number 14</td> <td><input type="text" name="container_number_14" size="10" value="<?php echo $row->container_number_14; ?>" /></td> <td>Container number 15</td> <td><input type="text" name="container_number_15" size="10" value="<?php echo $row->container_number_15; ?>" /></td> </tr> <tr> <td>Seal Number 1</td> <td><input type="text" name="seal_number_1" size="10" value="<?php echo $row->seal_number_1; ?>" /></td> <td>Seal number 2</td> <td><input type="text" name="seal_number_2" size="10" value="<?php echo $row->seal_number_2; ?>" /></td> <td>Seal number 3</td> <td><input type="text" name="seal_number_3" size="10" value="<?php echo $row->seal_number_3; ?>" /></td> </tr> <tr> <td>Seal Number 4</td> <td><input type="text" name="seal_number_4" size="10" value="<?php echo $row->seal_number_4; ?>" /></td> <td>Seal number 5</td> <td><input type="text" name="seal_number_5" size="10" value="<?php echo $row->seal_number_5; ?>" /></td> <td>Seal number 6</td> <td><input type="text" name="seal_number_6" size="10" value="<?php echo $row->seal_number_6; ?>" /></td> </tr> <tr> <td>Seal Number 7</td> <td><input type="text" name="seal_number_7" size="10" value="<?php echo $row->seal_number_7; ?>" /></td> <td>Seal number 8</td> <td><input type="text" name="seal_number_8" size="10" value="<?php echo $row->seal_number_8; ?>" /></td> <td>Seal number 9</td> <td><input type="text" name="seal_number_9" size="10" value="<?php echo $row->seal_number_9; ?>" /></td> </tr> <tr> <td>Seal Number 10</td> <td><input type="text" name="seal_number_10" size="10" value="<?php echo $row->seal_number_10; ?>" /></td> <td>Seal number 11</td> <td><input type="text" name="seal_number_11" size="10" value="<?php echo $row->seal_number_11; ?>" /></td> <td>Seal number 12</td> <td><input type="text" name="seal_number_12" size="10" value="<?php echo $row->seal_number_12; ?>" /></td> </tr> <tr> <td>Seal Number 13</td> <td><input type="text" name="seal_number_13" size="10" value="<?php echo $row->seal_number_13; ?>" /></td> <td>Seal number 14</td> <td><input type="text" name="seal_number_14" size="10" value="<?php echo $row->seal_number_14; ?>" /></td> <td>Seal number 15</td> <td><input type="text" name="seal_number_15" size="10" value="<?php echo $row->seal_number_15; ?>" /></td> </tr> <input type="hidden" name="invoice" value="<?php echo $invoice; ?>" > <tr> <td colspan="6" align="right"><input type="submit" name="edit_invoice" value="Edit Invoice" style="width:150px;height:30px;" /></td> </tr> </table> </form> </div> </body> </html>
- September 28, 2015
- 8 replies
Help Please

sgunn replied to sgunn's topic in PHP Coding Help

Thanks for the replies. I have no idea what you are asking but here is the script. <?php require_once 'lib/PHPRtfLite.php'; PHPRtfLite::registerAutoloader(); /*CODE FOR EXTRACTING DATA FROM DATABASE*/ include('config.php'); extract($_GET); $result = mysql_query("SELECT * FROM custom_doc WHERE invoice = '$invoice' ORDER BY inv_date DESC "); $row = mysql_fetch_object($result); if($row->container_number_1 != "") $container[] = $row->container_number_1; if($row->container_number_2 != "") $container[] = $row->container_number_2; if($row->container_number_3 != "") $container[] = $row->container_number_3; if($row->container_number_4 != "") $container[] = $row->container_number_4; if($row->container_number_5 != "") $container[] = $row->container_number_5; if($row->container_number_6 != "") $container[] = $row->container_number_6; if($row->container_number_7 != "") $container[] = $row->container_number_7; if($row->container_number_8 != "") $container[] = $row->container_number_8; if($row->container_number_9 != "") $container[] = $row->container_number_9; if($row->container_number_10 != "") $container[] = $row->container_number_10; if($row->container_number_11 != "") $container[] = $row->container_number_11; if($row->container_number_12 != "") $container[] = $row->container_number_12; if($row->container_number_13 != "") $container[] = $row->container_number_13; if($row->container_number_14 != "") $container[] = $row->container_number_14; if($row->container_number_15 != "") $container[] = $row->container_number_15; //$container_number = implode(',',$container); if(count($container)>1) $container_number = implode(',',$container); else if (count($container) == 1) $container_number = $container[0]; else $container_number = ''; $total_container_number = count($container); if($row->seal_number_1 != "") $seal[] = $row->seal_number_1; if($row->seal_number_2 != "") $seal[] = $row->seal_number_2; if($row->seal_number_3 != "") $seal[] = $row->seal_number_3; if($row->seal_number_4 != "") $seal[] = $row->seal_number_4; if($row->seal_number_5 != "") $seal[] = $row->seal_number_5; if($row->seal_number_6 != "") $seal[] = $row->seal_number_6; if($row->seal_number_7 != "") $seal[] = $row->seal_number_7; if($row->seal_number_8 != "") $seal[] = $row->seal_number_8; if($row->seal_number_9 != "") $seal[] = $row->seal_number_9; if($row->seal_number_10 != "") $seal[] = $row->seal_number_10; if($row->seal_number_11 != "") $seal[] = $row->seal_number_11; if($row->seal_number_12 != "") $seal[] = $row->seal_number_12; if($row->seal_number_13 != "") $seal[] = $row->seal_number_13; if($row->seal_number_14 != "") $seal[] = $row->seal_number_14; if($row->seal_number_15 != "") $seal[] = $row->seal_number_15; if(count($seal)>1) $seal_number = implode(',',$seal); else if (count($seal) == 1) $seal_number = $seal[0]; else $seal_number = ''; /*** Variables used in the following document ***/ $rtf = new PHPRtfLite(); // Set margins $rtf->setMarginLeft(1.5); $rtf->setMarginRight(1.5); $rtf->setMarginTop(1.7564); $rtf->setMarginBottom(1.27); if($row->bl_number > 0) { //################################################# /*START OF CERTIFICATE OF ANALYSIS PAGE FROM HERE*/ $section = $rtf->addSection(); // This is the standard font. $font = new PHPRtfLite_Font(24,'Arial Black'); $parFormat = new PHPRtfLite_ParFormat(PHPRtfLite_ParFormat::TEXT_ALIGN_CENTER); // Spaces after paragraph $parFormat->setSpaceAfter(1); $parFormat->setSpaceBefore(1); $parFormat = new PHPRtfLite_ParFormat(PHPRtfLite_ParFormat::TEXT_ALIGN_LEFT); $header = $section->addHeader(); $header->writeText('Carbora Environmental', $font, $parFormat); $font = new PHPRtfLite_Font(22,'Calibri (Body)'); $parFormat = new PHPRtfLite_ParFormat(PHPRtfLite_ParFormat::TEXT_ALIGN_CENTER); $section->writeText(' CERTIFICATE OF ANALYSIS ', $font, $parFormat); $parFormat = new PHPRtfLite_ParFormat(PHPRtfLite_ParFormat::TEXT_ALIGN_LEFT); $font = new PHPRtfLite_Font(12,'Calibri (Body)'); $section->writeText(' '.date('d/m/Y').' ', $font, $parFormat); $section->writeText('We are forwarding you the material analysis certificate certifying to the following test in values taken on average basis. ', $font, $parFormat); $section->writeText('Container :'.$container_number.' ', $font, $parFormat); $section->writeText('Seal :'.$seal_number.' ', $font, $parFormat); $section->writeText("Invoice No : $invoice".' ', $font, $parFormat); $section->writeText("Dated : ".date('y-m-d',strtotime($row->inv_date))." ", $font, $parFormat); $section->writeText('Total Quantity: 26.5 tonnes'.' ', $font, $parFormat); $section->writeText('RUBBER CONTENT : 50%'.' ', $font, $parFormat); $section->writeText('CARBON CONTENT : 24%'.' ', $font, $parFormat); $section->writeText('ACETONE CONTENT : 11%'.' ', $font, $parFormat); $section->writeText('ASH CONTENT : 04%'.' ', $font, $parFormat); $section->writeText(' STEEL WIRE : 11%'.' ', $font, $parFormat); //############################################# /*STARTING OF FOOTER SECTION OF THE DOCUMENT*/ $parFormat = new PHPRtfLite_ParFormat(PHPRtfLite_ParFormat::TEXT_ALIGN_LEFT); $font = new PHPRtfLite_Font(8,'Calibri (Body)'); $footer = $section->addFooter(); $imageFile = 'stamp.png'; $table = $footer->addTable(); $table->addRows(1); $table->addColumnsList(array(5, 8, 6)); // add image to table in header $table->writeToCell(1, 1, 'Carbora Environmental Limited 72 North Road Richmond TW9 4HQ England', $font, $parFormat); $table->writeToCell(1, 2, 'enquiries@carboraenvironmental.com www.carboraenvironmental.com Registered in England Company No 9321437', $font, $parFormat); $image = $table->addImageToCell(1, 3, $imageFile); } if($row->bl_number > 0) { //################################################# /*START OF CERTIFICATE OF ORIGIN PAGE FROM HERE*/ $section = $rtf->addSection(); // This is the standard font. $font = new PHPRtfLite_Font(24,'Arial Black'); $parFormat = new PHPRtfLite_ParFormat(PHPRtfLite_ParFormat::TEXT_ALIGN_CENTER); // Spaces after paragraph $parFormat->setSpaceAfter(1); $parFormat->setSpaceBefore(1); $parFormat = new PHPRtfLite_ParFormat(PHPRtfLite_ParFormat::TEXT_ALIGN_LEFT); $header = $section->addHeader(); $header->writeText('Carbora Environmental', $font, $parFormat); $font = new PHPRtfLite_Font(22,'Calibri (Body)'); $parFormat = new PHPRtfLite_ParFormat(PHPRtfLite_ParFormat::TEXT_ALIGN_CENTER); $section->writeText(' Certificate of Origin ', $font, $parFormat); $parFormat = new PHPRtfLite_ParFormat(PHPRtfLite_ParFormat::TEXT_ALIGN_LEFT); $font = new PHPRtfLite_Font(12,'Calibri (Body)'); $section->writeText(' Date :'.date('d/m/Y').'', $font, $parFormat); $section->writeText(' Invoice No :'.$invoice.' ', $font, $parFormat); $section->writeText("This is to certify that the Tyres Scrap (Cut in 2 &3 pcs arises from used & old tyres) shipped on the $row->vessel_name sailed from $row->port_name by Carbora Environmental Limited on ".date('y-m-d',strtotime($row->sail_date))." are cut into 3PCs in UK, after they become scrap. ", $font, $parFormat); $section->writeText('For Carbora Environmental limited ', $font, $parFormat); $font = new PHPRtfLite_Font(26,'Freestyle Script'); $section->writeText('Paul Gunn ', $font, $parFormat); $font = new PHPRtfLite_Font(12,'Calibri (Body)'); $section->writeText('Authorised Signatory', $font, $parFormat); //############################################# /*STARTING OF FOOTER SECTION OF THE DOCUMENT*/ $parFormat = new PHPRtfLite_ParFormat(PHPRtfLite_ParFormat::TEXT_ALIGN_LEFT); $font = new PHPRtfLite_Font(8,'Calibri (Body)'); $footer = $section->addFooter(); $imageFile = 'stamp.png'; $table = $footer->addTable(); $table->addRows(1); $table->addColumnsList(array(5, 8, 6)); // add image to table in header $table->writeToCell(1, 1, 'Carbora Environmental Limited 72 North Road Richmond TW9 4HQ England', $font, $parFormat); $table->writeToCell(1, 2, 'enquiries@carboraenvironmental.com www.carboraenvironmental.com Registered in England Company No 9321437', $font, $parFormat); $image = $table->addImageToCell(1, 3, $imageFile); } //################################################# /*START OF INVOICE PAGE FROM HERE*/ $section = $rtf->addSection(); // This is the standard font. $font = new PHPRtfLite_Font(24,'Arial Black'); $parFormat = new PHPRtfLite_ParFormat(PHPRtfLite_ParFormat::TEXT_ALIGN_CENTER); // Spaces after paragraph $parFormat->setSpaceAfter(1); $parFormat->setSpaceBefore(1); $parFormat = new PHPRtfLite_ParFormat(PHPRtfLite_ParFormat::TEXT_ALIGN_LEFT); $header = $section->addHeader(); $header->writeText('Carbora Environmental', $font, $parFormat); $font = new PHPRtfLite_Font(22,'Calibri (Body)'); $parFormat = new PHPRtfLite_ParFormat(PHPRtfLite_ParFormat::TEXT_ALIGN_CENTER); $section->writeText(' COMMERCIAL INVOICE ', $font, $parFormat); $parFormat_center = new PHPRtfLite_ParFormat(PHPRtfLite_ParFormat::TEXT_ALIGN_CENTER); $parFormat = new PHPRtfLite_ParFormat(PHPRtfLite_ParFormat::TEXT_ALIGN_LEFT); $font = new PHPRtfLite_Font(10,'Calibri (Body)'); $section->writeText(' Dated'.date('d/m/Y').'', $font, $parFormat); $section->writeText(' Inv. No .'.$invoice.'', $font, $parFormat); $section->writeText('', $font, $parFormat); $section->writeText('Importer:-Tinna Rubber & Infrastructure Limited,', $font, $parFormat); $section->writeText('Gut No. 113/2 & 114/2, Village Pali, Jawahar Road,', $font, $parFormat); $section->writeText('Taluka Wada, Distt. Thane, Maharashtra-431 303, India ', $font, $parFormat); $section->writeText('Shipper:- Carbora Environmental Limited, UK ', $font, $parFormat); $section->writeText("B/L No $row->bl_number ", $font, $parFormat); $section->writeText("Total Container:$total_container_number"."x40 HC. $container_number ", $font, $parFormat); $table = $section->addTable(); // Table border formating $border = new PHPRtfLite_Border( $rtf, new PHPRtfLite_Border_Format(1, '#000000'), new PHPRtfLite_Border_Format(1, '#000000'), new PHPRtfLite_Border_Format(1, '#000000'), new PHPRtfLite_Border_Format(1, '#000000') ); $table->addRows(3, 0.5); $table->addColumnsList(array(6,3,2,3,3)); $table->setBorderForCellRange($border, 1, 1, 3, 5); $table->mergeCellRange(3, 1, 3, 4); $table->writeToCell(1, 1, 'Descriptions', $font, $parFormat); $table->writeToCell(1, 2, 'Origin Of Merchandize', $font, $parFormat); $table->writeToCell(1, 3, 'No. of Containers', $font, $parFormat); $table->writeToCell(1, 4, 'Unit Price', $font, $parFormat); $table->writeToCell(1, 5, 'Amount USD', $font, $parFormat); $table->writeToCell(2, 1, 'Tyres Scrap cut in 2 &3 pcs(Arises from used & old tyres),', $font, $parFormat); $table->writeToCell(2, 2, 'United Kingdom', $font, $parFormat_center); $table->writeToCell(2, 3, '', $font, $parFormat_center); $table->writeToCell(2, 4, '', $font, $parFormat_center); $table->writeToCell(2, 5, '', $font, $parFormat_center); $table->writeToCell(3, 1, 'Net Payable Amount', $font, $parFormat_center); $table->writeToCell(3, 5, '', $font, $parFormat_center); $section->writeText(' Total Amount in USD ', $font, $parFormat); $parFormat = new PHPRtfLite_ParFormat(PHPRtfLite_ParFormat::TEXT_ALIGN_LEFT); $font = new PHPRtfLite_Font(8,'Calibri (Body)'); $footer = $section->addFooter(); $imageFile = 'stamp.png'; $table = $footer->addTable(); $table->addRows(1); $table->addColumnsList(array(5, 8, 6)); // add image to table in header $table->writeToCell(1, 1, 'Carbora Environmental Limited 72 North Road Richmond TW9 4HQ England', $font, $parFormat); $table->writeToCell(1, 2, 'enquiries@carboraenvironmental.com www.carboraenvironmental.com Registered in England Company No 9321437', $font, $parFormat); $image = $table->addImageToCell(1, 3, $imageFile); //################################################# /*START OF PACKING LIST PAGE FROM HERE*/ $section = $rtf->addSection(); // This is the standard font. $font = new PHPRtfLite_Font(22,'Arial Black'); $parFormat = new PHPRtfLite_ParFormat(PHPRtfLite_ParFormat::TEXT_ALIGN_CENTER); // Spaces after paragraph $parFormat->setSpaceAfter(1); $parFormat->setSpaceBefore(1); $parFormat = new PHPRtfLite_ParFormat(PHPRtfLite_ParFormat::TEXT_ALIGN_LEFT); $header = $section->addHeader(); $header->writeText('Carbora Environmental', $font, $parFormat); $font = new PHPRtfLite_Font(22,'Calibri (Body)'); $parFormat = new PHPRtfLite_ParFormat(PHPRtfLite_ParFormat::TEXT_ALIGN_CENTER); $section->writeText(' Packing List ', $font, $parFormat); $parFormat = new PHPRtfLite_ParFormat(PHPRtfLite_ParFormat::TEXT_ALIGN_LEFT); $font = new PHPRtfLite_Font(10,'Calibri (Body)'); $section->writeText(' PL No .'.$row->pl_number.'', $font, $parFormat); $section->writeText(' Date :'.date('d/m/Y').'', $font, $parFormat); $section->writeText('', $font, $parFormat); $section->writeText('Importer:-Tinna Rubber & Infrastructure Limited,', $font, $parFormat); $section->writeText('Gut No. 113/2 & 114/2, Village Pali, Jawahar Road,', $font, $parFormat); $section->writeText('Taluka Wada, Distt. Thane, Maharashtra-431 303, India ', $font, $parFormat); $section->writeText('Shipper:- Carbora Environmental Limited, UK ', $font, $parFormat); $parFormat_center = new PHPRtfLite_ParFormat(PHPRtfLite_ParFormat::TEXT_ALIGN_CENTER); $parFormat = new PHPRtfLite_ParFormat(PHPRtfLite_ParFormat::TEXT_ALIGN_LEFT); $font = new PHPRtfLite_Font(8,'Calibri (Body)'); $section->writeText("BL No :- $row->bl_number ", $font, $parFormat); $section->writeText("Vessel Name : $row->vessel_name ", $font, $parFormat); $section->writeText('Description of Goods: Tyres Scrap cut in 2 &3 pcs (Arises from used & old tyres) ', $font, $parFormat); $section->writeText(' Ex-Yard, UK ', $font, $parFormat); $section->writeText("Invoice No : $invoice ", $font, $parFormat); $section->writeText('Country of Origin: United Kingdom ', $font, $parFormat); $section->writeText("Packing Type: Loose Packing in $total_container_number"."x40 HC Container ", $font, $parFormat); $table = $section->addTable(); // Table border formating $border = new PHPRtfLite_Border( $rtf, new PHPRtfLite_Border_Format(1, '#000000'), new PHPRtfLite_Border_Format(1, '#000000'), new PHPRtfLite_Border_Format(1, '#000000'), new PHPRtfLite_Border_Format(1, '#000000') ); $table->addRows(16, 0.5); $table->addColumnsList(array(4,4,4,4)); $table->setBorderForCellRange($border, 1, 1, 16, 4); $table->writeToCell(1, 1, 'Sr. No.', $font, $parFormat); $table->writeToCell(1, 2, 'Container No.', $font, $parFormat); $table->writeToCell(1, 3, 'Container Seal No', $font, $parFormat); $table->writeToCell(1, 4, 'Cargo G.W M/Tons', $font, $parFormat); $table->writeToCell(2, 1, '1.', $font, $parFormat); $table->writeToCell(2, 2, "$row->container_number_1", $font, $parFormat_center); $table->writeToCell(2, 3, "$row->seal_number_1", $font, $parFormat_center); $table->writeToCell(2, 4, '', $font, $parFormat_center); $table->writeToCell(3, 1, '2.', $font, $parFormat); $table->writeToCell(3, 2, "$row->container_number_2", $font, $parFormat_center); $table->writeToCell(3, 3, "$row->seal_number_2", $font, $parFormat_center); $table->writeToCell(3, 4, '', $font, $parFormat_center); $table->writeToCell(4, 1, '3.', $font, $parFormat); $table->writeToCell(4, 2, "$row->container_number_3", $font, $parFormat_center); $table->writeToCell(4, 3, "$row->seal_number_3", $font, $parFormat_center); $table->writeToCell(4, 4, '', $font, $parFormat_center); $table->writeToCell(5, 1, '4.', $font, $parFormat); $table->writeToCell(5, 2, "$row->container_number_4", $font, $parFormat_center); $table->writeToCell(5, 3, "$row->seal_number_4", $font, $parFormat_center); $table->writeToCell(5, 4, '', $font, $parFormat_center); $table->writeToCell(6, 1, '5.', $font, $parFormat); $table->writeToCell(6, 2, "$row->container_number_5", $font, $parFormat_center); $table->writeToCell(6, 3, "$row->seal_number_5", $font, $parFormat_center); $table->writeToCell(6, 4, '', $font, $parFormat_center); $table->writeToCell(7, 1, '6.', $font, $parFormat); $table->writeToCell(7, 2, "$row->container_number_6", $font, $parFormat_center); $table->writeToCell(7, 3, "$row->seal_number_6", $font, $parFormat_center); $table->writeToCell(7, 4, '', $font, $parFormat_center); $table->writeToCell(8, 1, '7.', $font, $parFormat); $table->writeToCell(8, 2, "$row->container_number_7", $font, $parFormat_center); $table->writeToCell(8, 3, "$row->seal_number_7", $font, $parFormat_center); $table->writeToCell(8, 4, '', $font, $parFormat_center); $table->writeToCell(9, 1, '8.', $font, $parFormat); $table->writeToCell(9, 2, "$row->container_number_8", $font, $parFormat_center); $table->writeToCell(9, 3, "$row->seal_number_8", $font, $parFormat_center); $table->writeToCell(9, 4, '', $font, $parFormat_center); $table->writeToCell(10, 1, '9.', $font, $parFormat); $table->writeToCell(10, 2, "$row->container_number_9", $font, $parFormat_center); $table->writeToCell(10, 3, "$row->seal_number_9", $font, $parFormat_center); $table->writeToCell(10, 4, '', $font, $parFormat_center); $table->writeToCell(11, 1, '10.', $font, $parFormat); $table->writeToCell(11, 2, "$row->container_number_10", $font, $parFormat_center); $table->writeToCell(11, 3, "$row->seal_number_10", $font, $parFormat_center); $table->writeToCell(11, 4, '', $font, $parFormat_center); $table->writeToCell(12, 1, '11.', $font, $parFormat); $table->writeToCell(12, 2, "$row->container_number_11", $font, $parFormat_center); $table->writeToCell(12, 3, "$row->seal_number_11", $font, $parFormat_center); $table->writeToCell(12, 4, '', $font, $parFormat_center); $table->writeToCell(13, 1, '12.', $font, $parFormat); $table->writeToCell(13, 2, "$row->container_number_12", $font, $parFormat_center); $table->writeToCell(13, 3, "$row->seal_number_12", $font, $parFormat_center); $table->writeToCell(13, 4, '', $font, $parFormat_center); $table->writeToCell(14, 1, '13.', $font, $parFormat); $table->writeToCell(14, 2, "$row->container_number_13", $font, $parFormat_center); $table->writeToCell(14, 3, "$row->seal_number_13", $font, $parFormat_center); $table->writeToCell(14, 4, '', $font, $parFormat_center); $table->writeToCell(15, 1, '14.', $font, $parFormat); $table->writeToCell(15, 2, "$row->container_number_14", $font, $parFormat_center); $table->writeToCell(15, 3, "$row->seal_number_14", $font, $parFormat_center); $table->writeToCell(15, 4, '', $font, $parFormat_center); $table->writeToCell(16, 1, '15.', $font, $parFormat); $table->writeToCell(16, 2, "$row->container_number_15", $font, $parFormat_center); $table->writeToCell(16, 3, "$row->seal_number_15", $font, $parFormat_center); $table->writeToCell(16, 4, '', $font, $parFormat_center); $section->writeText(' Total Weight Mt.', $font, $parFormat); $parFormat = new PHPRtfLite_ParFormat(PHPRtfLite_ParFormat::TEXT_ALIGN_LEFT); $font = new PHPRtfLite_Font(8,'Calibri (Body)'); $footer = $section->addFooter(); $imageFile = 'stamp.png'; $table = $footer->addTable(); $table->addRows(1); $table->addColumnsList(array(5, 8, 6)); // add image to table in header $table->writeToCell(1, 1, 'Carbora Environmental Limited 72 North Road Richmond TW9 4HQ England', $font, $parFormat); $table->writeToCell(1, 2, 'enquiries@carboraenvironmental.com www.carboraenvironmental.com Registered in England Company No 9321437', $font, $parFormat); $image = $table->addImageToCell(1, 3, $imageFile); if($row->bl_number > 0) { //################################################# /*START OF PACKING LIST PAGE FROM HERE*/ $section = $rtf->addSection(); // This is the standard font. $font = new PHPRtfLite_Font(24,'Arial Black'); $parFormat_center = new PHPRtfLite_ParFormat(PHPRtfLite_ParFormat::TEXT_ALIGN_CENTER); // Spaces after paragraph $parFormat->setSpaceAfter(1); $parFormat->setSpaceBefore(1); $parFormat = new PHPRtfLite_ParFormat(PHPRtfLite_ParFormat::TEXT_ALIGN_LEFT); $header = $section->addHeader(); $header->writeText('Carbora Environmental', $font, $parFormat); $font = new PHPRtfLite_Font(9,'Arial (Body CS)'); $parFormat_l = new PHPRtfLite_ParFormat(PHPRtfLite_ParFormat::TEXT_ALIGN_LEFT); $section->writeText(' FORM-9', $font, $parFormat_center); $section->writeText('<hr>', $font, $parFormat_center); $section->writeText('[SEE RULES 15(5) AND 16(5), 16(6)1 TRANSBOUNDARY MOVEMENT-MOVEMENT DOCUMENT ', $font, $parFormat_center); $table = $section->addTable(); // Table border formating $border = new PHPRtfLite_Border( $rtf, new PHPRtfLite_Border_Format(1, '#000000'), new PHPRtfLite_Border_Format(1, '#000000'), new PHPRtfLite_Border_Format(1, '#000000'), new PHPRtfLite_Border_Format(1, '#000000') ); $table->addRows(39, 0.5); $table->addColumnsList(array(2,10,6)); $table->setBorderForCellRange($border, 1, 1, 39, 3); $table->mergeCellRange(1, 3, 2, 3); $table->mergeCellRange(2, 1, 7, 1); $table->mergeCellRange(8, 1, 9, 1); $table->mergeCellRange(17, 1, 23, 1); $table->mergeCellRange(25, 1, 26, 1); $table->mergeCellRange(27, 1, 32, 1); $table->writeToCell(1, 1, 'SR NO', $font, $parFormat); $table->writeToCell(1, 2, 'DESCRIPTION', $font, $parFormat_l); $table->writeToCell(1, 3, 'DETAILS TO BE FURNISHED BY THE EXPORTER IMPORTER Carbora Environmental Limited 72 North Road, Richmond, TW9 4HQ, England', $font, $parFormat_l); $table->writeToCell(2, 1, '1.', $font, $parFormat); $table->writeToCell(2, 2, '(1) EXPORTER (NAME AND ADDRESS)', $font, $parFormat_l); $table->writeToCell(2, 3, 'Carbora Environmental Limited 72 North Road, Richmond, TW9 4HQ, England ', $font, $parFormat_l); $table->writeToCell(3, 2, 'CONTACT PERSON', $font, $parFormat); $table->writeToCell(3, 3, 'Mr. Paul Gunn', $font, $parFormat); $table->writeToCell(4, 2, 'TEL,FAX', $font, $parFormat); $table->writeToCell(4, 3, '+007711 183969', $font, $parFormat); $table->writeToCell(5, 2, '(II) WASTE GENERATOR /EXPORTER FOR ** CATEGORY (NAME AND ADDRESS): ', $font, $parFormat); $table->writeToCell(5, 3, '-', $font, $parFormat); $table->writeToCell(6, 2, 'CONTACT PERSON WITH TEL./FAX', $font, $parFormat); $table->writeToCell(6, 3, '-', $font, $parFormat); $table->writeToCell(7, 2, 'SITE OF GENERATION (EXCLUDED FOR ** CATEGORY)', $font, $parFormat); $table->writeToCell(7, 3, '-', $font, $parFormat); $table->writeToCell(8, 1, '2.', $font, $parFormat); $table->writeToCell(8, 2, 'IMPORTER /RECYCLER(NAME & ADDRESS)', $font, $parFormat); $table->writeToCell(8, 3, 'Tinna Rubber & Infrastructure Limited, Gut No. 113/2 & 114/2, Village Pali, Jawahar Road, Taluka Wada, Distt. Thane, Maharashtra-431 303, India ', $font, $parFormat); $table->writeToCell(9, 2, 'CONTACT PERSON WITH TEL,FAX', $font, $parFormat); $table->writeToCell(9, 3, '-', $font, $parFormat); $table->writeToCell(10, 2, 'MOVEMENT SUBJECT TO SINGLE/MULTIPLE', $font, $parFormat); $table->writeToCell(10, 3, '-', $font, $parFormat); $table->writeToCell(11, 1, '3.', $font, $parFormat); $table->writeToCell(11, 2, 'CORRESPONDING TO APPLICANT REF .NO ,IF ANY', $font, $parFormat); $table->writeToCell(11, 3, '-', $font, $parFormat); $table->writeToCell(12, 1, '4.', $font, $parFormat); $table->writeToCell(12, 2, "BILL OF Laden", $font, $parFormat); $table->writeToCell(12, 3, "$row->bl_number", $font, $parFormat); $table->writeToCell(13, 1, '5.', $font, $parFormat); $table->writeToCell(13, 2, 'DESIGNATION AND CHEMICAL COMPOSITION OF THE WASTE', $font, $parFormat); $table->writeToCell(13, 3, 'TYRES SCRAP CUT IN 2 &3 PCS (ARISES FROM USED & OLD TYRES)', $font, $parFormat); $table->writeToCell(14, 1, '6.', $font, $parFormat); $table->writeToCell(14, 2, 'PHYSICAL CHARACTERISTICS(3)', $font, $parFormat); $table->writeToCell(14, 3, 'SOLID', $font, $parFormat); $table->writeToCell(15, 1, '7.', $font, $parFormat); $table->writeToCell(15, 2, 'ACTUAL QUANTITY KG/LITRE', $font, $parFormat); $table->writeToCell(15, 3, '26.500 MT', $font, $parFormat); $table->writeToCell(16, 1, '8.', $font, $parFormat); $table->writeToCell(16, 2, 'WASTE IDENTIFICATION CODE', $font, $parFormat); $table->writeToCell(16, 3, 'R CODE /D CODE : R3', $font, $parFormat); $table->writeToCell(17, 2, 'BASEL NO.', $font, $parFormat); $table->writeToCell(17, 3, '1K,B 3140', $font, $parFormat); $table->writeToCell(18, 2, 'OECD NO', $font, $parFormat); $table->writeToCell(18, 3, '-', $font, $parFormat); $table->writeToCell(19, 2, 'UN NO.', $font, $parFormat); $table->writeToCell(19, 3, '-', $font, $parFormat); $table->writeToCell(20, 2, 'ITC (HS)', $font, $parFormat); $table->writeToCell(20, 3, '-', $font, $parFormat); $table->writeToCell(21, 2, 'CUSTOMS CODE(H.S)', $font, $parFormat); $table->writeToCell(21, 3, '4004 00 00', $font, $parFormat); $table->writeToCell(22, 2, 'OTHER (SPECIFY)', $font, $parFormat); $table->writeToCell(22, 3, '-', $font, $parFormat); $table->writeToCell(23, 2, 'BILL OF LADING ', $font, $parFormat); $table->writeToCell(23, 3, '-', $font, $parFormat); $table->writeToCell(24, 1, '9.', $font, $parFormat); $table->writeToCell(24, 2, 'OECD CLASSIFICATION (2) (A) AMBER/RED/OTHER (ATTACH DETAILS) (B) NUMBER ', $font, $parFormat); $table->writeToCell(24, 3, '-', $font, $parFormat); $table->writeToCell(25, 1, '10.', $font, $parFormat); $table->writeToCell(25, 2, 'PACKING TYPE(3)', $font, $parFormat); $table->writeToCell(25, 3, 'LOOSE', $font, $parFormat); $table->writeToCell(26, 2, 'NUMBER', $font, $parFormat); $table->writeToCell(26, 3, '-', $font, $parFormat); $table->writeToCell(27, 1, '11.', $font, $parFormat); $table->writeToCell(27, 2, 'UN CLASSIFICATION', $font, $parFormat); $table->writeToCell(27, 3, 'NA', $font, $parFormat); $table->writeToCell(28, 2, 'UN SHIPPING NAME', $font, $parFormat); $table->writeToCell(28, 3, 'SCI', $font, $parFormat); $table->writeToCell(29, 2, 'UN IDENTIFICATION NO.', $font, $parFormat); $table->writeToCell(29, 3, 'NA', $font, $parFormat); $table->writeToCell(30, 2, 'UN CLASS(3)', $font, $parFormat); $table->writeToCell(30, 3, 'NA', $font, $parFormat); $table->writeToCell(31, 2, 'H NUMBER(3)', $font, $parFormat); $table->writeToCell(31, 3, 'NA', $font, $parFormat); $table->writeToCell(32, 2, 'Y NUMBER', $font, $parFormat); $table->writeToCell(32, 3, 'NA', $font, $parFormat); $table->writeToCell(35, 1, '12.', $font, $parFormat); $table->writeToCell(35, 2, 'SPECIAL HANDLING REQUIREMENTS', $font, $parFormat); $table->writeToCell(35, 3, 'NO', $font, $parFormat); $table->writeToCell(36, 1, '13.', $font, $parFormat); $table->writeToCell(36, 2, "EXPORTER'S DECLARATION FOR HAZARDOUS WASTE: I CERTIFY THAT THE INFORMATION IN SL.NO. 1 OF 12 ABOVE IS COMPLETE AND COORECT TO MY BEST KNOWLEDGE I ALSO CERTIFY THAT LEGALLY ENFORCEABLE WRII1EN CONTRACTUAL OBLIGATIONS HAVE BEEN ENTERED INTO AND ARE IN FORCE COVERING THE TRANSBOUNDARY ", $font, $parFormat); $table->writeToCell(36, 3, '-', $font, $parFormat); $table->writeToCell(37, 1, '14.', $font, $parFormat); $table->writeToCell(37, 2, 'NAME:', $font, $parFormat); $table->writeToCell(37, 3, 'Paul Gunn', $font, $parFormat); $table->writeToCell(38, 1, '15.', $font, $parFormat); $table->writeToCell(38, 2, 'DATE: SIGNATURE WITH STAMP ', $font, $parFormat); $table->writeToCell(38, 3, '', $font, $parFormat); $table->writeToCell(39, 1, '16.', $font, $parFormat); $table->writeToCell(39, 2, ' INVOICE NUMBER', $font, $parFormat); $table->writeToCell(39, 3, "$invoice", $font, $parFormat); $parFormat = new PHPRtfLite_ParFormat(PHPRtfLite_ParFormat::TEXT_ALIGN_LEFT); $font = new PHPRtfLite_Font(8,'Calibri (Body)'); $footer = $section->addFooter(); $imageFile = 'stamp.png'; $table = $footer->addTable(); $table->addRows(1); $table->addColumnsList(array(5, 8, 6)); // add image to table in header $table->writeToCell(1, 1, 'Carbora Environmental Limited 72 North Road Richmond TW9 4HQ England', $font, $parFormat); $table->writeToCell(1, 2, 'enquiries@carboraenvironmental.com www.carboraenvironmental.com Registered in England Company No 9321437', $font, $parFormat); $image = $table->addImageToCell(1, 3, $imageFile); } // Save the file $rtf->save('directors_declaration_form.doc'); $file_name = 'directors_declaration_form.doc'; header("Content-disposition: attachment; filename=".basename($file_name).""); header('Content-type: application/doc'); readfile($file_name); ?>
- September 28, 2015
- 8 replies
Help Please

sgunn posted a topic in PHP Coding Help

A ex employee of ours set up an web form that allows us to input certain data which then produces a word document with the fields entered in the form added to the document template. We have used this for a while with great success, until now. When certain fields are entered with numeric values the documents are created correctly. However, now some of these fields require alpha-numeric characters. This has stopped the documents being created. The mysql database fields that require alpha numeric characters are set to VarChar. But I do not know what could be causing the issue? Any help would be greatly appriciated as I am unable to get hold of the ex employee who created it!
- September 28, 2015
- 8 replies

Sign In

sgunn

Posts

Joined

Last visited

sgunn's Achievements

Newbie (1/5)

Reputation

Help Please

Help Please

Help Please

Help Please

Browse

Activity

Important Information