PHP oos_date_order_stat Exemples

Exemple #1

Fichier : stats_recover_cart_sales.php Projet : BackupTheBerlios/oos-svn

    $sql1 = "SELECT c.customers_firstname, c.customers_lastname FROM {$customerstable} c WHERE c.customers_id = '" . $cid . "'";
    $result1 = $dbconn->Execute($sql1);
    $crec = $result1->fields;
    // Query DB for the FIRST order that matches this customer ID and came after the abandoned cart
    $orderstable = $oostable['orders'];
    $orders_totaltable = $oostable['orders_total'];
    $orders_statustable = $oostable['orders_status'];
    $orders_sql = "SELECT o.orders_id, o.customers_id, o.date_purchased,\n                          s.orders_status_name, ot.text as order_total, ot.value\n                     FROM {$orderstable} o\n                LEFT JOIN {$orders_totaltable} ot ON (o.orders_id = ot.orders_id),\n                          {$orders_statustable} s\n                    WHERE (o.customers_id = '" . (int) $cid . "'\n                       OR o.customers_email_address like '" . $crec['customers_email_address'] . "'\n                       OR o.customers_name like '" . $crec['customers_firstname'] . ' ' . $crec['customers_lastname'] . "')\n                      AND o.orders_status > " . RCS_PENDING_SALE_STATUS . "\n                      AND o.orders_status = s.orders_status_id\n                      AND o.date_purchased >= '" . $inrec['recovercartsales_date_added'] . "'\n                      AND ot.class = 'ot_total'";
    $orders_result = $dbconn->Execute($orders_sql);
    $orders = $orders_result->fields;
    // If we got a match, create the table entry to display the information
    if (isset($orders) && !empty($orders)) {
        $custknt++;
        $total_recovered += $orders['value'];
        $custknt % 2 ? $class = RCS_REPORT_EVEN_STYLE : ($class = RCS_REPORT_ODD_STYLE);
        $custlist .= '<tr class="' . $class . '">' . '<td class="datatablecontent" align="right">' . $inrec['recovercartsales_id'] . '</td>' . '<td>&nbsp;</td>' . '<td class="datatablecontent" align="center">' . oos_date_order_stat($inrec['recovercartsales_date_added']) . '</td>' . '<td>&nbsp;</td>' . '<td class="datatablecontent"><a href="' . oos_href_link_admin($aFilename['customers'], 'search=' . $crec['customers_lastname'], 'NONSSL') . '">' . $crec['customers_firstname'] . ' ' . $crec['customers_lastname'] . '</a></td>' . '<td class="datatablecontent">' . oos_date_short($orders['date_purchased']) . '</td>' . '<td class="datatablecontent" align="center">' . $orders['orders_status_name'] . '</td>' . '<td class="datatablecontent" align="right">' . strip_tags($orders['order_total']) . '</td>' . '<td>&nbsp;</td>' . '</tr>';
    }
    // Move that ADOdb pointer!
    $result->MoveNext();
}
// Close result set
$result->Close();
$cline = "<tr><td height=\"15\" COLSPAN=8> </td></tr>" . "<tr>" . "<td align=right COLSPAN=3 class=main><b>" . TOTAL_RECORDS . "</b></td>" . "<td>&nbsp;</td>" . "<td align=left COLSPAN=5 class=main>" . $rc_cnt . "</td>" . "</tr>" . "<tr>" . "<td align=right COLSPAN=3 class=main><b>" . TOTAL_SALES . "</b></td>" . "<td>&nbsp;</td>" . "<td align=left COLSPAN=5 class=main>" . $custknt . TOTAL_SALES_EXPLANATION . " </td>" . "</tr>" . "<tr><td height=\"12\" COLSPAN=6> </td></tr>";
echo $cline;
?>
       <tr class="dataTableHeadingRow"> <!-- Header -->
        <td width="7%" class="dataTableHeadingContent" align="right"><?php 
echo TABLE_HEADING_SCART_ID;
?>
</td>
        <td width="1%" class="dataTableHeadingContent">&nbsp;</td>

Exemple #2

Fichier : stats_recover_cart_sales.php Projet : BackupTheBerlios/oos-svn

                      AND o.orders_status > " . RCS_PENDING_SALE_STATUS . "
                      AND o.orders_status = s.orders_status_id
                      AND o.date_purchased >= '" . $inrec['recovercartsales_date_added'] . "'
                      AND ot.class = 'ot_total'";
    $orders_result = $dbconn->Execute($orders_sql);
    $orders = $orders_result->fields;

    // If we got a match, create the table entry to display the information
    if (isset($orders) && !empty($orders)) {
      $custknt++;
      $total_recovered += $orders['value'];
      $custknt % 2 ? $class = RCS_REPORT_EVEN_STYLE : $class = RCS_REPORT_ODD_STYLE;
      $custlist .= '<tr class="' . $class . '">' .
                   '<td class="datatablecontent" align="right">' . $inrec['recovercartsales_id'] . '</td>' .
                   '<td>&nbsp;</td>' .
                   '<td class="datatablecontent" align="center">' . oos_date_order_stat($inrec['recovercartsales_date_added']) . '</td>' .
                   '<td>&nbsp;</td>' .
                   '<td class="datatablecontent"><a href="' . oos_href_link_admin($aFilename['customers'], 'search=' . $crec['customers_lastname'], 'NONSSL') . '">' . $crec['customers_firstname'] . ' ' . $crec['customers_lastname'] . '</a></td>' .
                   '<td class="datatablecontent">' . oos_date_short($orders['date_purchased']) . '</td>' .
                   '<td class="datatablecontent" align="center">' . $orders['orders_status_name'] . '</td>' .
                   '<td class="datatablecontent" align="right">' . strip_tags($orders['order_total']) . '</td>' .
                   '<td>&nbsp;</td>'.
                   '</tr>';
    }

    // Move that ADOdb pointer!
    $result->MoveNext();
  }

  // Close result set
  $result->Close();