PHP convert::toexcel Examples

Example #1

File: ljo.php Project: Presh/branch_for_Kenneth

    if (!empty($jobNumFrm) && empty($jobNumTom)) {
        $condition = $condition . $andRule . " jobOrder_jobNum>=" . $jobNumFrm;
    } else {
        if (empty($jobNumFrm) && !empty($jobNumTom)) {
            $condition = $condition . $andRule . " jobOrder_jobNum<=" . $jobNumTom;
        } else {
            $condition = $condition;
        }
    }
}
$xcelCondition = $condition . " ORDER BY jobOrder_jobNum ASC";
// excel file name
$filesname = "list_of_job_orders.xls";
// excel workbook sheet name
$sheetname = "list_of_job_orders";
$excel = convert::toexcel($filesname, $sheetname);
// for header
$infoHeader = array($header);
$excel->writeLine($infoHeader);
$whiteSpace = array("");
$excel->writeLine($whiteSpace);
$jo_dselect = "\r\n\t\t\t\t\t\t\tjoborder.jobOrder_id,\r\n\t\t\t\t\t\t\tjoborder.jobOrder_Branch,\r\n\t\t\t\t\t\t\tjoborder.jobOrder_clientNum,\r\n\t\t\t\t\t\t\tjoborder.jobOrder_jobNum";
$list = $pdo_sql->fetchAll($dbtable = "joborder", $jo_dselect, $xcelCondition);
$countList = $pdo_sql->count($dbtable = "joborder", $jo_dselect, $xcelCondition);
if (count($list) >= 1) {
    $joListNum = '';
    foreach ($list as $listKey => $listVal) {
        // get the necessary data from the database
        $jobOrderId = $listVal['jobOrder_id'];
        $listBranch = $listVal['jobOrder_Branch'];
        $listCnumber = $listVal['jobOrder_clientNum'];