<?php
/*
<LICENSE>
This file is part of CHASERS.
CHASERS is Copyright (c) 2003-2008 Downtown Emergency Service Center (DESC).
All rights reserved.
For more information, about DESC, see http://www.desc.org/.
For more information about CHASERS, see http://chasers.desc.org/.

CHASERS is free software: you can redistribute it and/or modify
it under the terms of version 3 of the GNU General Public License 
as published by the Free Software Foundation.

CHASERS is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with CHASERS.  If not, see <http://www.gnu.org/licenses/>.

</LICENSE>
*/

// configuration of stuff relating to payments

$payments_import_table = "qb_payment";
$qb_client_table = "qb_client";
$payments_table = "payment";

/*
$accounts_rent_residents = array( "1240.44"	=>	"Lyon",
				 "1260.33"	=>	"Union",
				 "1270.55"	=>	"KSH",
				 "1280.66"	=>	"Morr" );

$accounts_rent_subsidy  = array( "1244.44"	=>	"Lyon",
				 "1264.33"	=>	"Union",
				 "1274.55"	=>	"KSH",
				 "1284.66"	=>	"Morr" );

$accounts_security      = array( "1248.44"	=>	"Lyon",
				 "1268.33"	=>	"Union",
				 "1278.55"	=>	"KSH",
				 "1288.66"	=>	"Morr",
				 "2653.44"	=>	"Lyon",
				 "2605.33"	=>	"Union",
				 "2683.55"	=>	"KSH",
				 "2688.66"	=>	"Morr" );
*/
// Chart of accounts changed 9/12/03
//changed codes to upper case - 8/18/04 - JH
$accounts_rent_residents = array( "1640.44"	=>	"LYON",
				 "1630.33"	=>	"UNION",
				 "1650.55"	=>	"KSH",
				 "1660.66"	=>	"MORR" );

$accounts_rent_subsidy  = array( "1644.44"	=>	"LYON",
				 "1634.33"	=>	"UNION",
				 "1654.55"	=>	"KSH",
				 "1664.66"	=>	"MORR" );

$accounts_security      = array( "1648.44"	=>	"LYON",
				 "1638.33"	=>	"UNION",
				 "1658.55"	=>	"KSH",
				 "1668.66"	=>	"MORR",
				 "3540.44"	=>	"LYON",
				 "3530.33"	=>	"UNION",
				 "3550.55"	=>	"KSH",
				 "3560.66"	=>	"MORR" );



$payments_import_select_sql = "
	SELECT 	DISTINCT qb_id	AS	qb_id,
		qb_type		AS	qb_type,
		qb_name		AS	qb_name,
		qb_account	AS	qb_account,
		qb_memo		AS	qb_memo,
		qb_no		AS	qb_no,
		client_id	AS	client_id,
		qb_date		AS	payment_date,
		qb_amount	AS	amount
	FROM	$payments_import_table
	LEFT JOIN $qb_client_table using (qb_name)
	WHERE 1=1 ";

$payments_select_sql = "SELECT * FROM $payments_table AS PAY ";

?>