arrays - PHP: help with this logic -

-

i have problem. have table of support tickets (wh_task). each task has date_completed (d/m/y) , has_met_sla field (0 or -1). want allow user search table date_completed , display chart based on results.

the charts data has can populate barchart (fusion charts):

year: 2010 | month: nov | sla met: 12 | sla missed: 2

year: 2010 | month: oct | sla met: 15 | sla missed: 1

the chart have numbers x-axis , "nov 2010" along y. each month along y has 2 columns, met , not met.

so, can create kind of chart no problem it's generating data i'm having trouble coming with. below query:

        $tsql = "select task_id, has_met_service_level_agreement, date_completed ".                 "from wh_task ".                 "where (task_status_id = 5) , (account_id =$atid)";          $stmt = sqlsrv_query( $conn, $tsql);         if( $stmt === false)         {                  echo "error in query preparation/execution.\n";                  die( print_r( sqlsrv_errors(), true));         }           //sla counters         $met = 0;         $missed = 0;            /* retrieve each row associative array , display results.*/         while( $row = sqlsrv_fetch_array( $stmt, sqlsrv_fetch_assoc))         {             $date = $row['date_completed'];             $monthnumber = date_format($date, "n");             $year = date_format($date, "y");             $hasmetsla = $row['has_met_service_level_agreement'];          }       }

can give me hand logic here? i'm guessing need store data in array containing month, year, met total, , not met total. each task check if year month combination exist in array , if ammend totals based on $hasmetsla , if not add array??

thanks all!

jonesy

here's if had in php (using sql better option, here's 1 method of doing post-facto):

first, i'd setup multi-dimensional array following structure:

array(     'year1' => array(         'month1' => array(             'met' => 0,             'missed' => 0,         ),     ), ),

then, i'd change while loop this:

$yearinfo = array(); while( $row = sqlsrv_fetch_array( $stmt, sqlsrv_fetch_assoc)) {     $date = $row['date_completed'];     $monthnumber = date_format($date, "n");     $year = date_format($date, "y");     $hasmetsla = $row['has_met_service_level_agreement'];     if (!isset($yearinfo[$year])) {         $yearinfo[$year] = array(             $monthnumber => array(                 'met' => 0,                  'missed' => 0             )         );     } elseif (!isset($yearinfo[$year][$monthnumber])) {         $yearinfo[$year][$monthnumber] = array(             'met' => 0,             'missed' => 0,         );     }     $key = $hasmetsla ? 'met' : 'missed';     $yearinfo[$year][$monthnumber][$key]++; }

then, when display:

$data = ''; foreach ($yearinfo $year => $months) {     foreach ($months $month => $status) {         $data .= 'year: '.$year.' | '.               'month: '.$month.' | '.               'sla met: '.$status['met'].' | '.               'sla missed: '.$status['missed']."\n";     } }

Comments

Post a Comment

Popular posts from this blog

android - Spacing between the stars of a rating bar? -

-
ho can set spacing beween stars? thats ratingbar: ratingbar = (ratingbar) inflater.inflate(r.layout.ratingbar, null); ratingbar.setlayoutparams(new layoutparams(layoutparams.wrap_content, layoutparams.wrap_content)); the layout: <?xml version="1.0" encoding="utf-8"?> <ratingbar xmlns:android="http://schemas.android.com/apk/res/android" style="@style/mystyle" android:layout_alignparentright="true" android:layout_height="19dp" android:layout_width="wrap_content" android:numstars="5"> </ratingbar> the style: <style name="mystyle" parent="@android:style/widget.ratingbar"> <item name="android:progressdrawable">@drawable/android_r2_ratingstar_yellow</item> <item name="android:indeterminatedrawable">@drawable/android_r2_ratingstar_grey</item> </style> thanks, cheers you have ...
Read more

html - Instapaper-like algorithm -

-
does of algorithm extracts contents webpage? instapaper ? there 2 steps instapaper does: find main content block on page (excluding headers, footers, menus etc) from content block extract , format text to find content block (typically html block element, div containing key page text content) instapaper uses algorithm 1 used readability . can @ source of readability.js see what's going on, @ core tries find area on page highest text/link ratio, although has other simple scoring metrics (e.g. off top of head, things ratio of text commas, para elements etc) go heuristics. once have identified root node element, relevant content, you'll need format it, if want can pull node element containing text out of source document , insert yours, in reality you'll want remove existing styles , apply own, standard , feel. if want output nice text-only can use jericho's renderer . update1 : should mention else instapaper - follow 'pagination' links (...
Read more

c# - How to execute a particular part of code asynchronously in a class -

-
i creating speech recognition engine that's going respond user commands.i have created button enable , disable speech recognition per user convenience.i have used dispose() of speech engine disable speech recoginition.here code private void button1_click(object sender, routedeventargs e) { engineon = !engineon; if (engineon) { speechengine = speech.createspeechengine(); //speech class creates , returns new speech engine. speechengine.audiolevelupdated += new eventhandler<audiolevelupdatedeventargs>(speechengine_audiolevelupdated); // use system's default microphone speechengine.setinputtodefaultaudiodevice(); speechengine.loadgrammar(new dictationgrammar()); // start listening speechengine.recognizeasync(recognizemode.multiple); } else { speechclass.myengine.dispose(); } } but disposal of speech obj...
Read more