Fidelity Data Information

'); define('NL', '
'); $debugFlg=1; include('connDb.php'); include('dbFunc.php'); #include('getData.php?o=rick'); #$sqlCmd="SELECT fidId as 'Id', DAYNAME(fidCurDate) as 'Day',date(fidCurDate) as 'Date', fidTot as 'Total', ar091, ai163,at420,mi866,mi543,mt592,as551 from fidelity order by fidCurDate DESC limit 5;"; #echo "

sqlCmd=$sqlCmd

"; #showDataTable($sqlCmd,$pdo,'All Fields Data'); echo '

'; include('banTableNew.php');/* create html table */ ?> 'Record Id Number' , 'Total'=>'All Accounts' , 'Individual'=>'Individual 420' , 'Personal'=>'Personal: 163, 091' , 'Managed'=>'Managed: 855, 543, 592' , 'SEP'=>'SEP: 551' , 'Date'=>'Current Date' , 'at420'=>'X' , 'ai163'=>'X' , 'ar091'=>'X' , 'as551'=>'X' , 'mi866'=>'X' , 'mt592'=>'X' , 'TotManaged'=>'Total Managed' , 'TotNonManaged'=>'Total Not Managed', 'Add'=>'Add New Record', 'Delete'=>'Delete Record' ); if (isset($_GET['o']) && !empty($_GET['o'])) { #sort $orderBy = $_GET['o']; } else { $orderBy = " `fidId` "; } if (isset($_GET['s']) && !empty($_GET['s'])) { #Stored Procedure $sp = $_GET['s']; echo "SP****=$sp*****".NL; if (isset($_GET['sv']) && !empty($_GET['sv'])) { $spVal = $_GET['sv']; } if (isset($_GET['sv2']) && !empty($_GET['sv2'])) { $spVal2 = $_GET['sv2']; } else { $spVal2=""; } } else { $sp = "XXX"; } if (isset($_GET['l']) && !empty($_GET['l'])) { $limitRows = $_GET['l']; } else { $limitRows="10"; } echo ''; $colTitles = array( array('holder','holder Id Number' ), array('Id','Record Id Number' ), array('Total','All Accounts' ), array('Individual','Individual 420' ), array('Personal','Personal: 163, 091' ), array('Managed','Managed: 855, 543, 592' ), array('SEP','SEP: 551' ), array('Date','Current Date' ), array('Comments','Comments for this Date' ), array('at420','X' ), array('ai163','X' ), array('ar091','X' ), array('as551','X' ), array('mi866','X' ), array('mi543','X' ), array('mt592','X' ), array('TotManaged','X' ), array('TotNonManaged','X' ) ); $maxColTitles=sizeof($colTitles); //Create all the Titles for all Fields for ($i=1; $i< $maxColTitles; $i++) { echo ''.$colTitles[$i][0].''.PHP_EOL; } if (isset($_GET['o']) && !empty($_GET['o'])) { #sort $orderBy = $_GET['o']; } else { $orderBy = " `fidId` "; } if (isset($_GET['s']) && !empty($_GET['s'])) { #Stored Procedure $sp = $_GET['s']; if (isset($_GET['sv']) && !empty($_GET['sv'])) { $spVal = $_GET['sv']; } else { $spVal=""; } if (isset($_GET['sv2']) && !empty($_GET['sv2'])) { $spVal2 = $_GET['sv2']; } else { $spVal2=""; } } else { $sp = ""; } if (isset($_GET['l']) && !empty($_GET['l'])) { $limitRows = $_GET['l']; } else { $limitRows="10"; } echo ''; $colTitles = array( array('holder','holder Id Number' ), array('Id','Record Id Number' ), array('Total','All Accounts' ), array('Individual','Individual 420' ), array('Personal','Personal: 163, 091' ), array('Managed','Managed: 855, 543, 592' ), array('SEP','SEP: 551' ), array('Date','Current Date' ), array('Comments','Comments for this Date' ), array('at420','X' ), array('ai163','X' ), array('ar091','X' ), array('as551','X' ), array('mi866','X' ), array('mi543','X' ), array('mt592','X' ), array('TotManaged','X' ), array('TotNonManaged','X' ) ); $maxColTitles=sizeof($colTitles); for ($i=1; $i< $maxColTitles; $i++) { echo ''.$colTitles[$i][0].''.PHP_EOL; } ### 1. Create Data Container ### 2 Parse Commandline ### 3 Run Sql Command ?> 'Record Id Number' , 'Total'=>'All Accounts' , 'Individual'=>'Individual 420' , 'Personal'=>'Personal: 420, 163, 091' , 'Managed'=>'Managed: 866,543, 551,, 592' , 'SEP'=>'SEP: 551' , 'Date'=>'Current Date' , 'at420'=>'X' , 'ai163'=>'X' , 'ar091'=>'X' , 'as551'=>'X' , 'mi866'=>'X' , 'mt592'=>'X' , 'Tot NonMngd'=>'X' , 'Tot Mngd'=>'X' , 'Add'=>'X' , 'Delete'=>'X' ); #sort ASC/DESC if (isset($_GET['so']) && !empty($_GET['so'])) { $sortBy = $_GET['so']; } else { $sortBy = " DeSc"; } if (isset($_GET['o']) && !empty($_GET['o'])) { $orderBy = $_GET['o']; } else { $orderBy = " `fidId` "; } if (isset($_GET['sp']) && !empty($_GET['sp'])) { #Stored Procedure $sp = $_GET['sp']; if (isset($_GET['sv']) && !empty($_GET['sv'])) { $spVal = $_GET['sv']; } else { $spVal=""; } if (isset($_GET['sv2']) && !empty($_GET['sv2'])) { $spVal2 = $_GET['sv2']; } else { $spVal2=""; } } else { $sp = ""; } if (isset($_GET['l']) && !empty($_GET['l'])) { $limitRows = $_GET['l']; } else { $limitRows="10"; } if (isset($_GET['r']) && !empty($_GET['r'])) $report=$_GET['r']; else $report=""; #Define table View if ( !empty($sp)) { $viewTitle="$viewName=$viewName s=$s sp=$sp View Order: $orderBy $sortOrder Limit Records to: $limitRows"; } else { $viewTitle="viewName= $viewName Order by: $orderBy Sort Order: $sortOrder Limit Records to: $limitRows"; } echo "TABLE: l=$limitRows o=$orderBy sp=$sp sv=$spVal sv2=$spVal2 so=$sortBy".NL.NL; echo '

Table View: ' . $viewTitle. '

'; echo NL.NL.''; #DEBUG echo "limitRows=$limitRows format=$formatFlg"; echo ''; $colTitles = [ ['None','Place Holder ' ], ['Id','Record Id Number' ], ['Total','All Accounts' ], ['Individual','Individual 420' ], ['Personal','Personal: 420, 163, 091' ], ['GetWeek','GetWeek: 420, 163, 091' ], ['Managed','Managed: 866, 543, 592, 551' ], ['SEP','SEP: 551' ], ['Date','Current Date' ], ['Comment','Comment ' ], ['at420','X' ], ['ai163','X' ], ['ar091','X' ], ['as551','X' ], ['mi866','X' ], ['mt592','X' ], ['Tot Mng','X' ], ['Tot NonMng','X' ], ['Edit','Edit Record' ], ['Delete','Delete Record' ] ]; $maxColTitles=sizeof($colTitles); for ($i=1; $i< $maxColTitles; $i++) { echo ''; } if ($formatFlg == 9 ) { echo ''; } else if( $formatFlg == 10 ) echo ''; echo ''; #Show Min/Max each Column if ($x == "XXX") { #XXX Can't have two th with same names ` echo 'trMinMax'; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ""; } if ($formatFlg == 3 ) { echo ''; } else if ($formatFlg == 0 ) { echo ''; } echo ''; echo ""; echo ""; echo '

Current View: '. $viewName .'

'; echo '

Records Found: '. $rowCount.'

'; echo ''; // If you need to fetch them now, put it in a while loop just like below: if($rowCount>0) { for ($i=0; $i< $rowCount; $i++) { $data = $results[$i]; ?> ' . $data['fidId'] . ''; echo ''; echo ''; echo ''; echo ''; echo ''; if ($formatFlg == 0 ) { echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; } if ($formatFlg == 3 ) { ?> '; } echo " "; echo "

'.$colTitles[$i][0].'	Edit	Delete
$-123.00tdTot+20%	$-123.00tdTot+20%	$-123.00wtdIndiv+20%	$-123.00Personal+20%	$-123.00Personal+20%	$-123.00SEP+20%	Date	Max/Min Comments	$-123.00at420+20%	$-123.00ai163+20%	$-123.00ar091+20%	$-123.00as551+20%	$-123.00mi866+20%	$-123.00mi543+20%	$-123.00mt592+20%	$-123.00mi543+20%	$-123.00mt592+20%
' . money_format('%2n', $data['fidTot']) . '	' . money_format('%2n', $data['fidIndiv']) . '	' . money_format('%2n', $data['fidPer']) . '	' . money_format('%2n', $data['fidProMan']) . '	' . money_format('%2n', $data['fidSep']) . '	' . $data['fidCurDate'] . '	' . $data['fidComment']. '	' . money_format('%2n', $data['at420']). '	' . money_format('%2n', $data['ai163']) . '	' . money_format('%2n', $data['ar091']). '	' . money_format('%2n', $data['as551']). '	' . money_format('%2n', $data['mi866']). '	' . money_format('%2n', $data['mi543']) . '	' . money_format('%2n', $data['mt592']) . '	' . money_format('%2n', $data['totNonManaged']) . '	' . money_format('%2n', $data['totManaged']) . '	Edit Del
NO RECORDS FOUND

"; ?>