mirror of
https://github.com/kennethreitz-archive/shopp.git
synced 2026-06-05 23:40:16 +00:00
Kenneth Reitz
561 lines
18 KiB
PHP
561 lines
18 KiB
PHP
<?php
|
|
/**
|
|
* Purchase class
|
|
* Order invoice logging
|
|
*
|
|
* @author Jonathan Davis
|
|
* @version 1.0
|
|
* @copyright Ingenesis Limited, 28 March, 2008
|
|
* @package shopp
|
|
**/
|
|
|
|
require("Purchased.php");
|
|
|
|
class Purchase extends DatabaseObject {
|
|
static $table = "purchase";
|
|
var $purchased = array();
|
|
var $columns = array();
|
|
var $looping = false;
|
|
var $dataloop = false;
|
|
|
|
function Purchase ($id=false,$key=false) {
|
|
$this->init(self::$table);
|
|
if (!$id) return true;
|
|
if ($this->load($id,$key)) return true;
|
|
else return false;
|
|
}
|
|
|
|
function load_purchased () {
|
|
$db = DB::get();
|
|
|
|
$table = DatabaseObject::tablename(Purchased::$table);
|
|
if (empty($this->id)) return false;
|
|
$this->purchased = $db->query("SELECT * FROM $table WHERE purchase=$this->id",AS_ARRAY);
|
|
foreach ($this->purchased as &$purchase) $purchase->data = unserialize($purchase->data);
|
|
return true;
|
|
}
|
|
|
|
function notification ($addressee,$address,$subject,$template="order.html",$receipt="receipt.php") {
|
|
global $Shopp;
|
|
global $is_IIS;
|
|
|
|
$template = trailingslashit(SHOPP_TEMPLATES).$template;
|
|
if (!file_exists($template))
|
|
return new ShoppError(__('A purchase notification could not be sent because the template for it does not exist.','purchase_notification_template',SHOPP_ADMIN_ERR));
|
|
|
|
// // Send the e-mail receipt
|
|
$email = array();
|
|
$email['from'] = '"'.get_bloginfo("name").'"';
|
|
if ($Shopp->Settings->get('merchant_email'))
|
|
$email['from'] .= ' <'.$Shopp->Settings->get('merchant_email').'>';
|
|
if($is_IIS) $email['to'] = $address;
|
|
else $email['to'] = '"'.html_entity_decode($addressee,ENT_QUOTES).'" <'.$address.'>';
|
|
$email['subject'] = $subject;
|
|
$email['receipt'] = $Shopp->Flow->order_receipt($receipt);
|
|
$email['url'] = get_bloginfo('siteurl');
|
|
$email['sitename'] = get_bloginfo('name');
|
|
$email['orderid'] = $this->id;
|
|
|
|
$email = apply_filters('shopp_email_receipt_data',$email);
|
|
|
|
if (shopp_email($template,$email)) {
|
|
if (SHOPP_DEBUG) new ShoppError('A purchase notification was sent to "'.$addressee.'" <'.$address.'>',false,SHOPP_DEBUG_ERR);
|
|
return true;
|
|
}
|
|
|
|
if (SHOPP_DEBUG) new ShoppError('A purchase notification FAILED to be sent to "'.$addressee.'" <'.$address.'>',false,SHOPP_DEBUG_ERR);
|
|
return false;
|
|
}
|
|
|
|
function copydata ($Object,$prefix="") {
|
|
$ignores = array("_datatypes","_table","_key","_lists","id","created","modified");
|
|
foreach(get_object_vars($Object) as $property => $value) {
|
|
$property = $prefix.$property;
|
|
if (property_exists($this,$property) &&
|
|
!in_array($property,$ignores))
|
|
$this->{$property} = $value;
|
|
}
|
|
}
|
|
|
|
function exportcolumns () {
|
|
$prefix = "o.";
|
|
return array(
|
|
$prefix.'id' => __('Order ID','Shopp'),
|
|
$prefix.'ip' => __('Customer\'s IP Address','Shopp'),
|
|
$prefix.'firstname' => __('Customer\'s First Name','Shopp'),
|
|
$prefix.'lastname' => __('Customer\'s Last Name','Shopp'),
|
|
$prefix.'email' => __('Customer\'s Email Address','Shopp'),
|
|
$prefix.'phone' => __('Customer\'s Phone Number','Shopp'),
|
|
$prefix.'company' => __('Customer\'s Company','Shopp'),
|
|
$prefix.'card' => __('Credit Card Number','Shopp'),
|
|
$prefix.'cardtype' => __('Credit Card Type','Shopp'),
|
|
$prefix.'cardexpires' => __('Credit Card Expiration Date','Shopp'),
|
|
$prefix.'cardholder' => __('Credit Card Holder\'s Name','Shopp'),
|
|
$prefix.'address' => __('Billing Street Address','Shopp'),
|
|
$prefix.'xaddress' => __('Billing Street Address 2','Shopp'),
|
|
$prefix.'city' => __('Billing City','Shopp'),
|
|
$prefix.'state' => __('Billing State/Province','Shopp'),
|
|
$prefix.'country' => __('Billing Country','Shopp'),
|
|
$prefix.'postcode' => __('Billing Postal Code','Shopp'),
|
|
$prefix.'shipaddress' => __('Shipping Street Address','Shopp'),
|
|
$prefix.'shipxaddress' => __('Shipping Street Address 2','Shopp'),
|
|
$prefix.'shipcity' => __('Shipping City','Shopp'),
|
|
$prefix.'shipstate' => __('Shipping State/Province','Shopp'),
|
|
$prefix.'shipcountry' => __('Shipping Country','Shopp'),
|
|
$prefix.'shippostcode' => __('Shipping Postal Code','Shopp'),
|
|
$prefix.'shipmethod' => __('Shipping Method','Shopp'),
|
|
$prefix.'promos' => __('Promotions Applied','Shopp'),
|
|
$prefix.'subtotal' => __('Order Subtotal','Shopp'),
|
|
$prefix.'discount' => __('Order Discount','Shopp'),
|
|
$prefix.'freight' => __('Order Shipping Fees','Shopp'),
|
|
$prefix.'tax' => __('Order Taxes','Shopp'),
|
|
$prefix.'total' => __('Order Total','Shopp'),
|
|
$prefix.'fees' => __('Transaction Fees','Shopp'),
|
|
$prefix.'transactionid' => __('Transaction ID','Shopp'),
|
|
$prefix.'transtatus' => __('Transaction Status','Shopp'),
|
|
$prefix.'gateway' => __('Payment Gateway','Shopp'),
|
|
$prefix.'status' => __('Order Status','Shopp'),
|
|
$prefix.'data' => __('Order Data','Shopp'),
|
|
$prefix.'created' => __('Order Date','Shopp'),
|
|
$prefix.'modified' => __('Order Last Updated','Shopp')
|
|
);
|
|
}
|
|
|
|
function tag ($property,$options=array()) {
|
|
global $Shopp;
|
|
|
|
|
|
if ($property == "item-unitprice" || $property == "item-total")
|
|
$taxrate = shopp_taxrate($options['taxes']);
|
|
|
|
// Return strings with no options
|
|
switch ($property) {
|
|
case "url": return $Shopp->link('cart'); break;
|
|
case "id": return $this->id; break;
|
|
case "date":
|
|
if (empty($options['format'])) $options['format'] = get_option('date_format');
|
|
return _d($options['format'],((is_int($this->created))?$this->created:mktimestamp($this->created)));
|
|
break;
|
|
case "card": return (!empty($this->card))?sprintf("%'X16d",$this->card):''; break;
|
|
case "cardtype": return $this->cardtype; break;
|
|
case "transactionid": return $this->transactionid; break;
|
|
case "firstname": return $this->firstname; break;
|
|
case "lastname": return $this->lastname; break;
|
|
case "company": return $this->company; break;
|
|
case "email": return $this->email; break;
|
|
case "phone": return $this->phone; break;
|
|
case "address": return $this->address; break;
|
|
case "xaddress": return $this->xaddress; break;
|
|
case "city": return $this->city; break;
|
|
case "state":
|
|
if (strlen($this->state > 2)) return $this->state;
|
|
$regions = $Shopp->Settings->get('zones');
|
|
$states = $regions[$this->country];
|
|
return $states[$this->state];
|
|
break;
|
|
case "postcode": return $this->postcode; break;
|
|
case "country":
|
|
$countries = $Shopp->Settings->get('target_markets');
|
|
return $countries[$this->country]; break;
|
|
case "shipaddress": return $this->shipaddress; break;
|
|
case "shipxaddress": return $this->shipxaddress; break;
|
|
case "shipcity": return $this->shipcity; break;
|
|
case "shipstate":
|
|
if (strlen($this->shipstate > 2)) return $this->shipstate;
|
|
$regions = $Shopp->Settings->get('zones');
|
|
$states = $regions[$this->country];
|
|
return $states[$this->shipstate];
|
|
break;
|
|
case "shippostcode": return $this->shippostcode; break;
|
|
case "shipcountry":
|
|
$countries = $Shopp->Settings->get('target_markets');
|
|
return $countries[$this->shipcountry]; break;
|
|
case "shipmethod": return $this->shipmethod; break;
|
|
case "totalitems": return count($this->purchased); break;
|
|
case "hasitems": if (count($this->purchased) > 0) return true; else return false; break;
|
|
case "items":
|
|
if (!$this->looping) {
|
|
reset($this->purchased);
|
|
$this->looping = true;
|
|
} else next($this->purchased);
|
|
|
|
if (current($this->purchased)) return true;
|
|
else {
|
|
$this->looping = false;
|
|
reset($this->purchased);
|
|
return false;
|
|
}
|
|
case "item-id":
|
|
$item = current($this->purchased);
|
|
return $item->id; break;
|
|
case "item-product":
|
|
$item = current($this->purchased);
|
|
return $item->product; break;
|
|
case "item-price":
|
|
$item = current($this->purchased);
|
|
return $item->price; break;
|
|
case "item-name":
|
|
$item = current($this->purchased);
|
|
return $item->name; break;
|
|
case "item-description":
|
|
$item = current($this->purchased);
|
|
return $item->description; break;
|
|
case "item-options":
|
|
$item = current($this->purchased);
|
|
return (!empty($item->optionlabel))?$options['before'].$item->optionlabel.$options['after']:''; break;
|
|
case "item-sku":
|
|
$item = current($this->purchased);
|
|
return $item->sku; break;
|
|
case "item-download":
|
|
$item = current($this->purchased);
|
|
if (empty($item->download)) return "";
|
|
if (!isset($options['label'])) $options['label'] = __('Download','Shopp');
|
|
$classes = "";
|
|
if (isset($options['class'])) $classes = ' class="'.$options['class'].'"';
|
|
if (SHOPP_PERMALINKS) $url = $Shopp->shopuri."download/".$item->dkey;
|
|
else $url = add_query_arg('shopp_download',$item->dkey,$Shopp->link('account'));
|
|
return '<a href="'.$url.'"'.$classes.'>'.$options['label'].'</a>'; break;
|
|
case "item-quantity":
|
|
$item = current($this->purchased);
|
|
return $item->quantity; break;
|
|
case "item-unitprice":
|
|
$item = current($this->purchased);
|
|
return money($item->unitprice+($item->unitprice*$taxrate)); break;
|
|
case "item-total":
|
|
$item = current($this->purchased);
|
|
return money($item->total+($item->total*$taxrate)); break;
|
|
case "item-has-inputs":
|
|
case "item-hasinputs":
|
|
$item = current($this->purchased);
|
|
return (count($item->data) > 0); break;
|
|
case "item-inputs":
|
|
$item = current($this->purchased);
|
|
if (!$this->itemdataloop) {
|
|
reset($item->data);
|
|
$this->itemdataloop = true;
|
|
} else next($item->data);
|
|
|
|
if (current($item->data)) return true;
|
|
else {
|
|
$this->itemdataloop = false;
|
|
return false;
|
|
}
|
|
break;
|
|
case "item-input":
|
|
$item = current($this->purchased);
|
|
$data = current($item->data);
|
|
$name = key($item->data);
|
|
if (isset($options['name'])) return $name;
|
|
return $data;
|
|
break;
|
|
case "item-inputs-list":
|
|
case "item-inputslist":
|
|
case "item-inputs-list":
|
|
case "iteminputslist":
|
|
$item = current($this->purchased);
|
|
if (empty($item->data)) return false;
|
|
$before = ""; $after = ""; $classes = ""; $excludes = array();
|
|
if (!empty($options['class'])) $classes = ' class="'.$options['class'].'"';
|
|
if (!empty($options['exclude'])) $excludes = explode(",",$options['exclude']);
|
|
if (!empty($options['before'])) $before = $options['before'];
|
|
if (!empty($options['after'])) $after = $options['after'];
|
|
|
|
$result .= $before.'<ul'.$classes.'>';
|
|
foreach ($item->data as $name => $data) {
|
|
if (in_array($name,$excludes)) continue;
|
|
$result .= '<li><strong>'.$name.'</strong>: '.$data.'</li>';
|
|
}
|
|
$result .= '</ul>'.$after;
|
|
return $result;
|
|
break;
|
|
case "has-data":
|
|
case "hasdata": return (is_array($this->data) && count($this->data) > 0); break;
|
|
case "orderdata":
|
|
if (!$this->dataloop) {
|
|
reset($this->data);
|
|
$this->dataloop = true;
|
|
} else next($this->data);
|
|
|
|
if (current($this->data) !== false) return true;
|
|
else {
|
|
$this->dataloop = false;
|
|
return false;
|
|
}
|
|
break;
|
|
case "data":
|
|
if (!is_array($this->data)) return false;
|
|
$data = current($this->data);
|
|
$name = key($this->data);
|
|
if (isset($options['name'])) return $name;
|
|
return $data;
|
|
break;
|
|
case "has-promo":
|
|
case "haspromo":
|
|
if (empty($options['name'])) return false;
|
|
return (in_array($options['name'],$this->promos));
|
|
break;
|
|
case "subtotal": return money($this->subtotal); break;
|
|
case "hasfreight": return (!empty($this->shipmethod) || $this->freight > 0);
|
|
case "freight": return money($this->freight); break;
|
|
case "hasdiscount": return ($this->discount > 0);
|
|
case "discount": return money($this->discount); break;
|
|
case "hastax": return ($this->tax > 0)?true:false;
|
|
case "tax": return money($this->tax); break;
|
|
case "total": return money($this->total); break;
|
|
case "status":
|
|
$labels = $Shopp->Settings->get('order_status');
|
|
if (empty($labels)) $labels = array('');
|
|
return $labels[$this->status];
|
|
break;
|
|
|
|
}
|
|
}
|
|
|
|
} // end Purchase class
|
|
|
|
class PurchasesExport {
|
|
var $sitename = "";
|
|
var $headings = false;
|
|
var $data = false;
|
|
var $defined = array();
|
|
var $purchase_cols = array();
|
|
var $purchased_cols = array();
|
|
var $selected = array();
|
|
var $recordstart = true;
|
|
var $content_type = "text/plain";
|
|
var $extension = "txt";
|
|
var $date_format = 'F j, Y';
|
|
var $time_format = 'g:i:s a';
|
|
|
|
function PurchasesExport () {
|
|
global $Shopp;
|
|
|
|
$this->purchase_cols = Purchase::exportcolumns();
|
|
$this->purchased_cols = Purchased::exportcolumns();
|
|
$this->defined = array_merge($this->purchase_cols,$this->purchased_cols);
|
|
|
|
$this->sitename = get_bloginfo('name');
|
|
$this->headings = ($Shopp->Settings->get('purchaselog_headers') == "on");
|
|
$this->selected = $Shopp->Settings->get('purchaselog_columns');
|
|
$this->date_format = get_option('date_format');
|
|
$this->time_format = get_option('time_format');
|
|
$Shopp->Settings->save('purchaselog_lastexport',mktime());
|
|
}
|
|
|
|
function query ($request=array()) {
|
|
$db =& DB::get();
|
|
if (empty($request)) $request = $_GET;
|
|
|
|
if (!empty($request['start'])) {
|
|
list($month,$day,$year) = explode("/",$request['start']);
|
|
$starts = mktime(0,0,0,$month,$day,$year);
|
|
}
|
|
|
|
if (!empty($request['end'])) {
|
|
list($month,$day,$year) = explode("/",$request['end']);
|
|
$ends = mktime(0,0,0,$month,$day,$year);
|
|
}
|
|
|
|
$where = "WHERE o.id IS NOT NULL AND p.id IS NOT NULL ";
|
|
if (isset($request['status'])) $where .= "AND status='{$request['status']}'";
|
|
if (isset($request['s']) && !empty($request['s'])) $where .= " AND (id='{$request['s']}' OR firstname LIKE '%{$request['s']}%' OR lastname LIKE '%{$request['s']}%' OR CONCAT(firstname,' ',lastname) LIKE '%{$request['s']}%' OR transactionid LIKE '%{$request['s']}%')";
|
|
if (!empty($request['start']) && !empty($request['end'])) $where .= " AND (UNIX_TIMESTAMP(o.created) >= $starts AND UNIX_TIMESTAMP(o.created) <= $ends)";
|
|
|
|
$purchasetable = DatabaseObject::tablename(Purchase::$table);
|
|
$purchasedtable = DatabaseObject::tablename(Purchased::$table);
|
|
|
|
$c = 0; $columns = array();
|
|
foreach ($this->selected as $column) $columns[] = "$column AS col".$c++;
|
|
$query = "SELECT ".join(",",$columns)." FROM $purchasedtable AS p LEFT JOIN $purchasetable AS o ON o.id=p.purchase $where ORDER BY o.created ASC";
|
|
$this->data = $db->query($query,AS_ARRAY);
|
|
}
|
|
|
|
// Implement for exporting all the data
|
|
function output () {
|
|
if (!$this->data) $this->query();
|
|
if (!$this->data) return false;
|
|
|
|
header("Content-type: $this->content_type; charset=UTF-8");
|
|
header("Content-Disposition: attachment; filename=\"$this->sitename Purchase Log.$this->extension\"");
|
|
header("Content-Description: Delivered by WordPress/Shopp ".SHOPP_VERSION);
|
|
header("Cache-Control: maxage=1");
|
|
header("Pragma: public");
|
|
|
|
$this->begin();
|
|
if ($this->headings) $this->heading();
|
|
$this->records();
|
|
$this->end();
|
|
}
|
|
|
|
function begin() {}
|
|
|
|
function heading () {
|
|
foreach ($this->selected as $name)
|
|
$this->export($this->defined[$name]);
|
|
$this->record();
|
|
}
|
|
|
|
function records () {
|
|
foreach ($this->data as $key => $record) {
|
|
foreach(get_object_vars($record) as $column)
|
|
$this->export($this->parse($column));
|
|
$this->record();
|
|
}
|
|
}
|
|
|
|
function parse ($column) {
|
|
if (preg_match("/^[sibNaO](?:\:.+?\{.*\}$|\:.+;$|;$)/",$column)) {
|
|
$list = unserialize($column);
|
|
$column = "";
|
|
foreach ($list as $name => $value)
|
|
$column .= (empty($column)?"":";")."$name:$value";
|
|
}
|
|
return $column;
|
|
}
|
|
|
|
function end() {}
|
|
|
|
// Implement for exporting a single value
|
|
function export ($value) {
|
|
echo ($this->recordstart?"":"\t").$value;
|
|
$this->recordstart = false;
|
|
}
|
|
|
|
function record () {
|
|
echo "\n";
|
|
$this->recordstart = true;
|
|
}
|
|
|
|
function settings () {}
|
|
|
|
}
|
|
|
|
class PurchasesTabExport extends PurchasesExport {
|
|
function PurchasesTabExport () {
|
|
parent::PurchasesExport();
|
|
$this->output();
|
|
}
|
|
}
|
|
|
|
class PurchasesCSVExport extends PurchasesExport {
|
|
function PurchasesCSVExport () {
|
|
parent::PurchasesExport();
|
|
$this->content_type = "text/csv";
|
|
$this->extension = "csv";
|
|
$this->output();
|
|
}
|
|
|
|
function export ($value) {
|
|
$value = str_replace('"','""',$value);
|
|
if (preg_match('/^\s|[,"\n\r]|\s$/',$value)) $value = '"'.$value.'"';
|
|
echo ($this->recordstart?"":",").$value;
|
|
$this->recordstart = false;
|
|
}
|
|
|
|
}
|
|
|
|
class PurchasesXLSExport extends PurchasesExport {
|
|
function PurchasesXLSExport () {
|
|
parent::PurchasesExport();
|
|
$this->content_type = "application/vnd.ms-excel";
|
|
$this->extension = "xls";
|
|
$this->c = 0; $this->r = 0;
|
|
$this->output();
|
|
}
|
|
|
|
function begin () {
|
|
echo pack("ssssss", 0x809, 0x8, 0x0, 0x10, 0x0, 0x0);
|
|
}
|
|
|
|
function end () {
|
|
echo pack("ss", 0x0A, 0x00);
|
|
}
|
|
|
|
function export ($value) {
|
|
if (preg_match('/^[\d\.]+$/',$value)) {
|
|
echo pack("sssss", 0x203, 14, $this->r, $this->c, 0x0);
|
|
echo pack("d", $value);
|
|
} else {
|
|
$l = strlen($value);
|
|
echo pack("ssssss", 0x204, 8+$l, $this->r, $this->c, 0x0, $l);
|
|
echo $value;
|
|
}
|
|
$this->c++;
|
|
}
|
|
|
|
function record () {
|
|
$this->c = 0;
|
|
$this->r++;
|
|
}
|
|
}
|
|
|
|
class PurchasesIIFExport extends PurchasesExport {
|
|
function PurchasesIIFExport () {
|
|
global $Shopp;
|
|
parent::PurchasesExport();
|
|
$this->content_type = "application/qbooks";
|
|
$this->extension = "iif";
|
|
$account = $Shopp->Settings->get('purchaselog_iifaccount');
|
|
if (empty($account)) $account = "Merchant Account";
|
|
$this->selected = array(
|
|
"'\nTRNS'",
|
|
"DATE_FORMAT(o.created,'\"%m/%d/%Y\"')",
|
|
"'\"$account\"'",
|
|
"CONCAT('\"',o.firstname,' ',o.lastname,'\"')",
|
|
"'\"Shopp Payment Received\"'",
|
|
"o.total-o.fees",
|
|
"''",
|
|
"'\nSPL'",
|
|
"DATE_FORMAT(o.created,'\"%m/%d/%Y\"')",
|
|
"'\"Other Income\"'",
|
|
"CONCAT('\"',o.firstname,' ',o.lastname,'\"')",
|
|
"o.total*-1",
|
|
"'\nSPL'",
|
|
"DATE_FORMAT(o.created,'\"%m/%d/%Y\"')",
|
|
"'\"Other Expenses\"'",
|
|
"'Fee'",
|
|
"o.fees",
|
|
"''",
|
|
"'\nENDTRNS'"
|
|
);
|
|
$this->output();
|
|
}
|
|
|
|
function begin () {
|
|
echo "!TRNS\tDATE\tACCNT\tNAME\tCLASS\tAMOUNT\tMEMO\n!SPL\tDATE\tACCNT\tNAME\tAMOUNT\tMEMO\n!ENDTRNS";
|
|
}
|
|
|
|
function export ($value) {
|
|
echo (substr($value,0,1) != "\n")?"\t".$value:$value;
|
|
}
|
|
|
|
function record () { }
|
|
|
|
function settings () {
|
|
global $Shopp;
|
|
?>
|
|
<div id="iif-settings" class="hidden">
|
|
<input type="text" id="iif-account" name="settings[purchaselog_iifaccount]" value="<?php echo $Shopp->Settings->get('purchaselog_iifaccount'); ?>" size="30"/><br />
|
|
<label for="iif-account"><small><?php _e('QuickBooks account name for transactions','Shopp'); ?></small></label>
|
|
</div>
|
|
<script type="text/javascript">
|
|
jQuery(document).ready( function() {
|
|
var $=jQuery.noConflict();
|
|
$('#purchaselog-format').change(function () {
|
|
if ($(this).val() == "iif") {
|
|
$('#export-columns').hide();
|
|
$('#iif-settings').show();
|
|
$('#iif-account').focus();
|
|
} else {
|
|
$('#export-columns').show();
|
|
$('#iif-settings').hide();
|
|
}
|
|
}).change();
|
|
});
|
|
</script>
|
|
<?php
|
|
}
|
|
}
|
|
|
|
|
|
?>
|