summaryrefslogtreecommitdiff
path: root/scripts/payment.pl
blob: a081c5e80517c539d30b3ed9acd2ffacedd2d820 (plain)
  1. =pod
  2. =head1 NAME
  3. LedgerSMB::Scripts::payment - LedgerSMB class defining the Controller functions for payment handling.
  4. =head1 SYNOPSIS
  5. Defines the controller functions and workflow logic for payment processing.
  6. =head1 COPYRIGHT
  7. Portions Copyright (c) 2007, David Mora R and Christian Ceballos B.
  8. Licensed to the public under the terms of the GNU GPL version 2 or later.
  9. Original copyright notice below.
  10. #=====================================================================
  11. # PLAXIS
  12. # Copyright (c) 2007
  13. #
  14. # Author: David Mora R
  15. # Christian Ceballos B
  16. #
  17. #
  18. #
  19. #
  20. #
  21. # This program is free software; you can redistribute it and/or modify
  22. # it under the terms of the GNU General Public License as published by
  23. # the Free Software Foundation; either version 2 of the License, or
  24. # (at your option) any later version.
  25. #
  26. # This program is distributed in the hope that it will be useful,
  27. # but WITHOUT ANY WARRANTY; without even the implied warranty of
  28. # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
  29. # GNU General Public License for more details.
  30. # You should have received a copy of the GNU General Public License
  31. # along with this program; if not, write to the Free Software
  32. # Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
  33. =head1 METHODS
  34. =cut
  35. package LedgerSMB::Scripts::payment;
  36. use LedgerSMB::Template;
  37. use LedgerSMB::Sysconfig;
  38. use LedgerSMB::DBObject::Payment;
  39. use LedgerSMB::DBObject::Date;
  40. use Error::Simple;
  41. use strict;
  42. # CT: A few notes for future refactoring of this code:
  43. # 1: I don't think it is a good idea to make the UI too dependant on internal
  44. # code structures but I don't see a good alternative at the moment.
  45. # 2: CamelCasing: -1
  46. =pod
  47. =item payment
  48. This method is used to set the filter screen and prints it, using the
  49. TT2 system.
  50. =back
  51. =cut
  52. sub payments {
  53. my ($request) = @_;
  54. my $payment = LedgerSMB::DBObject::Payment->new({'base' => $request});
  55. $payment->get_metadata();
  56. if (!defined $payment->{batch_date}){
  57. $payment->error("No Batch Date!");
  58. }
  59. my $template = LedgerSMB::Template->new(
  60. user => $request->{_user},
  61. locale => $request->{_locale},
  62. path => 'UI/payments',
  63. template => 'payments_filter',
  64. format => 'HTML',
  65. );
  66. $template->render($payment);
  67. }
  68. sub get_search_criteria {
  69. my ($request) = @_;
  70. my $payment = LedgerSMB::DBObject::Payment->new({'base' => $request});
  71. $payment->get_metadata();
  72. if ($payment->{batch_id} && $payment->{batch_date}){
  73. $payment->{date_reversed} = $payment->{batch_date};
  74. }
  75. my $template = LedgerSMB::Template->new(
  76. user => $request->{_user},
  77. locale => $request->{_locale},
  78. path => 'UI/payments',
  79. template => 'search',
  80. format => 'HTML',
  81. );
  82. $template->render($payment);
  83. }
  84. sub get_search_results {
  85. my ($request) = @_;
  86. my $rows = [];
  87. my $payment = LedgerSMB::DBObject::Payment->new({'base' => $request});
  88. my @search_results = $payment->search;
  89. my $template = LedgerSMB::Template->new(
  90. user => $request->{_user},
  91. locale => $request->{_locale},
  92. path => 'UI',
  93. template => 'form-dynatable',
  94. format => ($payment->{format}) ? $payment->{format} : 'HTML',
  95. );
  96. my $base_url = "payment.pl?";
  97. my $search_url = "$base_url";
  98. for my $key (keys %{$request->take_top_level}){
  99. if ($base_url =~ /\?$/){
  100. $base_url .= "$key=$request->{key}";
  101. } else {
  102. $base_url .= "&$key=$request->{key}";
  103. }
  104. }
  105. my @columns = qw(selected meta_number date_paid amount source company_paid);
  106. my $contact_type = ($payment->{account_class} == 1) ? 'Vendor' : 'Customer';
  107. # CT: Locale strings for gettext:
  108. # $request->{_locale}->text("Vendor Number");
  109. # $request->{_locale}->text("Customer Number");
  110. my $heading = {
  111. selected => $request->{_locale}->text('Selected'),
  112. company_paid => {
  113. text => $request->{_locale}->text('Company Name'),
  114. href => "$search_url&orderby=company_paid",
  115. },
  116. meta_number => {
  117. text => $request->{_locale}->text(
  118. "$contact_type Number"
  119. ),
  120. href => "$search_url&orderby=meta_number",
  121. },
  122. date_paid => {
  123. text => $request->{_locale}->text('Date Paid'),
  124. href => "$search_url&orderby=date_paid",
  125. },
  126. amount => {
  127. text => $request->{_locale}->text('Total Paid'),
  128. href => "$search_url&orderby=amount",
  129. },
  130. source => {
  131. text => $request->{_locale}->text('Source'),
  132. href => "$search_url&orderby=source",
  133. },
  134. };
  135. my $classcount;
  136. $classcount = 0;
  137. my $rowcount;
  138. $rowcount = 1;
  139. for my $line (@search_results){
  140. $classcount ||= 0;
  141. $rowcount += 1;
  142. push(@$rows, {
  143. company_paid => $line->{company_paid},
  144. amount => $request->format_amount(amount => $line->{amount}),
  145. i => "$classcount",
  146. date_paid => $line->{date_paid},
  147. source => $line->{source},
  148. meta_number => $line->{meta_number},
  149. selected => {
  150. input => {
  151. type => "checkbox",
  152. name => "payment_$rowcount",
  153. value => "1",
  154. },
  155. }
  156. });
  157. $payment->{"credit_id_$rowcount"} = $line->{credit_id};
  158. $payment->{"date_paid_$rowcount"} = $line->{date_paid};
  159. $payment->{"source_$rowcount"} = $line->{source};
  160. $classcount = ($classcount + 1) % 2;
  161. ++$rowcount;
  162. }
  163. $payment->{rowcount} = $rowcount;
  164. $payment->{script} = 'payment.pl';
  165. $payment->{title} = $request->{_locale}->text("Payment Results");
  166. my $hiddens = $payment->take_top_level;
  167. $template->render({
  168. form => $payment,
  169. columns => \@columns,
  170. heading => $heading,
  171. hiddens => $payment->take_top_level,
  172. rows => $rows,
  173. buttons => [{
  174. value => 'reverse_payments',
  175. name => 'action',
  176. class => 'submit',
  177. type => 'submit',
  178. text => $request->{_locale}->text('Reverse Payments'),
  179. }]
  180. });
  181. }
  182. sub get_search_results_reverse_payments {
  183. my ($request) = @_;
  184. my $payment = LedgerSMB::DBObject::Payment->new({base => $request});
  185. for my $count (1 .. $payment->{rowcount}){
  186. if ($payment->{"payment_$count"}){
  187. $payment->{credit_id} = $payment->{"credit_id_$count"};
  188. $payment->{date_paid} = $payment->{"date_paid_$count"};
  189. $payment->{source} = $payment->{"source_$count"};
  190. $payment->reverse;
  191. }
  192. }
  193. get_search_criteria($payment);
  194. }
  195. sub check_job {
  196. my ($request) = @_;
  197. my $payment = LedgerSMB::DBObject::Payment->new({'base' => $request});
  198. $payment->check_job;
  199. my $template = LedgerSMB::Template->new(
  200. user => $request->{_user},
  201. locale => $request->{_locale},
  202. path => 'UI/payments',
  203. template => 'check_job',
  204. format => 'HTML',
  205. );
  206. $template->render($payment);
  207. }
  208. sub post_payments_bulk {
  209. my ($request) = @_;
  210. my $payment = LedgerSMB::DBObject::Payment->new({'base' => $request});
  211. $payment->post_bulk();
  212. my $template;
  213. if ($payment->{queue_payments}){
  214. $payment->{job_label} = 'Payments';
  215. $template = LedgerSMB::Template->new(
  216. user => $request->{_user},
  217. locale => $request->{_locale},
  218. path => 'UI/payments',
  219. template => 'check_job',
  220. format => 'HTML',
  221. );
  222. } else {
  223. payments($request);
  224. }
  225. $template->render($payment);
  226. }
  227. sub print {
  228. use LedgerSMB::DBObject::Company;
  229. use LedgerSMB::Batch;
  230. my ($request) = @_;
  231. my $payment = LedgerSMB::DBObject::Payment->new({'base' => $request});
  232. $payment->{company} = $payment->{_user}->{company};
  233. $payment->{address} = $payment->{_user}->{address};
  234. my $template;
  235. if ($payment->{batch_id}){
  236. my $batch = LedgerSMB::Batch->new(
  237. {base => $payment,
  238. copy => 'base' }
  239. );
  240. $batch->{batch_id} = $payment->{batch_id};
  241. $batch->get;
  242. $payment->{batch_description} = $batch->{description};
  243. $payment->{batch_control_code} = $batch->{control_code};
  244. }
  245. $payment->{format_amount} = sub {return $payment->format_amount(@_); };
  246. if ($payment->{multiple}){
  247. $payment->{checks} = [];
  248. for my $line (1 .. $payment->{contact_count}){
  249. my $id = $payment->{"contact_$line"};
  250. next if !defined $payment->{"id_$id"};
  251. my $check = LedgerSMB::DBObject::Company->new(
  252. {base => $request, copy => 'base' }
  253. );
  254. $check->{entity_class} = $payment->{account_class};
  255. $check->{id} = $id;
  256. $check->get_billing_info;
  257. $check->{amount} = $check->parse_amount(amount => '0');
  258. $check->{invoices} = [];
  259. $check->{source} = $payment->{"source_$id"};
  260. my $inv_count;
  261. if ($LedgerSMB::Sysconfig::check_max_invoices >
  262. $payment->{"invoice_count_$id"})
  263. {
  264. $inv_count = $payment->{"invoice_count_$id"};
  265. } else {
  266. $inv_count = $LedgerSMB::Sysconfig::check_max_invoices;
  267. }
  268. for my $inv (1 .. $inv_count){
  269. my $invhash = {};
  270. my $inv_id = $payment->{"invoice_${id}_$inv"};
  271. for (qw(invnumber invdate)){
  272. $invhash->{$_} = $payment->{"${_}_$inv_id"};
  273. }
  274. if ($payment->{"paid_$id"} eq 'some'){
  275. $invhash->{paid} = $payment->parse_amount(amount => $payment->{"payment_$inv_id"});
  276. } elsif ($payment->{"paid_$id"} eq 'all'){
  277. $invhash->{paid} = $payment->parse_amount(amount => $payment->{"net_$inv_id"});
  278. } else {
  279. $payment->error("Invalid Payment Amount Option");
  280. }
  281. $check->{amount} += $invhash->{paid};
  282. $invhash->{paid} = $check->format_amount(amount => $invhash->{paid});
  283. push @{$check->{invoices}}, $invhash;
  284. }
  285. my $amt = $check->{amount}->copy;
  286. $amt->bfloor();
  287. $check->{text_amount} = $payment->text_amount($amt);
  288. $check->{amount} = $check->format_amount(amount => $check->{amount},
  289. format => '1000.00');
  290. $check->{decimal} = $check->format_amount(amount => ($check->{amount} - $amt) * 100);
  291. push @{$payment->{checks}}, $check;
  292. }
  293. $template = LedgerSMB::Template->new(
  294. user => $payment->{_user}, template => 'check_multiple',
  295. format => uc $payment->{'format'},
  296. no_auto_output => 1,
  297. output_args => $payment,
  298. );
  299. #try {
  300. $template->render($payment);
  301. $template->output(%$payment);
  302. #}
  303. #catch Error::Simple with {
  304. # my $E = shift;
  305. # $payment->error( $E->stacktrace );
  306. #};
  307. display_payments(@_);
  308. } else {
  309. }
  310. }
  311. sub update_payments {
  312. display_payments(@_);
  313. }
  314. sub display_payments {
  315. my ($request) = @_;
  316. my $payment = LedgerSMB::DBObject::Payment->new({'base' => $request});
  317. $payment->get_payment_detail_data();
  318. $payment->{grand_total} = 0;
  319. for (@{$payment->{contact_invoices}}){
  320. my $contact_total = 0;
  321. $_->{total_due} = $payment->format_amount(amount => $_->{total_due},
  322. money => 1);
  323. for my $invoice (@{$_->{invoices}}){
  324. if (($payment->{action} ne 'update_payments')
  325. or (defined $payment->{"id_$_->{contact_id}"})){
  326. if ($payment->{"paid_$_->{contact_id}"} eq 'some'){
  327. my $i_id = $invoice->[0];
  328. $contact_total
  329. += $payment->{"payment_$i_id"};
  330. }
  331. }
  332. $invoice->[3] = $payment->format_amount(amount => $invoice->[3],
  333. money => 1);
  334. $invoice->[4] = $payment->format_amount(amount => $invoice->[4],
  335. money => 1);
  336. $invoice->[5] = $payment->format_amount(amount => $invoice->[5],
  337. money => 1);
  338. $invoice->[6] = $payment->format_amount(amount => $invoice->[6],
  339. money => 1);
  340. my $fld = "payment_" . $invoice->[0];
  341. if (!defined $payment->{"$fld"} ){
  342. $payment->{"$fld"} = $invoice->[6];
  343. }
  344. }
  345. if ($payment->{"paid_$_->{contact_id}"} ne 'some') {
  346. $contact_total = $_->{total_due};
  347. }
  348. if (($payment->{action} ne 'update_payments')
  349. or (defined $payment->{"id_$_->{contact_id}"})){
  350. $_->{contact_total} = $contact_total;
  351. $payment->{grand_total} += $contact_total;
  352. }
  353. }
  354. @{$payment->{media_options}} = (
  355. {text => $request->{_locale}->text('Screen'),
  356. value => 'screen'});
  357. for (keys %LedgerSMB::Sysconfig::printer){
  358. push @{$payment->{media_options}},
  359. {text => $_,
  360. value => $_};
  361. }
  362. if ($LedgerSMB::Sysconfig::latex){
  363. @{$payment->{format_options}} = (
  364. {text => 'PDF', value => 'PDF'},
  365. {text => 'Postscript', value => 'Postscript'},
  366. );
  367. $payment->{can_print} = 1;
  368. }
  369. my $template = LedgerSMB::Template->new(
  370. user => $request->{_user},
  371. locale => $request->{_locale},
  372. path => 'UI/payments',
  373. template => 'payments_detail',
  374. format => 'HTML',
  375. );
  376. $template->render($payment);
  377. }
  378. =item payment
  379. This method is used to set the filter screen and prints it, using the
  380. TT2 system.
  381. =back
  382. =cut
  383. sub payment {
  384. my ($request) = @_;
  385. my $locale = $request->{_locale};
  386. my $dbPayment = LedgerSMB::DBObject::Payment->new({'base' => $request});
  387. # Lets get the project data...
  388. my @projectOptions;
  389. my @arrayOptions = $dbPayment->list_open_projects();
  390. push @projectOptions, {}; #A blank field on the select box
  391. for my $ref (0 .. $#arrayOptions) {
  392. push @projectOptions, { value => $arrayOptions[$ref]->{id}."--".$arrayOptions[$ref]->{projectnumber}."--".$arrayOptions[$ref]->{description},
  393. text => $arrayOptions[$ref]->{projectnumber}."--".$arrayOptions[$ref]->{description}};
  394. }
  395. # Lets get the departments data...
  396. my @departmentOptions;
  397. my $role = $request->{type} eq 'receipt' ? 'P' : 'C';
  398. @arrayOptions = $dbPayment->list_departments($role);
  399. push @departmentOptions, {}; # A blank field on the select box
  400. for my $ref (0 .. $#arrayOptions) {
  401. push @departmentOptions, { value => $arrayOptions[$ref]->{id}."--".$arrayOptions[$ref]->{description},
  402. text => $arrayOptions[$ref]->{description}};
  403. }
  404. # Lets get the currencies (this uses the $dbPayment->{account_class} property)
  405. my @currOptions;
  406. @arrayOptions = $dbPayment->get_open_currencies();
  407. for my $ref (0 .. $#arrayOptions) {
  408. push @currOptions, { value => $arrayOptions[$ref]->{payments_get_open_currencies},
  409. text => $arrayOptions[$ref]->{payments_get_open_currencies} };
  410. }
  411. # Lets build filter by period
  412. my $date = LedgerSMB::DBObject::Date->new({base => $request});
  413. $date->build_filter_by_period($locale);
  414. # Lets set the data in a hash for the template system. :)
  415. my $select = {
  416. stylesheet => $request->{_user}->{stylesheet},
  417. login => { name => 'login',
  418. value => $request->{_user}->{login} },
  419. projects => {
  420. name => 'projects',
  421. options => \@projectOptions
  422. },
  423. department => {
  424. name => 'department',
  425. options => \@departmentOptions
  426. },
  427. curr => {
  428. name => 'curr',
  429. options => \@currOptions
  430. },
  431. month => {
  432. name => 'month',
  433. options => $date->{monthsOptions}
  434. },
  435. year => {
  436. name => 'year',
  437. options => $date->{yearsOptions}
  438. },
  439. interval_radios => $date->{radioOptions},
  440. amountfrom => {
  441. name => 'amountfrom',
  442. },
  443. amountto => {
  444. name => 'amountto',
  445. },
  446. accountclass => {
  447. name => 'account_class',
  448. value => $dbPayment->{account_class}
  449. },
  450. type => {
  451. name => 'type',
  452. value => $request->{type}
  453. },
  454. action => {
  455. name => 'action',
  456. value => 'payment1_5',
  457. text => $locale->text("Continue"),
  458. }
  459. };
  460. my $template;
  461. $template = LedgerSMB::Template->new(
  462. user => $request->{_user},
  463. locale => $request->{_locale},
  464. path => 'UI/payments',
  465. template => 'payment1',
  466. format => 'HTML' );
  467. $template->render($select);# And finally, Lets print the screen :)
  468. }
  469. =pod
  470. =item payment1_5
  471. This method is called between payment and payment2, it will search the database
  472. for entity_credit_accounts that match the parameter, if only one is found it will
  473. run unnoticed by the user, if more than one is found it will ask the user to pick
  474. one to handle the payment against
  475. =back
  476. =cut
  477. sub payment1_5 {
  478. my ($request) = @_;
  479. my $locale = $request->{_locale};
  480. my $dbPayment = LedgerSMB::DBObject::Payment->new({'base' => $request});
  481. my @array_options = $dbPayment->get_entity_credit_account();
  482. if ($#array_options == -1) {
  483. &payment($request);
  484. } elsif ($#array_options == 0) {
  485. $request->{'vendor-customer'} = $array_options[0]->{id}.'--'.$array_options[0]->{name};
  486. &payment2($request);
  487. } else {
  488. # Lets call upon the template system
  489. my @company_options;
  490. for my $ref (0 .. $#array_options) {
  491. push @company_options, { id => $array_options[$ref]->{id},
  492. name => $array_options[$ref]->{name}};
  493. }
  494. my $select = {
  495. companies => \@company_options,
  496. stylesheet => $request->{_user}->{stylesheet},
  497. login => { name => 'login',
  498. value => $request->{_user}->{login}},
  499. department => { name => 'department',
  500. value => $request->{department}},
  501. currency => { name => 'curr',
  502. value => $request->{curr}},
  503. datefrom => { name => 'datefrom',
  504. value => $request->{datefrom}},
  505. dateto => { name => 'dateto',
  506. value => $request->{dateto}},
  507. amountfrom => { name => 'amountfrom',
  508. value => $request->{datefrom}},
  509. amountto => { name => 'amountto',
  510. value => $request->{dateto}},
  511. accountclass => { name => 'account_class',
  512. value => $dbPayment->{account_class}},
  513. type => { name => 'type',
  514. value => $request->{type}},
  515. action => { name => 'action',
  516. value => 'payment2',
  517. text => $locale->text("Continue")}
  518. };
  519. my $template;
  520. $template = LedgerSMB::Template->new(
  521. user => $request->{_user},
  522. locale => $request->{_locale},
  523. path => 'UI/payments',
  524. template => 'payment1_5',
  525. format => 'HTML' );
  526. eval {$template->render($select) };
  527. if ($@) { $request->error("$@"); } # PRINT ERRORS ON THE UI
  528. }
  529. }
  530. =pod
  531. =item payment2
  532. This method is used for the payment module, it is a consecuence of the payment sub,
  533. and its used for all the mechanics of an invoices payment module.
  534. =back
  535. =cut
  536. sub payment2 {
  537. my ($request) = @_;
  538. my $locale = $request->{_locale};
  539. my $Payment = LedgerSMB::DBObject::Payment->new({'base' => $request});
  540. # VARIABLES
  541. my ($project_id, $project_number, $project_name, $department_id, $department_name );
  542. my @array_options;
  543. my @project;
  544. my @selected_checkboxes;
  545. my @department;
  546. my @array_options;
  547. my @currency_options;
  548. my $exchangerate;
  549. # LETS GET THE CUSTOMER/VENDOR INFORMATION
  550. ($Payment->{entity_credit_id}, $Payment->{company_name}) = split /--/ , $request->{'vendor-customer'};
  551. # WE NEED TO RETRIEVE A BILLING LOCATION, THIS IS HARDCODED FOR NOW... Should we change it?
  552. $Payment->{location_class_id} = '1';
  553. my @vc_options;
  554. @vc_options = $Payment->get_vc_info();
  555. # LETS BUILD THE PROJECTS INFO
  556. # I DONT KNOW IF I NEED ALL THIS, BUT AS IT IS AVAILABLE I'LL STORE IT FOR LATER USAGE.
  557. if ($request->{projects}) {
  558. ($project_id, $project_number, $project_name) = split /--/ , $request->{projects} ;
  559. @project = { name => 'projects', text => $project_number.' '.$project_name, value => $request->{projects}};
  560. }
  561. # LETS GET THE DEPARTMENT INFO
  562. # WE HAVE TO SET $dbPayment->{department_id} NOW, THIS DATA WILL BE USED LATER WHEN WE
  563. # CALL FOR payment_get_open_invoices. :)
  564. if ($request->{department}) {
  565. ($Payment->{department_id}, $department_name) = split /--/, $request->{department};
  566. @department = { name => 'department', text => $department_name, value => $request->{department}};
  567. }
  568. # LETS GET ALL THE ACCOUNTS
  569. my @account_options = $Payment->list_accounting();
  570. # LETS GET THE POSSIBLE SOURCES
  571. my @sources_options = $Payment->get_sources(\%$locale);
  572. # WE MUST PREPARE THE ENTITY INFORMATION
  573. #@array_options = $Payment->get_vc_info();# IS THIS WORKING?
  574. # LETS BUILD THE CURRENCIES INFORMATION
  575. # FIRST, WE NEED TO KNOW THE DEFAULT CURRENCY
  576. my $default_currency = $Payment->get_default_currency();
  577. # LETS BUILD THE COLUMN HEADERS WE ALWAYS NEED
  578. # THE OTHER HEADERS WILL BE BUILT IF THE RIGHT CONDITIONS ARE MET.
  579. # -----------------------------------------------
  580. # SOME USERS WONT USE MULTIPLE CURRENCIES, AND WONT LIKE THE FACT CURRENCY BEING
  581. # ON THE SCREEN ALL THE TIME, SO IF THEY ARE USING THE DEFAULT CURRENCY WE WONT PRINT IT
  582. my $currency_text = $request->{curr} eq $default_currency ? '' : '('.$request->{curr}.')';
  583. my $default_currency_text = $currency_text ? '('.$default_currency.')' : '';
  584. my @column_headers = ({text => $locale->text('Invoice')},
  585. {text => $locale->text('Date')},
  586. {text => $locale->text('Total').$default_currency_text},
  587. {text => $locale->text('Paid').$default_currency_text},
  588. {text => $locale->text('Discount').$default_currency_text},
  589. {text => $locale->text('Apply Disc')},
  590. {text => $locale->text('Amount Due').$default_currency_text},
  591. {text => $locale->text('To pay').$default_currency_text}
  592. );
  593. # WE NEED TO KNOW IF WE ARE USING A CURRENCY THAT NEEDS AN EXCHANGERATE
  594. if ($default_currency ne $request->{curr} ) {
  595. # FIRST WE PUSH THE OTHER COLUMN HEADERS WE NEED
  596. push @column_headers, {text => $locale->text('Exchange Rate')},
  597. {text => $locale->text('Amount Due').$currency_text},
  598. {text => $locale->text('To pay').$currency_text};
  599. # WE SET THEM IN THE RIGHT ORDER FOR THE TABLE INSIDE THE UI
  600. @column_headers[6,7,8] = @column_headers[7,8,6];
  601. # DOES THE CURRENCY IN USE HAS AN EXCHANGE RATE?, IF SO
  602. # WE MUST SET THE VALUE, OTHERWISE THE UI WILL HANDLE IT
  603. $exchangerate = $request->{exrate} ?
  604. $request->{exrate} :
  605. $Payment->get_exchange_rate($request->{curr},
  606. $request->{datepaid} ? $request->{datepaid} : $Payment->{current_date});
  607. if ($exchangerate) {
  608. @currency_options = {
  609. name => 'exrate',
  610. value => "$exchangerate", #THERE IS A STRANGE BEHAVIOUR WITH THIS,
  611. text => "$exchangerate" #IF I DONT USE THE DOUBLE QUOTES, IT WILL PRINT THE ADDRESS
  612. #THERE MUST BE A REASON FOR THIS, I MUST RETURN TO IT LATER
  613. };
  614. } else {
  615. @currency_options = {
  616. name => 'exrate'};
  617. }
  618. } else {
  619. # WE MUST SET EXCHANGERATE TO 1 FOR THE MATHS SINCE WE
  620. # ARE USING THE DEFAULT CURRENCY
  621. $exchangerate = 1;
  622. @currency_options = {
  623. name => 'exrate',
  624. value => 1,
  625. text => 1
  626. };
  627. }
  628. # FINALLY WE ADD TO THE COLUMN HEADERS A LAST FIELD TO PRINT THE CLOSE INVOICE CHECKBOX TRICK :)
  629. push @column_headers, {text => 'X'};
  630. # WE NEED TO QUERY THE DATABASE TO CHECK FOR OPEN INVOICES
  631. # WE WONT DO ANYTHING IF WE DONT FIND ANY INVOICES, THE USER CAN STILL POST A PREPAYMENT
  632. my @invoice_data;
  633. my @topay_state; # WE WILL USE THIS TO HELP UI TO DETERMINE WHAT IS VISIBLE
  634. @array_options = $Payment->get_open_invoices();
  635. my $unhandled_overpayment;
  636. for my $ref (0 .. $#array_options) {
  637. if ( !$request->{"checkbox_$array_options[$ref]->{invoice_id}"}) {
  638. # SHOULD I APPLY DISCCOUNTS?
  639. $request->{"optional_discount_$array_options[$ref]->{invoice_id}"} = $request->{first_load}? "on": $request->{"optional_discount_$array_options[$ref]->{invoice_id}"};
  640. # LETS SET THE EXCHANGERATE VALUES
  641. my $due_fx; my $topay_fx_value;
  642. if ("$exchangerate") {
  643. $topay_fx_value = $due_fx = $request->round_amount("$array_options[$ref]->{due}"/"$exchangerate");
  644. if ($request->{"optional_discount_$array_options[$ref]->{invoice_id}"}) {
  645. $topay_fx_value = $due_fx = $request->round_amount($due_fx - "$array_options[$ref]->{discount}"/"$exchangerate");
  646. }
  647. } else {
  648. $topay_fx_value = $due_fx = "N/A";
  649. }
  650. # We need to check for unhandled overpayment, see the post function for details
  651. # First we will see if the discount should apply?
  652. my $temporary_discount = 0;
  653. if (($request->{"optional_discount_$array_options[$ref]->{invoice_id}"})&&($due_fx <= $request->{"topay_fx_$array_options[$ref]->{invoice_id}"} + $request->round_amount($array_options[$ref]->{discount}/"$exchangerate"))) {
  654. $temporary_discount = $request->round_amount("$array_options[$ref]->{discount}"/"$exchangerate");
  655. }
  656. # We need to compute the unhandled_overpayment, notice that all the values inside the if already have
  657. # the exchangerate applied
  658. if ( $due_fx < $request->{"topay_fx_$array_options[$ref]->{invoice_id}"}) {
  659. # We need to store all the overpayments so we can use it on the screen
  660. $unhandled_overpayment = $request->round_amount($unhandled_overpayment + $request->{"topay_fx_$array_options[$ref]->{invoice_id}"} - $due_fx );
  661. $request->{"topay_fx_$array_options[$ref]->{invoice_id}"} = "$due_fx";
  662. }
  663. push @invoice_data, { invoice => { number => $array_options[$ref]->{invnumber},
  664. id => $array_options[$ref]->{invoice_id},
  665. href => 'ar.pl?id='."$array_options[$ref]->{invoice_id}"
  666. },
  667. invoice_date => "$array_options[$ref]->{invoice_date}",
  668. amount => "$array_options[$ref]->{amount}",
  669. due => $request->{"optional_discount_$array_options[$ref]->{invoice_id}"}? "$array_options[$ref]->{due}" - "$array_options[$ref]->{discount}": "$array_options[$ref]->{due}",
  670. paid => "$array_options[$ref]->{amount}" - "$array_options[$ref]->{due}",
  671. discount => $request->{"optional_discount_$array_options[$ref]->{invoice_id}"} ? "$array_options[$ref]->{discount}" : 0 ,
  672. optional_discount => $request->{"optional_discount_$array_options[$ref]->{invoice_id}"},
  673. exchange_rate => "$exchangerate",
  674. due_fx => "$due_fx", # This was set at the begining of the for statement
  675. topay => "$array_options[$ref]->{due}" - "$array_options[$ref]->{discount}",
  676. source_text => $request->{"source_text_$array_options[$ref]->{invoice_id}"},
  677. optional => $request->{"optional_pay_$array_options[$ref]->{invoice_id}"},
  678. selected_account => $request->{"account_$array_options[$ref]->{invoice_id}"},
  679. selected_source => $request->{"source_$array_options[$ref]->{invoice_id}"},
  680. topay_fx => { name => "topay_fx_$array_options[$ref]->{invoice_id}",
  681. value => $request->{"topay_fx_$array_options[$ref]->{invoice_id}"} ?
  682. $request->{"topay_fx_$array_options[$ref]->{invoice_id}"} eq 'N/A' ?
  683. "$topay_fx_value" :
  684. $request->{"topay_fx_$array_options[$ref]->{invoice_id}"} :
  685. "$topay_fx_value"
  686. # Ugly hack, but works ;) ...
  687. }#END HASH
  688. };# END PUSH
  689. push @topay_state, {
  690. id => "topaystate_$array_options[$ref]->{invoice_id}",
  691. value => $request->{"topaystate_$array_options[$ref]->{invoice_id}"}
  692. }; #END PUSH
  693. }
  694. else {
  695. push @selected_checkboxes, {name => "checkbox_$array_options[$ref]->{invoice_id}",
  696. value => "checked"} ;
  697. } #END IF
  698. }# END FOR
  699. # And finally, we are going to store the information for the overpayment / prepayment / advanced payment
  700. # and all the stuff, this is only needed for the update function.
  701. my @overpayment;
  702. my @overpayment_account;
  703. # Got to build the account selection box first.
  704. my @overpayment_account = $Payment->list_overpayment_accounting();
  705. # Now we build the structure for the UI
  706. for (my $i=1 ; $i <= $request->{overpayment_qty}; $i++) {
  707. if (!$request->{"overpayment_checkbox_$i"}) {
  708. if ( $request->{"overpayment_topay_$i"} ) {
  709. # Now we split the account selected options
  710. my ($id, $accno, $description) = split(/--/, $request->{"overpayment_account_$i"});
  711. my ($cashid, $cashaccno, $cashdescription ) = split(/--/, $request->{"overpayment_cash_account_$i"});
  712. push @overpayment, {amount => $request->{"overpayment_topay_$i"},
  713. source1 => $request->{"overpayment_source1_$i"},
  714. source2 => $request->{"overpayment_source2_$i"},
  715. memo => $request->{"overpayment_memo_$i"},
  716. account => { id => $id,
  717. accno => $accno,
  718. description => $description
  719. },
  720. cashaccount => { id => $cashid,
  721. accno => $cashaccno,
  722. description => $cashdescription
  723. }
  724. };
  725. } else {
  726. $i = $request->{overpayment_qty} + 1;
  727. }
  728. }
  729. }
  730. # We need to set the availible media and format from printing
  731. my @media_options;
  732. push @media_options, {value => 1, text => "Screen"};
  733. if ($#{LedgerSMB::Sysconfig::printer}) {
  734. for (keys %{LedgerSMB::Sysconfig::printer}) {
  735. push @media_options, {value => 1, text => $_};
  736. }
  737. }
  738. #$request->error("@media_options");
  739. my @format_options;
  740. push @format_options, {value => 1, text => "HTML"};
  741. if (${LedgerSMB::Sysconfig::latex}) {
  742. push @format_options, {value => 2, text => "PDF" }, {value => 3, text => "POSTSCRIPT" };
  743. }
  744. # LETS BUILD THE SELECTION FOR THE UI
  745. # Notice that the first data inside this selection is the firs_load, this
  746. # will help payment2.html to know wether it is beeing called for the first time
  747. my $select = {
  748. first_load => $request->{first_load},
  749. stylesheet => $request->{_user}->{stylesheet},
  750. header => { text => $request->{type} eq 'receipt' ? $locale->text('Receipt') : $locale->text('Payment') },
  751. type => { name => 'type',
  752. value => $request->{type} },
  753. login => { name => 'login',
  754. value => $request->{_user}->{login} },
  755. accountclass => {
  756. name => 'account_class',
  757. value => $Payment->{account_class}
  758. },
  759. project => @project ? @project : '' , # WE NEED TO VERIFY THAT THE ARRAY EXISTS, IF IT DOESNT,
  760. department => @department ? @department : '', # WE WILL PASS A NULL STRING, THIS FIXES THE ISSUES
  761. # I WAS HAVING WITH THE NULL ARRAYS, STILL UGLY :P
  762. account => \@account_options,
  763. selected_account => $request->{account},
  764. datepaid => {
  765. name => 'datepaid',
  766. value => $request->{datepaid} ? $request->{datepaid} : $Payment->{current_date}
  767. },
  768. source => \@sources_options,
  769. selected_source => $request->{source},
  770. source_value => $request->{source_value},
  771. defaultcurrency => {
  772. text => $default_currency
  773. },
  774. curr => { name => 'curr',
  775. value => $request->{curr},
  776. },
  777. column_headers => \@column_headers,
  778. rows => \@invoice_data,
  779. topay_state => \@topay_state,
  780. vendorcustomer => { name => 'vendor-customer',
  781. value => $request->{'vendor-customer'}
  782. },
  783. unhandled_overpayment => { name => 'unhandledoverpayment', value => "$unhandled_overpayment" } ,
  784. vc => { name => $Payment->{company_name}, # We will assume that the first Billing Information as default
  785. address => [ {text => $vc_options[0]->{'line_one'}},
  786. {text => $vc_options[0]->{'line_two'}},
  787. {text => $vc_options[0]->{'line_three'}},
  788. {text => $vc_options[0]->{city}},
  789. {text => $vc_options[0]->{state}},
  790. {text => $vc_options[0]->{country}}]
  791. },
  792. format => {
  793. name => 'FORMAT',
  794. options => \@format_options
  795. },
  796. media => {
  797. name => 'MEDIA',
  798. options => \@media_options
  799. },
  800. exrate => @currency_options,
  801. selectedcheckboxes => @selected_checkboxes ? \@selected_checkboxes : '',
  802. notes => $request->{notes},
  803. overpayment => \@overpayment,
  804. overpayment_account => \@overpayment_account
  805. };
  806. my $template = LedgerSMB::Template->new(
  807. user => $request->{_user},
  808. locale => $request->{_locale},
  809. path => 'UI/payments',
  810. template => 'payment2',
  811. format => 'HTML' );
  812. eval {$template->render($select) };
  813. if ($@) { $request->error("$@"); } # PRINT ERRORS ON THE UI
  814. }
  815. =pod
  816. =item post_payment
  817. This method is used for the payment module (not the bulk payment),
  818. and its used for all the mechanics of storing a payment.
  819. =back
  820. =cut
  821. sub post_payment {
  822. my ($request) = @_;
  823. my $locale = $request->{_locale};
  824. my $Payment = LedgerSMB::DBObject::Payment->new({'base' => $request});
  825. # LETS GET THE CUSTOMER/VENDOR INFORMATION
  826. ($Payment->{entity_credit_id}, $Payment->{company_name}) = split /--/ , $request->{'vendor-customer'};
  827. # LETS GET THE DEPARTMENT INFO
  828. # WE HAVE TO SET $dbPayment->{department_id} in order to process
  829. if ($request->{department}) {
  830. $request->{department} =~ /^(\d+)--*/;
  831. $Payment->{department_id} = $1;
  832. }
  833. #
  834. # We want to set a gl_description,
  835. # since we are using two tables there is no need to use doubled information,
  836. # we could specify this gl is the result of a payment movement...
  837. #
  838. $Payment->{gl_description} = $locale->text('This gl movement, is the result of a payment transaction');
  839. #
  840. # Im not sure what this is for... gotta comment this later
  841. $Payment->{approved} = 'true';
  842. #
  843. # We have to setup a lot of things before we can process the payment
  844. # they are related to payment_post sql function, so if you have any doubts
  845. # look there.
  846. #-------------------------------------------------------------------------
  847. #
  848. # Variable definition
  849. #
  850. # We use the prefix op to refer to the overpayment variables.
  851. my $unhandled_overpayment = 0; # This variable might be fuzzy, we are using it to handle invalid data
  852. # i.e. a user set an overpayment qty inside an invoice.
  853. my @array_options;
  854. my @amount;
  855. my @discount;
  856. my @cash_account_id;
  857. my @source;
  858. my @transaction_id;
  859. my @op_amount;
  860. my @op_cash_account_id;
  861. my @op_source;
  862. my @op_memo;
  863. my @op_account_id;
  864. #
  865. # We need the invoices in order to process the income data, this is done this way
  866. # since the data we have isn't indexed in any way.
  867. #
  868. # Ok, we want to use the disccount information in order to do some accounting movements,
  869. # we will process it with the same logic for a regular payment, and see where does this leave us.
  870. @array_options = $Payment->get_entity_credit_account();# We need to know the disccount account
  871. my $discount_account_id = $array_options[0]->{discount};
  872. @array_options = $Payment->get_open_invoices();
  873. for my $ref (0 .. $#array_options) {
  874. if ( !$request->{"checkbox_$array_options[$ref]->{invoice_id}"}) {
  875. # First i have to determine if discounts will apply
  876. # we will assume that a discount should apply only
  877. # if this is the last payment of an invoice
  878. my $temporary_discount = 0;
  879. if (($request->{"optional_discount_$array_options[$ref]->{invoice_id}"})&&("$array_options[$ref]->{due}"/"$request->{exrate}" <= $request->{"topay_fx_$array_options[$ref]->{invoice_id}"} + $array_options[$ref]->{discount})) {
  880. $temporary_discount = $array_options[$ref]->{discount};
  881. }
  882. #
  883. # The prefix cash is to set the movements of the cash accounts,
  884. # same names are used for ap/ar accounts w/o the cash prefix.
  885. #
  886. if ( "$array_options[$ref]->{due}"/"$request->{exrate}" < $request->{"topay_fx_$array_options[$ref]->{invoice_id}"} + $temporary_discount ) {
  887. # We need to store all the overpayments so we can use it on a new payment2 screen
  888. $unhandled_overpayment = $request->round_amount($unhandled_overpayment + $request->{"topay_fx_$array_options[$ref]->{invoice_id}"} + $temporary_discount - $array_options[$ref]->{amount}) ;
  889. }
  890. if ($request->{"optional_discount_$array_options[$ref]->{invoice_id}"}) {
  891. push @amount, $array_options[$ref]->{discount};
  892. push @cash_account_id, $discount_account_id;
  893. push @source, $locale->text('Applied discount');
  894. push @transaction_id, $array_options[$ref]->{invoice_id};
  895. }
  896. push @amount, $request->{"topay_fx_$array_options[$ref]->{invoice_id}"}; # We'll use this for both cash and ap/ar accounts
  897. push @cash_account_id, $request->{"optional_pay_$array_options[$ref]->{invoice_id}"} ? $request->{"account_$array_options[$ref]->{invoice_id}"} : $request->{account};
  898. push @source, $request->{"source1_$array_options[$ref]->{invoice_id}"}.' '.$request->{"source2_$array_options[$ref]->{invoice_id}"}; # We'll use this for both source and ap/ar accounts
  899. push @transaction_id, $array_options[$ref]->{invoice_id};
  900. }
  901. }
  902. # Check if there is an unhandled overpayment and run payment2 as needed
  903. if ($unhandled_overpayment) {
  904. &payment2($request);
  905. return 0;
  906. }
  907. #
  908. # Now we need the overpayment information.
  909. #
  910. # We will use the prefix op to indicate it is an overpayment information.
  911. #
  912. # note: I love the for's C-like syntax.
  913. for (my $i=1 ; $i <= $request->{overpayment_qty}; $i++) {
  914. if (!$request->{"overpayment_checkbox_$i"}) { # Is overpayment marked as deleted ?
  915. if ( $request->{"overpayment_topay_$i"} ) { # Is this overpayment an used field?
  916. # Now we split the account selected options, using the namespace the if statement
  917. # provides for us.
  918. $request->{"overpayment_account_$i"} =~ /^(\d+)--*/;
  919. my $id = $1;
  920. $request->{"overpayment_cash_account_$i"} =~ /^(\d+)--*/;
  921. my $cashid = $1;
  922. push @op_amount, $request->{"overpayment_topay_$i"};
  923. push @op_cash_account_id, $cashid;
  924. push @op_source, $request->{"overpayment_source1_$i"}.' '.$request->{"overpayment_source2_$i"};
  925. push @op_memo, $request->{"overpayment_memo_$i"};
  926. push @op_account_id, $id;
  927. }
  928. }
  929. }
  930. # Finally we store all the data inside the LedgerSMB::DBObject::Payment object.
  931. $Payment->{cash_account_id} = $Payment->_db_array_scalars(@cash_account_id);
  932. $Payment->{amount} = $Payment->_db_array_scalars(@amount);
  933. $Payment->{source} = $Payment->_db_array_scalars(@source);
  934. $Payment->{transaction_id} = $Payment->_db_array_scalars(@transaction_id);
  935. $Payment->{op_amount} = $Payment->_db_array_scalars(@op_amount);
  936. $Payment->{op_cash_account_id} = $Payment->_db_array_scalars(@op_cash_account_id);
  937. $Payment->{op_source} = $Payment->_db_array_scalars(@op_source);
  938. $Payment->{op_memo} = $Payment->_db_array_scalars(@op_memo);
  939. $Payment->{op_account_id} = $Payment->_db_array_scalars(@op_account_id);
  940. # Ok, hoping for the best...
  941. $Payment->post_payment();
  942. # We've gotta print anything, in the near future this will redirect to a new payment.
  943. my $select = {};
  944. my $template = LedgerSMB::Template->new(
  945. user => $request->{_user},
  946. locale => $request->{_locale},
  947. path => 'UI/payments',
  948. template => 'payment2',
  949. format => 'HTML' );
  950. eval {$template->render($select) };
  951. if ($@) { $request->error("$@"); } # PRINT ERRORS ON THE UI
  952. }
  953. eval { do "scripts/custom/payment.pl"};
  954. 1;