Chip Cotton
|
| Posted: 08/16/2002, 4:29 AM |
|
I thought this was so easy enough to do when I was doing it
'manually', but CCS has spoiled me! Please help prevent me from going
back to "ultra edit"!
I'm looking for a way to produce a list of accounts, and under each
account, activity for that account (in a given period).
two tables: customers and activity (sales and payments)
Desired report:
Customer 1
1/03 sale $20
1/21 sale $10
3/02 pmt $30
bal $0
Customer 2
1/13 sale $10
2/02 sale $25
3/20 pmt $30
balance $5
etc.
The 'balance' is an extra which would be really nice, but the primary
focus is the list of details per customer.
From the 'ground level' a activity table query has to be looped
through every time the customer table steps through the loop.
This is easy enough to do, of course, when you're doing one customer
at a time, but I want to see multiple customers on the same page.
I'm honestly wondering: can codecharge DO this?
If so, where do I start?
|
|
|
 |
Sixto Luis Santos
|
| Posted: 08/20/2002, 12:50 PM |
|
Hello Chip,
This is how I would do it:
1. Create your SQL as an inner join. For the example sake, say the query is
SELECT header_name,detail_name,detail_value FROM MyDetails INNER JOIN
MyHeaders ON MyDetails.header_ID=MyHeaders.header_ID;
2. Modyfy the HTML template to add your header row spanning all columns and
enclose it in a custom block:
<!-- BEGIN headTitle -->
<tr>
<td colspan="3"><B>{header_name}</B></td>
</tr>
<!-- END headTitle -->
3. Add BeforeShowRow event code to check for repeated header_name. If new
header_name, display it, otherwise hide it:
global $mydetails_myhea;
global $Tpl;
global $last_title;
$cur_title=$mydetails_myhea->ds->header_name->GetValue();
if($last_title!=$cur_title)
{
$Tpl->setvar("header_name",$cur_title);
// You must parse the template block, otherwise it won't be rendered.
$Tpl->parse("headTitle",false);
$last_title=$cur_title;
}
else
{
$Tpl->setvar("header_name","");
$Tpl->parse("headTitle",false);
}
Well, all this is easier to follow with an actual sample, so find attached a
ZIP with a CCS project in PHP showing a Master/Detail grid. You must first
create a database (in MySQL) called MasterDetail_sample and then execute the
enclosed file MasterDetail_sample.sql that creates the tables and adds some
sample data. The project is expecting an ODBC data source called
MasterDetail_sample.
Regards,
Sixto
"Chip Cotton" <please.no.email@Jail-Spammers.com> wrote in message
news:9pnpluomnmqso25dp4med3l6i3gvidckbe@4ax.com...
> I thought this was so easy enough to do when I was doing it
> 'manually', but CCS has spoiled me! Please help prevent me from going
> back to "ultra edit"!
>
> I'm looking for a way to produce a list of accounts, and under each
> account, activity for that account (in a given period).
>
> two tables: customers and activity (sales and payments)
>
> Desired report:
>
> Customer 1
> 1/03 sale $20
> 1/21 sale $10
> 3/02 pmt $30
> bal $0
> Customer 2
> 1/13 sale $10
> 2/02 sale $25
> 3/20 pmt $30
> balance $5
> etc.
>
> The 'balance' is an extra which would be really nice, but the primary
> focus is the list of details per customer.
>
> From the 'ground level' a activity table query has to be looped
> through every time the customer table steps through the loop.
>
> This is easy enough to do, of course, when you're doing one customer
> at a time, but I want to see multiple customers on the same page.
>
> I'm honestly wondering: can codecharge DO this?
>
> If so, where do I start?
begin 666 MasterDetail_sample.zip
M4$L#!!0````(`%=\%"U\1D5P6P,``&(*```0````36%S=&5R1&5T86EL+F-C
M<,U6WV_3,!!^!HG_P?(C0LLZ!@RIK;25_4)M598"CY.77%N#8P?;:=?]]=CG
M)$VR@D" Q)-]=_;==]_99_=G; F$IP/:H\1"E@MFX?S>@C1<R0%=V4Q0HL&I
M^1IFS*X&]("212'$35=I("DT.%<73!B@I-!BOLUA0*N5E'!S+1-1I(U5<3P^
M31(PIM(,GSU]TA^I+%<2I#5>?-*_U#Q%F$>/XQA5Z 1"J#F[$^ !VT++3TP4
MI7Y:9'>@*4EAP0IA?=8Q?W"&WN$A)8F2$A*+&2?R=L*,!?T.+.,N><DRMR[;
MIBB;VVR[`N8\,<MBC-PPOB!H34$;2I1VX]G6D8B:6^_H15B(<TKR$L:89]R6
M6#;\@>ETQ/(`9\R-)6I!)KL0DRH$J5;/5^ Q3IS]3MVWM&7ZCLM*[:FLR2H$
MTY7A5 BUB96V7"YK<H/IHP&D+-%*"- =*VZ\E@:T?62Q-Y X(CKZH(PA9YI9
M5?L;-NO>'[,[$%CT$W?B.(@T;E3ZW=E(B2*3H1)E0G!O*?%GMHX'*;?^3-2*
M4,Y&25J^.Y9.,:[01J8-VV]1'X[<J[K*$W8_!KGT]V>GO#8S9LRF05J3EFC8
M/U^7DP@9:A+U]J\3U3JO+:):E@Y1X>[\*5''^X@Z_BM$]0[_%5-KWW3V4U6:
M]G/UJ6G\'\B*FG<Q6,NQ3/@,%DI#O%*;&[5QKP<"BT&O7:,=]D^QGYIJ0A@.
M4]PY*HQ5&1FIU"41#"/W[BR5=MWR$B1HYAHOUJE'/:3:680`JM$IL.'/7!O)
MP/5LC_^]XA*UIC%'9R\=2"],VQW=]6%E/O/4$X8MV(E7P)<KNY/'L'!2F,]5
M[J=1U_VKCOOZ(?A5][V3E[L`1R'S;C9C+K\V$SO"T&_*`Q?\U)D=E,V,IZ7]
M)H2ML347(/:.@U+;W88OIKL%KB;A.)Y_*WS%OGA4J.#N0=5U`B7H"P^A&A'W
M\8\J@F@[VH/GWN%N\^L?\=W:7&6*FZ,*0CQKG9GXP[@M^R\&M]M+K8H<+X5_
M-=MW(GQ34KC@OCCX2ZE$A!=.*"6"R67A'L\!G5W-YN47RU1=H_G7N 7<<I"O
M<L]PECEI0*/(9:2TOV?5U8V&[5#A(OUZH)]%F.LB_-WV;(F0@4;*CXG:M1'_
M87!KO@-02P,$% ````@`5GP4+>?2ZEH/`P``TP@``! ```!-87-T97)$971A
M:6PN8V-SQ59;;]HP%'[>I/V'R.\MFS9I5=U4HE &$^W80OM4J7(2DY@YMF<[
M7/;K=QP32& M8B_C!?OSN9_O'+B*F*4!2T/T'@6<B*PD&0W19#B9TD)Q8JE!
M@2 %8'?$6*K[U!+&46! ;[R5OQ499R9'@2IC=V BFZZ5,Z3EG"86!8/IY,4W
M0Y-2,[OV\+T4% 6EYO[:C8WDI:5.3"^H#M%H%'V"8&5"+),B1&,X\:;K+N<0
M[,\0Y;;@>&XP,0JK7,%1X6168,6Q*G"2,5RD,<[8#,]5AA-C\,HID 4!E63E
M]%8`8TT-?$LQ8QE>F)291 *L('Z\I#$3,XEC8K'E*2CK9BBWJX0JZZ-)P%*2
MJ*H6$V(,6] [F4**4UW2O0K]QQ3V(OEK!B7T8M2/K-3TCMI<`G\B"AE)4;\]
M$LU(S"&[A^KN\;',F&@_59!_=4592IVV!6H4!9F6I6J:_N(!% `ENDIQ5E-B
M0+B!DD*^`AA608EX;C,X9UD.[NF"\JV"(Q6/*IX]_!B[ZEMUV>E4<"Z-[;1-
M-,0GQ.8AZET^C02U4+VGY7*II;1/>V.SH7KOM<B6[#?1Z32G?NP8C^6JA?K)
M&#!.T?6[MV^N>K)0,#7"FNK:V;OOG%7W)E"-_@<4P,#W;\8L!G_KZ/L8!2FQ
M)":&;@$_??T#.)?+1T:7IJ:Q`Z*UD&)=[#!?(JH-@SR%;6;O)7:=\KE]Z]_T
MFFAD-7"QO82>#8$51>O]=%!&[I@5(D-@(#<<"I$[??Q\<;&?T/W!CMN:]X)#
M:'^(MDPX0J[^#1BF`ZD+`EIK^)P5Q5F:!L/AI1"7QM1FQ[L@-U5Z,=0(0NR:
M/C4L$^W*]O:JYZN%.M>."JW>0^M3ZHBS98*_5CQHK/S7?PIJX!PVDBM$44!3
M0]3IH& F=00,J"<*0FBY`&86;DF\;M]+G6X]DAIZ<,RZESK=^CU9L(S SCOF
M8"OX#_7AT/3C#=B(G6[_:S0HA:?#,1^S6O!\;DYSDL;/Q=K\XB][V#.P\5CK
M':;EF=Q@[E6U^@W@MPNWYYR ^RL#;W\`4$L#!!0````(`%=\%"UN"!W8OP$`
M`$T&```1````36%S=&5R1&5T86EL+FAT;6S%5<%.W# 0O2/Q#U-7ZHDHE*V0
M$$FD5B#:0W,`Q!5-[,ENA&-'CEFZ1?WW>N)-N^RRM%2@.H=X[)'GO>=G.YOY
M5A>[.]F,4/'?-UY3\15[3^Z$/#8Z2^-8F$S'K,JJ!513:;5UN7A;#TV IV\^
MA/M#$Z ;<[,,>7:^%N,RKNLAG==]DR3PZ?3L2PEGKE'0+M0`H;]N%Z$T)$F1
MU=9XJ%%2+CZZ!O4>7.+,MK@'5^04FM#Y3'I.OI$HH&^^A\2)*+*JN,"VT[2[
MDT"DET9^0ZDLK8HLY;6+=Z;JNV.6`BM-($GKOD/9F&DN`BF..U1JC"N4-U-G
M;XW*18BL4^1X(M !R+P;_MQ38.R=PVY%M\F'P\.CH["FY1(F%P?BN037MR 2
M/A@(1WZQ/D")+6W0#)NK_@+AZZ&Z0GW[!*S0B0JN6./<WK$3UD;9FI=LU%]S
M#[3_38E"DW)%],D_T]M_S]]#>O<,A-RU"7+_6"&VA=)I>?)LZ(_OW6;:2[&Z
MCZ=PI+3=/J\/8<YVV8)A4]C'G5+:<Y+AG/;_TRFE'4^ BV!>:N%1E*7I_N2]
M-3%"`M]ZXUW,&=MN8D[F=R ^#/R,_ 102P,$% ````@`A'P4+5/;*58R`P``
M"1(``!<```!-87-T97)$971A:6Q?<V%M<&QE+G-Q;+6776_:,!2&[Y'X#T?J
M!51J@=@.%*I=L!6M:$ 9I)5Z5=S&+9$@H&"*V*]?PD=.VNUT)Y4&0B+VZ\<?
MYQ'")["<+OO;MC\/0NAOQS][YU?K^;)8.(%7$ZV"10BB(BKUI&%J[;)5K<8#
M-L$O'?F5T-@J#J]F,IO-IA+WS+<ZZ=D%H>PO-N%LH7U8ZA=S&J>3`=>+E6V!
M(QJ56OQVDJ;O)C21MLG<7C W+6BO7T#4SN)/38"V4),M68=A/PF/310O]+C8
M%LB*D!753+J&UT.X.[:K>!<[^I6V^E&O#+1@TM<K:Z(K8W4P>UCI^7)F)DGF
M_).O8N&P*T\_S@RL;+1^LNO(P/,B`KMKF\RW_FZ^U627+1:^C3IMKP->^VNO
M`VDOE(L%@/W#0^!#$-JRXYS"X,:#P6VO!WIM%P]!^!29N0GM628=ZKF!5QT]
M37545K7,&-\\Z_7,0JF4S;_JV9HW8&JT;Z*_+B=-UO;1X:C;;X_NX4?G'N+2
M'_<1E_T4O/MAYTM_VQVW^Y?ID27:!>$+^'%]/CRO[F#<&7G0'7@WF>.Z:_=N
M.V,H.V=0VK<Y3BG]#@XLG@_+AZ3=.;W\%TD@261((C])(DEF2#(_22%)94@J
M/\E%DILAN?E)=235,Z1Z?E(#28T,J9&?=(&DBPSI(C^IB:1FAM3,3W)JZ7!!
MJ9F()A@HM%Q0;G)1J+F@Y.2BT'-!V<E%H>B"TI.+0M,%Y2<7A:H+2E N"ET7
ME*%<%,HN*$6Y*+1=4HHFDDC&KR?:+BE%N2BT75**<E%HNZ04Y:+0=DDIRD6A
M[9)2E(M"VR6E*!>%MDM*42X*;9>4HEP4VJXH19/**@8*;5>4HDR41-L5I2@7
MA;8K2E$N"FU7E*)<%-JN*$6Y*+1=48IR46B[HA3EHM!V12G*1:'M+J5H4@Z7
M@4+;74I1+@IM=RE%F2B%MKN4HEP4VNY2BG)1:+M+*<I%H>TNI2@7A;:[E*)<
M%-KN4HJFJ/]]B=W/1UUB#[W[2^S^@7N)/:3?7&+=#^ZD;R^:Z5R?N6B^V]/;
M:ARWE/Y7B@MPO3]TI_1G\=['!<8%(RXQ+AEQA7'%B+L8=W?Q8N$W4$L#!!0`
M```(`%=\%"VI+E)A6@$``#(#```7````36%S=&5R1&5T86EL7V5V96YT<RYP
M:'"-4M%.PC 4?:9)_Z$V/(R$9C(2D" #-] G7X3X8LQ26>>6=.NR=A!"^'=;
MIS(A3.]3VW/N.3?W]'::QSD$MNTE6;C8L$Q)],A4+$(TZY'^3=_Q%@,'@JC,
MUBH1&3KRK X$>PB0KG<NWBA'[707,D43+H-T%S,ZKM#39^+Z_K+2>,$>BT3!
MEK'8/HDM?D43A$_HP6^*%CV8@1=9B,Z&AJ V:J..U4%[9-N-'#1S2&\XFH_Z
MWL HV[9?2B52Y(N0Z?WTB'/GC+RY-S08(I<*@LL+^D96.:_=.)4J4(GB;&R,
MV^NRJ*Z3\V6&DKCZ$+(BR&C*B/O U#/E);,ZG\U)9-7TKB9',1U@2R?8,N;$
ME4QM:&'AFA;NULCC'V9."\DJXLI N!M1+K\81ZN:DT%T:DRS_O;$^)]>ARJ4
MIL57_Z06FVDYZ.!]+B1K_B(F_GO?&RR<:]^T03!U(?@`4$L!`A0`% ````@`
M5WP4+7Q&17!;`P``8@H``! ``````````0`@`+:!`````$UA<W1E<D1E=&%I
M;"YC8W!02P$"% `4````" !6?!0MY]+J6@\#``#3" ``$ `````````!`" `
MMH&)`P``36%S=&5R1&5T86EL+F-C<U!+`0(4`!0````(`%=\%"UN"!W8OP$`
M`$T&```1``````````$`( "V@<8&``!-87-T97)$971A:6PN:'1M;%!+`0(4
M`!0````(`(1\%"U3VRE6,@,```D2```7``````````$`( "V@;0(``!-87-T
M97)$971A:6Q?<V%M<&QE+G-Q;%!+`0(4`!0````(`%=\%"VI+E)A6@$``#(#
M```7``````````$`( "V@1L,``!-87-T97)$971A:6Q?979E;G1S+G!H<%!+
4!08`````!0`%`$4!``"J#0``````
`
end
|
|
|
|
Chip Cotton
|
| Posted: 08/21/2002, 6:14 AM |
|
Thank you for your excellent help.
You've been an inspiration to me, and I've ended up looking INSIDE the
Classes.php file.
The datasource object ds being in the *Navigator* class is a very good
example of why I DIDN'T find it (until you pointed it out).
May I ask, did you figure all of these functions out on your own, or
is there some CCS PHP reference that outlines (WITH EXAMPLES, CCS
PEOPLE) the use of these properties...?
|
|
|
|
|
