sruder Report post Posted January 26, 2010 Using AppGini to develop an online resource for tracking information, similar to this link. It shows a chart with the data and basically I would like generate a graph below to reflect the data! Does anybody have an easy way to use the Record_ID_Week to build a graph based on any of the other aspects? Pay, Labor, etc... understand the concept in my head just can't seem to get it started yet. Here is the PHP code: <?php // Data functions for table WeeklyData // This script and data application were generated by AppGini 4.46 // Download AppGini for free from http://www.bigprof.com/appgini/download/ function WeeklyData_insert(){ global $Translation; if($_GET['insert_x']){$_POST=$_GET;} // mm: can member insert record? $arrPerm=getTablePermissions('WeeklyData'); if(!$arrPerm[1]){ return 0; } $WeekEndDate = makeSafe($_POST['WeekEndDateYear']) . '-' . makeSafe($_POST['WeekEndDateMonth']) . '-' . makeSafe($_POST['WeekEndDateDay']); $WeekEndDate = parseMySQLDate($WeekEndDate, ''); $CP_RO_Count = makeSafe($_POST["CP_RO_Count"]); $CP_HRs = makeSafe($_POST["CP_HRs"]); $CustomerPay = makeSafe($_POST["CustomerPay"]); $Total_CP_Labor = makeSafe($_POST["Total_CP_Labor"]); $Total_CP_Parts = makeSafe($_POST["Total_CP_Parts"]); $Notes = makeSafe($_POST["Notes"]); if($WeekEndDate== ''){ echo StyleSheet() . "" . $Translation['error:'] . " 'Week End Date': " . $Translation['field not null'] . ' '; echo ''.$Translation['< back'].''; exit; } if($CP_RO_Count== ''){ echo StyleSheet() . "" . $Translation['error:'] . " 'CP RO Count': " . $Translation['field not null'] . ' '; echo ''.$Translation['< back'].''; exit; } if($CP_HRs== ''){ echo StyleSheet() . "" . $Translation['error:'] . " 'CP HRs': " . $Translation['field not null'] . ' '; echo ''.$Translation['< back'].''; exit; } if($CustomerPay== ''){ echo StyleSheet() . "" . $Translation['error:'] . " 'Customer Pay': " . $Translation['field not null'] . ' '; echo ''.$Translation['< back'].''; exit; } if($Total_CP_Labor== ''){ echo StyleSheet() . "" . $Translation['error:'] . " 'Total CP Labor': " . $Translation['field not null'] . ' '; echo ''.$Translation['< back'].''; exit; } if($Total_CP_Parts== ''){ echo StyleSheet() . "" . $Translation['error:'] . " 'Total CP Parts': " . $Translation['field not null'] . ' '; echo ''.$Translation['< back'].''; exit; } sql("insert into `WeeklyData` set " . "`WeekEndDate`=" . (($WeekEndDate != '') ? "'$WeekEndDate'" : "NULL") . ", " . "`CP_RO_Count`=" . (($CP_RO_Count != '') ? "'$CP_RO_Count'" : "NULL") . ", " . "`CP_HRs`=" . (($CP_HRs != '') ? "'$CP_HRs'" : "NULL") . ", " . "`CustomerPay`=" . (($CustomerPay != '') ? "'$CustomerPay'" : "NULL") . ", " . "`Total_CP_Labor`=" . (($Total_CP_Labor != '') ? "'$Total_CP_Labor'" : "NULL") . ", " . "`Total_CP_Parts`=" . (($Total_CP_Parts != '') ? "'$Total_CP_Parts'" : "NULL") . ", " . "`Notes`=" . (($Notes != '') ? "'$Notes'" : "NULL") . ""); // mm: save ownership data $recID=mysql_insert_id(); sql("insert into membership_userrecords set tableName='WeeklyData', pkValue='$recID', memberID='".getLoggedMemberID()."', dateAdded='".time()."', dateUpdated='".time()."', groupID='".getLoggedGroupID()."'"); return (get_magic_quotes_gpc() ? stripslashes($recID) : $recID); } function WeeklyData_delete($selected_id, $AllowDeleteOfParents=false, $SkipChecks=false){ // insure referential integrity ... global $Translation; // mm: can member delete record? $arrPerm=getTablePermissions('WeeklyData'); $ownerGroupID=sqlValue("select groupID from membership_userrecords where tableName='WeeklyData' and pkValue='".makeSafe($selected_id)."'"); $ownerMemberID=sqlValue("select lcase(memberID) from membership_userrecords where tableName='WeeklyData' and pkValue='".makeSafe($selected_id)."'"); if(($arrPerm[4]==1 && $ownerMemberID==getLoggedMemberID()) || ($arrPerm[4]==2 && $ownerGroupID==getLoggedGroupID()) || $arrPerm[4]==3){ // allow delete? // delete allowed, so continue ... }else{ return FALSE; } sql("delete from `WeeklyData` where `Record_ID_Week`='".makeSafe($selected_id)."'"); // mm: delete ownership data sql("delete from membership_userrecords where tableName='WeeklyData' and pkValue='".makeSafe($selected_id)."'"); } function WeeklyData_update($selected_id){ global $Translation; if($_GET['update_x']){$_POST=$_GET;} // mm: can member edit record? $arrPerm=getTablePermissions('WeeklyData'); $ownerGroupID=sqlValue("select groupID from membership_userrecords where tableName='WeeklyData' and pkValue='".makeSafe($selected_id)."'"); $ownerMemberID=sqlValue("select lcase(memberID) from membership_userrecords where tableName='WeeklyData' and pkValue='".makeSafe($selected_id)."'"); if(($arrPerm[3]==1 && $ownerMemberID==getLoggedMemberID()) || ($arrPerm[3]==2 && $ownerGroupID==getLoggedGroupID()) || $arrPerm[3]==3){ // allow update? // update allowed, so continue ... }else{ return; } $WeekEndDate = makeSafe($_POST['WeekEndDateYear']) . '-' . makeSafe($_POST['WeekEndDateMonth']) . '-' . makeSafe($_POST['WeekEndDateDay']); $WeekEndDate = parseMySQLDate($WeekEndDate, ''); if($WeekEndDate== ''){ echo StyleSheet() . "" . $Translation['error:'] . " 'Week End Date': " . $Translation['field not null'] . ' '; echo ''.$Translation['< back'].''; exit; } $CP_RO_Count = makeSafe($_POST["CP_RO_Count"]); if($CP_RO_Count== ''){ echo StyleSheet() . "" . $Translation['error:'] . " 'CP RO Count': " . $Translation['field not null'] . ' '; echo ''.$Translation['< back'].''; exit; } $CP_HRs = makeSafe($_POST["CP_HRs"]); if($CP_HRs== ''){ echo StyleSheet() . "" . $Translation['error:'] . " 'CP HRs': " . $Translation['field not null'] . ' '; echo ''.$Translation['< back'].''; exit; } $CustomerPay = makeSafe($_POST["CustomerPay"]); if($CustomerPay== ''){ echo StyleSheet() . "" . $Translation['error:'] . " 'Customer Pay': " . $Translation['field not null'] . ' '; echo ''.$Translation['< back'].''; exit; } $Total_CP_Labor = makeSafe($_POST["Total_CP_Labor"]); if($Total_CP_Labor== ''){ echo StyleSheet() . "" . $Translation['error:'] . " 'Total CP Labor': " . $Translation['field not null'] . ' '; echo ''.$Translation['< back'].''; exit; } $Total_CP_Parts = makeSafe($_POST["Total_CP_Parts"]); if($Total_CP_Parts== ''){ echo StyleSheet() . "" . $Translation['error:'] . " 'Total CP Parts': " . $Translation['field not null'] . ' '; echo ''.$Translation['< back'].''; exit; } $Notes = makeSafe($_POST["Notes"]); sql("update `WeeklyData` set " . "`WeekEndDate`=" . (($WeekEndDate != '') ? "'$WeekEndDate'" : "NULL") . ", " . "`CP_RO_Count`=" . (($CP_RO_Count != '') ? "'$CP_RO_Count'" : "NULL") . ", " . "`CP_HRs`=" . (($CP_HRs != '') ? "'$CP_HRs'" : "NULL") . ", " . "`CustomerPay`=" . (($CustomerPay != '') ? "'$CustomerPay'" : "NULL") . ", " . "`Total_CP_Labor`=" . (($Total_CP_Labor != '') ? "'$Total_CP_Labor'" : "NULL") . ", " . "`Total_CP_Parts`=" . (($Total_CP_Parts != '') ? "'$Total_CP_Parts'" : "NULL") . ", " . "`Notes`=" . (($Notes != '') ? "'$Notes'" : "NULL") . " where `Record_ID_Week`='".makeSafe($selected_id)."'"); // mm: update ownership data sql("update membership_userrecords set dateUpdated='".time()."' where tableName='WeeklyData' and pkValue='".makeSafe($selected_id)."'"); } function WeeklyData_form($selected_id = "", $AllowUpdate = 1, $AllowInsert = 1, $AllowDelete = 1, $ShowCancel = 0){ // function to return an editable form for a table records // and fill it with data of record whose ID is $selected_id. If $selected_id // is empty, an empty form is shown, with only an 'Add New' // button displayed. global $Translation; // mm: get table permissions $arrPerm=getTablePermissions('WeeklyData'); if(!$arrPerm[1] && $selected_id==""){ return ""; } // combobox: WeekEndDate $combo_WeekEndDate = new DateCombo; $combo_WeekEndDate->DateFormat = "mdy"; $combo_WeekEndDate->MinYear = 1900; $combo_WeekEndDate->MaxYear = 2100; $combo_WeekEndDate->DefaultDate = date('Y-m-d', strtotime('last saturday')); $combo_WeekEndDate->MonthNames = $Translation['month names']; $combo_WeekEndDate->CSSOptionClass = 'Option'; $combo_WeekEndDate->CSSSelectedClass = 'SelectedOption'; $combo_WeekEndDate->NamePrefix = 'WeekEndDate'; $WeekEndDateToday=" [".$Translation['today']."]"; if($selected_id){ // mm: check member permissions if(!$arrPerm[2]){ return ""; } // mm: who is the owner? $ownerGroupID=sqlValue("select groupID from membership_userrecords where tableName='WeeklyData' and pkValue='".makeSafe($selected_id)."'"); $ownerMemberID=sqlValue("select lcase(memberID) from membership_userrecords where tableName='WeeklyData' and pkValue='".makeSafe($selected_id)."'"); if($arrPerm[2]==1 && getLoggedMemberID()!=$ownerMemberID){ return ""; } if($arrPerm[2]==2 && getLoggedGroupID()!=$ownerGroupID){ return ""; } // can edit? if(($arrPerm[3]==1 && $ownerMemberID==getLoggedMemberID()) || ($arrPerm[3]==2 && $ownerGroupID==getLoggedGroupID()) || $arrPerm[3]==3){ $AllowUpdate=1; }else{ $AllowUpdate=0; } $res = sql("select * from `WeeklyData` where `Record_ID_Week`='".makeSafe($selected_id)."'"); $row = mysql_fetch_array($res); $combo_WeekEndDate->DefaultDate = $row["WeekEndDate"]; }else{ } // code for template based detail view forms // open the detail view template if(($_POST['dvprint_x'] || $_GET['dvprint_x']) && $selected_id){ $templateCode=@implode('', @file('./templates/WeeklyData_templateDVP.html')); $dvprint=true; }else{ $templateCode=@implode('', @file('./templates/WeeklyData_templateDV.html')); $dvprint=false; } // process form title $templateCode=str_replace('<%%DETAIL_VIEW_TITLE%%>', 'Detail View', $templateCode); // process buttons if($arrPerm[1]){ // allow insert? $templateCode=str_replace('<%%INSERT_BUTTON%%>', '', $templateCode); }else{ $templateCode=str_replace('<%%INSERT_BUTTON%%>', '', $templateCode); } if($selected_id){ $templateCode=str_replace('<%%DVPRINT_BUTTON%%>', '', $templateCode); if($AllowUpdate){ $templateCode=str_replace('<%%UPDATE_BUTTON%%>', '', $templateCode); }else{ $templateCode=str_replace('<%%UPDATE_BUTTON%%>', '', $templateCode); // set records to read only if user can't insert new records if(!$arrPerm[1]){ $jsReadOnly.="tif(document.getElementsByName('Record_ID_Week').length){ document.getElementsByName('Record_ID_Week')[0].readOnly=true; }"; $jsReadOnly.="tif(document.getElementsByName('WeekEndDate').length){ document.getElementsByName('WeekEndDate')[0].readOnly=true; }"; $jsReadOnly.="tif(document.getElementsByName('WeekEndDateDay').length){ var WeekEndDateDay=document.getElementsByName('WeekEndDateDay')[0]; WeekEndDateDay.disabled=true; WeekEndDateDay.style.backgroundColor='white'; WeekEndDateDay.style.color='black'; }"; $jsReadOnly.="tif(document.getElementsByName('WeekEndDateMonth').length){ var WeekEndDateMonth=document.getElementsByName('WeekEndDateMonth')[0]; WeekEndDateMonth.disabled=true; WeekEndDateMonth.style.backgroundColor='white'; WeekEndDateMonth.style.color='black'; }"; $jsReadOnly.="tif(document.getElementsByName('WeekEndDateYear').length){ var WeekEndDateYear=document.getElementsByName('WeekEndDateYear')[0]; WeekEndDateYear.disabled=true; WeekEndDateYear.style.backgroundColor='white'; WeekEndDateYear.style.color='black'; }"; $jsReadOnly.="tif(document.getElementsByName('CP_RO_Count').length){ document.getElementsByName('CP_RO_Count')[0].readOnly=true; }"; $jsReadOnly.="tif(document.getElementsByName('CP_HRs').length){ document.getElementsByName('CP_HRs')[0].readOnly=true; }"; $jsReadOnly.="tif(document.getElementsByName('CustomerPay').length){ document.getElementsByName('CustomerPay')[0].readOnly=true; }"; $jsReadOnly.="tif(document.getElementsByName('Total_CP_Labor').length){ document.getElementsByName('Total_CP_Labor')[0].readOnly=true; }"; $jsReadOnly.="tif(document.getElementsByName('Total_CP_Parts').length){ document.getElementsByName('Total_CP_Parts')[0].readOnly=true; }"; $jsReadOnly.="tif(document.getElementsByName('Notes').length){ document.getElementsByName('Notes')[0].readOnly=true; }"; $noUploads=true; } } if(($arrPerm[4]==1 && $ownerMemberID==getLoggedMemberID()) || ($arrPerm[4]==2 && $ownerGroupID==getLoggedGroupID()) || $arrPerm[4]==3){ // allow delete? $templateCode=str_replace('<%%DELETE_BUTTON%%>', " "');">", $templateCode); }else{ $templateCode=str_replace('<%%DELETE_BUTTON%%>', '', $templateCode); } $templateCode=str_replace('<%%DESELECT_BUTTON%%>', "", $templateCode); }else{ $templateCode=str_replace('<%%UPDATE_BUTTON%%>', '', $templateCode); $templateCode=str_replace('<%%DELETE_BUTTON%%>', '', $templateCode); $templateCode=str_replace('<%%DESELECT_BUTTON%%>', ($ShowCancel ? "" : ''), $templateCode); } // process combos $templateCode=str_replace('<%%COMBO(WeekEndDate)%%>', $combo_WeekEndDate->GetHTML().($noUploads ? '' : $WeekEndDateToday), $templateCode); $templateCode=str_replace('<%%COMBOTEXT(WeekEndDate)%%>', $combo_WeekEndDate->GetHTML(true), $templateCode); // process foreign key links if($selected_id){ } // process images $templateCode=str_replace('<%%UPLOADFILE(Record_ID_Week)%%>', '', $templateCode); $templateCode=str_replace('<%%UPLOADFILE(WeekEndDate)%%>', '', $templateCode); $templateCode=str_replace('<%%UPLOADFILE(CP_RO_Count)%%>', '', $templateCode); $templateCode=str_replace('<%%UPLOADFILE(CP_HRs)%%>', '', $templateCode); $templateCode=str_replace('<%%UPLOADFILE(CustomerPay)%%>', '', $templateCode); $templateCode=str_replace('<%%UPLOADFILE(Total_CP_Labor)%%>', '', $templateCode); $templateCode=str_replace('<%%UPLOADFILE(Total_CP_Parts)%%>', '', $templateCode); $templateCode=str_replace('<%%UPLOADFILE(Notes)%%>', '', $templateCode); // process values if($selected_id){ $templateCode=str_replace('<%%VALUE(Record_ID_Week)%%>', htmlspecialchars($row['Record_ID_Week'], ENT_QUOTES), $templateCode); $templateCode=str_replace('<%%VALUE(WeekEndDate)%%>', date('n/j/Y', strtotime(htmlspecialchars($row['WeekEndDate'], ENT_QUOTES))), $templateCode); $templateCode=str_replace('<%%VALUE(CP_RO_Count)%%>', htmlspecialchars($row['CP_RO_Count'], ENT_QUOTES), $templateCode); $templateCode=str_replace('<%%VALUE(CP_HRs)%%>', htmlspecialchars($row['CP_HRs'], ENT_QUOTES), $templateCode); $templateCode=str_replace('<%%VALUE(CustomerPay)%%>', htmlspecialchars($row['CustomerPay'], ENT_QUOTES), $templateCode); $templateCode=str_replace('<%%VALUE(Total_CP_Labor)%%>', htmlspecialchars($row['Total_CP_Labor'], ENT_QUOTES), $templateCode); $templateCode=str_replace('<%%VALUE(Total_CP_Parts)%%>', htmlspecialchars($row['Total_CP_Parts'], ENT_QUOTES), $templateCode); $templateCode=str_replace('<%%VALUE(Notes)%%>', htmlspecialchars($row['Notes'], ENT_QUOTES), $templateCode); }else{ $templateCode=str_replace('<%%VALUE(Record_ID_Week)%%>', '', $templateCode); $templateCode=str_replace('<%%VALUE(WeekEndDate)%%>', '', $templateCode); $templateCode=str_replace('<%%VALUE(CP_RO_Count)%%>', '', $templateCode); $templateCode=str_replace('<%%VALUE(CP_HRs)%%>', '', $templateCode); $templateCode=str_replace('<%%VALUE(CustomerPay)%%>', '', $templateCode); $templateCode=str_replace('<%%VALUE(Total_CP_Labor)%%>', '', $templateCode); $templateCode=str_replace('<%%VALUE(Total_CP_Parts)%%>', '', $templateCode); $templateCode=str_replace('<%%VALUE(Notes)%%>', '', $templateCode); } // process translations foreach($Translation as $symbol=>$trans){ $templateCode=str_replace("<%%TRANSLATION($symbol)%%>", $trans, $templateCode); } // clear scrap $templateCode=str_replace('<%%', '', $templateCode); // hide links to inaccessible tables $templateCode.=""; // ajaxed auto-fill fields $templateCode.=""; $templateCode.=""; // handle enforced parent values for read-only lookup fields return $templateCode; } ?> Share this post Link to post Share on other sites
