PageRenderTime 52ms CodeModel.GetById 13ms RepoModel.GetById 0ms app.codeStats 0ms

/web-invoice.php

http://web-invoice.googlecode.com/
PHP | 1336 lines | 1089 code | 182 blank | 65 comment | 216 complexity | 549454dca8e94c4b4a9ac61de3f18642 MD5 | raw file
Possible License(s): GPL-3.0

Large files files are truncated, but you can click here to view the full file

    

  1. <?php

    2. 

  2. /*

    3. 

  3.  Plugin Name: Web Invoice

    4. 

  4.  Plugin URI: http://mohanjith.com/wordpress/web-invoice.html

    5. 

  5.  Description: Send itemized web invoices directly to your clients.  Credit card payments may be accepted via Authorize.net, MerchantPlus NaviGate, Moneybookers, AlertPay, Google Checkout or PayPal account. Recurring billing is also available via Authorize.net's ARB, Moneybookers, Google Checkout and PayPal. Visit <a href="admin.php?page=web_invoice_settings">Web Invoice Settings Page</a> to setup.

    6. 

  6.  Author: S H Mohanjith (Zinglix)

    7. 

  7.  Version: 2.1.0

    8. 

  8.  Author URI: http://mohanjith.com/

    9. 

  9.  Text Domain: web-invoice

    10. 

  10.  Stable tag: 2.1.0

    11. 

  11.  License: GPL

    12. 

  12. 

    13. 

  13.  Copyright 2011  S H Mohanjith (email : moha@mohanjith.net)

    14. 

  14.  */

    15. 

  15. 

    16. 

  16. /*

    17. 

  17.  Created by TwinCitiesTech.com

    18. 

  18.  (website: twincitiestech.com       email : support@twincitiestech.com)

    19. 

  19. 

    20. 

  20.  Modified by S H Mohanjith

    21. 

  21.  (website: mohanjith.com       email : support@mohanjith.com)

    22. 

  22. 

    23. 

  23.  This program is free software; you can redistribute it and/or modify

    24. 

  24.  it under the terms of the GNU General Public License as published by

    25. 

  25.  the Free Software Foundation; version 3 of the License, with the

    26. 

  26.  exception of the JQuery JavaScript framework which is released

    27. 

  27.  under it's own license.  You may view the details of that license in

    28. 

  28.  the prototype.js file.

    29. 

  29. 

    30. 

  30.  This program is distributed in the hope that it will be useful,

    31. 

  31.  but WITHOUT ANY WARRANTY; without even the implied warranty of

    32. 

  32.  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

    33. 

  33.  GNU General Public License for more details.

    34. 

  34. 

    35. 

  35.  You should have received a copy of the GNU General Public License

    36. 

  36.  along with this program; if not, write to the Free Software

    37. 

  37.  Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA

    38. 

  38.  */

    39. 

  39. 

    40. 

  40. define("WEB_INVOICE_VERSION_NUM", "2.1.0");

    41. 

  41. define("WEB_INVOICE_PHP_VERSION", "5.2");

    42. 

  42. define("WEB_INVOICE_TRANS_DOMAIN", "web-invoice");

    43. 

  43. 

    44. 

  44. require_once "Flow.php";

    45. 

  45. require_once "Functions.php";

    46. 

  46. require_once "Display.php";

    47. 

  47. require_once "Frontend.php";

    48. 

  48. 

    49. 

  49. global $web_invoice, $web_invoice_print, $web_invoice_memory_head_room;

    50. 

  50. global $_web_invoice_getinfo, $_web_invoice_payment_cache, $_web_invoice_payment_meta_cache, $_web_invoice_clear_cache;

    51. 

  51. 

    52. 

  52. $web_invoice_memory_head_room = web_invoice_return_bytes(ini_get('memory_limit'))-memory_get_usage();

    53. 

  53. 

    54. 

  54. $web_invoice_print = false;

    55. 

  55. 

    56. 

  56. $php_version_check = version_compare(WEB_INVOICE_PHP_VERSION, PHP_VERSION, '<');

    57. 

  57. 

    58. 

  58. if ($_GET['action'] == 'error_scrape') {

    59. 

  59.     die(sprintf(__("Web Invoice requires PHP ".WEB_INVOICE_PHP_VERSION." or better. Please upgrade or switch to a host that supports PHP ".WEB_INVOICE_PHP_VERSION." like %s.", WEB_INVOICE_TRANS_DOMAIN), '<a href="http://bit.ly/atOh9t" target="_blank">Pacific Host</a>'));

    60. 

  60. }

    61. 

  61. 

    62. 

  62. if ( $php_version_check )

    63. 

  63. {	

    64. 

  64.     class Web_Invoice

    65. 

  65.     {

    66. 

  66. 	

    67. 

  67. 	var $Invoice;

    68. 

  68.     	var $web_invoice_user_level = array('administrator');

    69. 

  69.     	var $uri;

    70. 

  70.     	var $the_path;

    71. 

  71.     	var $message;

    72. 

  72. 	

    73. 

  73. 	static function tablename ($table)

    74. 

  74. 	{

    75. 

  75. 	    global $table_prefix;

    76. 

  76. 	    return $table_prefix.'web_invoice_'.$table;

    77. 

  77. 	}

    78. 

  78. 	

    79. 

  79.     	function the_path()

    80. 

  80. 	{

    81. 

  81.     	    $path = WP_PLUGIN_URL."/".basename(dirname(__FILE__));

    82. 

  82. 	    return $path;

    83. 

  83.     	}

    84. 

  84. 	

    85. 

  85. 	function frontend_path()

    86. 

  86. 	{

    87. 

  87. 	    $path = WP_PLUGIN_URL."/".basename(dirname(__FILE__));

    88. 

  88. 	

    89. 

  89. 	    if(get_option('web_invoice_force_https') == 'true')

    90. 

  90. 		$path = str_replace('http://','https://',$path);

    91. 

  91. 	    return $path;

    92. 

  92. 	}

    93. 

  93. 	

    94. 

  94. 	function Web_Invoice()

    95. 

  95. 	{

    96. 

  96. 	    $version = get_option('web_invoice_version');

    97. 

  97. 	    $_file = "web-invoice/" . basename(__FILE__);

    98. 

  98. 	    

    99. 

  99. 	    $this->path = dirname(__FILE__);

    100. 

  100. 	    $this->file = basename(__FILE__);

    101. 

  101. 	    $this->directory = basename($this->path);

    102. 

  102. 	    $this->uri = WP_PLUGIN_URL."/".$this->directory;

    103. 

  103. 	    $this->the_path = $this->the_path();

    104. 

  104. 	    

    105. 

  105. 	    register_activation_hook($_file, array(&$this, 'install'));

    106. 

  106. 	    register_deactivation_hook($_file, array(&$this, 'uninstall'));

    107. 

  107. 	    

    108. 

  108. 	    add_action('init',  array($this, 'init'), 0);

    109. 

  109. 	    add_action('profile_update','web_invoice_profile_update');

    110. 

  110. 	    add_action('edit_user_profile', 'web_invoice_user_profile_fields');

    111. 

  111. 	    add_action('show_user_profile', 'web_invoice_user_profile_fields');

    112. 

  112. 	    add_action('wp', array($this, 'api'));

    113. 

  113. 	    add_action('admin_head', array($this, 'admin_head'));

    114. 

  114. 	    add_action('contextual_help', 'web_invoice_contextual_help_list', 10, 3);

    115. 

  115. 	    add_action('wp_head', 'web_invoice_frontend_css');

    116. 

  116. 	    add_action('admin_menu', array($this, 'web_invoice_add_pages'));

    117. 

  117. 	    

    118. 

  118. 	    add_filter('favorite_actions', array(&$this, 'favorites'));

    119. 

  119. 	    

    120. 

  120. 	    if (strcasecmp(get_option('web_invoice_payment_method'), 'cc') || strcasecmp(get_option('web_invoice_payment_method'), 'pfp')) {

    121. 

  121. 		add_action('wp_head', 'web_invoice_frontend_js');

    122. 

  122. 	    }

    123. 

  123. 	    

    124. 

  124. 	    add_filter('the_content', 'web_invoice_the_content');

    125. 

  125. 	    add_filter('web_invoice_email_variables', 'web_invoice_email_variables');

    126. 

  126. 	    add_filter('web_invoice_pdf_variables', 'web_invoice_pdf_variables');

    127. 

  127. 	    add_filter('web_invoice_html_variables', 'web_invoice_html_variables');

    128. 

  128. 	    add_filter('web_invoice_web_variables', 'web_invoice_web_variables');

    129. 

  129. 	    add_filter('wp_redirect', array($this, 'redirect'));

    130. 

  130. 	    

    131. 

  131. 	    $this->SetUserAccess(get_option('web_invoice_user_level'));

    132. 

  132. 	}

    133. 

  133. 	

    134. 

  134. 	function SetUserAccess($level = 8)

    135. 

  135. 	{

    136. 

  136. 	    if (is_array($level) && count($level) > 0) {

    137. 

  137. 		$this->web_invoice_user_level = 'manage_web_invoice';

    138. 

  138. 	    } else {

    139. 

  139. 		$this->web_invoice_user_level = $level;

    140. 

  140. 	    }

    141. 

  141. 	}

    142. 

  142. 	

    143. 

  143. 	function redirect($location)

    144. 

  144. 	{

    145. 

  145. 	    if (get_option('web_invoice_redirect_after_user_add') == 'yes' && preg_match('/^users\.php\?usersearch/', $location) > 0) {

    146. 

  146. 		return 'admin.php?page=new_web_invoice';

    147. 

  147. 	    }

    148. 

  148. 	    return $location;

    149. 

  149. 	}

    150. 

  150. 	

    151. 

  151. 	function admin_head()

    152. 

  152. 	{

    153. 

  153. 	    echo "<link rel='stylesheet' href='".$this->uri."/css/wp_admin.css?v=".WEB_INVOICE_VERSION_NUM."' type='text/css'type='text/css' media='all' />";

    154. 

  154. 	}

    155. 

  155. 	

    156. 

  156. 	function web_invoice_add_pages()

    157. 

  157. 	{

    158. 

  158. 	    $file = "web-invoice/" . basename(__FILE__);

    159. 

  159. 	    

    160. 

  160. 	    add_menu_page(__('Web Invoice System', WEB_INVOICE_TRANS_DOMAIN), __('Web Invoice', WEB_INVOICE_TRANS_DOMAIN),  $this->web_invoice_user_level, $file, array(&$this,'invoice_overview'),$this->uri."/images/web_invoice.png");

    161. 

  161. 	    add_submenu_page($file, __("Recurring Billing", WEB_INVOICE_TRANS_DOMAIN), __("Recurring Billing", WEB_INVOICE_TRANS_DOMAIN), $this->web_invoice_user_level, 'web_invoice_recurring_billing', array(&$this,'recurring'));

    162. 

  162. 	    add_submenu_page($file, __("Manage Invoice", WEB_INVOICE_TRANS_DOMAIN), __("New Invoice", WEB_INVOICE_TRANS_DOMAIN), $this->web_invoice_user_level, 'new_web_invoice', array(&$this,'new_web_invoice'));

    163. 

  163. 	    add_submenu_page($file, __("Templates", WEB_INVOICE_TRANS_DOMAIN), __("Templates", WEB_INVOICE_TRANS_DOMAIN), $this->web_invoice_user_level, 'web_invoice_templates', array(&$this,'template_page'));

    164. 

  164. 	    // add_submenu_page($file, __("Items/Inventory"), __("Items"), $this->web_invoice_user_level, 'web_invoice_inventory_items', array(&$this,'inventory_items_page'));

    165. 

  165. 	    add_submenu_page($file, __("Settings", WEB_INVOICE_TRANS_DOMAIN), __("Settings", WEB_INVOICE_TRANS_DOMAIN), $this->web_invoice_user_level, 'web_invoice_settings', array(&$this,'settings_page'));

    166. 

  166. 	    

    167. 

  167. 	    add_submenu_page('profile.php', __("Your invoices", WEB_INVOICE_TRANS_DOMAIN), __("Invoices", WEB_INVOICE_TRANS_DOMAIN), 'subscriber', 'user_invoice_overview', array(&$this,'user_invoice_overview'));

    168. 

  168. 	}

    169. 

  169. 	

    170. 

  170. 	function security()

    171. 

  171. 	{

    172. 

  172. 	    //More to come later

    173. 

  173. 	    if(($_REQUEST['eqdkp_data'])) {

    174. 

  174. 		setcookie('eqdkp_data');

    175. 

  175. 	    };

    176. 

  176. 	}

    177. 

  177. 	

    178. 

  178. 	function new_web_invoice()

    179. 

  179. 	{

    180. 

  180. 	    $Web_Invoice_Decider = new Web_Invoice_Decider('doInvoice');

    181. 

  181. 	    if($this->message) {

    182. 

  182. 		echo "<div id=\"message\" class='error' ><p>".$this->message."</p></div>";

    183. 

  183. 	    }

    184. 

  184. 	    echo $Web_Invoice_Decider->display();

    185. 

  185. 	}

    186. 

  186. 	

    187. 

  187. 	function favorites($actions)

    188. 

  188. 	{

    189. 

  189. 	    $key = 'admin.php?page=new_web_invoice';

    190. 

  190. 	    $actions[$key] = array(__('New Invoice', WEB_INVOICE_TRANS_DOMAIN),$this->web_invoice_user_level);

    191. 

  191. 	    return $actions;

    192. 

  192. 	}

    193. 

  193. 	

    194. 

  194. 	function recurring()

    195. 

  195. 	{

    196. 

  196. 	    $Web_Invoice_Decider = new Web_Invoice_Decider('web_invoice_recurring_billing');

    197. 

  197. 	    if($this->message) {

    198. 

  198. 		echo "<div id=\"message\" class='error' ><p>".$this->message."</p></div>";

    199. 

  199. 	    }

    200. 

  200. 	    echo $Web_Invoice_Decider->display();

    201. 

  201. 	}

    202. 

  202. 	

    203. 

  203. 	function api()

    204. 

  204. 	{

    205. 

  205. 	    if(get_option('web_invoice_web_invoice_page') != '' && is_page(get_option('web_invoice_web_invoice_page')))

    206. 

  206. 	    {

    207. 

  207. 		if((get_option('web_invoice_moneybookers_merchant') == 'True') && isset($_POST['mb_transaction_id']) && isset($_POST['status'])) {

    208. 

  208. 		    require_once("gateways/moneybookers.class.php");

    209. 

  209. 		    $moneybookers_obj = new Web_Invoice_Moneybookers($_POST['transaction_id']);

    210. 

  210. 		    $moneybookers_obj->processRequest($_SERVER['REMOTE_ADDR'], $_POST);

    211. 

  211. 		} else if((get_option('web_invoice_alertpay_merchant') == 'True') && isset($_POST['ap_itemname']) && isset($_POST['ap_securitycode'])) {

    212. 

  212. 		    require_once("gateways/alertpay.class.php");

    213. 

  213. 		    $alertpay_obj = new Web_Invoice_AlertPay($_POST['ap_itemname']);

    214. 

  214. 		    $alertpay_obj->processRequest($_SERVER['REMOTE_ADDR'], $_POST);

    215. 

  215. 		} else if((get_option('web_invoice_google_checkout_level2') == 'True') && isset($_POST['_type'])) {

    216. 

  216. 		    require_once("gateways/googlecheckout.class.php");

    217. 

  217. 		    $gc_obj = new Web_Invoice_GoogleCheckout($_POST['_type'], $_POST);

    218. 

  218. 		    $gc_obj->processRequest($_SERVER['REMOTE_ADDR'], $_POST);

    219. 

  219. 		} else if((get_option('web_invoice_payflow_silent_post') == 'True') && isset($_POST['PNREF'])) {

    220. 

  220. 		    require_once("gateways/payflow.class.php");

    221. 

  221. 		    $pf_obj = new Web_Invoice_Payflow($_POST['CUSTID'], $_POST);

    222. 

  222. 		    $pf_obj->processRequest($_SERVER['REMOTE_ADDR'], $_POST);

    223. 

  223. 		} else if (isset($_GET['crypt'])) {

    224. 

  224. 		    require_once("gateways/sagepay.class.php");

    225. 

  225. 		    $pf_obj = new Web_Invoice_SagePay($_GET['crypt']);

    226. 

  226. 		    $pf_obj->processRequest($_SERVER['REMOTE_ADDR']);

    227. 

  227. 		} else if (isset($_GET['paypal_ipn'])) {

    228. 

  228. 		    require_once("gateways/paypal.class.php");

    229. 

  229. 		    $pf_obj = new Web_Invoice_Paypal($_POST['invoice']);

    230. 

  230. 		    $pf_obj->processRequest($_SERVER['REMOTE_ADDR'], $_POST);

    231. 

  231. 		} else if (isset($_REQUEST['order_number'])) {

    232. 

  232. 		    require_once("gateways/2co.class.php");

    233. 

  233. 		    $tco_obj = new Web_Invoice_2CO($_GET['cart_order_id']);

    234. 

  234. 		    $tco_obj->processRequest($_SERVER['REMOTE_ADDR'], $_REQUEST);

    235. 

  235. 		}

    236. 

  236. 		

    237. 

  237. 		wp_enqueue_script('jquery');

    238. 

  238. 		wp_enqueue_script('web-invoice',$this->uri."/js/web-invoice-frontend.js", array('jquery'), WEB_INVOICE_VERSION_NUM);

    239. 

  239. 		

    240. 

  240. 		// Make sure proper MD5 is being passed (32 chars), and strip of everything but numbers and letters

    241. 

  241. 		if(isset($_GET['invoice_id']) && strlen($_GET['invoice_id']) != 32)

    242. 

  242. 		{

    243. 

  243. 		    unset($_GET['invoice_id']);

    244. 

  244. 		}

    245. 

  245. 		

    246. 

  246. 		$_GET['invoice_id'] = preg_replace('/[^A-Za-z0-9-]/', '', $_GET['invoice_id']);

    247. 

  247. 		

    248. 

  248. 		// Make sure proper MD5 is being passed (32 chars), and strip of everything but numbers and letters

    249. 

  249. 		if (isset($_GET['generate_from']) && strlen($_GET['generate_from']) != 32)

    250. 

  250. 		{

    251. 

  251. 		    unset($_GET['generate_from']);

    252. 

  252. 		}

    253. 

  253. 		$_GET['generate_from'] = preg_replace('/[^A-Za-z0-9-]/', '', $_GET['generate_from']);

    254. 

  254. 		

    255. 

  255. 		if (isset($_GET['generate_from']) && !empty($_GET['generate_from']) && (get_option('web_invoice_self_generate_from_template') == "yes"))

    256. 

  256. 		{

    257. 

  257. 		    global $current_user;

    258. 

  258. 		    get_currentuserinfo();

    259. 

  259. 		    

    260. 

  260. 		    if ($current_user->ID > 0)

    261. 

  261. 		    {

    262. 

  262. 			// Convert MD5 hash into Actual Invoice ID

    263. 

  263. 			$template_id = web_invoice_md5_to_invoice($_GET['generate_from']);

    264. 

  264. 			$invoice_id = web_invoice_self_generate_from_template($template_id, $current_user->ID);

    265. 

  265. 			

    266. 

  266. 			$web_invoice_getinfo = new Web_Invoice_GetInfo($invoice_id);

    267. 

  267. 			wp_redirect($web_invoice_getinfo->display('link'));

    268. 

  268. 			

    269. 

  269. 			exit(0);

    270. 

  270. 		    }

    271. 

  271. 		}

    272. 

  272. 		

    273. 

  273. 		if (isset($_GET['print']))

    274. 

  274. 		{

    275. 

  275. 		    web_invoice_print_pdf();

    276. 

  276. 		}

    277. 

  277. 	    }

    278. 

  278. 	}

    279. 

  279. 	

    280. 

  280. 	function invoice_overview()

    281. 

  281. 	{

    282. 

  282. 	    $web_invoice_web_invoice_page = get_option("web_invoice_web_invoice_page");

    283. 

  283. 	    

    284. 

  284. 	    $Web_Invoice_Decider = new Web_Invoice_Decider('overview');

    285. 

  285. 	    

    286. 

  286. 	    if($this->message)

    287. 

  287. 	    {

    288. 

  288. 		echo "<div id=\"message\" class='error' ><p>".$this->message."</p></div>";

    289. 

  289. 	    }

    290. 

  290. 	    if(!function_exists('curl_exec'))

    291. 

  291. 	    {

    292. 

  292. 		echo "<div id=\"message\" class='error' ><p>".__('cURL is not turned on on your server, credit card processing will not work. If you have access to your php.ini file, activate <b>extension=php_curl.dll</b>.', WEB_INVOICE_TRANS_DOMAIN)."</p></div>";

    293. 

  293. 	    }

    294. 

  294. 	    echo $Web_Invoice_Decider->display();

    295. 

  295. 	}

    296. 

  296. 	

    297. 

  297. 	function user_invoice_overview()

    298. 

  298. 	{

    299. 

  299. 	    $web_invoice_web_invoice_page = get_option("web_invoice_web_invoice_page");

    300. 

  300. 	    

    301. 

  301. 	    $Web_Invoice_Decider = new Web_Invoice_Decider('user_overview');

    302. 

  302. 	    

    303. 

  303. 	    if($this->message)

    304. 

  304. 	    {

    305. 

  305. 		echo "<div id=\"message\" class='error' ><p>".$this->message."</p></div>";

    306. 

  306. 	    }

    307. 

  307. 	    echo $Web_Invoice_Decider->display();

    308. 

  308. 	}

    309. 

  309. 	

    310. 

  310. 	function settings_page()

    311. 

  311. 	{

    312. 

  312. 	    $Web_Invoice_Decider = new Web_Invoice_Decider('web_invoice_settings');

    313. 

  313. 	    if($this->message)

    314. 

  314. 	    {

    315. 

  315. 		echo "<div id=\"message\" class='error' ><p>".$this->message."</p></div>";

    316. 

  316. 	    }

    317. 

  317. 	    echo $Web_Invoice_Decider->display();

    318. 

  318. 	}

    319. 

  319. 	

    320. 

  320. 	function template_page()

    321. 

  321. 	{

    322. 

  322. 	    $Web_Invoice_Decider = new Web_Invoice_Decider('web_invoice_email_templates');

    323. 

  323. 	    if($this->message)

    324. 

  324. 	    {

    325. 

  325. 		echo "<div id=\"message\" class='error' ><p>".$this->message."</p></div>";

    326. 

  326. 	    }

    327. 

  327. 	    echo $Web_Invoice_Decider->display();

    328. 

  328. 	}

    329. 

  329. 	

    330. 

  330. 	function inventory_items_page()

    331. 

  331. 	{

    332. 

  332. 	    $Web_Invoice_Decider = new Web_Invoice_Decider('web_invoice_inventory_items');

    333. 

  333. 	    if($this->message)

    334. 

  334. 	    {

    335. 

  335. 		echo "<div id=\"message\" class='error' ><p>".$this->message."</p></div>";

    336. 

  336. 	    }

    337. 

  337. 	    echo $Web_Invoice_Decider->display();

    338. 

  338. 	}

    339. 

  339. 	

    340. 

  340. 	function init()

    341. 

  341. 	{

    342. 

  342. 	    global $wpdb, $wp_version;

    343. 

  343. 	    

    344. 

  344. 	    if (version_compare($wp_version, '2.6', '<'))

    345. 

  345. 	    {

    346. 

  346. 		// Using old WordPress

    347. 

  347. 		load_plugin_textdomain(WEB_INVOICE_TRANS_DOMAIN, PLUGINDIR.'/'.dirname(plugin_basename(__FILE__)).'/languages');

    348. 

  348. 	    } else {

    349. 

  349. 		load_plugin_textdomain(WEB_INVOICE_TRANS_DOMAIN, PLUGINDIR.'/'.dirname(plugin_basename(__FILE__)).'/languages', dirname(plugin_basename(__FILE__)).'/languages');

    350. 

  350. 	    }

    351. 

  351. 	    

    352. 

  352. 	    if (is_admin())

    353. 

  353. 	    {

    354. 

  354. 		if (is_multisite() && !get_option('web_invoice_installed', false)) {

    355. 

  355. 		    $this->install();

    356. 

  356. 		}

    357. 

  357. 		

    358. 

  358. 		wp_enqueue_script('jquery');

    359. 

  359. 		wp_enqueue_script('jquery-ui-core');

    360. 

  360. 		wp_enqueue_script('jquery-ui-tabs');

    361. 

  361. 		

    362. 

  362. 		wp_enqueue_script('jquery-maskedinput',$this->uri."/js/jquery.maskedinput.js", array('jquery'));

    363. 

  363. 		wp_enqueue_script('jquery-cookie',$this->uri."/js/jquery.cookie.js", array('jquery'));

    364. 

  364. 		wp_enqueue_script('jquery-form',$this->uri."/js/jquery.form.js", array('jquery') );

    365. 

  365. 		wp_enqueue_script('jquery-impromptu',$this->uri."/js/jquery-impromptu.1.7.js", array('jquery'), '1.8.0');

    366. 

  366. 		wp_enqueue_script('jquery-field',$this->uri."/js/jquery.field.min.js", array('jquery'), '1.8.0');

    367. 

  367. 		wp_enqueue_script('jquery-delegate',$this->uri."/js/jquery.delegate.js", array('jquery'), '1.8.0');

    368. 

  368. 		wp_enqueue_script('jquery-calculation',$this->uri."/js/jquery.calculation.min.js", array('jquery'), '1.8.0');

    369. 

  369. 		wp_enqueue_script('jquery-tablesorter',$this->uri."/js/jquery.tablesorter.min.js", array('jquery'), '1.8.0');

    370. 

  370. 		wp_enqueue_script('jquery-autogrow-textarea',$this->uri."/js/jquery.autogrow-textarea.js", array('jquery'), '1.8.0');

    371. 

  371. 		wp_enqueue_script('web-invoice',$this->uri."/js/web-invoice.js", array('jquery', 'jquery-ui-core', 'jquery-ui-tabs'), WEB_INVOICE_VERSION_NUM, true);

    372. 

  372. 	    } else {

    373. 

  373. 		if(isset($_POST['web_invoice_id_hash']))

    374. 

  374. 		{

    375. 

  375. 		    $md5_invoice_id = $_POST['web_invoice_id_hash'];

    376. 

  376. 		    $invoice_id = web_invoice_md5_to_invoice($md5_invoice_id);

    377. 

  377. 		    

    378. 

  378. 		    //Check to see if this is a credit card transaction, if so process

    379. 

  379. 		    if(web_invoice_does_invoice_exist($invoice_id))

    380. 

  380. 		    {

    381. 

  381. 			web_invoice_process_cc_transaction($_POST);

    382. 

  382. 			exit(0);

    383. 

  383. 		    }

    384. 

  384. 		}

    385. 

  385. 		

    386. 

  386. 		if (isset($_GET['invoice_id']))

    387. 

  387. 		{	

    388. 

  388. 		    $md5_invoice_id = $_GET['invoice_id'];

    389. 

  389. 		    // Convert MD5 hash into Actual Invoice ID

    390. 

  390. 		    $invoice_id = web_invoice_md5_to_invoice($md5_invoice_id);

    391. 

  391. 		    

    392. 

  392. 		    //Check if invoice exists, SSL enforcement is setup, and we are not currently browing HTTPS,  then reload page into HTTPS

    393. 

  393. 		    if (!function_exists('wp_https_redirect'))

    394. 

  394. 		    {

    395. 

  395. 			if (web_invoice_does_invoice_exist($invoice_id) &&

    396. 

  396. 			    get_option('web_invoice_force_https') == 'true' &&

    397. 

  397. 			    $_SERVER['HTTPS'] != "on" &&

    398. 

  398. 			    preg_match('/^https/', get_option('siteurl')) == 0)

    399. 

  399. 			{

    400. 

  400. 			    

    401. 

  401. 			    $host_x = preg_split('/\//', get_option('siteurl'));

    402. 

  402. 			    $host = $host_x[2];  

    403. 

  403. 			    header("Location: https://". $host . $_SERVER['REQUEST_URI']); 

    404. 

  404. 			    exit(0);

    405. 

  405. 			}

    406. 

  406. 		    }

    407. 

  407. 		}

    408. 

  408. 	    }

    409. 

  409. 	    if (empty($_GET['invoice_id']))

    410. 

  410. 	    {

    411. 

  411. 		unset($_GET['invoice_id']);

    412. 

  412. 	    }

    413. 

  413. 	}

    414. 

  414. 	

    415. 

  415. 	function uninstall()

    416. 

  416. 	{

    417. 

  417. 	    global $wpdb;

    418. 

  418. 	    // Nothing to do

    419. 

  419. 	}

    420. 

  420. 	

    421. 

  421. 	function install()

    422. 

  422. 	{

    423. 

  423. 	    global $wpdb;

    424. 

  424. 	    

    425. 

  425. 	    require_once(ABSPATH . 'wp-admin/includes/upgrade.php');

    426. 

  426. 	    

    427. 

  427. 	    if (!empty($wpdb->charset))

    428. 

  428. 	    {

    429. 

  429. 	        $charset_collate = "DEFAULT CHARACTER SET $wpdb->charset";

    430. 

  430. 	    }

    431. 

  431. 	    if (!empty($wpdb->collate))

    432. 

  432. 	    {

    433. 

  433. 	        $charset_collate .= " COLLATE $wpdb->collate";

    434. 

  434. 	    }

    435. 

  435. 	    

    436. 

  436. 	    //change old table name to new one

    437. 

  437. 	    if($wpdb->get_var("SHOW TABLES LIKE 'web_invoice'"))

    438. 

  438. 	    {

    439. 

  439. 		global $table_prefix;

    440. 

  440. 		$sql_update = "RENAME TABLE ".$table_prefix."invoice TO ". Web_Invoice::tablename('main')."";

    441. 

  441. 		$wpdb->query($sql_update);

    442. 

  442. 	    }

    443. 

  443. 	    

    444. 

  444. 	    if($wpdb->get_var("SHOW TABLES LIKE '". Web_Invoice::tablename('main') ."'") != Web_Invoice::tablename('main'))

    445. 

  445. 	    {

    446. 

  446. 		$sql_main = "CREATE TABLE IF NOT EXISTS ". Web_Invoice::tablename('main') ." (

    447. 

  447. 				id int(11) NOT NULL auto_increment,

    448. 

  448. 				invoice_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

    449. 

  449. 				amount double default '0',

    450. 

  450. 				description text NOT NULL,

    451. 

  451. 				invoice_num varchar(45) NOT NULL default '',

    452. 

  452. 				user_id varchar(20) NOT NULL default '',

    453. 

  453. 				subject text NOT NULL,

    454. 

  454. 				itemized text NOT NULL,

    455. 

  455. 				status int(11) NOT NULL,

    456. 

  456. 				PRIMARY KEY  (id),

    457. 

  457. 				UNIQUE KEY invoice_num (invoice_num)

    458. 

  458. 			    ) {$charset_collate};";

    459. 

  459. 		dbDelta($sql_main);

    460. 

  460. 	    } else {

    461. 

  461. 		if ($wpdb->get_var("SHOW COLUMNS FROM ". Web_Invoice::tablename('main') ." LIKE 'invoice_date'") != 'invoice_date')

    462. 

  462. 		{

    463. 

  463. 		    $wpdb->query("ALTER TABLE ". Web_Invoice::tablename('main') ." ADD invoice_date TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER id;");

    464. 

  464. 		    $all_invoices = $wpdb->get_results("SELECT DISTINCT invoice_id, time_stamp FROM ". Web_Invoice::tablename('log') ." WHERE action_type = 'created'");

    465. 

  465. 		    foreach ($all_invoices as $invoice_log) {

    466. 

  466. 			$wpdb->query("UPDATE ". Web_Invoice::tablename('main') ." SET invoice_date = '{$invoice_log->time_stamp}' WHERE invoice_date = '0000-00-00 00:00:00' AND invoice_num = '{$invoice_log->invoice_id}'");

    467. 

  467. 		    }

    468. 

  468. 		}

    469. 

  469. 	    }

    470. 

  470. 	

    471. 

  471. 	    if(preg_match('/^4\.0.*/', $wpdb->get_var("SELECT version()")) > 0)

    472. 

  472. 	    {

    473. 

  473. 		$sql_log = "CREATE TABLE IF NOT EXISTS " . Web_Invoice::tablename('log') . " (

    474. 

  474. 				id bigint(20) NOT NULL auto_increment,

    475. 

  475. 				invoice_id int(11) NOT NULL default '0',

    476. 

  476. 				action_type varchar(255) NOT NULL,

    477. 

  477. 				`value` longtext NOT NULL,

    478. 

  478. 				time_stamp timestamp NOT NULL,

    479. 

  479. 				PRIMARY KEY  (id)

    480. 

  480. 			    ) {$charset_collate};";

    481. 

  481. 		dbDelta($sql_log);

    482. 

  482. 	    } else {

    483. 

  483. 		$sql_log = "CREATE TABLE IF NOT EXISTS " . Web_Invoice::tablename('log') . " (

    484. 

  484. 				id bigint(20) NOT NULL auto_increment,

    485. 

  485. 				invoice_id int(11) NOT NULL default '0',

    486. 

  486. 				action_type varchar(255) NOT NULL,

    487. 

  487. 				`value` longtext NOT NULL,

    488. 

  488. 				time_stamp timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,

    489. 

  489. 				PRIMARY KEY  (id)

    490. 

  490. 			    ) {$charset_collate};";

    491. 

  491. 		dbDelta($sql_log);

    492. 

  492. 	    }

    493. 

  493. 	

    494. 

  494. 	    $sql_meta= "CREATE TABLE IF NOT EXISTS `" . Web_Invoice::tablename('meta') . "` (

    495. 

  495. 			    `meta_id` bigint(20) NOT NULL auto_increment,

    496. 

  496. 			    `invoice_id` bigint(20) NOT NULL default '0',

    497. 

  497. 			    `meta_key` varchar(255) default NULL,

    498. 

  498. 			    `meta_value` longtext,

    499. 

  499. 			    PRIMARY KEY  (`meta_id`),

    500. 

  500. 			    KEY `invoice_id` (`invoice_id`),

    501. 

  501. 			    KEY `meta_key` (`meta_key`)

    502. 

  502. 			) {$charset_collate};";

    503. 

  503. 	    dbDelta($sql_meta);

    504. 

  504. 	

    505. 

  505. 	    if($wpdb->get_var("SHOW TABLES LIKE '". Web_Invoice::tablename('payment') ."'") != Web_Invoice::tablename('payment'))

    506. 

  506. 	    {

    507. 

  507. 		$sql_payment = "CREATE TABLE IF NOT EXISTS ". Web_Invoice::tablename('payment') ." (

    508. 

  508. 				    payment_id int(20) NOT NULL auto_increment,

    509. 

  509. 				    amount double default '0',

    510. 

  510. 				    invoice_id int(20) NOT NULL,

    511. 

  511. 				    user_id int(20) NOT NULL,

    512. 

  512. 				    status int(11) NOT NULL,

    513. 

  513. 				    PRIMARY KEY  (payment_id)

    514. 

  514. 				) {$charset_collate};";

    515. 

  515. 		dbDelta($sql_payment);

    516. 

  516. 	    } else {

    517. 

  517. 		if ($wpdb->get_var("SHOW COLUMNS FROM ". Web_Invoice::tablename('payment') ." LIKE 'invoice_id'") != 'invoice_id')

    518. 

  518. 		{

    519. 

  519. 		    $wpdb->query("ALTER TABLE ". Web_Invoice::tablename('payment') ." ADD `invoice_id` INT( 20 ) NOT NULL AFTER `amount`;");

    520. 

  520. 		    $wpdb->query("ALTER TABLE ". Web_Invoice::tablename('payment') ." CHANGE `user_id` `user_id` INT( 20 ) NOT NULL;");

    521. 

  521. 		    $wpdb->query("ALTER TABLE ". Web_Invoice::tablename('payment') ." CHANGE `payment_id` `payment_id` INT( 20 ) NOT NULL;");

    522. 

  522. 		}

    523. 

  523. 		if ($wpdb->get_var("SHOW COLUMNS FROM ". Web_Invoice::tablename('payment') ." LIKE 'trx_id'") != 'trx_id')

    524. 

  524. 		{

    525. 

  525. 		    $wpdb->query("TRUNCATE TABLE ". Web_Invoice::tablename('payment') .";");

    526. 

  526. 		    $wpdb->query("ALTER TABLE ". Web_Invoice::tablename('payment') ." CHANGE `payment_id` `payment_id` INT( 20 ) NOT NULL AUTO_INCREMENT;"); 

    527. 

  527. 		    $wpdb->query("ALTER TABLE ". Web_Invoice::tablename('payment') ." ADD `trx_id` VARCHAR( 25 ) NOT NULL AFTER `invoice_id`, ADD UNIQUE ( `trx_id` );");

    528. 

  528. 		}

    529. 

  529. 	    }

    530. 

  530. 	    

    531. 

  531. 	    $sql_payment_meta = "CREATE TABLE IF NOT EXISTS `" . Web_Invoice::tablename('payment_meta') . "` (

    532. 

  532. 				    `payment_meta_id` int(20) NOT NULL auto_increment,

    533. 

  533. 				    `payment_id` int(20) NOT NULL default '0',

    534. 

  534. 				    `meta_key` varchar(255) default NULL,

    535. 

  535. 				    `meta_value` longtext,

    536. 

  536. 				    PRIMARY KEY  (`payment_meta_id`),

    537. 

  537. 				    KEY `payment_id` (`payment_id`),

    538. 

  538. 				    KEY `meta_key` (`meta_key`)

    539. 

  539. 				) {$charset_collate};";

    540. 

  540. 	    dbDelta($sql_payment_meta);

    541. 

  541. 	

    542. 

  542. 	    // Fix Paid Statuses  from Old Version where they were kept in main table

    543. 

  543. 	    $all_invoices = $wpdb->get_results("SELECT invoice_num FROM ".Web_Invoice::tablename('main')." WHERE status ='1'");

    544. 

  544. 	    if(!empty($all_invoices))

    545. 

  545. 	    {

    546. 

  546. 		foreach ($all_invoices as $invoice)

    547. 

  547. 		{

    548. 

  548. 		    web_invoice_update_invoice_meta($invoice->invoice_num,'paid_status','paid');

    549. 

  549. 		}

    550. 

  550. 	    }

    551. 

  551. 	

    552. 

  552. 	    // Fix old phone_number and street_address to be without the dash

    553. 

  553. 	    $all_users_with_meta = $wpdb->get_col("SELECT DISTINCT user_id FROM $wpdb->usermeta");

    554. 

  554. 	    if(!empty($all_users_with_meta))

    555. 

  555. 	    {

    556. 

  556. 		foreach ($all_users_with_meta as $user)

    557. 

  557. 		{

    558. 

  558. 		    if (get_usermeta($user, 'company_name'))

    559. 

  559. 		    {

    560. 

  560. 			update_usermeta($user, 'company_name',get_usermeta($user, 'company_name'));

    561. 

  561. 		    }

    562. 

  562. 		    if (get_usermeta($user, 'tax_id'))

    563. 

  563. 		    {

    564. 

  564. 			update_usermeta($user, 'tax_id',get_usermeta($user, 'tax_id'));

    565. 

  565. 		    }

    566. 

  566. 		    if (get_usermeta($user, 'street_address'))

    567. 

  567. 		    {

    568. 

  568. 			update_usermeta($user, 'streetaddress',get_usermeta($user, 'street_address'));

    569. 

  569. 		    }

    570. 

  570. 		    if (get_usermeta($user, 'phone_number'))

    571. 

  571. 		    {

    572. 

  572. 			update_usermeta($user, 'phonenumber',get_usermeta($user, 'phone_number'));

    573. 

  573. 		    }

    574. 

  574. 		    if (get_usermeta($user, 'country'))

    575. 

  575. 		    {

    576. 

  576. 			update_usermeta($user, 'country',get_usermeta($user, 'country'));

    577. 

  577. 		    }

    578. 

  578. 		}

    579. 

  579. 	    }

    580. 

  580. 	    

    581. 

  581. 	    add_option('web_invoice_version', WEB_INVOICE_SCHEDULER_VERSION_NUM);

    582. 

  582. 	    add_option('web_invoice_email_address', get_bloginfo('admin_email'));

    583. 

  583. 	    add_option('web_invoice_business_name', get_bloginfo('blogname'));

    584. 

  584. 	    add_option('web_invoice_business_address', '');

    585. 

  585. 	    add_option('web_invoice_show_billing_address', 'no');

    586. 

  586. 	    add_option('web_invoice_show_business_address', 'no');

    587. 

  587. 	    add_option('web_invoice_payment_method','');

    588. 

  588. 	    add_option('web_invoice_protocol','http');

    589. 

  589. 	    add_option('web_invoice_user_level', array('administrator'));

    590. 

  590. 	    

    591. 

  591. 	    $current_role = get_option('web_invoice_user_level');

    592. 

  592. 	    

    593. 

  593. 	    if (!is_array($current_role) || in_array('level_8', $current_role))

    594. 

  594. 	    {

    595. 

  595. 		$current_role = array('administrator');

    596. 

  596. 		update_option('web_invoice_user_level', $current_role);

    597. 

  597. 	    }

    598. 

  598. 	    

    599. 

  599. 	    $ro = new WP_Roles();

    600. 

  600. 	    foreach ($ro->role_objects as $role)

    601. 

  601. 	    {

    602. 

  602. 		if (in_array($role->name, $current_role))

    603. 

  603. 		{

    604. 

  604. 		    $role->add_cap('manage_web_invoice', true);

    605. 

  605. 		}

    606. 

  606. 	    }

    607. 

  607. 	    

    608. 

  608. 	    add_option('web_invoice_web_invoice_page','');

    609. 

  609. 	    add_option('web_invoice_redirect_after_user_add', 'no');

    610. 

  610. 	    add_option('web_invoice_self_generate_from_template', 'no');

    611. 

  611. 	    add_option('web_invoice_partial_payments', 'no');

    612. 

  612. 	    add_option('web_invoice_default_currency_code','USD');

    613. 

  613. 	    

    614. 

  614. 	    add_option('web_invoice_show_quantities','Hide');

    615. 

  615. 	    add_option('web_invoice_show_invoice_date','Hide');

    616. 

  616. 	    add_option('web_invoice_use_css','yes');

    617. 

  617. 	    add_option('web_invoice_force_https','false');

    618. 

  618. 	    add_option('web_invoice_send_thank_you_email','no');

    619. 

  619. 	    add_option('web_invoice_cc_thank_you_email','no');

    620. 

  620. 	    add_option('web_invoice_tax_count','1');

    621. 

  621. 	    add_option('web_invoice_tax_name',serialize(array()));

    622. 

  622. 	

    623. 

  623. 	    //Authorize.net Gateway Settings

    624. 

  624. 	    add_option('web_invoice_gateway_username','');

    625. 

  625. 	    add_option('web_invoice_gateway_tran_key','');

    626. 

  626. 	    add_option('web_invoice_gateway_delim_char',',');

    627. 

  627. 	    add_option('web_invoice_gateway_encap_char','');

    628. 

  628. 	    add_option('web_invoice_gateway_merchant_email',get_bloginfo('admin_email'));

    629. 

  629. 	    add_option('web_invoice_gateway_header_email_receipt','Thanks for your payment!');

    630. 

  630. 	    add_option('web_invoice_recurring_gateway_url','https://api.authorize.net/xml/v1/request.api');

    631. 

  631. 	    add_option('web_invoice_gateway_url','https://gateway.merchantplus.com/cgi-bin/PAWebClient.cgi');

    632. 

  632. 	    add_option('web_invoice_gateway_MD5Hash','');

    633. 

  633. 	    

    634. 

  634. 	    add_option('web_invoice_gateway_test_mode','FALSE');

    635. 

  635. 	    add_option('web_invoice_gateway_delim_data','TRUE');

    636. 

  636. 	    add_option('web_invoice_gateway_relay_response','FALSE');

    637. 

  637. 	    add_option('web_invoice_gateway_email_customer','FALSE');

    638. 

  638. 	    

    639. 

  639. 	    // PayPal

    640. 

  640. 	    add_option('web_invoice_paypal_button','');

    641. 

  641. 	    add_option('web_invoice_paypal_subscribe_button','');

    642. 

  642. 	    add_option('web_invoice_paypal_address','');

    643. 

  643. 	    add_option('web_invoice_paypal_only_button', 'False');

    644. 

  644. 	    

    645. 

  645. 	    // Payflow

    646. 

  646. 	    add_option('web_invoice_payflow_button','');

    647. 

  647. 	    add_option('web_invoice_payflow_login','');

    648. 

  648. 	    add_option('web_invoice_payflow_partner','');

    649. 

  649. 	    add_option('web_invoice_payflow_only_button', 'False');

    650. 

  650. 	    add_option('web_invoice_payflow_shipping_details', 'True');

    651. 

  651. 	    add_option('web_invoice_payflow_silent_post', 'False');

    652. 

  652. 	    

    653. 

  653. 	    // Payflow Pro

    654. 

  654. 	    add_option('web_invoice_pfp_partner','');

    655. 

  655. 	    add_option('web_invoice_pfp_env', 'live');

    656. 

  656. 	    add_option('web_invoice_pfp_authentication','');

    657. 

  657. 	    add_option('web_invoice_pfp_username', '');

    658. 

  658. 	    add_option('web_invoice_pfp_password', '');

    659. 

  659. 	    add_option('web_invoice_pfp_signature', '');

    660. 

  660. 	    add_option('web_invoice_pfp_wpppe_vendor', '');

    661. 

  661. 	    add_option('web_invoice_pfp_wpppe_username', '');

    662. 

  662. 	    add_option('web_invoice_pfp_wpppe_password', '');

    663. 

  663. 	    add_option('web_invoice_pfp_3rdparty_email', '');

    664. 

  664. 	    add_option('web_invoice_pfp_shipping_details', 'True');

    665. 

  665. 	    

    666. 

  666. 	    // Other

    667. 

  667. 	    add_option('web_invoice_other_details','');

    668. 

  668. 	    

    669. 

  669. 	    // Moneybookers

    670. 

  670. 	    add_option('web_invoice_moneybookers_button','');

    671. 

  671. 	    add_option('web_invoice_moneybookers_address','');

    672. 

  672. 	    add_option('web_invoice_moneybookers_recurring_address','');

    673. 

  673. 	    add_option('web_invoice_moneybookers_merchant','False');

    674. 

  674.     	    add_option('web_invoice_moneybookers_secret',uniqid());

    675. 

  675. 	    add_option('web_invoice_moneybookers_ip', '83.220.158.0-83.220.158.31,213.129.75.193-213.129.75.206,91.208.28.0-91.208.28.255,193.105.47.0-193.105.47.255');

    676. 

  676. 	    

    677. 

  677. 	    // AlertPay

    678. 

  678. 	    add_option('web_invoice_alertpay_button','');

    679. 

  679. 	    add_option('web_invoice_alertpay_address','');

    680. 

  680. 	    add_option('web_invoice_alertpay_merchant','False');

    681. 

  681. 	    add_option('web_invoice_alertpay_secret',uniqid());

    682. 

  682. 	    add_option('web_invoice_alertpay_test_mode','FALSE');

    683. 

  683. 	    add_option('web_invoice_alertpay_ip', '67.205.87.225-67.205.87.226,67.205.87.235');

    684. 

  684. 	    

    685. 

  685. 	    // 2CO

    686. 

  686. 	    add_option('web_invoice_2co_button','');

    687. 

  687. 	    add_option('web_invoice_2co_sid','');

    688. 

  688. 	    add_option('web_invoice_2co_secret_word',uniqid());

    689. 

  689. 	    add_option('web_invoice_2co_demo_mode','FALSE');

    690. 

  690. 	    

    691. 

  691. 	    // Google Checkout

    692. 

  692. 	    add_option('web_invoice_google_checkout_button','');

    693. 

  693. 	    add_option('web_invoice_google_checkout_env','live');

    694. 

  694. 	    add_option('web_invoice_google_checkout_merchant_id','');

    695. 

  695. 	    add_option('web_invoice_google_checkout_level2','False');

    696. 

  696. 	    add_option('web_invoice_google_checkout_merchant_key','');

    697. 

  697. 	    add_option('web_invoice_google_checkout_tax_state','NY');

    698. 

  698. 	    

    699. 

  699. 	    // Sage Pay

    700. 

  700. 	    add_option('web_invoice_sagepay_button','');

    701. 

  701. 	    add_option('web_invoice_sagepay_env','live');

    702. 

  702. 	    add_option('web_invoice_sagepay_vendor_name','');

    703. 

  703. 	    add_option('web_invoice_sagepay_vendor_key','');

    704. 

  704. 	    add_option('web_invoice_sagepay_shipping_details', 'True');

    705. 

  705. 	    

    706. 

  706. 	    // Send invoice

    707. 

  707. 	    add_option('web_invoice_email_send_invoice_subject','%subject');

    708. 

  708. 	    add_option('web_invoice_email_send_invoice_content',

    709. 

  709. "Dear %call_sign,

    710. 

  710. 

    711. 

  711. %business_name has sent you a %recurring

    712. 

  712. web invoice in the amount of %amount.

    713. 

  713. 

    714. 

  714. %description

    715. 

  715. 

    716. 

  716. You may pay, view and print the invoice online by visiting the following link: 

    717. 

  717. %link

    718. 

  718. 

    719. 

  719. Best regards,

    720. 

  720. %business_name ( %business_email )");

    721. 

  721. 	    

    722. 

  722. 	    // Send reminder (past due date)

    723. 

  723. 	    add_option('web_invoice_email_send_reminder_subject','[Reminder] %subject');

    724. 

  724. 	    add_option('web_invoice_email_send_reminder_content',

    725. 

  725. "Dear %call_sign, 

    726. 

  726. 

    727. 

  727. %business_name has sent you a reminder for the %recurring

    728. 

  728. web invoice in the amount of %amount.

    729. 

  729. 

    730. 

  730. %description

    731. 

  731. 

    732. 

  732. You may pay, view and print the invoice online by visiting the following link: 

    733. 

  733. %link.

    734. 

  734. 

    735. 

  735. Best regards,

    736. 

  736. %business_name ( %business_email )");

    737. 

  737. 	    

    738. 

  738. 	    // Send reminder (Due in future)

    739. 

  739. 	    add_option('web_invoice_email_send_reminder_pre_due_subject','[Reminder] %subject due on %due_date');

    740. 

  740. 	    add_option('web_invoice_email_send_reminder_pre_due_content',

    741. 

  741. "Dear %call_sign, 

    742. 

  742. 

    743. 

  743. %business_name has sent you a friendly reminder for the %recurring

    744. 

  744. web invoice in the amount of %amount due on %due_date.

    745. 

  745. 

    746. 

  746. %description

    747. 

  747. 

    748. 

  748. You may pay, view and print the invoice online by visiting the following link: 

    749. 

  749. %link.

    750. 

  750. 

    751. 

  751. Best regards,

    752. 

  752. %business_name ( %business_email )");

    753. 

  753. 

    754. 

  754. 	    // Send receipt

    755. 

  755. 	    add_option('web_invoice_email_send_receipt_subject','Receipt for %subject');

    756. 

  756. 	    add_option('web_invoice_email_send_receipt_content',

    757. 

  757. "Dear %call_sign, 

    758. 

  758. 

    759. 

  759. %business_name has received your payment for the %recurring

    760. 

  760. web invoice in the amount of %amount.

    761. 

  761. 

    762. 

  762. Thank you very much for your patronage.

    763. 

  763. 

    764. 

  764. Best regards,

    765. 

  765. %business_name ( %business_email )");

    766. 

  766. 	    

    767. 

  767. 	    add_option('web_invoice_pdf_content',

    768. 

  768. "<html>

    769. 

  769.     <head>

    770. 

  770. 	<title>Invoice</title>

    771. 

  771. 	<meta http-equiv='Content-Type' content='text/html; charset=UTF-8' />

    772. 

  772.     </head>

    773. 

  773.     <body>

    774. 

  774. 	<div id='invoice_page' class='clearfix'>

    775. 

  775. 	    <img style='float: right;' src='".$this->the_path."/images/logo_small_padding.gif' style='width:420px; height: 110px;' />

    776. 

  776. 	    <h1>Invoice</h1>

    777. 

  777. 	    %content

    778. 

  778. 	</div>

    779. 

  779.     </body>

    780. 

  780. </html>");

    781. 

  781. 	

    782. 

  782. 	    add_option('web_invoice_html_content',

    783. 

  783. '<div id="invoice_page" class="clearfix">

    784. 

  784. <div class="noprint"><p>%print_message</p></div>

    785. 

  785. %content

    786. 

  786. </div>');

    787. 

  787. 	    

    788. 

  788. 	    add_option('web_invoice_installed', true);

    789. 

  789. 	}

    790. 

  790.     }

    791. 

  791. 

    792. 

  792.     class Web_Invoice_GetInfo

    793. 

  793.     {

    794. 

  794. 	var $id;

    795. 

  795. 	var $_row_cache;

    796. 

  796. 	

    797. 

  797. 	function __construct($invoice_id)

    798. 

  798. 	{

    799. 

  799. 	    global $_web_invoice_getinfo, $_web_invoice_clear_cache, $wpdb;

    800. 

  800. 	    

    801. 

  801. 	    $this->id = $invoice_id;

    802. 

  802. 	    

    803. 

  803. 	    if (isset($_web_invoice_getinfo[$this->id]) && $_web_invoice_getinfo[$this->id])

    804. 

  804. 	    {

    805. 

  805. 		$this->_row_cache = $_web_invoice_getinfo[$this->id];

    806. 

  806. 	    }

    807. 

  807. 	    

    808. 

  808. 	    if (!$this->_row_cache || $_web_invoice_clear_cache)

    809. 

  809. 	    {

    810. 

  810. 		$this->_setRowCache($wpdb->get_row("SELECT * FROM ".Web_Invoice::tablename('main')." WHERE invoice_num = '{$invoice_id}'"));

    811. 

  811. 		$_web_invoice_clear_cache = false;

    812. 

  812. 	    }

    813. 

  813. 	    

    814. 

  814. 	    if (!$this->_row_cache)

    815. 

  815. 	    {

    816. 

  816. 		$_custom_invoice = $wpdb->get_row("SELECT invoice_id FROM ".Web_Invoice::tablename('meta')." WHERE meta_key = 'web_invoice_custom_invoice_id' AND meta_value = '{$invoice_id}'");

    817. 

  817. 		$this->id = $_custom_invoice->invoice_id;

    818. 

  818. 		$this->_setRowCache($wpdb->get_row("SELECT * FROM ".Web_Invoice::tablename('main')." WHERE invoice_num = '{$this->id}'"));

    819. 

  819. 	    }

    820. 

  820. 	}

    821. 

  821. 	

    822. 

  822. 	function _setRowCache($row)

    823. 

  823. 	{

    824. 

  824. 	    global $_web_invoice_getinfo;

    825. 

  825. 	    

    826. 

  826. 	    if (!$row)

    827. 

  827. 	    {

    828. 

  828. 		$this->id = null;

    829. 

  829. 		return;

    830. 

  830. 	    }

    831. 

  831. 	    

    832. 

  832. 	    $this->_row_cache = $row;

    833. 

  833. 	    $_web_invoice_getinfo[$this->id] = $this->_row_cache;

    834. 

  834. 	}

    835. 

  835. 	

    836. 

  836. 	function recipient($what)

    837. 

  837. 	{

    838. 

  838. 	    global $_web_invoice_clear_cache, $wpdb;

    839. 

  839. 	    

    840. 

  840. 	    if (!$this->_row_cache || $_web_invoice_clear_cache)

    841. 

  841. 	    {

    842. 

  842. 		$this->_setRowCache($wpdb->get_row("SELECT * FROM ".Web_Invoice::tablename('main')." WHERE invoice_num = '{$this->id}'"));

    843. 

  843. 		$_web_invoice_clear_cache = false;

    844. 

  844. 	    }

    845. 

  845. 	    

    846. 

  846. 	    if ($this->_row_cache)

    847. 

  847. 	    {

    848. 

  848. 		$uid = $this->_row_cache->user_id;

    849. 

  849. 		$profileuser = get_userdata($uid);

    850. 

  850. 		$user_email = $profileuser->user_email;

    851. 

  851. 	    } else {

    852. 

  852. 		$uid = false;

    853. 

  853. 		$user_email = false;

    854. 

  854. 	    }

    855. 

  855. 	    

    856. 

  856. 	    $invoice_info = $this->_row_cache;

    857. 

  857. 	

    858. 

  858. 	    switch ($what)

    859. 

  859. 	    {

    860. 

  860. 		case 'callsign':

    861. 

  861. 		    $first_name = strip_tags(get_usermeta($uid,'first_name'));

    862. 

  862. 		    $last_name = strip_tags(get_usermeta($uid,'last_name'));

    863. 

  863. 		    if (empty($first_name) || empty($last_name))

    864. 

  864. 		    {

    865. 

  865. 			return $user_email;

    866. 

  866. 		    } else {

    867. 

  867. 			return $first_name . " " . $last_name;

    868. 

  868. 		    }

    869. 

  869. 		    break;

    870. 

  870. 		case 'user_id':

    871. 

  871. 		    return $uid;

    872. 

  872. 		    break;

    873. 

  873. 		case 'email_address':

    874. 

  874. 		    return $user_email;

    875. 

  875. 		    break;

    876. 

  876. 		case 'first_name':

    877. 

  877. 		    return strip_tags(get_usermeta($uid,'first_name'));

    878. 

  878. 		    break;

    879. 

  879. 		case 'last_name':

    880. 

  880. 		    return strip_tags(get_usermeta($uid,'last_name'));

    881. 

  881. 		    break;

    882. 

  882. 		case 'phonenumber':

    883. 

  883. 		    return web_invoice_format_phone(get_usermeta($uid,'phonenumber'));

    884. 

  884. 		    break;

    885. 

  885. 		case 'paypal_phonenumber':

    886. 

  886. 		    return get_usermeta($uid,'phonenumber');

    887. 

  887. 		    break;

    888. 

  888. 		case 'log_status':

    889. 

  889. 		    if ($status_update = $wpdb->get_row("SELECT * FROM ".Web_Invoice::tablename('log')." WHERE invoice_id = ".$this->id ." ORDER BY `".Web_Invoice::tablename('log')."`.`time_stamp` DESC LIMIT 0 , 1"))

    890. 

  890. 		    {

    891. 

  891. 			return $status_update->value . " - " . web_invoice_Date::convert($status_update->time_stamp, 'Y-m-d H', __('M d Y', WEB_INVOICE_TRANS_DOMAIN));

    892. 

  892. 		    }

    893. 

  893. 		    break;

    894. 

  894. 		case 'paid_date':

    895. 

  895. 		    $paid_date = $wpdb->get_var("SELECT time_stamp FROM  ".Web_Invoice::tablename('log')." WHERE action_type = 'paid' AND invoice_id = '".$this->id."' ORDER BY time_stamp DESC LIMIT 0, 1");

    896. 

  896. 		    if ($paid_date)

    897. 

  897. 		    {

    898. 

  898. 			return web_inv;

    899. 

  899. 		    }

    900. 

  900. 		    break;

    901. 

  901. 		case 'streetaddress':

    902. 

  902. 		    return get_usermeta($uid,'streetaddress');

    903. 

  903. 		    break;

    904. 

  904. 		case 'state':

    905. 

  905. 		    return strtoupper(get_usermeta($uid,'state'));

    906. 

  906. 		    break;

    907. 

  907. 		case 'city':

    908. 

  908. 		    return get_usermeta($uid,'city');

    909. 

  909. 		    break;

    910. 

  910. 		case 'zip':

    911. 

  911. 		    return get_usermeta($uid,'zip');

    912. 

  912. 		    break;

    913. 

  913. 		case 'country':

    914. 

  914. 		    if (get_usermeta($uid,'country'))

    915. 

  915. 		    {

    916. 

  916. 			return get_usermeta($uid,'country');

    917. 

  917. 		    } else {

    918. 

  918. 			return "US";

    919. 

  919. 		    }

    920. 

  920. 		    break;

    921. 

  921. 		case 'company_name':

    922. 

  922. 		    if (get_usermeta($uid,'company_name'))

    923. 

  923. 		    {

    924. 

  924. 			return get_usermeta($uid,'company_name');

    925. 

  925. 		    } else {

    926. 

  926. 			return "";

    927. 

  927. 		    }

    928. 

  928. 		    break;

    929. 

  929. 		case 'tax_id':

    930. 

  930. 		    if (get_usermeta($uid,'tax_id'))

    931. 

  931. 		    {

    932. 

  932. 			return get_usermeta($uid,'tax_id');

    933. 

  933. 		    } else {

    934. 

  934. 			return "";

    935. 

  935. 		    }

    936. 

  936. 		    break;

    937. 

  937. 	    }

    938. 

  938. 	}

    939. 

  939. 	

    940. 

  940. 	function shipping($what) {

    941. 

  941. 	    global $_web_invoice_clear_cache, $wpdb;

    942. 

  942. 	    

    943. 

  943. 	    if (!$this->_row_cache || $_web_invoice_clear_cache)

    944. 

  944. 	    {

    945. 

  945. 		$this->_setRowCache($wpdb->get_row("SELECT * FROM ".Web_Invoice::tablename('main')." WHERE invoice_num = '{$this->id}'"));

    946. 

  946. 		$_web_invoice_clear_cache = false;

    947. 

  947. 	    }

    948. 

  948. 	    

    949. 

  949. 	    if ($this->_row_cache)

    950. 

  950. 	    {

    951. 

  951. 		$uid = $this->_row_cache->user_id;

    952. 

  952. 		$user_email = $wpdb->get_var("SELECT user_email FROM ". $wpdb->prefix . "users WHERE id=".$uid);

    953. 

  953. 	    } else {

    954. 

  954. 		$uid = false;

    955. 

  955. 		$user_email = false;

    956. 

  956. 	    }

    957. 

  957. 	    

    958. 

  958. 	    $invoice_info = $this->_row_cache;

    959. 

  959. 	    

    960. 

  960. 	    switch ($what)

    961. 

  961. 	    {

    962. 

  962. 		case 'first_name':

    963. 

  963. 		    return (get_usermeta($uid,'shipto_first_name')!="")?get_usermeta($uid,'shipto_first_name'):get_usermeta($uid,'first_name');

    964. 

  964. 		    break;

    965. 

  965. 		

    966. 

  966. 		case 'last_name':

    967. 

  967. 		    return (get_usermeta($uid,'shipto_last_name')!="")?get_usermeta($uid,'shipto_last_name'):get_usermeta($uid,'last_name');

    968. 

  968. 		    break;

    969. 

  969. 		

    970. 

  970. 		case 'email_address':

    971. 

  971. 		    return $user_email;

    972. 

  972. 		    break;

    973. 

  973. 		

    974. 

  974. 		case 'phonenumber':

    975. 

  975. 		    $phone_number = (get_usermeta($uid,'shipto_phonenumber')!="")?get_usermeta($uid,'shipto_phonenumber'):get_usermeta($uid,'phonenumber');

    976. 

  976. 		    return web_invoice_format_phone($phone_number);

    977. 

  977. 		    break;

    978. 

  978. 		

    979. 

  979. 		case 'paypal_phonenumber':

    980. 

  980. 		    return (get_usermeta($uid,'shipto_phonenumber')!="")?get_usermeta($uid,'shipto_phonenumber'):get_usermeta($uid,'phonenumber');

    981. 

  981. 		    break;

    982. 

  982. 		

    983. 

  983. 		case 'streetaddress':

    984. 

  984. 		    return (get_usermeta($uid,'shipto_streetaddress')!="")?get_usermeta($uid,'shipto_streetaddress'):get_usermeta($uid,'streetaddress');

    985. 

  985. 		    break;

    986. 

  986. 	

    987. 

  987. 		case 'state':

    988. 

  988. 		    $state = (get_usermeta($uid,'shipto_state')!="")?get_usermeta($uid,'shipto_state'):get_usermeta($uid,'state');

    989. 

  989. 		    return strtoupper($state);

    990. 

  990. 		    break;

    991. 

  991. 		

    992. 

  992. 		case 'city':

    993. 

  993. 		    return (get_usermeta($uid,'shipto_city')!="")?get_usermeta($uid,'shipto_city'):get_usermeta($uid,'city');

    994. 

  994. 		    break;

    995. 

  995. 		

    996. 

  996. 		case 'zip':

    997. 

  997. 		    return (get_usermeta($uid,'shipto_zip')!="")?get_usermeta($uid,'shipto_zip'):get_usermeta($uid,'zip');

    998. 

  998. 		    break;

    999. 

  999. 		

    1000. 

  1000. 		case 'country':

    1001. 

  1001. 		    if(get_usermeta($uid,'shipto_country'))

    1002. 

  1002. 		    {

    1003. 

  1003. 			return get_usermeta($uid,'shipto_country');  

    1004. 

  1004. 		    } else if(get_usermeta($uid,'country')) {

    1005. 

  1005. 			return get_usermeta($uid,'country');  

    1006. 

  1006. 		    } else {

    1007. 

  1007. 			return "US";

    1008. 

  1008. 		    }

    1009. 

  1009. 		    break;

    1010. 

  1010. 		

    1011. 

  1011. 		case 'company_name':

    1012. 

  1012. 		    if (get_usermeta($uid,'shipto_company_name'))

    1013. 

  1013. 		    {

    1014. 

  1014. 			return get_usermeta($uid,'shipto_company_name');

    1015. 

  1015. 		    } else if(get_usermeta($uid,'company_name')) {

    1016. 

  1016. 			return get_usermeta($uid,'company_name');

    1017. 

  1017. 		    } else {

    1018. 

  1018. 			return "";

    1019. 

  1019. 			break;

    1020. 

  1020. 		    }

    1021. 

  1021. 	    }

    1022. 

  1022. 	}

    1023. 

  1023. 	    

    1024. 

  1024. 	function display($what)

    1025. 

  1025. 	{

    1026. 

  1026. 	    global $_web_invoice_clear_cache, $wpdb;

    1027. 

  1027. 		

    1028. 

  1028. 	    if (!$this->_row_cache || $_web_invoice_clear_cache)

    1029. 

  1029. 	    {

    1030. 

  1030. 	        $this->_setRowCache($wpdb->get_row("SELECT * FROM ".Web_Invoice::tablename('main')." WHERE invoice_num = '{$this->id}'"));

    1031. 

  1031. 	        $_web_invoice_clear_cache = false;

    1032. 

  1032. 	    }

    1033. 

  1033. 	

    1034. 

  1034. 	    $invoice_info = $this->_row_cache;

    1035. 

  1035. 	    

    1036. 

  1036. 	    switch ($what)

    1037. 

  1037. 	    {

    1038. 

  1038. 		case 'log_status':

    1039. 

  1039. 		    if($status_update = $wpdb->get_row("SELECT * FROM ".Web_Invoice::tablename('log')." WHERE invoice_id = ".$this->id ." ORDER BY `".Web_Invoice::tablename('log')."`.`time_stamp` DESC LIMIT 0 , 1"))

    1040. 

  1040. 		    {

    1041. 

  1041. 		        return $status_update->value . " - " . web_invoice_Date::convert($status_update->time_stamp, 'Y-m-d H', __('M d Y', WEB_INVOICE_TRANS_DOMAIN));

    1042. 

  1042. 		    }

    1043. 

  1043. 		    break;

    1044. 

  1044. 		    

    1045. 

  1045. 		case 'paid_date':

    1046. 

  1046. 		    $paid_date = $wpdb->get_var("SELECT time_stamp FROM  ".Web_Invoice::tablename('log')." WHERE action_type = 'paid' AND invoice_id = '".$this->id."' ORDER BY time_stamp DESC LIMIT 0, 1");

    1047. 

  1047. 		    if ($paid_date)

    1048. 

  1048. 		    {

    1049. 

  1049. 		        return date(get_option('date_format', __('Y-m-d', WEB_INVOICE_TRANS_DOMAIN)), strtotime(web_invoice_Date::convert($paid_date, 'Y-m-d H', __('M d Y', WEB_INVOICE_TRANS_DOMAIN))));

    1050. 

  1050. 		    }

    1051. 

  1051. 		    break;

    1052. 

  1052. 		    

    1053. 

  1053. 		case 'paid_date_raw':

    1054. 

  1054. 		    $paid_date = $wpdb->get_var("SELECT time_stamp FROM  ".Web_Invoice::tablename('log')." WHERE action_type = 'paid' AND invoice_id = '".$this->id."' ORDER BY time_stamp DESC LIMIT 0, 1");

    1055. 

  1055. 		    if ($paid_date) {

    1056. 

  1056. 		        return $paid_date;

    1057. 

  1057. 		    }

    1058. 

  1058. 		    break;

    1059. 

  1059. 		

    1060. 

  1060. 		case 'subscription_name':

    1061. 

  1061. 		    return web_invoice_meta($this->id,'web_invoice_subscription_name');

    1062. 

  1062. 		    break;

    1063. 

  1063. 		

    1064. 

  1064. 		case 'interval_length':

    1065. 

  1065. 		    return web_invoice_meta($this->id,'web_invoice_subscription_length');

    1066. 

  1066. 		    break;

    1067. 

  1067. 		

    1068. 

  1068. 		case 'interval_unit':

    1069. 

  1069. 		    return web_invoice_meta($this->id,'web_invoice_subscription_unit');

    1070. 

  1070. 		    break;

    1071. 

  1071. 		

    1072. 

  1072. 		case 'totalOccurrences':

    1073. 

  1073. 		    return web_invoice_meta($this->id,'web_invoice_subscription_total_occurances');

    1074. 

  1074. 		    break;

    1075. 

  1075. 		

    1076. 

  1076. 		case 'installment':

    1077. 

  1077. 		    return web_invoice_meta($this->id,'installment',0);

    1078. 

  1078. 		    break;

    1079. 

  1079. 		

    1080. 

  1080. 		case 'startDate':

    1081. 

  1081. 		    $web_invoice_subscription_start_day = web_invoice_meta($this->id,'web_invoice_subscription_start_day');

    1082. 

  1082. 		    $web_invoice_subscription_start_year = web_invoice_meta($this->id,'web_invoice_subscription_start_year');

    1083. 

  1083. 		    $web_invoice_subscription_start_month = web_invoice_meta($this->id,'web_invoice_subscription_start_month');

    1084. 

  1084. 		    

    1085. 

  1085. 		    if ($web_invoice_subscription_start_month && $web_invoice_subscription_start_year && $web_invoice_subscription_start_day && strtotime($web_invoice_subscription_start_year . "-" . $web_invoice_subscription_start_month . "-" . $web_invoice_subscription_start_day) > time())

    1086. 

  1086. 		    {

    1087. 

  1087. 		        return date(get_option('date_format', __('Y-m-d', WEB_INVOICE_TRANS_DOMAIN)), strtotime($web_invoice_subscription_start_year . "-" . $web_invoice_subscription_start_month . "-" . $web_invoice_subscription_start_day));

    1088. 

  1088. 		    } else {

    1089. 

  1089. 		        return date(get_option('date_format', __('Y-m-d', WEB_INVOICE_TRANS_DOMAIN)), time()+1800);

    1090. 

  1090. 		    }

    1091. 

  1091. 		    break;

    1092. 

  1092. 		

    1093. 

  1093. 		case 'endDate':

    1094. 

  1094. 		    return date(get_option('date_format', __('Y-m-d', WEB_INVOICE_TRANS_DOMAIN)), strtotime("+".($this->display('interval_length')*$this->display('totalOccurrences'))." ".$this->display('interval_unit'), strtotime($this->display('startDateM'))));

    1095. 

  1095. 		    break;

    1096. 

  1096. 		

    1097. 

  1097. 		case 'nextDate':

    1098. 

  1098. 		    if ($this->display('totalOccurrences') > $this->display('installment')) {

    1099. 

  1099. 			if ($this->display('installment') == 0 && strtotime($this->display('startDateM')) >= strtotime($this->display('due_dateM'))) {

    1100. 

  1100. 			    $start_date = $this->display('due_dateM');

    1101. 

  1101. 			} else {

    1102. 

  1102. 			    $start_date = $this->display('startDateM');

    1103. 

  1103. 			}

    1104. 

  1104. 			return date(get_option('date_format', __('Y-m-d', WEB_INVOICE_TRANS_DOMAIN)), strtotime("+".($this->display('interval_length')*$this->display('installment'))." ".$this->display('interval_unit'), strtotime($start_date)));

    1105. 

  1105. 		    }

    1106. 

  1106. 		    return $this->display('endDate');

    1107. 

  1107. 		    break;

    1108. 

  1108. 		

    1109. 

  1109. 		case 'startDateM':

    1110. 

  1110. 		    $web_invoice_subscription_start_day = web_invoice_meta($this->id,'web_invoice_subscription_start_day');

    1111. 

  1111. 		    $web_invoice_subscription_start_year = web_invoice_meta($this->id,'web_invoice_subscription_start_year');

    1112. 

  1112. 		    $web_invoice_subscription_start_month = web_invoice_meta($this->id,'web_invoice_subscription_start_month');

    1113. 

  1113. 		    

    1114. 

  1114. 		    if ($web_invoice_subscription_start_month && $web_invoice_subscription_start_year && $web_invoice_subscription_start_day && strtotime($web_invoice_subscription_start_year . "-" . $web_invoice_subscription_start_month . "-" . $web_invoice_subscription_start_day) > time())

    1115. 

  1115. 		    {

    1116. 

  1116. 		        return date('Y-m-d', strtotime($web_invoice_subscription_start_year . "-" . $web_invoice_subscription_start_month . "-" . $web_invoice_subscription_start_day));

    1117. 

  1117. 		    } else {

    1118. 

  1118. 		        return date('Y-m-d', time()+1800);

    1119. 

  1119. 		    }

    1120. 

  1120. 		    break;

    1121. 

  1121. 		

    1122. 

  1122. 		case 'endDateM':

    1123. 

  1123. 		    return date('Y-m-d', strtotime("+".($this->display('interval_length')*$this->display('totalOccurrences'))." ".$this->display('interval_unit'), strtotime($this->display('startDateM'))));

    1124. 

  1124. 		    break;

    1125. 

  1125. 		

    1126. 

  1126. 		case 'nextDateM':

    1127. 

  1127. 		    if ($this->display('totalOccurrences') > $this->display('installment')) {

    1128. 

  1128. 			if ($this->display('installment') == 0 && strtotime($this->display('startDateM')) >= strtotime($this->display('due_dateM'))) {

    1129. 

  1129. 			    $start_date = $this->display('due_dateM');

    1130. 

  1130. 			} else {

    1131. 

  1131. 			    $start_date = $this->display('startDateM');

    1132. 

  1132. 			}

    1133. 

  1133. 			return date('Y-m-d', strtotime("+".($this->display('interval_length')*$this->display('installment'))." ".$this->display('interval_unit'), strtotime($start_date)));

    1134. 

  1134. 		    }

    1135. 

  1135. 		    return $this->display('endDate');

    1136. 

  1136. 		    break;

    1137. 

  1137. 		

    1138. 

  1138. 		case 'profileEndDate':

    1139. 

  1139. 		    return date(get_option('date_format', __('Y-m-d', WEB_INVOICE_TRANS_DOMAIN)), strtotime("+".($this->display('interval_length')*($this->display('totalOccurrences')-1))." ".$this->display('interval_unit'), strtotime($this->display('startDate'))+3600*24));

    1140. 

  1140. 		    break;

    1141. 

  1141. 		    

    1142. 

  1142. 		case 'archive_status':

    1143. 

  1143. 		    $result = $wpdb->get_col("SELECT action_type FROM  ".Web_Invoice::tablename('log')." WHERE invoice_id = '".$this->id."' ORDER BY time_stamp DESC");

    1144. 

  1144. 		    foreach ($result as $event)

    1145. 

  1145. 		    {

    1146. 

  1146. 			if ($event == 'unarchive')

    1147. 

  1147. 			{

    1148. 

  1148. 			    return ''; break;

    1149. 

  1149. 			}

    1150. 

  1150. 			if ($event == 'archive')

    1151. 

  1151. 			{

    1152. 

  1152. 			    return 'archive';

    1153. 

  1153. 			    break;

    1154. 

  1154. 		        }

    1155. 

  1155. 		    }

    1156. 

  1156. 		    break;

    1157. 

  1157. 		

    1158. 

  1158. 		case 'display_billing_rate':

    1159. 

  1159. 		    $length = web_invoice_meta($this->id,'web_invoice_subscription_length');

    1160. 

  1160. 		    $unit = web_invoice_meta($this->id,'web_invoice_subscription_unit');

    1161. 

  1161. 		    $occurances = web_invoice_meta($this->id,'web_invoice_subscription_total_occurances');

    1162. 

  1162. 		    // days

    1163. 

  1163. 		    if($unit == "days") {

    1164. 

  1164. 			if($length == '1')

    1165. 

  1165. 			{

    1166. 

  1166. 			    return "daily for $occurances days";

    1167. 

  1167. 			}

    1168. 

  1168. 			if ($length > '1') {

    1169. 

  1169. 			    return "every $length days for a total of $occurances billing cycles";

    1170. 

  1170. 			}

    1171. 

  1171. 		    }

    1172. 

  1172. 		    //months

    1173. 

  1173. 		    if ($unit == "months")

    1174. 

  1174. 		    {

    1175. 

  1175. 			if ($length == '1') {

    1176. 

  1176. 			    return "monthly for $occurances months";

    1177. 

  1177. 		        }

    1178. 

  1178. 			if ($length > '1') {

    1179. 

  1179. 			    return "every $length months $occurances times";

    1180. 

  1180. 			}

    1181. 

  1181. 		    }

    1182. 

  1182. 		    if ($unit == "years")

    1183. 

  1183. 		    {

    1184. 

  1184. 			if ($length == '1') {

    1185. 

  1185. 			    return "annually for $occurances years";

    1186. 

  1186. 			}

    1187. 

  1187. 			if ($length > '1') {

    1188. 

  1188. 			    return "every $length years $occurances times";

    1189. 

  1189. 			}

    1190. 

  1190. 		    }

    1191. 

  1191. 		    break;

    1192. 

  1192. 		

    1193. 

  1193. 		case 'link':

    1194. 

  1194. 		    $link_to_page = get_permalink(get_option('web_invoice_web_invoice_page'));

    1195. 

  1195. 		    $hashed = md5($this->id);

    1196. 

  1196. 		    if(get_option("permalink_structure")) {

    1197. 

  1197. 			return $link_to_page . "?invoice_id=" .$hashed;

    1198. 

  1198. 		    } else {

    1199. 

  1199. 			return  $link_to_page . "&invoice_id=" . $hashed;

    1200. 

  1200. 		    }

    1201. 

  1201. 		    break;

    1202. 

  1202. 		    

    1203. 

  1203. 		case 'invoice_hash':

    1204. 

  1204. 		    return md5($this->id);

    1205. 

  1205. 		    break;

    1206. 

  1206. 		

    1207. 

  1207. 		case 'print_link':

    1208. 

  1208. 		    return $this->display('link').'&print=1';

    1209. 

  1209. 		    break;

    1210. 

  1210. 		

    1211. 

  1211. 		case 'hash':

    1212. 

  1212. 		    return md5($this->id);

    1213. 

  1213. 		    break;

    1214. 

  1214. 		

    1215. 

  1215. 		case 'currency':

    1216. 

  1216. 		    if (web_invoice_meta($this->id,'web_invoice_currency_code') != '')

    1217. 

  1217. 		    {

    1218. 

  1218. 			$currency_code = web_invoice_meta($this->id,'web_invoice_currency_code');

    1219. 

  1219. 		    } else if (get_option('web_invoice_default_currency_code') != '') {

    1220. 

  1220. 			$currency_code = get_option('web_invoice_default_currency_code');

    1221. 

  1221. 		    } else {

    1222. 

  1222. 			$currency_code = "USD";

    1223. 

  1223. 		    }

    1224. 

  1224. 		    return $currency_code;

    1225. 

  1225. 		    break;

    1226. 

  1226. 		

    1227. 

  1227. 		case 'display_id':

    1228. 

  1228. 		    $web_invoice_custom_invoice_id = web_invoice_meta($this->id,'web_invoice_custom_invoice_id');

    1229. 

  1229. 		    if (empty($web_invoice_custom_invoice_id))

    1230. 

  1230. 		    {

    1231. 

  1231. 			return $this->id;

    1232. 

  1232. 		    } else {

    1233. 

  1233. 			return $web_invoice_custom_invoice_id;

    1234. 

  1234. 		    }

    1235. 

  1235. 		    break;

    1236. 

  1236. 		

    1237. 

  1237. 		case 'due_date':

    1238. 

  1238. 		    $web_invoice_due_date_month = web_invoice_meta($this->id,'web_invoice_due_date_month');

    1239. 

  1239. 		    $web_invoice_due_date_year = web_invoice_meta($this->id,'web_invoice_due_date_year');

    1240. 

  1240. 		    $web_invoice_due_date_day = web_invoice_meta($this->id,'web_invoice_due_date_day');

    1241. 

  1241. 		    if (!empty($web_invoice_due_date_month) && !empty($web_invoice_due_date_year) && !empty($web_invoice_due_date_day))

    1242. 

  1242. 		    {

    1243. 

  1243. 			return date(get_option('date_format', __('Y-m-d', WEB_INVOICE_TRANS_DOMAIN)), strtotime("$web_invoice_due_date_year-$web_invoice_due_date_month-$web_invoice_due_date_day"));

    1244. 

  1244. 		    }

    1245. 

  1245. 		    return date(get_option('date_format', __('Y-m-d', WEB_INVOICE_TRANS_DOMAIN)));

    1246. 

  1246. 		    break;

    1247. 

  1247. 		

    1248. 

  1248. 		case 'due_dateM':

    1249. 

  1249. 		    $web_invoice_due_date_month = web_invoice_meta($this->id,'web_invoice_due_date_month');

    1250. 

  1250. 		    $web_invoice_due_date_year = web_invoice_meta($this->id,'web_invoice_due_date_year');

    1251. 

  1251. 		    $web_invoice_due_date_day = web_invoice_meta($this->id,'web_invoice_due_date_day');

    1252. 

  1252. 		    if (!empty($web_invoice_due_date_month) && !empty($web_invoice_due_date_year) && !empty($web_invoice_due_date_day))

    1253. 

  1253. 		    {

    1254. 

  1254. 			return date('Y-m-d', strtotime("$web_invoice_due_date_year-$web_invoice_due_date_month-$web_invoice_due_date_day"));

    1255. 

  1255. 		    }

    1256. 

  1256. 		    return date('Y-m-d');

    1257. 

  1257. 		    break;

    1258. 

  1258. 		

    1259. 

  1259. 		case 'invoice_date':

    1260. 

  1260. 		    if ($invoice_info && $invoice_info->invoice_date && !empty($invoice_info->invoice_date)) {

    1261. 

  1261. 			date(get_option('date_format', __('Y-m-d', WEB_INVOICE_TRANS_DOMAIN)), strtotime($invoice_info->invoice_date));

    1262. 

  1262. 		    }

    1263. 

  1263. 		    return date(get_option('date_format', __('Y-m-d', WEB_INVOICE_TRANS_DOMAIN)));

    1264. 

  1264. 		    break;

    1265. 

  1265. 		

    1266. 

  1266. 		case 'amount':

    1267. 

  1267. 		    return $invoice_info->amount;

    1268. 

  1268. 		    break;

    1269. 

  1269. 		

    1270. 

  1270. 		case 'due_amount':

    1271. 

  1271. 		    $payments = web_invoice_sum_payments($this->id);

    1272. 

  1272. 		    return max(0, $invoice_info->amount-$payments);

    1273. 

  1273. 		    bre…
    1274.

Large files files are truncated, but you can click here to view the full file