예제 #1
0
 function generateCoupon(&$allresults, $i, &$user)
 {
     list($percent, $gift, $value, $name) = explode('|', $allresults[1][$i]);
     $db =& JFactory::getDBO();
     $key = JUserHelper::genrandompassword(5);
     $value = str_replace(',', '.', $value);
     $name = str_replace(array('[name]', '[subid]', '[email]', '[key]', '[value]'), array($user->name, $user->subid, $user->email, $key, $value), $name);
     $db->setQuery('INSERT INTO ' . acymailing::table('vm_coupons', false) . '(`coupon_code`,`percent_or_total`,`coupon_type`,`coupon_value`) VALUES (' . $db->Quote($name) . ',' . $db->Quote($percent) . ',' . $db->Quote($gift) . ',' . $db->Quote($value) . ')');
     $db->query();
     return $name;
 }
예제 #2
0
    function generateCoupon(&$allresults, $i, &$user)
    {
        list($minimum_order, $quota, $start, $end, $percent_amount, $flat_amount, $currency_id, $code, $product_id) = explode('|', $allresults[1][$i]);
        jimport('joomla.user.helper');
        $key = JUserHelper::genrandompassword(5);
        if (!hikashop_level(1)) {
            $minimum_order = 0;
            $quota = '';
            $product_id = '';
        }
        if ($percent_amount > 0) {
            $value = $percent_amount;
        } else {
            $value = $flat_amount;
        }
        $value = str_replace(',', '.', $value);
        if ($start) {
            $start = hikashop_getTime($start);
        }
        if ($end) {
            $end = hikashop_getTime($end);
        }
        $clean_name = strtoupper($user->name);
        $space = strpos($clean_name, ' ');
        if (!empty($space)) {
            $clean_name = substr($clean_name, 0, $space);
        }
        $code = str_replace(array('[name]', '[clean_name]', '[subid]', '[email]', '[key]', '[flat]', '[percent]', '[value]', '[prodid]'), array($user->name, $clean_name, $user->subid, $user->email, $key, $flat_amount, $percent_amount, $value, $product_id), $code);
        $this->db->setQuery('INSERT IGNORE INTO ' . acymailing_table('hikashop_discount', false) . '(
		`discount_code`,
		`discount_percent_amount`,
		`discount_flat_amount`,
		`discount_type`,
		`discount_start`,
		`discount_end`,
		`discount_minimum_order`,
		`discount_quota`,
		`discount_currency_id`,
		`discount_product_id`,
		`discount_published`
		) VALUES (' . $this->db->Quote($code) . ',' . $this->db->Quote($percent_amount) . ',' . $this->db->Quote($flat_amount) . ',\'coupon\',' . $this->db->Quote($start) . ',' . $this->db->Quote($end) . ',' . $this->db->Quote($minimum_order) . ',' . $this->db->Quote($quota) . ',' . $this->db->Quote(hikashop_getCurrency()) . ',' . $this->db->Quote($product_id) . ',
		1)');
        $this->db->query();
        return $code;
    }