The links you see here are partly for instructional examples, but mostly for object debugging.

Warning:
mysql_connect() [function.mysql-connect]: Access denied for user 'peak10'@'localhost' (using password: YES)
/home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php, line 120 (Array)

Error:
Connect: Access denied for user 'peak10'@'localhost' (using password: YES)

There is no data to display

	Group	Col1	Col2	Col3
group1
	group1	1	2	3

	group1	4	5	6

	group1	7	8	9

group2
	group2	1	2	3

	group2	5	4	3

			21	4.8

/home/bartniedner_com/core.bartniedner.com/htdocs/examples/expandytable.php

<?
/**
 * Core Example File
 *
 * @author Mark Young
 * @version $Id: expandytable.php 153 2007-04-17 15:03:38Z mark.young $
 * @copyright MarkYoung, 19 February, 2007
 * @package examples
 **/

include("head.php");

// get the contract items
/*
$COMPANY_ID=162;
$maxdate = GrabData("select max(date_status) as maxdate 
					from proposals pro, persons p
					where pro.person_id = p.person_id and p.company_id = $COMPANY_ID 
						and pro.signature_confirmed = 'TRUE' and pro.proposal_type = 'PROPOSAL'");
$query = "select pro.proposal_id,si.title, pi.proposal_item_id, i.item, si.special_info_id,  l.abbr
			from persons p, proposals pro, proposal_items pi, location_items li, items i, item_info ii, special_info si, locations l
			where p.company_id = $COMPANY_ID and p.person_id = pro.person_id and pro.status = 'SIGNED' and pro.revision = pi.revision and pro.proposal_id = pi.proposal_id 
				and pi.location_item_id = li.location_item_id and li.item_id = i.item_id and i.item_id = ii.item_id and ii.special_info_id = si.special_info_id and pi.`change` = 'ADD'
				and pro.date_status >= '$maxdate' and li.location_id = l.location_id
			group by pi.proposal_item_id, si.special_info_id
			order by proposal_id, item, title";
$query2 = 'select  sif.title,  pii.value, concat(\'Set \',pii.occurrence) as occ
			from special_info_fields sif 
				left join proposal_item_info pii 
				on sif.special_info_field_id = pii.special_info_field_id and pii.is_active = \'TRUE\' 
					and pii.proposal_item_id = $proposal_item_id
			where sif.special_info_id = $special_info_id and sif.is_active = \'TRUE\'
			order by pii.occurrence, sif.the_order';

$d = new data($query, true, DATA_SHERPA);
$o = new outputExpandyTable($d);
 $o->PageByLetter='si.title';
 $o->Title = "Contract Overview";
 $o->Description = "Contract items newer than $maxdate";
 $o->Types['proposal_item_id']="hidden";
 $o->Types['special_info_id']="hidden";
 $o->hyperlinks['cmd']='service.php?piid=$proposal_item_id&siid=$special_info_id';
 $o->Subobject = "outputTable";  // defines the output mechanism for the hidden row.  OutputTable is the default.  Could be "outputExpandyTable" though.
 $o->Subquery = $query2; // this is the query used for the Subobject.  Note it contains variables which happen to be the "hidden" types above.
 $o->Hideable=true;
 $o->Display();
*/

///////////////////////////////////////////////////////////////////////////////////
//http://sherpa/reports/installs.php
$report = "Last Week's";
$date_start = date("Y-m-d H:i:s",mktime(0,0,0,1,date("d")-date("w")-6,date("Y")));
$date_end = date("Y-m-d H:i:s",mktime(23,59,59,1,date("d")-date("w"),date("Y")));
$date_start="2006-04-04 00:00:00";

$query = "select  abbr as market, name as customer, proposal_id, sum(mymrc) as mrr, 'x' as extra 
					from (select round(pi.mrc * ifnull(sum(bs.quantity),0),2) as mymrc, pi.proposal_id, l.abbr, c.name
						from proposal_items pi, location_items li, billing_summary bs, locations l, proposals pro, persons p, companies c
						where pi.location_item_id = li.location_item_id and pi.`change` = 'ADD' and pi.proposal_item_id = bs.proposal_item_id 
							and li.location_id = l.location_id and pi.proposal_id = pro.proposal_id and pro.person_id = p.person_id and p.company_id = c.company_id
							and bs.date_installed between cast('$date_start' as datetime)	and cast('$date_end' as datetime) and pro.signature_confirmed = 'TRUE' 
							and pro.status = 'SIGNED' $location
						group by pi.proposal_item_id) as mytotals
					group by proposal_id
					order by abbr, name limit 10";
$query2 = "select i.item, pi.mrc, bs.quantity
		from proposal_items pi, location_items li, billing_summary bs, items i
		where pi.location_item_id = li.location_item_id and pi.`change` = 'ADD' and pi.proposal_item_id = bs.proposal_item_id and li.item_id = i.item_id
			and bs.date_installed between cast('$date_start' as datetime)	and cast('$date_end' as datetime) and pi.proposal_id = \$proposal_id limit 10";
$d = new data($query, true, DATA_SHERPA);
$o = new outputExpandyTable($d);
 $o->Title = $report;
 $o->Types['proposal_id']="hidden";
 $o->Summary['mrr']="sum";
 $o->Sub['data']=$query2;
 $o->Sub['obj']="outputSingle";
 $o->Sorting=true;
 $o->Hideable=true;
 $o->Format['extra']='getmicrotime()';
 $o->Filter=true;
 $o->Display();


$data['row1']=array('group'=>'group1', 'col1'=>1,'col2'=>2,'col3'=>3);
$data['row2']=array('group'=>'group1', 'col1'=>4,'col2'=>5,'col3'=>6);
$data['row3']=array('group'=>'group1', 'col1'=>7,'col2'=>8,'col3'=>9);
$data['row4']=array('group'=>'group2', 'col1'=>1,'col2'=>2,'col3'=>3);
$data['row5']=array('group'=>'group2', 'col1'=>5,'col2'=>4,'col3'=>3);
$d = new data($data);

$o = new outputExpandyTable($d);
 $o->Class="output";
 $o->Title="from an array";
 $o->Sorting=true;
 $o->Footer="This is the footer";
 $o->Summary['col2']="sum";
 $o->Summary['col3']="avg";
 $o->GroupBy='group';
 $o->Filter=true;
 $o->Sub['obj']='outputTable';
 $o->Sub['data']=$data;
 $o->Sub['GroupBy']='group';
 $o->Display();


include("foot.php");
?>

CORE Revision 1.1.45