Пример #1
0
 public function __construct()
 {
     parent::__construct();
     $this->content_type = "application/qbooks";
     $this->extension = "iif";
     $account = shopp_setting('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();
 }
Пример #2
0
	function PurchasesIIFExport () {
		global $Ecart;
		parent::PurchasesExport();
		$this->content_type = "application/qbooks";
		$this->extension = "iif";
		$account = $Ecart->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,'\"')",
			"'\"Ecart 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();
	}