Beispiel #1
0
 function fetch($cols = '', $kids = false, $get_images = false)
 {
     $info = parent::fetch($cols, $kids);
     if ($get_images) {
         $info['images'] = $this->get_images(null, $get_images);
     }
     return $info;
 }
Beispiel #2
0
 function fetch_any($cols = null, $offset = 0, $range = 0, $orderby = null, $where = '', $orderdir = 'ASC')
 {
     if (!empty($where)) {
         $where .= " AND";
     }
     $where .= " cm_products_id = " . $this->db->quote($this->_cm_product_id);
     if (!$orderby) {
         $orderby = 'order_weight,optkey';
     }
     return parent::fetch_any($cols, $offset, $range, $orderby, $where, $orderdir);
 }
Beispiel #3
0
 /**
  * store form values. Special post-save proc for sending notifications.
  */
 function store($vals)
 {
     $res = parent::store($vals);
     if (!PEAR::isError($res) or $res->getCode() == DBCON_ZERO_EFFECT) {
         if (!empty($vals['do_notify']) && !empty($vals['belongs_email'])) {
             $this->send_coupon_notification($vals['belongs_email'], $vals['belongs_name']);
         }
     }
     return $res;
 }
 /**
  * extend parent to clear our little cache 
  */
 function set_id($id)
 {
     $this->_catpath_cache = null;
     parent::set_id($id);
 }
 /**
  * store a new basis for the given method
  * @param $meth_id int the ship_method id
  * @param $min int minimum of the range
  * @param $max int max of the range
  * @param $cost int how much it will cost ya
  * @throws PE
  */
 function store_basis($methid, $min, $max, $cost)
 {
     global $pdb;
     $dbc = new db_container($pdb);
     $dbc->set_table('cm_shipmethods_zone_costs');
     $vals = array('cm_shipmethods_zone_methods_id' => $methid, 'basis_min' => $min, 'basis_max' => $max, 'cost' => $cost);
     return $dbc->store($vals, true);
 }
Beispiel #6
0
} elseif ($ACTION == OP_GC_LOAD && defined('CSHOP_CONTROL_SHOW_STS_GIFTCARD_LOADER') && CSHOP_CONTROL_SHOW_STS_GIFTCARD_LOADER) {
    $order->set_id_by_token($itemid);
    $gc = cmClassFactory::getInstanceOf(CSHOP_CLASSES_GIFTCARD, $pdb);
    $gc->setErrorHandling(PEAR_ERROR_RETURN);
    $orderitems = $order->fetch_items();
    $errs = array();
    foreach ($orderitems as $item) {
        if (in_array($item['id'], array_keys($_POST['gc_number']))) {
            $successful_cards = array();
            $gc_numbers = $_POST['gc_number'][$item['id']];
            # get product's STS merchant ID
            $product = cmClassFactory::getInstanceOf(CSHOP_CLASSES_PRODUCT, $pdb);
            $product->set_id($item['product_id']);
            $product_merch_id = $product->get_header('sts_merchant_id');
            # store the giftcard details as options on the order line item, so admin can see
            $oi = db_container::factory($pdb, $order->_items_table);
            $oi->set_id($item['id']);
            for ($i = 0; $i < count($gc_numbers); $i++) {
                $gc_number = trim($gc_numbers[$i]);
                if (!empty($gc_number)) {
                    if (empty($product_merch_id)) {
                        $errs[] = "Product \"{$item['product_descrip']}\" does not have a STS Merchant ID, so can\\'t be activated here.";
                    } elseif ($gc->find_by_card_number($gc_number)) {
                        $errs[] = "Card Number \"{$gc_number}\" is already in the system, and cannot be activated again.";
                    } else {
                        $res = $gc->activate($order, $product_merch_id, $item['price'], $gc_number);
                        # TESTING $res = print_r(array($product_merch_id, $item['price'], $gc_number));
                        if (!PEAR::isError($res)) {
                            $successful_cards[] = $gc->fetch(array('gc_no', 'transaction_id'));
                            # TESTING $successful_cards[] = array('gc_no'=>rand('100000000000001','999999999999999'), 'transaction_id' => '3e12982132131038oi');
                        } else {
Beispiel #7
0
 /**
  * does the order contains any digital items.
  * @return bool
  */
 function fetch_digital_goods()
 {
     if (!defined('CSHOP_ENABLE_DIGITAL_DOWNLOADS') || !CSHOP_ENABLE_DIGITAL_DOWNLOADS) {
         return;
     }
     if (defined('CSHOP_DOWNLOAD_LINK_FMT')) {
         $sql = sprintf("SELECT id, product_id, product_descrip, download_token FROM %s WHERE is_digital = 1 AND order_id = %d", $this->_items_table, $this->get_id());
         $res = $this->db->query($sql);
         $items = array();
         while ($row = $res->fetchRow()) {
             if (empty($row['download_token'])) {
                 // create and save new URL if not done yet.
                 $row['download_token'] = $this->generate_download_token($row['product_id']);
                 $oi = db_container::factory($this->db, $this->_items_table);
                 $oi->set_id($row['id']);
                 $oi->store(array('download_token' => $row['download_token']));
             }
             $row['download_url'] = sprintf(CSHOP_DOWNLOAD_LINK_FMT, $this->fetch_token(), $row['download_token']);
             $items[] = $row;
         }
         return $items;
     }
 }