Retour à Forum de programmation

d'erreur jusqu'à

  • diyath
  • Newbie
  • Newbie
  • No Avatar
  • Inscription: Oct 13, 2010
  • Messages: 5
  • Status: Offline

Message Avril 6th, 2011, 1:25 am

J'essaie de créer un fichier Excel en utilisant php, mais ça marche avec une petite quantité d'enregistrer des données mais plus de 400 dossier, il ne fonctionnera pas. Et il donne le temps à l'erreur. S'il vous plaît m'aider à résoudre ce. Mon code ci-dessous

Code: [ Select ]
<?php
session_start();

include_once 'classes/dbcnxn.php';
include_once 'classes/mysql.class.php';
include_once 'classes/fun_userentry.php';
require('gen_excel/Classes/PHPExcel.php');
require('gen_excel/Classes/PHPExcel/IOFactory.php');

if(!logged_in() || ($_SESSION['user_type']!=ADMIN && $_SESSION['user_type']!=DATA_ENTRY))
{
    include_once 'admin_unauthorized.php';
    exit();
}

$objPHPExcel = new PHPExcel();
$db = new MySQLDrives($db_info);

$timezone = new DateTimeZone( "Asia/Colombo" );
$date = new DateTime();
$date->setTimezone( $timezone );

$srch = array('slctyard'=>'', 'scltshpngline'=>'');

if(isset($_REQUEST['slctyard'])){$srch['slctyard'] = $_REQUEST['slctyard'];}
if(isset($_REQUEST['scltshpngline'])){$srch['scltshpngline'] = $_REQUEST['scltshpngline'];}

    $srch_sql     =     'SELECT cnt.* , cntmv.yard_code,cntmv.movement_date, cntmv.vessel, cntmv.vessel_date, DATEDIFF(CURRENT_DATE(),cntmv.movement_date) as strday
FROM
t01_00container_movemant cntmv, m01_00container cnt,
(select MAX(movemant_id) as movemant_id , container_no from m02_00movement_details group by container_no) cntmndtl

WHERE
cntmndtl.container_no = cnt.container_no AND cntmndtl.movemant_id=cntmv.movemant_id
                        AND cnt.status != "N"';
$cnxn = ' AND ';
if($srch['slctyard']!='')
{
    $srch_sql .= $cnxn.' cntmv.yard_code = "'.$srch['slctyard'].'"';
    $cnxn = ' AND ';
}
if($srch['scltshpngline']!='')
{
    $srch_sql .= $cnxn.' cntmv.shippinng_line = "'.$srch['scltshpngline'].'"';
}
$srch_sql .= ' ORDER BY cntmv.yard_code, cntmv.shippinng_line';


$qry_id = $db->query($srch_sql);

/*$rwtype = $db->fetch_all_array("SELECT code FROM m05_00container_type");
foreach($rwtype as $typekey => $typeval)
    {$type[] = $typeval['code'];}
*/    //print_r($type);

/*$rwshpln = $db->fetch_all_array("SELECT contact_id FROM m03_00contacts");
foreach($rwshpln as $shplnkey => $shplnval)
    {$shpln[] = $shplnval['contact_id'];}
*/    //print_r($shpln);

//-------- Start of the Stock Summary-----------------

//$objPHPExcel->getActiveSheet()
//->setTitle(' Stock Report')
//print $srch_sql;
$objWorksheet1 = $objPHPExcel->createSheet(1);
$objWorksheet1->setTitle('Stock Report');

$objPHPExcel->setActiveSheetIndex(1);

//--Start Styles for
$objPHPExcel->getDefaultStyle()->getFont()->setName('Arial');
$objPHPExcel->getDefaultStyle()->getFont()->setSize(8);
$objPHPExcel->getDefaultStyle()->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID)->getStartColor()->setARGB('FFFFFFFF');

$objPHPExcel->getActiveSheet()
->getStyle('C1:F1s')
->getFont()
->setBold(true)
->setSize(13);

$objPHPExcel->getActiveSheet()
->getStyle('B3:M3')
->getFont()
->setBold(true)
->setSize(9);

$objPHPExcel->getActiveSheet()
->getStyle('B5:K5')
->getFont()
->setBold(true)
->setSize(9);

$styleArray = array(
    'borders' => array(
        'outline' => array(
            'style' => PHPExcel_Style_Border::BORDER_THIN,
            'color' => array('argb' => 'FF000000'),
        ),
    ),
);

//--End Styles


$objPHPExcel->getActiveSheet()
->mergeCells('C1:F1')
->setCellValue('C1', 'SEACON CONTAINERS (PVT) LTD')

->mergeCells('B3:C3')
->setCellValue('B3', 'Date : '.$date->format( 'Y-m-d'))

->mergeCells('J3:K3')
->setCellValue('J3', 'Time : '.$date->format( 'h:i:s A'));

$heding = array('Yard Code', 'Shipping Line', 'Container Number', 'Container Type','In Date','Ex Vessel','Ex.Vs. Date', 'Status', 'Grade','Days Stored');
$col = 1; $row = 5;

$objPHPExcel->getActiveSheet()->getStyle('B5:K5')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);

foreach($heding as $hdval)
{
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, $row, $hdval);
    $objPHPExcel->getActiveSheet()->getColumnDimensionByColumn($col)->setAutoSize(true);
    $col++;
}
$objPHPExcel->getActiveSheet()->getStyle('B'.$row.':K'.$row)->getBorders()->getVertical()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$row++;

if($db->affected_rows>0)
{
    $pre_yard_code = '';
    
    while($rwsrch = mysql_fetch_array($qry_id))
    {
        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, $row, strtoupper($rwsrch['yard_code']));
        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(2, $row, strtoupper($db->get_name_byid($rwsrch['contact_id'], 'contact_id','', '', 'company_name', 'm03_00contacts')));
        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(3, $row, strtoupper($rwsrch['container_no']));
        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(4, $row, strtoupper($rwsrch['type']));
        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(5, $row, strtoupper($rwsrch['movement_date']));
        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(6, $row, strtoupper($db->get_name_byid($rwsrch['vessel'], 'vessel_id', '', '', 'name', 'm06_00vessel')));
        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(7, $row, strtoupper($rwsrch['vessel_date']));
        if($rwsrch['status']=='A'){$status = 'Available';}
        if($rwsrch['status']=='B'){$status = 'Block';}
        if($rwsrch['status']=='R'){$status = 'Reserved';}
        if($rwsrch['status']=='D'){$status = 'Damaged';}
        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(8, $row, strtoupper($status));
        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(9, $row, strtoupper($rwsrch['grade']));
        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(10, $row, strtoupper($rwsrch['strday']));
        
        //This array is use for count number of status in each shipping line belongs to yards.
        $sts[$rwsrch['yard_code'].'+'.$rwsrch['contact_id'].'+'.$rwsrch['type']][$rwsrch['status']]++;
        //This array is use for count sub tatal of status in each shipping line belongs to yards.
        $subtot[$rwsrch['yard_code'].'+'.$rwsrch['contact_id']][$rwsrch['status']]++;
        //This array is use for count total of status .
        $grndtot[$rwsrch['status']]++;
        
        $objPHPExcel->getActiveSheet()->getStyle('B'.$row.':K'.$row)->getBorders()->getVertical()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
        $row++;
    }
    $objPHPExcel->getActiveSheet()->getStyle('B'.$row.':K'.$row)->getBorders()->getVertical()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
}
else
{
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, $row, 'No Records Found.');
}

$objPHPExcel->getActiveSheet()
->getStyle('B5:K'.$row)->getFill()
->setFillType(PHPExcel_Style_Fill::FILL_SOLID)
->getStartColor()->setARGB('00E8F3FF');

$objPHPExcel->getActiveSheet()->getStyle('B5:K'.$row)->applyFromArray($styleArray);

//-------- End of the Stock Report ------------------


//-------- Start of the Stock Summary-----------------

/*$objWorksheet1 = $objPHPExcel->createSheet(1);
$objWorksheet1->setTitle('Stock Summary');

$objPHPExcel->setActiveSheetIndex(1);
*/

$objPHPExcel->setActiveSheetIndex(0);
$objPHPExcel->getActiveSheet()->setTitle('Stock Summary');

//--Start Styles for Declaration Report
$objPHPExcel->getDefaultStyle()->getFont()->setName('Arial');
$objPHPExcel->getDefaultStyle()->getFont()->setSize(8);

$objPHPExcel->getActiveSheet()
->getStyle('C1:H1')
->getFont()
->setBold(true)
->setSize(13);

$objPHPExcel->getActiveSheet()
->getStyle('B2:G2')
->getFont()
->setBold(true)
->setSize(9);

$styleArray = array(
    'borders' => array(
        'outline' => array(
            'style' => PHPExcel_Style_Border::BORDER_THIN,
            'color' => array('argb' => 'FF000000'),
        ),
    ),
);

/*$objPHPExcel->getActiveSheet()
->getStyle('A1:Z500')->getFill()
->setFillType(PHPExcel_Style_Fill::FILL_SOLID)
->getStartColor()->setARGB('FFFFFFFF');
*/
//--End Styles

$objPHPExcel->getActiveSheet()
->mergeCells('C1:H1')
->setCellValue('C1', 'SEACON CONTAINERS (PVT) LTD');


$objPHPExcel->getActiveSheet()
->mergeCells('B2:C2')
->setCellValue('B2', 'Date : '.$date->format( 'Y-m-d'))

->mergeCells('F2:G2')
->setCellValue('F2', 'Time : '.$date->format( 'h:i:s A'));

$pre_yard=''; $pre_shpln = ''; $pre_cntype = '';
$col = 1; $row = 4;
//print_r($subtot);
if(!empty($sts))
{
    foreach($sts as $stskey => $stscal)
    {
        //print "<br>".$stskey." => ".$stscal;
        //print_r($stscal);
        //print "<br /><br />";
        if($stscal['A']==''){$stscal['A']='0';}
        if($stscal['B']==''){$stscal['B']='0';}
        if($stscal['R']==''){$stscal['R']='0';}
        if($stscal['D']==''){$stscal['D']='0';}
        
        
        list($yard,$shpline,$cntype) = explode('+',$stskey);
        
        if($pre_yard=='')
        {
            $pre_yard = $yard;
            
            if($clr==0){$bgcolr='00E8F3FF';$clr++;}
            else{$clr=0;$bgcolr='FFFFFFFF';}
            
            $str_row = $row;
            
            $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, $row, 'Yard Code : ');
            $objPHPExcel->getActiveSheet()->getStyleByColumnAndRow($col, $row)->getFont()->setBold(true)->setSize(9);
            $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+1, $row, strtoupper($yard));
            $row++;
            
            $pre_shpln=$shpline;
            $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, $row, 'Shipping Line : ');
            $objPHPExcel->getActiveSheet()->getStyleByColumnAndRow($col, $row)->getFont()->setBold(true)->setSize(9);
            $objPHPExcel->getActiveSheet()->getColumnDimensionByColumn($col)->setAutoSize(true);
            $objPHPExcel->getActiveSheet()->mergeCells('C'.$row.':G'.$row.'');
            
            $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+1, $row, strtoupper($db->get_name_byid($shpline, 'contact_id','', '', 'company_name', 'm03_00contacts')));
            $row+=2;
            
            $objPHPExcel->getActiveSheet()->getStyle('C'.$row.':G'.$row)->getFont()->setBold(true)->setSize(8);
            $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+1, $row, 'Type');
            $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+2, $row, 'Available');
            $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+3, $row, 'Block');
            $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+4, $row, 'Reserved');
            $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+5, $row, 'Damaged');
            $row++;
            
            $pre_cntype=$cntype;
            $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+1, $row, $cntype);
            $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+2, $row, $stscal['A']);
            $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+3, $row, $stscal['B']);
            $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+4, $row, $stscal['R']);
            $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+5, $row, $stscal['D']);
            $row++;
        }
        elseif($pre_yard!=$yard)
        {
            $objPHPExcel->getActiveSheet()->getStyle('C'.$row.':G'.$row)->getFont()->setBold(true)->setSize(8);
            $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+1, $row, 'SUB TOTAL');
            $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+2, $row, $subtot[$pre_yard.'+'.$pre_shpln]['A']);
            $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+3, $row, $subtot[$pre_yard.'+'.$pre_shpln]['B']);
            $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+4, $row, $subtot[$pre_yard.'+'.$pre_shpln]['R']);
            $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+5, $row, $subtot[$pre_yard.'+'.$pre_shpln]['D']);
            $row++;
            $end_row = $row;
            
            $objPHPExcel->getActiveSheet()->getStyle('B'.$str_row.':G'.$end_row)->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID)->getStartColor()->setARGB($bgcolr);    
    
            $pre_yard = $yard;
            $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, $row, '');
            $row++;
            
            if($clr==0){$bgcolr='00E8F3FF';$clr++;}
            else{$clr=0;$bgcolr='FFFFFFFF';}
            
            $str_row = $row;
            
            $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, $row, 'Yard Code : ');
            $objPHPExcel->getActiveSheet()->getStyleByColumnAndRow($col, $row)->getFont()->setBold(true)->setSize(9);
            $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+1, $row,strtoupper( $yard));
            $row++;
            
            $pre_shpln=$shpline;
            $objPHPExcel->getActiveSheet()->mergeCells('C'.$row.':G'.$row.'');
            $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, $row, 'Shipping Line : ');
            $objPHPExcel->getActiveSheet()->getStyleByColumnAndRow($col, $row)->getFont()->setBold(true)->setSize(9);
            $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+1, $row, strtoupper($db->get_name_byid($shpline, 'contact_id','', '', 'company_name', 'm03_00contacts')));
            $row+=2;
            
            $objPHPExcel->getActiveSheet()->getStyle('C'.$row.':G'.$row)->getFont()->setBold(true)->setSize(8);
            $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+1, $row, 'Type');
            $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+2, $row, 'Available');
            $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+3, $row, 'Block');
            $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+4, $row, 'Reserved');
            $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+5, $row, 'Damaged');
            $row++;
            
            $pre_cntype=$cntype;
            $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+1, $row, $cntype);
            $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+2, $row, $stscal['A']);
            $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+3, $row, $stscal['B']);
            $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+4, $row, $stscal['R']);
            $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+5, $row, $stscal['D']);
            $row++;
        }
        else
        {
            if($pre_shpln!=$shpline)
            {
            $objPHPExcel->getActiveSheet()->getStyle('C'.$row.':G'.$row)->getFont()->setBold(true)->setSize(8);
                $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+1, $row, 'SUB TOTAL');
                $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+2, $row, $subtot[$pre_yard.'+'.$pre_shpln]['A']);
                $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+3, $row, $subtot[$pre_yard.'+'.$pre_shpln]['B']);
                $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+4, $row, $subtot[$pre_yard.'+'.$pre_shpln]['R']);
                $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+5, $row, $subtot[$pre_yard.'+'.$pre_shpln]['D']);
                $row++;
            
                $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+2, $row, '');
                $row++;
                $end_row = $row;
            
                $objPHPExcel->getActiveSheet()->getStyle('B'.$str_row.':G'.$end_row)->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID)->getStartColor()->setARGB($bgcolr);    
    
                $pre_shpln=$shpline;
                $objPHPExcel->getActiveSheet()->mergeCells('C'.$row.':G'.$row.'');
                $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, $row, 'Shipping Line : ');
            $objPHPExcel->getActiveSheet()->getStyleByColumnAndRow($col, $row)->getFont()->setBold(true)->setSize(9);
                $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+1, $row, strtoupper($db->get_name_byid($shpline, 'contact_id','', '', 'company_name', 'm03_00contacts')));
                $row+=2;
                
            $objPHPExcel->getActiveSheet()->getStyle('C'.$row.':G'.$row)->getFont()->setBold(true)->setSize(8);
                $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+1, $row, 'Type');
                $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+2, $row, 'Available');
                $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+3, $row, 'Block');
                $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+4, $row, 'Reserved');
                $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+5, $row, 'Damaged');
                $objPHPExcel->getActiveSheet()->getStyle($col, $row)->getFont()->setBold(true)->setSize(9);
                $row++;
                
                $pre_cntype=$cntype;
                $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+1, $row, $cntype);
                $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+2, $row, $stscal['A']);
                $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+3, $row, $stscal['B']);
                $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+4, $row, $stscal['R']);
                $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+5, $row, $stscal['D']);
                $row++;
            }
            else
            {
                if($pre_cntype!=$cntype)
                {
                    $pre_cntype=$cntype;
                    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+1, $row, $cntype);
                    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+2, $row, $stscal['A']);
                    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+3, $row, $stscal['B']);
                    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+4, $row, $stscal['R']);
                    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+5, $row, $stscal['D']);
                    $row++;
                }
            }
        }
    }
    
    $objPHPExcel->getActiveSheet()->getStyle('C'.$row.':G'.$row)->getFont()->setBold(true)->setSize(8);
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+1, $row, 'SUB TOTAL');
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+2, $row, $subtot[$pre_yard.'+'.$pre_shpln]['A']);
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+3, $row, $subtot[$pre_yard.'+'.$pre_shpln]['B']);
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+4, $row, $subtot[$pre_yard.'+'.$pre_shpln]['R']);
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+5, $row, $subtot[$pre_yard.'+'.$pre_shpln]['D']);
    $row+=2;
    $end_row = $row;
            
    $objPHPExcel->getActiveSheet()->getStyle('B'.$str_row.':G'.$end_row)->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID)->getStartColor()->setARGB($bgcolr);    
    
    $objPHPExcel->getActiveSheet()->getStyle('C'.$row.':G'.$row)->getFont()->setBold(true)->setSize(9);
    
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+1, $row, 'GRAND TOTAL');
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+2, $row, $grndtot['A']);
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+3, $row, $grndtot['B']);
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+4, $row, $grndtot['R']);
    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+5, $row, $grndtot['D']);
    $objPHPExcel->getActiveSheet()->getColumnDimensionByColumn($col+1)->setAutoSize(true);
}

$objPHPExcel->getActiveSheet()->getStyle('before:G'.$row)->applyFromArray($styleArray);

header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment;filename="stock_report.xls"');
header('Cache-Control: max-age=0');

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');
?>
  1. <?php
  2. session_start();
  4. include_once 'classes/dbcnxn.php';
  5. include_once 'classes/mysql.class.php';
  6. include_once 'classes/fun_userentry.php';
  7. require('gen_excel/Classes/PHPExcel.php');
  8. require('gen_excel/Classes/PHPExcel/IOFactory.php');
  10. if(!logged_in() || ($_SESSION['user_type']!=ADMIN && $_SESSION['user_type']!=DATA_ENTRY))
  11. {
  12.     include_once 'admin_unauthorized.php';
  13.     exit();
  14. }
  16. $objPHPExcel = new PHPExcel();
  17. $db = new MySQLDrives($db_info);
  19. $timezone = new DateTimeZone( "Asia/Colombo" );
  20. $date = new DateTime();
  21. $date->setTimezone( $timezone );
  23. $srch = array('slctyard'=>'', 'scltshpngline'=>'');
  25. if(isset($_REQUEST['slctyard'])){$srch['slctyard'] = $_REQUEST['slctyard'];}
  26. if(isset($_REQUEST['scltshpngline'])){$srch['scltshpngline'] = $_REQUEST['scltshpngline'];}
  28.     $srch_sql     =     'SELECT cnt.* , cntmv.yard_code,cntmv.movement_date, cntmv.vessel, cntmv.vessel_date, DATEDIFF(CURRENT_DATE(),cntmv.movement_date) as strday
  29. FROM
  30. t01_00container_movemant cntmv, m01_00container cnt,
  31. (select MAX(movemant_id) as movemant_id , container_no from m02_00movement_details group by container_no) cntmndtl
  33. WHERE
  34. cntmndtl.container_no = cnt.container_no AND cntmndtl.movemant_id=cntmv.movemant_id
  35.                         AND cnt.status != "N"';
  36. $cnxn = ' AND ';
  37. if($srch['slctyard']!='')
  38. {
  39.     $srch_sql .= $cnxn.' cntmv.yard_code = "'.$srch['slctyard'].'"';
  40.     $cnxn = ' AND ';
  41. }
  42. if($srch['scltshpngline']!='')
  43. {
  44.     $srch_sql .= $cnxn.' cntmv.shippinng_line = "'.$srch['scltshpngline'].'"';
  45. }
  46. $srch_sql .= ' ORDER BY cntmv.yard_code, cntmv.shippinng_line';
  49. $qry_id = $db->query($srch_sql);
  51. /*$rwtype = $db->fetch_all_array("SELECT code FROM m05_00container_type");
  52. foreach($rwtype as $typekey => $typeval)
  53.     {$type[] = $typeval['code'];}
  54. */    //print_r($type);
  56. /*$rwshpln = $db->fetch_all_array("SELECT contact_id FROM m03_00contacts");
  57. foreach($rwshpln as $shplnkey => $shplnval)
  58.     {$shpln[] = $shplnval['contact_id'];}
  59. */    //print_r($shpln);
  61. //-------- Start of the Stock Summary-----------------
  63. //$objPHPExcel->getActiveSheet()
  64. //->setTitle(' Stock Report')
  65. //print $srch_sql;
  66. $objWorksheet1 = $objPHPExcel->createSheet(1);
  67. $objWorksheet1->setTitle('Stock Report');
  69. $objPHPExcel->setActiveSheetIndex(1);
  71. //--Start Styles for
  72. $objPHPExcel->getDefaultStyle()->getFont()->setName('Arial');
  73. $objPHPExcel->getDefaultStyle()->getFont()->setSize(8);
  74. $objPHPExcel->getDefaultStyle()->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID)->getStartColor()->setARGB('FFFFFFFF');
  76. $objPHPExcel->getActiveSheet()
  77. ->getStyle('C1:F1s')
  78. ->getFont()
  79. ->setBold(true)
  80. ->setSize(13);
  82. $objPHPExcel->getActiveSheet()
  83. ->getStyle('B3:M3')
  84. ->getFont()
  85. ->setBold(true)
  86. ->setSize(9);
  88. $objPHPExcel->getActiveSheet()
  89. ->getStyle('B5:K5')
  90. ->getFont()
  91. ->setBold(true)
  92. ->setSize(9);
  94. $styleArray = array(
  95.     'borders' => array(
  96.         'outline' => array(
  97.             'style' => PHPExcel_Style_Border::BORDER_THIN,
  98.             'color' => array('argb' => 'FF000000'),
  99.         ),
  100.     ),
  101. );
  103. //--End Styles
  106. $objPHPExcel->getActiveSheet()
  107. ->mergeCells('C1:F1')
  108. ->setCellValue('C1', 'SEACON CONTAINERS (PVT) LTD')
  110. ->mergeCells('B3:C3')
  111. ->setCellValue('B3', 'Date : '.$date->format( 'Y-m-d'))
  113. ->mergeCells('J3:K3')
  114. ->setCellValue('J3', 'Time : '.$date->format( 'h:i:s A'));
  116. $heding = array('Yard Code', 'Shipping Line', 'Container Number', 'Container Type','In Date','Ex Vessel','Ex.Vs. Date', 'Status', 'Grade','Days Stored');
  117. $col = 1; $row = 5;
  119. $objPHPExcel->getActiveSheet()->getStyle('B5:K5')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
  121. foreach($heding as $hdval)
  122. {
  123.     $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, $row, $hdval);
  124.     $objPHPExcel->getActiveSheet()->getColumnDimensionByColumn($col)->setAutoSize(true);
  125.     $col++;
  126. }
  127. $objPHPExcel->getActiveSheet()->getStyle('B'.$row.':K'.$row)->getBorders()->getVertical()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
  128. $row++;
  130. if($db->affected_rows>0)
  131. {
  132.     $pre_yard_code = '';
  133.     
  134.     while($rwsrch = mysql_fetch_array($qry_id))
  135.     {
  136.         $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, $row, strtoupper($rwsrch['yard_code']));
  137.         $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(2, $row, strtoupper($db->get_name_byid($rwsrch['contact_id'], 'contact_id','', '', 'company_name', 'm03_00contacts')));
  138.         $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(3, $row, strtoupper($rwsrch['container_no']));
  139.         $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(4, $row, strtoupper($rwsrch['type']));
  140.         $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(5, $row, strtoupper($rwsrch['movement_date']));
  141.         $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(6, $row, strtoupper($db->get_name_byid($rwsrch['vessel'], 'vessel_id', '', '', 'name', 'm06_00vessel')));
  142.         $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(7, $row, strtoupper($rwsrch['vessel_date']));
  143.         if($rwsrch['status']=='A'){$status = 'Available';}
  144.         if($rwsrch['status']=='B'){$status = 'Block';}
  145.         if($rwsrch['status']=='R'){$status = 'Reserved';}
  146.         if($rwsrch['status']=='D'){$status = 'Damaged';}
  147.         $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(8, $row, strtoupper($status));
  148.         $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(9, $row, strtoupper($rwsrch['grade']));
  149.         $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(10, $row, strtoupper($rwsrch['strday']));
  150.         
  151.         //This array is use for count number of status in each shipping line belongs to yards.
  152.         $sts[$rwsrch['yard_code'].'+'.$rwsrch['contact_id'].'+'.$rwsrch['type']][$rwsrch['status']]++;
  153.         //This array is use for count sub tatal of status in each shipping line belongs to yards.
  154.         $subtot[$rwsrch['yard_code'].'+'.$rwsrch['contact_id']][$rwsrch['status']]++;
  155.         //This array is use for count total of status .
  156.         $grndtot[$rwsrch['status']]++;
  157.         
  158.         $objPHPExcel->getActiveSheet()->getStyle('B'.$row.':K'.$row)->getBorders()->getVertical()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
  159.         $row++;
  160.     }
  161.     $objPHPExcel->getActiveSheet()->getStyle('B'.$row.':K'.$row)->getBorders()->getVertical()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
  162. }
  163. else
  164. {
  165.     $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, $row, 'No Records Found.');
  166. }
  168. $objPHPExcel->getActiveSheet()
  169. ->getStyle('B5:K'.$row)->getFill()
  170. ->setFillType(PHPExcel_Style_Fill::FILL_SOLID)
  171. ->getStartColor()->setARGB('00E8F3FF');
  173. $objPHPExcel->getActiveSheet()->getStyle('B5:K'.$row)->applyFromArray($styleArray);
  175. //-------- End of the Stock Report ------------------
  178. //-------- Start of the Stock Summary-----------------
  180. /*$objWorksheet1 = $objPHPExcel->createSheet(1);
  181. $objWorksheet1->setTitle('Stock Summary');
  183. $objPHPExcel->setActiveSheetIndex(1);
  184. */
  186. $objPHPExcel->setActiveSheetIndex(0);
  187. $objPHPExcel->getActiveSheet()->setTitle('Stock Summary');
  189. //--Start Styles for Declaration Report
  190. $objPHPExcel->getDefaultStyle()->getFont()->setName('Arial');
  191. $objPHPExcel->getDefaultStyle()->getFont()->setSize(8);
  193. $objPHPExcel->getActiveSheet()
  194. ->getStyle('C1:H1')
  195. ->getFont()
  196. ->setBold(true)
  197. ->setSize(13);
  199. $objPHPExcel->getActiveSheet()
  200. ->getStyle('B2:G2')
  201. ->getFont()
  202. ->setBold(true)
  203. ->setSize(9);
  205. $styleArray = array(
  206.     'borders' => array(
  207.         'outline' => array(
  208.             'style' => PHPExcel_Style_Border::BORDER_THIN,
  209.             'color' => array('argb' => 'FF000000'),
  210.         ),
  211.     ),
  212. );
  214. /*$objPHPExcel->getActiveSheet()
  215. ->getStyle('A1:Z500')->getFill()
  216. ->setFillType(PHPExcel_Style_Fill::FILL_SOLID)
  217. ->getStartColor()->setARGB('FFFFFFFF');
  218. */
  219. //--End Styles
  221. $objPHPExcel->getActiveSheet()
  222. ->mergeCells('C1:H1')
  223. ->setCellValue('C1', 'SEACON CONTAINERS (PVT) LTD');
  226. $objPHPExcel->getActiveSheet()
  227. ->mergeCells('B2:C2')
  228. ->setCellValue('B2', 'Date : '.$date->format( 'Y-m-d'))
  230. ->mergeCells('F2:G2')
  231. ->setCellValue('F2', 'Time : '.$date->format( 'h:i:s A'));
  233. $pre_yard=''; $pre_shpln = ''; $pre_cntype = '';
  234. $col = 1; $row = 4;
  235. //print_r($subtot);
  236. if(!empty($sts))
  237. {
  238.     foreach($sts as $stskey => $stscal)
  239.     {
  240.         //print "<br>".$stskey." => ".$stscal;
  241.         //print_r($stscal);
  242.         //print "<br /><br />";
  243.         if($stscal['A']==''){$stscal['A']='0';}
  244.         if($stscal['B']==''){$stscal['B']='0';}
  245.         if($stscal['R']==''){$stscal['R']='0';}
  246.         if($stscal['D']==''){$stscal['D']='0';}
  247.         
  248.         
  249.         list($yard,$shpline,$cntype) = explode('+',$stskey);
  250.         
  251.         if($pre_yard=='')
  252.         {
  253.             $pre_yard = $yard;
  254.             
  255.             if($clr==0){$bgcolr='00E8F3FF';$clr++;}
  256.             else{$clr=0;$bgcolr='FFFFFFFF';}
  257.             
  258.             $str_row = $row;
  259.             
  260.             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, $row, 'Yard Code : ');
  261.             $objPHPExcel->getActiveSheet()->getStyleByColumnAndRow($col, $row)->getFont()->setBold(true)->setSize(9);
  262.             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+1, $row, strtoupper($yard));
  263.             $row++;
  264.             
  265.             $pre_shpln=$shpline;
  266.             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, $row, 'Shipping Line : ');
  267.             $objPHPExcel->getActiveSheet()->getStyleByColumnAndRow($col, $row)->getFont()->setBold(true)->setSize(9);
  268.             $objPHPExcel->getActiveSheet()->getColumnDimensionByColumn($col)->setAutoSize(true);
  269.             $objPHPExcel->getActiveSheet()->mergeCells('C'.$row.':G'.$row.'');
  270.             
  271.             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+1, $row, strtoupper($db->get_name_byid($shpline, 'contact_id','', '', 'company_name', 'm03_00contacts')));
  272.             $row+=2;
  273.             
  274.             $objPHPExcel->getActiveSheet()->getStyle('C'.$row.':G'.$row)->getFont()->setBold(true)->setSize(8);
  275.             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+1, $row, 'Type');
  276.             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+2, $row, 'Available');
  277.             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+3, $row, 'Block');
  278.             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+4, $row, 'Reserved');
  279.             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+5, $row, 'Damaged');
  280.             $row++;
  281.             
  282.             $pre_cntype=$cntype;
  283.             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+1, $row, $cntype);
  284.             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+2, $row, $stscal['A']);
  285.             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+3, $row, $stscal['B']);
  286.             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+4, $row, $stscal['R']);
  287.             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+5, $row, $stscal['D']);
  288.             $row++;
  289.         }
  290.         elseif($pre_yard!=$yard)
  291.         {
  292.             $objPHPExcel->getActiveSheet()->getStyle('C'.$row.':G'.$row)->getFont()->setBold(true)->setSize(8);
  293.             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+1, $row, 'SUB TOTAL');
  294.             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+2, $row, $subtot[$pre_yard.'+'.$pre_shpln]['A']);
  295.             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+3, $row, $subtot[$pre_yard.'+'.$pre_shpln]['B']);
  296.             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+4, $row, $subtot[$pre_yard.'+'.$pre_shpln]['R']);
  297.             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+5, $row, $subtot[$pre_yard.'+'.$pre_shpln]['D']);
  298.             $row++;
  299.             $end_row = $row;
  300.             
  301.             $objPHPExcel->getActiveSheet()->getStyle('B'.$str_row.':G'.$end_row)->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID)->getStartColor()->setARGB($bgcolr);    
  302.     
  303.             $pre_yard = $yard;
  304.             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, $row, '');
  305.             $row++;
  306.             
  307.             if($clr==0){$bgcolr='00E8F3FF';$clr++;}
  308.             else{$clr=0;$bgcolr='FFFFFFFF';}
  309.             
  310.             $str_row = $row;
  311.             
  312.             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, $row, 'Yard Code : ');
  313.             $objPHPExcel->getActiveSheet()->getStyleByColumnAndRow($col, $row)->getFont()->setBold(true)->setSize(9);
  314.             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+1, $row,strtoupper( $yard));
  315.             $row++;
  316.             
  317.             $pre_shpln=$shpline;
  318.             $objPHPExcel->getActiveSheet()->mergeCells('C'.$row.':G'.$row.'');
  319.             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, $row, 'Shipping Line : ');
  320.             $objPHPExcel->getActiveSheet()->getStyleByColumnAndRow($col, $row)->getFont()->setBold(true)->setSize(9);
  321.             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+1, $row, strtoupper($db->get_name_byid($shpline, 'contact_id','', '', 'company_name', 'm03_00contacts')));
  322.             $row+=2;
  323.             
  324.             $objPHPExcel->getActiveSheet()->getStyle('C'.$row.':G'.$row)->getFont()->setBold(true)->setSize(8);
  325.             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+1, $row, 'Type');
  326.             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+2, $row, 'Available');
  327.             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+3, $row, 'Block');
  328.             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+4, $row, 'Reserved');
  329.             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+5, $row, 'Damaged');
  330.             $row++;
  331.             
  332.             $pre_cntype=$cntype;
  333.             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+1, $row, $cntype);
  334.             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+2, $row, $stscal['A']);
  335.             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+3, $row, $stscal['B']);
  336.             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+4, $row, $stscal['R']);
  337.             $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+5, $row, $stscal['D']);
  338.             $row++;
  339.         }
  340.         else
  341.         {
  342.             if($pre_shpln!=$shpline)
  343.             {
  344.             $objPHPExcel->getActiveSheet()->getStyle('C'.$row.':G'.$row)->getFont()->setBold(true)->setSize(8);
  345.                 $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+1, $row, 'SUB TOTAL');
  346.                 $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+2, $row, $subtot[$pre_yard.'+'.$pre_shpln]['A']);
  347.                 $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+3, $row, $subtot[$pre_yard.'+'.$pre_shpln]['B']);
  348.                 $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+4, $row, $subtot[$pre_yard.'+'.$pre_shpln]['R']);
  349.                 $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+5, $row, $subtot[$pre_yard.'+'.$pre_shpln]['D']);
  350.                 $row++;
  351.             
  352.                 $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+2, $row, '');
  353.                 $row++;
  354.                 $end_row = $row;
  355.             
  356.                 $objPHPExcel->getActiveSheet()->getStyle('B'.$str_row.':G'.$end_row)->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID)->getStartColor()->setARGB($bgcolr);    
  357.     
  358.                 $pre_shpln=$shpline;
  359.                 $objPHPExcel->getActiveSheet()->mergeCells('C'.$row.':G'.$row.'');
  360.                 $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, $row, 'Shipping Line : ');
  361.             $objPHPExcel->getActiveSheet()->getStyleByColumnAndRow($col, $row)->getFont()->setBold(true)->setSize(9);
  362.                 $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+1, $row, strtoupper($db->get_name_byid($shpline, 'contact_id','', '', 'company_name', 'm03_00contacts')));
  363.                 $row+=2;
  364.                 
  365.             $objPHPExcel->getActiveSheet()->getStyle('C'.$row.':G'.$row)->getFont()->setBold(true)->setSize(8);
  366.                 $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+1, $row, 'Type');
  367.                 $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+2, $row, 'Available');
  368.                 $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+3, $row, 'Block');
  369.                 $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+4, $row, 'Reserved');
  370.                 $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+5, $row, 'Damaged');
  371.                 $objPHPExcel->getActiveSheet()->getStyle($col, $row)->getFont()->setBold(true)->setSize(9);
  372.                 $row++;
  373.                 
  374.                 $pre_cntype=$cntype;
  375.                 $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+1, $row, $cntype);
  376.                 $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+2, $row, $stscal['A']);
  377.                 $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+3, $row, $stscal['B']);
  378.                 $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+4, $row, $stscal['R']);
  379.                 $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+5, $row, $stscal['D']);
  380.                 $row++;
  381.             }
  382.             else
  383.             {
  384.                 if($pre_cntype!=$cntype)
  385.                 {
  386.                     $pre_cntype=$cntype;
  387.                     $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+1, $row, $cntype);
  388.                     $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+2, $row, $stscal['A']);
  389.                     $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+3, $row, $stscal['B']);
  390.                     $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+4, $row, $stscal['R']);
  391.                     $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+5, $row, $stscal['D']);
  392.                     $row++;
  393.                 }
  394.             }
  395.         }
  396.     }
  397.     
  398.     $objPHPExcel->getActiveSheet()->getStyle('C'.$row.':G'.$row)->getFont()->setBold(true)->setSize(8);
  399.     $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+1, $row, 'SUB TOTAL');
  400.     $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+2, $row, $subtot[$pre_yard.'+'.$pre_shpln]['A']);
  401.     $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+3, $row, $subtot[$pre_yard.'+'.$pre_shpln]['B']);
  402.     $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+4, $row, $subtot[$pre_yard.'+'.$pre_shpln]['R']);
  403.     $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+5, $row, $subtot[$pre_yard.'+'.$pre_shpln]['D']);
  404.     $row+=2;
  405.     $end_row = $row;
  406.             
  407.     $objPHPExcel->getActiveSheet()->getStyle('B'.$str_row.':G'.$end_row)->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID)->getStartColor()->setARGB($bgcolr);    
  408.     
  409.     $objPHPExcel->getActiveSheet()->getStyle('C'.$row.':G'.$row)->getFont()->setBold(true)->setSize(9);
  410.     
  411.     $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+1, $row, 'GRAND TOTAL');
  412.     $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+2, $row, $grndtot['A']);
  413.     $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+3, $row, $grndtot['B']);
  414.     $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+4, $row, $grndtot['R']);
  415.     $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col+5, $row, $grndtot['D']);
  416.     $objPHPExcel->getActiveSheet()->getColumnDimensionByColumn($col+1)->setAutoSize(true);
  417. }
  419. $objPHPExcel->getActiveSheet()->getStyle('before:G'.$row)->applyFromArray($styleArray);
  421. header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
  422. header('Content-Disposition: attachment;filename="stock_report.xls"');
  423. header('Cache-Control: max-age=0');
  425. $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
  426. $objWriter->save('php://output');
  427. ?>
  • Anonymous
  • Bot
  • No Avatar
  • Inscription: 25 Feb 2008
  • Messages: ?
  • Loc: Ozzuland
  • Status: Online

Message Avril 6th, 2011, 1:25 am

  • dark_lord
  • Graduate
  • Graduate
  • Avatar de l’utilisateur
  • Inscription: Jan 14, 2009
  • Messages: 162
  • Loc: India-Kolkata
  • Status: Offline

Message Avril 6th, 2011, 11:44 am

et ce n'est évidemment pas possible de vérifier, ce que je crois, puisque vous êtes capable de faire avec des données petites, le code est réalisable, ce que vous pouvez faire est de diviser les gros fichiers en petits morceaux et continuer sur le fonctionnement ou augmenter le délai d'attente secondes.
Wrap Up your Big Url | Mariana World Community
  • SpooF
  • ٩๏̯͡๏۶
  • Bronze Member
  • Avatar de l’utilisateur
  • Inscription: Mai 22, 2004
  • Messages: 3415
  • Loc: Richland, WA
  • Status: Offline

Message Avril 6th, 2011, 1:22 pm

Je suppose que c'est votre course dans une limite de mémoire ou d'un problème de temps d'exécution.

Whats le plus de données que vous pouvez faire sans le gel sur vous et combien de temps cela prend-il?
#define NULL (::rand() % 2)

Page 1 sur 1

Afficher de l'information

  • Total des messages de ce sujet: 3 messages
  • Utilisateurs parcourant ce forum: Aucun utilisateur enregistré et 262 invités
  • Vous ne pouvez pas poster de nouveaux sujets
  • Vous ne pouvez pas répondre aux sujets
  • Vous ne pouvez pas éditer vos messages
  • Vous ne pouvez pas supprimer vos messages
  • Vous ne pouvez pas joindre des fichiers
 
 

© 2011 Unmelted, LLC. Ozzu® est une marque déposée de Unmelted, LLC