public function getValue($attribute_id, $value_id)
{
$type = product_attributes::getType($attribute_id);
if ($type == 'list') {
$sql = "SELECT value FROM " . TB_PREFIX . "products_values WHERE id = :id";
$sth = dbQuery($sql, ':id', $value_id);
$attribute = $sth->fetch();
return $attribute['value'];
} else {
return $value_id;
}
}
public function getInvoiceItems($id, $domain_id = '')
{
global $logger;
if (!empty($domain_id)) {
$this->domain_id = $domain_id;
}
$sql = "SELECT * FROM " . TB_PREFIX . "invoice_items WHERE invoice_id = :id AND domain_id = :domain_id ORDER BY id";
$sth = dbQuery($sql, ':id', $id, ':domain_id', $this->domain_id);
$invoiceItems = null;
for ($i = 0; $invoiceItem = $sth->fetch(); $i++) {
// $invoiceItem['quantity'] = $invoiceItem['quantity'];
// $invoiceItem['unit_price'] = $invoiceItem['unit_price'];
// $invoiceItem['tax_amount'] = $invoiceItem['tax_amount'];
// $invoiceItem['gross_total'] = $invoiceItem['gross_total'];
// $invoiceItem['total'] = $invoiceItem['total'];
$invoiceItem['attribute_decode'] = json_decode($invoiceItem['attribute'], true);
foreach ($invoiceItem['attribute_decode'] as $key => $value) {
$invoiceItem['attribute_json'][$key]['name'] = product_attributes::getName($key);
$invoiceItem['attribute_json'][$key]['value'] = product_attributes::getValue($key, $value);
$invoiceItem['attribute_json'][$key]['type'] = product_attributes::getType($key);
$invoiceItem['attribute_json'][$key]['visible'] = product_attributes::getVisible($key);
}
$sql = "SELECT * FROM " . TB_PREFIX . "products WHERE id = :id AND domain_id = :domain_id";
$tth = dbQuery($sql, ':id', $invoiceItem['product_id'], ':domain_id', $this->domain_id);
$invoiceItem['product'] = $tth->fetch();
$tax = taxesGroupedForInvoiceItem($invoiceItem['id']);
foreach ($tax as $key => $value) {
$invoiceItem['tax'][$key] = $value['tax_id'];
$logger->log('Invoice: ' . $invoiceItem['invoice_id'] . ' Item id: ' . $invoiceItem['id'] . ' Tax ' . $key . ' Tax ID: ' . $value['tax_id'], Zend_Log::INFO);
}
$invoiceItems[$i] = $invoiceItem;
}
return $invoiceItems;
}
<?php
//stop the direct browsing to this file - let index.php handle which files get displayed
checkLogin();
//if valid then do save
if ($_POST['name'] != "") {
include "./modules/product_attribute/save.php";
}
#get the invoice id
$id = $_GET['id'];
$sql_prod = "SELECT * FROM " . TB_PREFIX . "products_attributes WHERE id = :id;";
$sth_prod = dbQuery($sql_prod, ':id', $id);
$product_attribute = $sth_prod->fetch();
$type = product_attributes::get($id);
$product_attribute['type'] = $type['type'];
$sql2 = "SELECT id, name FROM " . TB_PREFIX . "products_attribute_type";
$sth2 = dbQuery($sql2);
$types = $sth2->fetchAll(PDO::FETCH_ASSOC);
$smarty->assign("types", $types);
$product_attribute['wording_for_enabled'] = $product_attribute['enabled'] == 1 ? $LANG['enabled'] : $LANG['disabled'];
$product_attribute['wording_for_visible'] = $product_attribute['visible'] == 1 ? $LANG['enabled'] : $LANG['disabled'];
$pageActive = "product_attribute_manage";
$smarty->assign('pageActive', $pageActive);
$smarty->assign('active_tab', '#product');
$smarty->assign('product_attribute', $product_attribute);
