private function showMyOrders($COList)
{
$return = '';
$sql = 'SELECT * FROM orders WHERE o_custno = :custno ORDER BY o_ordertimestamp DESC';
$hResult = $this->db->prepare($sql);
$hResult->bindValue(':custno', CHelper::getUserData('cust_no'));
$hResult->execute();
if ($hResult->rowCount() >= 1) {
$aData = [];
while ($aRow = $hResult->fetch()) {
$sStatus = SHelper::showOrderStatusText($this->textcats, $aRow["o_ordercompleted"]);
if ($aRow["o_paymentmethod"] == 'prepay') {
$sPaymentmethod = $this->textcats->T("order_paymentmethod_prepay");
} elseif ($aRow["o_paymentmethod"] == 'paypal') {
$sPaymentmethod = $this->textcats->T("order_paymentmethod_paypal");
} elseif ($aRow["o_paymentmethod"] == 'debit') {
$sPaymentmethod = $this->textcats->T("order_paymentmethod_debit");
} elseif ($aRow["o_paymentmethod"] == 'invoice') {
$sPaymentmethod = $this->textcats->T("order_paymentmethod_invoice");
} else {
$sPaymentmethod = ucwords($aRow["o_paymentmethod"]);
}
if ($aRow["o_paymentcompleted"] == 'y') {
$sPaymentstatus = ucwords($this->textcats->T("misc_yes"));
} else {
$sPaymentstatus = ucwords($this->textcats->T("misc_no"));
}
$aData[] = ['o_id' => $aRow["o_id"], 'o_order_status' => $sStatus, 'o_ordertime' => date(HelperConfig::$customer['locale_format_date_time'], $aRow["o_ordertimestamp"]), 'o_paymentmethod' => $sPaymentmethod, 'o_paymentcompleted' => $sPaymentstatus, 'o_shipping_service' => $aRow["o_shipping_service"], 'o_shipping_trackingno' => $aRow["o_shipping_trackingno"]];
}
$return .= \HaaseIT\Tools::makeListtable($COList, $aData, $this->serviceManager->get('twig'));
} else {
$return .= $this->textcats->T("myorders_no_orders_to_display");
}
return $return;
}
