Re: [Chasers-general] Next Steps

[Nicholas B. <nbu...@co...>]

Ok, that cleared up most errors, except for one larger error window, =
which I can't seem to find:

Couldn't query with: SELECT desc_project_code,
                  subs_charge-subs_payment AS subsidy_balance,
                  non_subs_charge-non_subs_payment AS client_balance
                  FROM
                  (SELECT DISTINCT
                   COALESCE(CASE WHEN c.desc_project_code IS NULL THEN
                            (SELECT SUM(amount)
FROM charge c0
WHERE client_id=3D1 AND NOT is_void AND NOT is_subsidy
                            AND c0.desc_project_code IS NULL)
                            ELSE (SELECT SUM(amount)
FROM charge c0
WHERE client_id=3D1 AND NOT is_void AND NOT is_subsidy
                                     AND =
UPPER(c0.desc_project_code)=3DUPPER(c.desc_project_code))
                            END,0) AS non_subs_charge,
                   COALESCE(CASE WHEN c.desc_project_code IS NULL THEN
                            (SELECT SUM(amount)
FROM charge c0
WHERE client_id=3D1 AND NOT is_void AND is_subsidy
                            AND c0.desc_project_code IS NULL)
                            ELSE (SELECT SUM(amount)
FROM charge c0
WHERE client_id=3D1 AND NOT is_void AND is_subsidy
                                     AND =
UPPER(c0.desc_project_code)=3DUPPER(c.desc_project_code))
                            END,0) AS subs_charge,
                   COALESCE(CASE WHEN c.desc_project_code IS NULL THEN
                            (SELECT SUM(amount)
FROM payment p0
WHERE client_id=3D1 AND NOT is_void AND NOT is_subsidy
                            AND p0.desc_project_code IS NULL)
                            ELSE (SELECT SUM(amount)
FROM payment p0
WHERE client_id=3D1 AND NOT is_void AND NOT is_subsidy
                                     AND =
UPPER(p0.desc_project_code)=3DUPPER(c.desc_project_code))
                            END,0) AS non_subs_payment,
                   COALESCE(CASE WHEN c.desc_project_code IS NULL THEN
                            (SELECT SUM(amount)
FROM payment p0
WHERE client_id=3D1 AND NOT is_void AND is_subsidy
                            AND p0.desc_project_code IS NULL)
                            ELSE (SELECT SUM(amount)
FROM payment p0
WHERE client_id=3D1 AND NOT is_void AND is_subsidy
                                     AND =
UPPER(p0.desc_project_code)=3DUPPER(c.desc_project_code))
                            END,0) AS subs_payment,
                   COALESCE(c.desc_project_code,'Other') AS =
desc_project_code
                 =20
FROM charge c
WHERE client_id=3D1) as a
                 =20
                  UNION
                 =20
                  SELECT
                  'Total' AS desc_project_code,
                  (SELECT COALESCE(SUM(amount),0)
FROM charge
WHERE client_id=3D1 AND NOT is_void AND is_subsidy)-
                  (SELECT COALESCE(SUM(amount),0)
FROM payment
WHERE client_id=3D1 AND NOT is_void AND is_subsidy) AS subsidy_balance,
                  (SELECT COALESCE(SUM(amount),0)
FROM charge
WHERE client_id=3D1 AND NOT is_void AND NOT is_subsidy)-
                  (SELECT COALESCE(SUM(amount),0)
FROM payment
WHERE client_id=3D1 AND NOT is_void AND NOT is_subsidy) AS =
client_balance
The Postgres SQL server reported an error.
The error text was: ERROR: relation "charge" does not exist
The program is continuing

----------------------------------------------------

Additionally, I am getting a bunch of errors within the search results =
window. Do we do the same thing for the search results? If so, within =
the same file clients.php, or a different file?


Nicholas Burmeister
IT Department
The Compass Center
206-357-3144
nbu...@co...



-----Original Message-----
From: cha...@li... on behalf of =
Jonathan Hedstrom
Sent: Wed 8/23/2006 4:50 PM
To: general
Subject: Re: [Chasers-general] Next Steps
=20
Nicholas Burmeister wrote:
> Still not entirely clear on how to locate the client_show function =
call for bar,
comment out this section:
    //Bar Status
    $out .=3D row(
            rightcell('Bar Status')
            . leftcell(bar_status_f($client,'long',$is_provisional) .
gatemail_status_f($client)));
>  dal,
This is most likely in tier_status_f(), so commenting out that should
take care of it
>  income_date and income_clinical_date,
comment out this section:
    // Income
    $inc =3D income_f($id,$has_inc);
    $jump_add =3D !$has_inc ?
      =20
smaller(link_engine(array('object'=3D>'income','action'=3D>'add','rec_ini=
t'=3D>array(CG_MAIN_OBJECT_DB.'_id'=3D>$id)),smaller('Add
an income record')))
        : smaller(seclink('income','Jump to income
records','onclick=3D"javascript:showHideElement(\'incomeChildList\')"'));=

    $out .=3D row(rightcell('Monthly Income'.
html_no_print(oline().$jump_add)). leftcell($inc));
> In any case, I'll pick up on this tomorrow, time to hit the road. =
Thanks for being on top of this today!
>  =20
no problem :)