function display($tpl = null) { $filter = JRequest::getVar('q', JRequest::getVar('term', false)); $id = JRequest::getInt('id', false); $virtuemart_product_id = JRequest::getVar('virtuemart_product_id', array(), '', 'array'); if (is_array($virtuemart_product_id) && count($virtuemart_product_id) > 0) { $product_id = (int) $virtuemart_product_id[0]; } else { $product_id = (int) $virtuemart_product_id; } //$customfield = $this->model->getcustomfield(); /* Get the task */ if ($this->type == 'relatedproducts') { $query = "SELECT virtuemart_product_id AS id, CONCAT(product_name, '::', product_sku) AS value\n\t\t\t\tFROM #__virtuemart_products_" . VMLANG . "\n\t\t\t\t JOIN `#__virtuemart_products` AS p using (`virtuemart_product_id`)"; if ($filter) { $query .= " WHERE product_name LIKE '%" . $this->db->getEscaped($filter, true) . "%' or product_sku LIKE '%" . $this->db->getEscaped($filter, true) . "%' limit 0,10"; } self::setRelatedHtml($query, 'R'); } else { if ($this->type == 'relatedcategories') { $query = "SELECT virtuemart_category_id AS id, CONCAT(category_name, '::', virtuemart_category_id) AS value\n\t\t\t\tFROM #__virtuemart_categories_" . VMLANG; if ($filter) { $query .= " WHERE category_name LIKE '%" . $this->db->getEscaped($filter, true) . "%' limit 0,10"; } self::setRelatedHtml($query, 'Z'); } else { if ($this->type == 'custom') { $query = "SELECT CONCAT(virtuemart_custom_id, '|', custom_value, '|', field_type) AS id, CONCAT(custom_title, '::', custom_tip) AS value\n\t\t\t\tFROM #__virtuemart_customs"; if ($filter) { $query .= " WHERE custom_title LIKE '%" . $filter . "%' limit 0,50"; } $this->db->setQuery($query); $this->json['value'] = $this->db->loadObjectList(); $this->json['ok'] = 1; } else { if ($this->type == 'fields') { $fieldTypes = $this->model->getField_types(); $query = "SELECT *,custom_value as value FROM #__virtuemart_customs\n\t\t\tWHERE (`virtuemart_custom_id`=" . $id . " or `custom_parent_id`=" . $id . ")"; $query .= " order by custom_parent_id asc"; $this->db->setQuery($query); $rows = $this->db->loadObjectlist(); $html = array(); foreach ($rows as $field) { if ($field->field_type == 'C') { $this->json['table'] = 'childs'; $q = 'SELECT `virtuemart_product_id` FROM `#__virtuemart_products` WHERE `published`=1 AND `product_parent_id`= ' . JRequest::getInt('virtuemart_product_id'); //$this->db->setQuery(' SELECT virtuemart_product_id, product_name FROM `#__virtuemart_products` WHERE `product_parent_id` ='.(int)$product_id); $this->db->setQuery($q); if ($childIds = $this->db->loadResultArray()) { // Get childs foreach ($childIds as $childId) { $field->custom_value = $childId; $display = $this->model->displayProductCustomfieldBE($field, $childId, $this->row); if ($field->is_cart_attribute) { $cartIcone = 'default'; } else { $cartIcone = 'default-off'; } $html[] = '<div class="removable"> <td>' . $field->custom_title . '</td> <td>' . $display . $field->custom_tip . '</td> <td>' . JText::_($fieldTypes[$field->field_type]) . ' ' . $this->model->setEditCustomHidden($field, $this->row) . ' </td> <td><span class="vmicon vmicon-16-' . $cartIcone . '"></span></td> <td></td> </div>'; $this->row++; } } } elseif ($field->field_type == 'E') { $this->json['table'] = 'customPlugins'; $display = $this->model->displayProductCustomfieldBE($field, $product_id, $this->row); if ($field->is_cart_attribute) { $cartIcone = 'default'; } else { $cartIcone = 'default-off'; } $html[] = ' <tr class="removable"> <td><span class="hasTip" title="' . JText::_($field->custom_tip) . '">' . $field->custom_title . '</td> <td>' . $display . ' ' . $this->model->setEditCustomHidden($field, $this->row) . ' <p>' . JTEXT::_('COM_VIRTUEMART_CUSTOM_ACTIVATE_JAVASCRIPT') . '</p></td> <td><span class="vmicon vmicon-16-' . $cartIcone . '"></span>' . JText::_('COM_VIRTUEMART_CUSTOM_EXTENSION') . '</td> <td><span class="vmicon vmicon-16-move"></span> <span class="vmicon vmicon-16-remove"></span><input class="ordering" type="hidden" value="' . $this->row . '" name="field[' . $this->row . '][ordering]" /> </td> </tr>'; $this->row++; } else { $this->json['table'] = 'fields'; $display = $this->model->displayProductCustomfieldBE($field, $product_id, $this->row); if ($field->is_cart_attribute) { $cartIcone = 'default'; } else { $cartIcone = 'default-off'; } $html[] = '<tr class="removable"> <td><span class="hasTip" title="' . JText::_($field->custom_tip) . '">' . $field->custom_title . '</td> <td>' . $display . '</td> <td><span class="vmicon vmicon-16-' . $cartIcone . '"></span>' . JText::_($fieldTypes[$field->field_type]) . ' ' . $this->model->setEditCustomHidden($field, $this->row) . ' </td> <td><span class="vmicon vmicon-16-move"></span><span class="vmicon vmicon-16-remove"></span><input class="ordering" type="hidden" value="' . $this->row . '" name="field[' . $this->row . '][ordering]" /></td> </tr>'; $this->row++; } } $this->json['value'] = $html; $this->json['ok'] = 1; } else { if ($this->type == 'userlist') { $status = JRequest::getvar('status'); $productShoppers = 0; if ($status) { $productModel = VmModel::getModel('product'); $productShoppers = $productModel->getProductShoppersByStatus($product_id, $status); } if (!class_exists('ShopFunctions')) { require JPATH_VM_ADMINISTRATOR . DS . 'helpers' . DS . 'shopfunctions.php'; } $html = ShopFunctions::renderProductShopperList($productShoppers); $this->json['value'] = $html; } else { $this->json['ok'] = 0; } } } } } if (empty($this->json)) { $this->json['value'] = null; $this->json['ok'] = 1; } echo json_encode($this->json); }
function display($tpl = null) { $filter = vRequest::getVar('q', vRequest::getVar('term', false)); $id = vRequest::getInt('id', false); $tsmart_product_id = vRequest::getInt('tsmart_product_id', array()); if (is_array($tsmart_product_id) && count($tsmart_product_id) > 0) { $product_id = (int) $tsmart_product_id[0]; } else { $product_id = (int) $tsmart_product_id; } //$customfield = $this->model->getcustomfield(); /* Get the task */ if ($this->type == 'relatedproducts') { $query = "SELECT tsmart_product_id AS id, CONCAT(product_name, '::', product_sku) AS value\n\t\t\t\tFROM #__tsmart_products_" . tsmConfig::$vmlang . "\n\t\t\t\t JOIN `#__tsmart_products` AS p using (`tsmart_product_id`)"; if ($filter) { $query .= " WHERE product_name LIKE '%" . $this->db->escape($filter, true) . "%' or product_sku LIKE '%" . $this->db->escape($filter, true) . "%' limit 0,10"; } self::setRelatedHtml($product_id, $query, 'R'); } else { if ($this->type == 'relatedcategories') { $query = "SELECT tsmart_category_id AS id, CONCAT(category_name, '::', tsmart_category_id) AS value\n\t\t\t\tFROM #__tsmart_categories_" . tsmConfig::$vmlang; if ($filter) { $query .= " WHERE category_name LIKE '%" . $this->db->escape($filter, true) . "%' limit 0,10"; } self::setRelatedHtml($product_id, $query, 'Z'); } else { if ($this->type == 'custom') { $query = "SELECT CONCAT(tsmart_custom_id, '|', custom_value, '|', field_type) AS id, CONCAT(custom_title, '::', custom_tip) AS value\n\t\t\t\tFROM #__tsmart_customs"; if ($filter) { $query .= " WHERE custom_title LIKE '%" . $filter . "%' limit 0,50"; } $this->db->setQuery($query); $this->json['value'] = $this->db->loadObjectList(); $this->json['ok'] = 1; } else { if ($this->type == 'fields') { if (!class_exists('tsmartModelCustom')) { require VMPATH_ADMIN . DS . 'models' . DS . 'custom.php'; } $fieldTypes = tsmartModelCustom::getCustomTypes(); $model = tmsModel::getModel('custom'); $q = 'SELECT `tsmart_custom_id` FROM `#__tsmart_customs` WHERE (`custom_parent_id`=' . $id . ') '; $q .= 'order by `ordering` asc'; $this->db->setQuery($q); $ids = $this->db->loadColumn(); if ($ids) { array_unshift($ids, $id); } else { $ids = array($id); } foreach ($ids as $k => $i) { $p = $model->getCustom($i); if ($p) { $p->value = $p->custom_value; $rows[] = $p; } } $html = array(); foreach ($rows as $field) { if ($field->field_type == 'deprecatedwasC') { $this->json['table'] = 'childs'; $q = 'SELECT `tsmart_product_id` FROM `#__tsmart_products` WHERE `published`=1 AND `product_parent_id`= ' . vRequest::getInt('tsmart_product_id'); //$this->db->setQuery(' SELECT tsmart_product_id, product_name FROM `#__tsmart_products` WHERE `product_parent_id` ='.(int)$product_id); $this->db->setQuery($q); if ($childIds = $this->db->loadColumn()) { // Get childs foreach ($childIds as $childId) { $field->custom_value = $childId; $display = $this->model->displayProductCustomfieldBE($field, $childId, $this->row); if ($field->is_cart_attribute) { $cartIcone = 'default'; } else { $cartIcone = 'default-off'; } $html[] = '<div class="removable"> <td>' . $field->custom_title . '</td> <td>' . $display . $field->custom_tip . '</td> <td>' . tsmText::_($fieldTypes[$field->field_type]) . ' ' . $this->model->setEditCustomHidden($field, $this->row) . ' </td> <td><span class="vmicon vmicon-16-' . $cartIcone . '"></span></td> <td></td> </div>'; $this->row++; } } } else { //if ($field->field_type =='E') { $this->json['table'] = 'customPlugins'; $colspan = ''; if ($field->field_type == 'E') { $this->model->bindCustomEmbeddedFieldParams($field, 'E'); } else { if ($field->field_type == 'C') { $colspan = 'colspan="2" '; } } $display = $this->model->displayProductCustomfieldBE($field, $product_id, $this->row); if ($field->is_cart_attribute) { $cartIcone = 'default'; } else { $cartIcone = 'default-off'; } $field->tsmart_product_id = $product_id; $html[] = ' <tr class="removable"> <td> <b>' . tsmText::_($fieldTypes[$field->field_type]) . '</b> ' . tsmText::_($field->custom_title) . '</span><br/> <span class="vmicon vmicon-16-' . $cartIcone . '"></span> <span class="vmicon vmicon-16-move"></span> <span class="vmicon vmicon-16-remove"></span> ' . $this->model->setEditCustomHidden($field, $this->row) . ' </td> <td ' . $colspan . '>' . $display . '</td> </tr> </tr>'; $this->row++; } } $this->json['value'] = $html; $this->json['ok'] = 1; } else { if ($this->type == 'userlist') { $status = vRequest::getvar('status'); $productShoppers = 0; if ($status) { $productModel = tmsModel::getModel('product'); $productShoppers = $productModel->getProductShoppersByStatus($product_id, $status); } if (!class_exists('ShopFunctions')) { require VMPATH_ADMIN . DS . 'helpers' . DS . 'shopfunctions.php'; } $html = ShopFunctions::renderProductShopperList($productShoppers); $this->json['value'] = $html; } else { $this->json['ok'] = 0; } } } } } if (empty($this->json)) { $this->json['value'] = null; $this->json['ok'] = 1; } echo vmJsApi::safe_json_encode($this->json); }
<th class="title"><?php echo vmText::_('COM_VIRTUEMART_ORDER_PRINT_ITEM_STATUS'); ?> </th> <th class="title"><?php echo vmText::_('COM_VIRTUEMART_ORDER_NUMBER'); ?> </th> </tr> </thead> <tbody id="customers-list"> <?php if (!class_exists('ShopFunctions')) { require VMPATH_ADMIN . DS . 'helpers' . DS . 'shopfunctions.php'; } echo ShopFunctions::renderProductShopperList($this->productShoppers); ?> </tbody> </table> </div> <div id="customer-mail-notify-list"> <?php if (VmConfig::get('stockhandle', 0) == 'disableadd' && !empty($this->waitinglist)) { ?> <div style="font-weight:bold;"><?php echo vmText::_('COM_VIRTUEMART_PRODUCT_WAITING_LIST_USERLIST'); ?> </div> <table class="adminlist table" cellspacing="0" cellpadding="0">
function display($tpl = null) { // Get the task $this->task = JRequest::getWord('task', $this->getLayout()); if ($this->task == 'massxref_cats_exe') { return; } $filter = JRequest::getVar('q', JRequest::getVar('term', false)); if ($filter) { $filter = $this->db->escape($filter, true); } $id = JRequest::getInt('id', false); $product_id = JRequest::getInt('virtuemart_product_id', 0); //$customfield = $this->model->getcustomfield(); /* Get the task */ if ($this->type == 'relatedproducts') { $query = "SELECT virtuemart_product_id AS id, CONCAT(product_name, '::', product_sku) AS value\n\t\t\t\tFROM #__virtuemart_products_" . VMLANG . "\n\t\t\t\t JOIN `#__virtuemart_products` AS p using (`virtuemart_product_id`)"; if ($filter) { $query .= " WHERE product_name LIKE '%" . $filter . "%' or product_sku LIKE '%" . $filter . "%'"; } $query .= " limit 0,10"; if (JRequest::getInt('kit', 0)) { $fieldType = "K"; } else { $fieldType = "R"; } self::setRelatedHtml($query, $fieldType); } else { if ($this->type == 'relatedcategories') { $query = "SELECT virtuemart_category_id AS id, CONCAT(category_name, '::', virtuemart_category_id) AS value\n\t\t\t\tFROM #__virtuemart_categories_" . VMLANG; if ($filter) { $query .= " WHERE category_name LIKE '%" . $filter . "%'"; } $query .= " limit 0,10"; self::setRelatedHtml($query, 'Z'); } else { if ($this->type == 'custom') { $query = "SELECT CONCAT(virtuemart_custom_id, '|', custom_value, '|', field_type) AS id, CONCAT(custom_title, '::', custom_tip) AS value\n\t\t\t\tFROM #__virtuemart_customs"; if ($filter) { $query .= " WHERE custom_title LIKE '%" . $filter . "%' limit 0,50"; } $this->db->setQuery($query); $this->json['value'] = $this->db->loadObjectList(); $this->json['ok'] = 1; } else { if ($this->type == 'fields') { $fieldTypes = $this->model->getField_types(); $query = "SELECT *,custom_value as value FROM #__virtuemart_customs\n\t\t\tWHERE (`virtuemart_custom_id`=" . $id . " or `custom_parent_id`=" . $id . ")"; $query .= " order by custom_parent_id asc"; $this->db->setQuery($query); $rows = $this->db->loadObjectlist(); $html = array('cart_attributes' => '', 'custom_fields' => '', 'childs' => ''); foreach ($rows as $field) { if ($field->field_type == 'C') { $this->json['table'] = 'childs'; $q = 'SELECT `virtuemart_product_id` FROM `#__virtuemart_products` WHERE `published`=1 AND `product_parent_id`= ' . JRequest::getInt('virtuemart_product_id'); //$this->db->setQuery(' SELECT virtuemart_product_id, product_name FROM `#__virtuemart_products` WHERE `product_parent_id` ='.(int)$product_id); $this->db->setQuery($q); if ($childIds = $this->db->loadColumn()) { // Get childs foreach ($childIds as $childId) { $field->custom_value = $childId; $display = $this->model->displayProductCustomfieldBE($field, $childId, $this->row); if ($field->is_cart_attribute) { $cartIcone = 'default'; } else { $cartIcone = 'default-off'; } $html[] = '<div class="removable"> <td>' . $field->custom_title . '</td> <td>' . $display . $field->custom_tip . '</td> <td>' . JText::_($fieldTypes[$field->field_type]) . ' ' . $this->model->setEditCustomHidden($field, $this->row) . ' </td> <td><span class="vmicon vmicon-16-' . $cartIcone . '"></span></td> <td></td> </div>'; $this->row++; } } } else { $this->json['table'] = 'fields'; $display = $this->model->displayProductCustomfieldBE($field, $product_id, $this->row); if ($field->custom_tip) { $tip = ' class="hasTooltip" title="' . $field->custom_tip . '"'; } else { $tip = ''; } if ($field->layout_pos) { $field->layout_pos = '<div><small>' . $field->layout_pos . '</small></div>'; } $tbName = $field->is_cart_attribute ? 'cart_attributes' : 'custom_fields'; $html[$tbName] .= '<tr class="removable"> <td class="hidden-phone"><span class="icon-menu"></span> <input class="ordering" type="hidden" value="' . $this->row . '" name="field[' . $this->row . '][ordering]" /> </td> <td><div ' . $tip . '>' . JText::_($field->custom_title) . '<div>' . ($field->custom_field_desc ? '<small>' . $field->custom_field_desc . '</small>' : '') . ' <td>' . $display . '</td> <td> ' . JText::_($fieldTypes[$field->field_type]) . ' ' . $field->layout_pos . ' ' . $this->model->setEditCustomHidden($field, $this->row) . ' </td> <td><span class="icon-remove"></span></td> </tr>'; $this->row++; } } foreach ($html as $key => $item) { if (empty($item)) { unset($html[$key]); } } $this->json['value'] = $html; $this->json['ok'] = 1; } else { if ($this->type == 'userlist') { $status = JRequest::getvar('status'); $productShoppers = 0; if ($status) { $productModel = VmModel::getModel('product'); $productShoppers = $productModel->getProductShoppersByStatus($product_id, $status); } JLoader::register('ShopFunctions', JPATH_VM_ADMINISTRATOR . 'helpers/shopfunctions.php'); $html = ShopFunctions::renderProductShopperList($productShoppers); $this->json['value'] = $html; } else { $this->json['ok'] = 0; } } } } } if (empty($this->json)) { $this->json['value'] = null; $this->json['ok'] = 1; } echo json_encode($this->json); }