Ejemplos de FetchAssoc en PHP

Ejemplo n.º 1

Archivo: list_orders.php Proyecto: exp-nazeem/financial

        $statusflag = ' o.status, ';
    }
    $query = "SELECT o.id, o.order_no,{$statusflag} u.first_name, DATE_FORMAT(o.created_date , " . SHORT_DATE_WITHTIME . " ) as order_date,o.credit, o.created_by FROM `[x]order` o ,`[x]user` u  WHERE o.created_by = u.id " . $extra . " {$statusCondition} ORDER BY o.id desc";
    $tpl->AssignValue("qry", $query);
}
$q = new splitResults($query);
$orders[] = '';
if (isset($_GET['page']) && $_GET['page'] != 1) {
    $i = ($_GET['page'] - 1) * 10 + 1;
} else {
    $i = 1;
}
$count = 0;
if (Num($q->out)) {
    $tpl->Zone("export", "enabled");
    while ($r = FetchAssoc($q->out)) {
        $r['slno'] = $i;
        if ($i % 2 == 0) {
            $r['class'] = "two";
        } else {
            $r['class'] = "one";
        }
        $r['fname'] = $order->getordermadeby($r['id'], 'name');
        $status = $order->getstatusname($order->getcurrentorderstatus($r['id']));
        $order_status = $order->getcurrentorderstatus($r['id']);
        if ($order_status == 8 || $order_status == 9 || $order_status == 10) {
            $r['display'] = "block";
        } else {
            $r['display'] = "none";
        }
        $r['currentstatus'] = $status['status'];

Ejemplo n.º 2

Archivo: export_order.php Proyecto: exp-nazeem/financial

$objPHPExcel->getActiveSheet()->getStyle('D1:H1')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('A1:L1')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet()->getStyle('A1:L1')->getFill()->getStartColor()->setARGB('FF146ac1');
$objPHPExcel->getActiveSheet()->getStyle('D2:H2')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet()->getStyle('D2:H2')->getFill()->getStartColor()->setARGB('FF146ac1');
$objPHPExcel->getActiveSheet()->getStyle('A1:L1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_WHITE);
$objPHPExcel->getActiveSheet()->getStyle('D2:H2')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_WHITE);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(30);
$objPHPExcel->getActiveSheet()->getColumnDimension('I')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('J')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('K')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('L')->setWidth(20);
$i = 1;
$row = 3;
while ($export = FetchAssoc($query)) {
    $status = $order->getstatusname($order->getcurrentorderstatus($export['id']));
    $products = $order->getproductsreport($export['id']);
    if ($export['credit'] == 0) {
        $creditby = "Zone";
    } else {
        $creditby = $order->getuserfirstname($export['credit']);
    }
    $total = $order->gettotal($export['id']);
    $status = $status['status'];
    $onum = ' ' . $export['order_no'];
    $objPHPExcel->getActiveSheet()->setCellValue('A' . $row, $i)->setCellValue('B' . $row, $onum)->setCellValue('C' . $row, $export['order_date']);
    $pr = 0;
    foreach ($products as $p) {
        $objPHPExcel->getActiveSheet()->setCellValue('D' . $row, $p['name'])->setCellValue('E' . $row, $p['carton_no'])->setCellValue('F' . $row, $p['quantity'])->setCellValue('G' . $row, number_format($p['rate'], 2))->setCellValue('H' . $row, '=F' . $row . '*G' . $row);
        $objPHPExcel->getActiveSheet()->setCellValue('J' . $row, $export['first_name'])->setCellValue('K' . $row, $status)->setCellValue('L' . $row, $creditby);