X-Git-Url: http://git.pippins.net/embedvideo/.git/static/gitweb.js?a=blobdiff_plain;f=inc%2Fclass.tc.inc.php;h=ac36a1e162330eccbd15466e8ee5c5e05580fa04;hb=acd44a72920b9fb87baebbe81bf1f83a24ab6ea0;hp=15086be6a9b14cde1086a9d24bff95c20cdbdcea;hpb=39346e4dae3d877b8aceec8ed6b3dadd2be42d0c;p=eq%2F.git diff --git a/inc/class.tc.inc.php b/inc/class.tc.inc.php index 15086be..ac36a1e 100644 --- a/inc/class.tc.inc.php +++ b/inc/class.tc.inc.php @@ -401,6 +401,7 @@ class tc function ht_sandbox() { $this->t->set_file(array('ht_sandbox_t' => 'ht_sandbox.tpl')); + $this->t->set_block('ht_sandbox_t','switch_case_list','sc_list'); $this->t->set_block('ht_sandbox_t','comp_list','c_list'); $this->t->set_block('ht_sandbox_t','district_list','d_list'); $this->t->set_block('ht_sandbox_t','unassigned_ht_list','uht_list'); @@ -411,7 +412,8 @@ class tc $this->t->set_block('ht_sandbox_t','companionship_table_list','ct_list'); $this->t->set_var('submit_action',$GLOBALS['phpgw']->link('/tc/index.php','menuaction=tc.tc.ht_sandbox&action=add')); - + $this->t->set_var('jquery_url',$GLOBALS['phpgw']->link('inc/jquery.js')); + $action = get_var('action',array('GET','POST')); $this->t->set_var('title','Hometeaching Sandbox'); @@ -426,7 +428,7 @@ class tc $unassigned_family_list = get_var('unassignedFamilies',array('POST')); if ($assignedHT_list || $unassignedHT_list) { - $sql = "INSERT INTO tc_companionship_sandbox (district) VALUES (\"$district\")"; + $sql = "INSERT INTO tc_companionship_sandbox (tc_companionship,district) VALUES (\"NULL\",\"$district\")"; $this->db2->query($sql,__LINE__,__FILE__); $companionship_sandbox = mysql_insert_id(); @@ -540,11 +542,11 @@ class tc while ($this->db->next_record()) { $companionship = $this->db->f('companionship'); $district = $this->db->f('district'); - $sql = "INSERT INTO tc_companionship_sandbox (district) VALUES (\"$district\")"; + $sql = "INSERT INTO tc_companionship_sandbox (tc_companionship,district) VALUES (\"$companionship\",\"$district\")"; $this->db2->query($sql,__LINE__,__FILE__); $companionship_sandbox = mysql_insert_id(); - $sql = "SELECT * FROM tc_companion WHERE companionship=$companionship AND valid=1"; + $sql = "SELECT * FROM tc_companion AS tc JOIN tc_individual AS ti WHERE tc.individual=ti.individual AND tc.companionship=$companionship AND tc.valid=1 AND ti.valid=1"; $this->db2->query($sql,__LINE__,__FILE__); while ($this->db2->next_record()) { $individual = $this->db2->f('individual'); @@ -651,8 +653,16 @@ class tc $sql = "SELECT DISTINCT companionship FROM tc_companionship_sandbox WHERE district=$districts[$d] ORDER BY companionship ASC"; $this->db->query($sql,__LINE__,__FILE__); while ($this->db->next_record()) { + $switch_case_list = ""; $sandbox_table_data .= ""; $companionship = $this->db->f('companionship'); + + $switch_case_list .= "case '". $companionship ."':\n"; + $switch_case_list .= " $(\"#district option:selected\").removeAttr(\"selected\");\n"; + $switch_case_list .= " $(\"#assignedHT option:selected\").removeAttr(\"selected\");\n"; + $switch_case_list .= " $(\"#assignedFamilies option:selected\").removeAttr(\"selected\");\n"; + $switch_case_list .= " $(\"#district option[value='".$districts[$d]."']\").attr(\"selected\",true);\n"; + # get names of companions in this companionship $sql = "SELECT * FROM tc_companion_sandbox AS tc JOIN tc_individual AS ti WHERE tc.individual=ti.individual AND companionship=$companionship ORDER BY ti.name ASC"; $this->db2->query($sql,__LINE__,__FILE__); @@ -663,9 +673,13 @@ class tc } else { $companion_names .= " / " . $this->db2->f('name'); } + $individual = $this->db2->f('individual'); + $switch_case_list .= " $(\"#assignedHT option[value='".$individual."']\").attr(\"selected\",true);\n"; } - $sandbox_table_data .= ""; - $sandbox_table_data .= ""; + $switch_case_list .= "break;\n"; + $this->t->set_var('switch_case_list',$switch_case_list); + $this->t->fp('sc_list','switch_case_list',True); } - $sandbox_table_data .= "
$companion_names
"; + $this->nextmatchs->template_alternate_row_color(&$this->t); + $sandbox_table_data .= ""; + $sandbox_table_data .= ""; + $sandbox_table_data .= ""; $sandbox_table_data .= "
$companion_names
"; # get families they visit $sql = "SELECT * FROM tc_companionship_sandbox AS tcp JOIN (tc_family_sandbox AS tf, tc_individual AS ti) WHERE tcp.companionship=$companionship AND tcp.companionship=tf.companionship AND tf.individual=ti.individual"; @@ -673,11 +687,15 @@ class tc while ($this->db2->next_record()) { $family_name = $this->db2->f('name') . " Family"; $family_id = $this->db2->f('tc_family'); - $sandbox_table_data .= ""; - $sandbox_table_data .= ""; - + $family = $this->db2->f('family'); + $tc_companionship = $this->db2->f('tc_companionship'); + $this->nextmatchs->template_alternate_row_color(&$this->t); + $sandbox_table_data .= ""; + $sandbox_table_data .= ""; + $switch_case_list .= " $(\"#assignedFamilies option[value='".$family."']\").attr(\"selected\",true);\n"; + # get 12 months visit data for given family - for($m=12; $m >= 0; $m--) { + for($m=$this->sandbox_stats_num_months; $m > 0; $m--) { $month = $this->current_month - $m; $year = $this->current_year; if($month <= 0) { $remainder = $month; $month = 12 + $remainder; $year=$year-1; } @@ -686,7 +704,11 @@ class tc $month_end = "$year"."-"."$month"."-"."31"; $month = "$month"."/"."$year"; - $sql = "SELECT * FROM tc_visit WHERE date >= '$month_start' AND date <= '$month_end' AND companionship!=0 AND family=". $family_id; + if ($this->sandbox_visits_comp_only == 0) { + $sql = "SELECT * FROM tc_visit WHERE date >= '$month_start' AND date <= '$month_end' AND companionship!=0 AND family=". $family_id; + } else { + $sql = "SELECT * FROM tc_visit WHERE date >= '$month_start' AND date <= '$month_end' AND companionship=$tc_companionship AND family=". $family_id; + } $query_id = $this->db3->query($sql,__LINE__,__FILE__); if($this->db3->next_record()) { @@ -705,8 +727,10 @@ class tc } $sandbox_table_data .= "
$family_name
$family_name
"; $sandbox_table_data .= ""; }