Esempio n. 1
0
    ?>
</td>    
    </tr> 
  	<?php 
}
?>
    <?php 
if (round($itemInvoice->{$type})) {
    ?>
    <tr>    
  	  <td style="text-align:left; font-size:14px;font-weight:bold; padding-bottom:10px" colspan="2">TOTAL <span style="display:block; font-weight:normal;font-size:11px">(including vat)</span></td>    
  	  <td style="text-align:right;padding-right:10px; font-size:14px;padding-bottom:10px"><?php 
    echo prep_costd($cdata->total, true, false);
    ?>
</td>
    </tr> 
  	<?php 
} else {
    ?>
    <tr>   
  	  <td style="text-align:left; font-size:14px;font-weight:bold; padding-bottom:10px" colspan="2">TOTAL</td>    
  	  <td style="text-align:right;padding-right:10px; font-size:14px;padding-bottom:10px"><?php 
    echo prep_costd($cdata->total, true, false);
    ?>
</td>
    </tr>
  	<?php 
}
?>
  </tfooter>
</table>
Esempio n. 2
0
 private function createXLSDate()
 {
     include_once APPPATH . 'third_party/PHPExcel/PHPExcel.php';
     $objPHPExcel = new PHPExcel();
     // Set document properties
     $objPHPExcel->getProperties()->setCreator("Inmediative")->setLastModifiedBy("Inmediative")->setTitle($this->config->item('client', 'app'))->setSubject($this->config->item('client', 'app'))->setDescription($this->config->item('client', 'app'))->setKeywords($this->config->item('client', 'app'))->setCategory("Result file");
     $alphabet = range('A', 'Z');
     // Add some data
     $fields = array('DESTINATARIO DEL ENVÍO', 'DIRECCION', 'CIUDAD', 'REGION/ESTADO', 'C.P.', 'PAIS', 'TELEFONO', 'EMAIL', 'PESO', 'TRACK', 'Lista de productos', 'CODIGO', 'FECHA', 'DNI/CIF/ ID NUMBER/UE VAT', 'CLIENTE', 'DIRECCION COMPLETA', 'BASE 4%', 'IVA 4%', 'BASE 10%', 'IVA 10%', 'BASE 21%', 'IVA 21%', 'TOTAL', 'GASTOS ENVIO', 'CATEGORÍA');
     $dd = date('Y-m-d', strtotime('-1 week'));
     $sql = "select id_cart from cart where id_state = 3 AND modified > '{$dd}' order by modified";
     $result = $this->db->query($sql)->result();
     $k = 2;
     $sheet = $objPHPExcel->setActiveSheetIndex(0);
     foreach ($fields as $ke => $value) {
         $sheet->setCellValue($alphabet[$ke] . '1', $value);
     }
     foreach ($result as $row) {
         $idc = $row->id_cart;
         $fdata = $this->Cart->DataCart($idc);
         $cdata = $this->Cart->DataCartComplete($idc);
         $cartItems = $this->Cart->ListItems($idc);
         if (!$fdata || !$cdata) {
             die('NO XLS');
         }
         $itemInvoice = $this->Data->GetCountry($fdata['id_country']);
         $type = 'iva_ind';
         if ($fdata['type'] == 'company') {
             $type = 'iva_emp';
         }
         if ($fdata['id_region']) {
             $ret = $this->Data->GetRegion($fdata['id_region'], $fdata['id_country']);
             if ($ret) {
                 $itemInvoice = $ret;
             }
         }
         $key = 0;
         $productsArr = array();
         $catArr = array();
         foreach ($cartItems as $c) {
             $productsArr[] = $c->title . ($c->size ? " {$c->size}" : "") . ' x' . $c->items;
             $catArr[] = strtoupper($c->category);
         }
         $products = implode(', ', $productsArr);
         $categories = implode(', ', $catArr);
         $dateTimeZone = new DateTimeZone('Europe/Madrid');
         $dateTime = new DateTime();
         $dateTime->setTimestamp(mysql_to_unix($cdata->modified));
         $dateTime->setTimeZone($dateTimeZone);
         $code = $cdata->invoice_code . str_pad($cdata->code, 4, "0", STR_PAD_LEFT);
         $sheet = $objPHPExcel->setActiveSheetIndex(0);
         if ($fdata['dname']) {
             $sheet->setCellValue($alphabet[$key++] . $k, $fdata['dname'] . ' ' . $fdata['dlastname']);
             $sheet->setCellValue($alphabet[$key++] . $k, $fdata['daddress']);
             $sheet->setCellValue($alphabet[$key++] . $k, $fdata['dcity']);
             $sheet->setCellValue($alphabet[$key++] . $k, $fdata['dprovince']);
             $sheet->setCellValue($alphabet[$key++] . $k, ' ' . $fdata['dcp']);
             $sheet->setCellValue($alphabet[$key++] . $k, $fdata['country2_name']);
             $sheet->setCellValue($alphabet[$key++] . $k, $fdata['dphone']);
         } else {
             $sheet->setCellValue($alphabet[$key++] . $k, $fdata['name'] . ' ' . $fdata['lastname']);
             $sheet->setCellValue($alphabet[$key++] . $k, $fdata['address']);
             $sheet->setCellValue($alphabet[$key++] . $k, $fdata['city']);
             $sheet->setCellValue($alphabet[$key++] . $k, $fdata['province']);
             $sheet->setCellValue($alphabet[$key++] . $k, ' ' . $fdata['cp']);
             $sheet->setCellValue($alphabet[$key++] . $k, $fdata['country_name']);
             $sheet->setCellValue($alphabet[$key++] . $k, $fdata['phone']);
         }
         $sheet->setCellValue($alphabet[$key++] . $k, $fdata['mail']);
         $sheet->setCellValue($alphabet[$key++] . $k, '');
         $sheet->setCellValue($alphabet[$key++] . $k, '');
         $sheet->setCellValue($alphabet[$key++] . $k, $products);
         $sheet->setCellValue($alphabet[$key++] . $k, $code);
         $sheet->setCellValue($alphabet[$key++] . $k, $dateTime->format('d/m/Y H:i:s'));
         $sheet->setCellValue($alphabet[$key++] . $k, $fdata['taxid'] ? $fdata['taxid'] : $fdata['vat']);
         $sheet->setCellValue($alphabet[$key++] . $k, $fdata['name'] . ' ' . $fdata['lastname']);
         $sheet->setCellValue($alphabet[$key++] . $k, $fdata['address'] . ', ' . $fdata['city'] . ', ' . $fdata['province'] . ', ' . $fdata['cp'] . ', ' . $fdata['country_name']);
         if ($itemInvoice && round($itemInvoice->{$type})) {
             $sheet->setCellValue($alphabet[$key++] . $k, prep_costd($cdata->tax4t - $cdata->tax4, true, false));
             $sheet->setCellValue($alphabet[$key++] . $k, prep_costd($cdata->tax4, true, false));
             $sheet->setCellValue($alphabet[$key++] . $k, prep_costd($cdata->tax10t - $cdata->tax10, true, false));
             $sheet->setCellValue($alphabet[$key++] . $k, prep_costd($cdata->tax10, true, false));
             $sheet->setCellValue($alphabet[$key++] . $k, prep_costd($cdata->tax21t - $cdata->tax21, true, false));
             $sheet->setCellValue($alphabet[$key++] . $k, prep_costd($cdata->tax21, true, false));
         } else {
             $sheet->setCellValue($alphabet[$key++] . $k, '');
             $sheet->setCellValue($alphabet[$key++] . $k, '');
             $sheet->setCellValue($alphabet[$key++] . $k, '');
             $sheet->setCellValue($alphabet[$key++] . $k, '');
             $sheet->setCellValue($alphabet[$key++] . $k, '');
             $sheet->setCellValue($alphabet[$key++] . $k, '');
         }
         $sheet->setCellValue($alphabet[$key++] . $k, prep_costd($cdata->total, true, false));
         $sheet->setCellValue($alphabet[$key++] . $k, prep_costd($cdata->shipping_notax, true, false));
         $sheet->setCellValue($alphabet[$key++] . $k, $categories);
         $k++;
     }
     PHPExcel_Shared_Font::setAutoSizeMethod(PHPExcel_Shared_Font::AUTOSIZE_METHOD_EXACT);
     $objPHPExcel->setActiveSheetIndex(0);
     foreach (range('A', $objPHPExcel->getActiveSheet()->getHighestDataColumn()) as $col) {
         $objPHPExcel->getActiveSheet()->getColumnDimension($col)->setAutoSize(true);
     }
     /*
     		// Redirect output to a client’s web browser (Excel5)
     		header('Content-Type: application/vnd.ms-excel');
     		header('Content-Disposition: attachment;filename="List.xls"');
     		header('Cache-Control: max-age=0');
     		// If you're serving to IE 9, then the following may be needed
     		header('Cache-Control: max-age=1');
     		// If you're serving to IE over SSL, then the following may be needed
     		header ('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); // Date in the past
     		header ('Last-Modified: '.gmdate('D, d M Y H:i:s').' GMT'); // always modified
     		header ('Cache-Control: cache, must-revalidate'); // HTTP/1.1
     		header ('Pragma: public'); // HTTP/1.0*/
     header('Content-Type: application/vnd.ms-excel');
     header('Content-Disposition: attachment;filename="Pedidos.xls"');
     header('Cache-Control: max-age=0');
     // If you're serving to IE 9, then the following may be needed
     header('Cache-Control: max-age=1');
     // If you're serving to IE over SSL, then the following may be needed
     header('Expires: Mon, 26 Jul 1997 05:00:00 GMT');
     // Date in the past
     header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT');
     // always modified
     header('Cache-Control: cache, must-revalidate');
     // HTTP/1.1
     header('Pragma: public');
     // HTTP/1.0
     $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
     $objWriter->save('php://output');
 }
Esempio n. 3
0
 public function ItemCost($cost = 0, $symbol = true)
 {
     return prep_costd($cost, $symbol, false);
 }
Esempio n. 4
0
        }
        ?>
				</div>
			</td>
		</tr>
		<?php 
    }
    ?>
             
		<tr class="row-total">
			<td class="delete"></th>
			<td class="image"></td>
			<td class="name">
				<div class="label">Total</div>
				<div class="cost"><?php 
    echo prep_costd($subtotal);
    ?>
</div>
			</td>
		</tr>
  </tbody>
</table> 
<div class="table-legend">* Shipping cost in the last step</div>
<script>

$(document).ready(function() {
  $('.table-list-cart-section tr').each(function(index, item){
    var dataId = $(this).attr('data-id');

    $('.select-size', item).change(function(e){      
      var data = {};
Esempio n. 5
0
echo prep_costd($fdata['subtotal_notax']);
?>
</div>
</div>
<div class="row rowl">
	<div class="label">Shipping</div>
	<div class="cost"><?php 
echo prep_costd($fdata['shipping_notax']);
?>
</div>
</div>
<?php 
if (round($fdata['desc_notax'])) {
    ?>
<div class="row">
	<div class="label">Discount</div>
	<div class="cost">- <?php 
    echo prep_costd($fdata['desc_notax']);
    ?>
</div>
</div>
<?php 
}
?>
<div class="row rowt">
	<div class="label">Total</div>
	<div class="cost"><?php 
echo prep_costd($fdata['total']);
?>
</div>
</div>