<?php 

	function fossee_stats_permission() {
		return array(
			"access fossee_stats" => array(
			"title" => t("Access fossee_stats"),
			"description" => t("Allows users to view job postings.")
			),
			"manage fossee_stats" => array(
			"title" => t("Manage fossee_stats"),
			"description" => t("Allows users to manage job postings.")
			),
		);
	}

	function fossee_stats_menu() {
		$items = array();
		$items["fossee-stats"] = array(
			"title" => "FOSSEE STATS",
			"page callback" => "drupal_get_form",
			"page arguments" => array("fossee_stats_form"),
			"access arguments" => array("access fossee_stats"),
			"type" => MENU_NORMAL_ITEM,
		);
		$items["fossee-stats-all"] = array(
			"title" => "FOSSEE STATS",
			"page callback" => "fossee_stats_all",			
			"access arguments" => array("access fossee_stats"),
			"type" => MENU_NORMAL_ITEM,
		);
		 $items["example-charts"] = array(
    			"title" => "Example",
    			"page callback" => "example_page",
    			"access arguments" => array("access content"),
    			"type" => MENU_NORMAL_ITEM,
 		 );
		$items["jobs/ajax"] = array(
			"title" => "Ajax callbacks",
			"page callback" => "fossee_stats_ajax",
			"access arguments" => array("access fossee_stats"),
			"type" => MENU_CALLBACK
		);
		return $items;
	}
		
	function fossee_stats_all(){
		$page = "";	
		$fossee_stats = drupal_get_form('fossee_stats_form');
		$page .= drupal_render($fossee_stats);
		$page .= "<div id ='fossee-stats-all'>";	
		$page .= "</div>";
		return $page;
	}
		
	function fossee_stats_form($form, &$form_state) {

	        $options_first = _ajax_example_get_first_dropdown_options();

		if(isset($form_state['values']['foss_sub_project'])&&isset($form_state['values']['foss_type'])&&isset($form_state['values']['foss_sub_project_status'])){
		 	$foss_project = isset($form_state['values']['foss_type']) ? $form_state['values']['foss_type'] : key	($options_first);
		}else{
			$foss_project = '';
		}
		
		$form['foss_type'] = array(
	
			'#type' => 'select',
			'#prefix' => '<div><table><tr><td>',
          		'#suffix' => '</td>',
			'#title' => t('FOSS Type'),
			'#options' => $options_first,
			'#default_value' => $foss_project,
			//'#attributes' => array('id' => 'ffoss_type'),
          		'#ajax' => array(
            		 	'callback' =>'ajax_example_dependent_dropdown_callback',
            			'wrapper' => 'dropdown-second-replace',
				'progress' => array(
                			'message' => '',
           			 ),
          		),
        	);


         	if(isset($form_state['values']['foss_sub_project'])&&isset($form_state['values']['foss_type'])&&isset($form_state['values']['foss_sub_project_status'])){
            		$foss_sub_project = isset($form_state['values']['foss_sub_project']) ? $form_state['values']['foss_sub_project'] : key(_ajax_example_get_second_dropdown_options($foss_project));
         	}else{
            		$foss_sub_project = '';
          	}

      		$form['foss_sub_project'] = array(
          		'#type' => 'select',
          		'#title' => t('Foss Sub Project'),
          		'#options' => _ajax_example_get_second_dropdown_options($foss_project),
          		'#prefix' => '<td><div id="dropdown-second-replace" style="width:300px">',
          		'#suffix' => '</div></td></tr>',
          		'#default_value' => '',
			//'#attributes' => array('id' => 'foss_sub_project'),
          		'#ajax' => array(
            			'callback' =>'ajax_example_dependent_dropdown_callback1',
            			'wrapper' => 'dropdown-third-replace',
				'progress' => array(
                			'message' => '',
           			 ), 
         		 ),
        	);


         if(isset($form_state['values']['foss_sub_project'])&&isset($form_state['values']['foss_type'])&&isset($form_state['values']['foss_sub_project_status'])){
         		$foss_sub_project_status = isset($form_state['values']['$foss_sub_project_status']) ? $form_state['values']['$foss_sub_project_status'] : '';
        	}else{
       	 		$foss_sub_project_status = '';
        	}
        
       		$form['foss_sub_project_status'] = array(
          		'#type' => 'select',
          		'#title' => t('Status'),
			//'#attributes' => array('id' => 'foss_sub_project_status'),
          		'#options' => _ajax_example_get_third_dropdown_options($foss_sub_project),
          		'#prefix' => '<tr><td><div id="dropdown-third-replace" style="width:300px">',
          		'#suffix' => '</div></td>',
          		'#default_value' => $foss_sub_project_status,
        	);
         
 	if(isset($form_state['values']['foss_sub_project'])&&isset($form_state['values']['foss_type'])&&isset($form_state['values']['foss_sub_project_status'])){
         		$foss_select_branch = isset($form_state['values']['foss_select_branch']) ? $form_state['values']['foss_select_branch'] : '';
        	}else{
        		$foss_select_branch = '';
        	}
        
        	$form['foss_select_branch'] = array(
          		'#type' => 'select',
          		'#title' => t('Branch'),
			//'#attributes' => array('id' => 'foss_select_branch'),
          		'#options' => _ajax_get_branch_options($foss_project,$foss_sub_project),
          		'#prefix' => '<td><div id="dropdown-fourth-replace" style="width:300px">',
          		'#suffix' => '</div></td></tr>',	
          		'#default_value' => $foss_select_branch,
        	);

       		$form['start_date'] = array(
        		'#type' => 'date_popup',
 			'#title' => t('Start Date:'),
			'#date_label_position' => '',
			//'#attributes' => array('id' => 'start_date'),
        		'#description' => '',
        		'#default_value' => '',
        		'#date_type' => DATE_DATETIME,
        		'#date_format' => 'd/m/Y',
        		'#date_increment' => 1,
        		'#date_year_range' => '-3:+3',
			'#prefix' => '<tr><td>',
          		'#suffix' => '</td>',
      		);

      		$form['end_date'] = array(
        		'#type' => 'date_popup',
			'#title' => t('End Date:'),
			'#date_label_position' => '',
			//'#attributes' => array('id' => 'end_date'),
        		'#description' => '',
        		'#default_value' =>'',
        		'#date_type' => DATE_DATETIME,
        		'#date_format' => 'd/m/Y',
        		'#date_increment' => 1,
       		 	'#date_year_range' => '-3:+3',
			'#prefix' => '<td>',
          		'#suffix' => '</td><tr></table></div>',
     		 );
        
        	$form['submit'] = array(
          		'#type' => 'submit',
			 	'#ajax' => array(
					'callback' => 'ajax_example_submit_driven_callback',
					'progress' => array(
                			'message' => '',
           			 	), 
				 ),
			 '#value' => t('Filter'),
			 '#attributes' => array('style' => 'margin-left:40px;margin-right:20px'),
        	);

         	$form['reset'] = array(
          		'#type' => 'submit',
          		'#value' => t('Reset'),
       		 );

		$form['displaytext'] = array(
			'#type' => 'markup',
			'#prefix' => '<table><tr><td><div id="displaytext" style="font-weight:bold;padding-top:20px">',
			'#suffix' => '</div></td></tr>',
			'#markup' => '',
		);
		$form['box'] = array(
			'#type' => 'markup',
			'#prefix' => '<tr><td><div id="box" style="float:left;padding-top:10px">',
			'#suffix' => '</div></tr></td>',
			'#markup' => '',
		); 
		$form['chart'] = array(
			'#type' => 'markup',
			'#prefix' => '<tr><td><div id="chart" style="float:left;padding-top:-100px">',
			'#suffix' => '</div></td></tr></table>',
			'#markup' => drupal_render(get_whole_db_chart()),
		);
	      
        
        return $form;
        }
    
function getchart(){

$chart = array(
    '#type' => 'chart',
    '#title' => t('Simple Pie Chart (alternative syntax)'),
    '#chart_type' => 'pie',
    '#chart_library' => 'google', // Allowed values: 'google' or 'highcharts'
    '#legend_position' => 'right',
    '#data_labels' => TRUE,
    '#tooltips' => FALSE,
  );
  $chart['pie_data'] = array(
    '#type' => 'chart_data',
    '#title' => t('Gender'),
    '#data' => array(array('Male', 10), array('Female', 20)),
  );

  $example['chart'] = $chart;

 return drupal_render($example);
}
	/**
 	* Callback function for menu item.
 	*/
	function example_page() {
  $data = array(
    array('fruit' => 'apple', 'votes' => 16),
    array('fruit' => 'mango', 'votes' => 10),
    //array('fruit' => 'banana', 'votes' => 34),
    //array('fruit' => 'peach', 'votes' => 20),
    //array('fruit' => 'orange', 'votes' => 15),
  );
 
  $options_pie = array(
    'title' => 'Favourite fruits',
    'fields' => array(
      'votes' => array(
        'label' => t('Votes'),
        'enabled' => TRUE,
      ),
    ),
    'xAxis' => array(
      'labelField' => 'fruit',
    ),
    'data' => $data,
    'type' => 'pie',
  );
 
  $options_column = array(
    'title' => 'Favourite fruits',
    'fields' => array(
      'votes' => array(
        'label' => t('Votes'),
        'enabled' => TRUE,
      ),
    ),
    'xAxis' => array(
      'labelField' => 'fruit',
    ),
    'data' => $data,
    'type' => 'column',
  );
 
  $build['pie'] =  array(
    '#theme' => 'visualization',
    '#options' => $options_pie,
  );
 
  //$build['column'] =  array(
  //  '#theme' => 'visualization',
   // '#options' => $options_column,
  //);
 
  return $build;
}

		function get_whole_db_chart() {
  	    	$data = get_count_tbc_lm_eachproject();

  	    	$options_column = array(
    		'title' => 'Completed Books/lab Statistic for each project',
    		'fields' => array(
      		'TBC' => array(
        	   'label' => t('Textbook companion'),
        	   'enabled' => TRUE,
      		  ),
		 'LM' => array(
        	   'label' => t('Lab migration'),
        	   'enabled' => TRUE,
      		  ),
   		),
    		'xAxis' => array(
      		   'labelField' => 'Project',
    		),
    		'data' => $data,
   		'type' => 'column',
 	    );
 
  	    $build['column'] =  array(
    		'#theme' => 'visualization',
    		'#options' => $options_column,
  	     );
 
  		return $build;
	}


	function get_count_tbc_lm_eachproject(){
 	   $query = db_select('foss_type');
	   $query->fields('foss_type', array('id'));
	   $query->fields('foss_type', array('foss_name'));
 	   $query->fields('foss_type', array('tbc'));
	   $query->fields('foss_type', array('lab_migration'));
	   $result = $query->execute();
	    while ($foss_detail = $result->fetchObject())
                {
		
		if($foss_detail->foss_name!=null){
		if($foss_detail->foss_name!='Python'){
		if($foss_detail->tbc!=0&&$foss_detail->lab_migration!=0){
		
		db_set_active($foss_detail->foss_name);//Active other database
		
		//For TBC

		$query2=db_query("SELECT COUNT( pe.book ) AS book_count FROM textbook_companion_preference pe LEFT JOIN textbook_companion_proposal po ON pe.proposal_id = po.id WHERE po.proposal_status =3 AND pe.approval_status =1 AND pe.category>0");
		
		//$query2 = db_select('textbook_companion_proposal');
		//$query2->addExpression('count(*)', 'count');
		//$query2->condition('proposal_status', 3);

		//For LM
		$query3 = db_select('lab_migration_proposal');
		$query3->addExpression('count(*)', 'count');
		$query3->condition('approval_status', 3);

		//$result2 = $query2->execute();
		$result3 = $query3->execute();
		db_set_active('default'); // We need to call the main (drupal) db back
		db_set_active();
		$completedbookcount = $query2->fetchObject()->book_count;
		$completedlabcount = $result3->fetchObject()->count;
		$option1=array(
			"Project"=>$foss_detail->foss_name, 
			"TBC"=>$completedbookcount, 
			"LM"=>$completedlabcount,
			);
			$options[$foss_detail->id] =$option1;

		}else if($foss_detail->tbc!=0&&$foss_detail->lab_migration==0){

		
		db_set_active($foss_detail->foss_name);//Active other database

		$query2 = db_select('textbook_companion_proposal');
		$query2->addExpression('count(*)', 'count');
		$query2->condition('proposal_status', 3);
		$result2 = $query2->execute();
		db_set_active('default'); // We need to call the main (drupal) db back
		db_set_active();
		$completedbookcount = $result2->fetchObject()->count;
		$option1=array(
			"Project"=>$foss_detail->foss_name, 
			"TBC"=>$completedbookcount, 
			"LM"=>0,
			);
			$options[$foss_detail->id] =$option1;

		}else if($foss_detail->tbc==0&&$foss_detail->lab_migration!=0){

		db_set_active($foss_detail->foss_name);//Active other database
		$query2 = db_select('lab_migration_proposal');
		$query2->addExpression('count(*)', 'count');
		$query2->condition('approval_status', 3);
		$result2 = $query2->execute();
		db_set_active('default'); // We need to call the main (drupal) db back
		db_set_active();
		$completedlabcount = $result2->fetchObject()->count;
		$option1=array(
			"Project"=>$foss_detail->foss_name, 
			"TBC"=>0, 
			"LM"=>$completedlabcount,
			);
			$options[$foss_detail->id] =$option1;

		}
		
	}else{

		db_set_active($foss_detail->foss_name);//Active other database
		$query2 = db_select('tbc_book');
		$query2->addExpression('count(*)', 'count');
		$query2->condition('approved', 1);
		$result2 = $query2->execute();
		db_set_active('default'); // We need to call the main (drupal) db back
		db_set_active();
		$completedbookcount = $result2->fetchObject()->count;
		$option1=array(
			"Project"=>$foss_detail->foss_name, 
			"TBC"=>$completedbookcount, 
			"LM"=>0,
			);
			$options[$foss_detail->id] =$option1;

			}	
		}
	
	    }
	
	return $options;
	}


	function _ajax_example_get_first_dropdown_options(){
           $query = db_select('foss_type');
	   $query->fields('foss_type', array('id'));
	   $query->fields('foss_type', array('foss_name'));
	   $result = $query->execute();
           $options = array();
           $options[''] = "--------------";
              while ($foss_detail = $result->fetchObject())
                {
                 $options[$foss_detail->id] = $foss_detail->foss_name;
                 }
            return $options;
      }
      

	function _ajax_example_get_second_dropdown_options($foss_project = ''){

           if($foss_project != NULL){
		 $query = db_select('foss_type');
		 $query->fields('foss_type', array('tbc'));
		 $query->fields('foss_type', array('lab_migration'));
		 $query->condition('id',$foss_project);
		 $result = $query->execute();
		 $subproject_detail = $result->fetchObject();
           	 $options = array();
              
		    if(($subproject_detail->tbc)!=0&&($subproject_detail->lab_migration)!=0){
		       $options[0] = "--------------";
		       $options[1] = "Textbook Companion";
		       $options[2] = "Lab Migration";
		    }else if(($subproject_detail->tbc)!=0&&($subproject_detail->lab_migration)==0){
		       $options[0] = "--------------";
		       $options[1] = "Textbook Companion";
		    }else if(($subproject_detail->tbc)==0&&($subproject_detail->lab_migration)!=0){
		       $options[0] = "--------------";
		       $options[2] = "Lab Migration";
		    }else if(($subproject_detail->tbc)==0&&($subproject_detail->lab_migration)==0) {
		       $options[0] = "No Sub-Project Available";
		    }else{
		      $options[0] = "--------------";
		      } 
  
            	    return $options;

           }else{
                     $options[0] = "--------------";
                    return $options;
               }
        }

           
	function _ajax_example_get_third_dropdown_options($foss_sub_project=''){

     	     $options = array();
     	   if($foss_sub_project!=0){
		        
           	if($foss_sub_project==1){
              	     $options[0] = "--------------";
              	     $options[1] = "Books In Progress";
                     $options[2] = "Completed Books";
 	    	 }else if($foss_sub_project==2){
		     $options[0] = "--------------";
		     $options[1] = "Labs in Progress";
      		     $options[2] = "Completed Labs"; 	
		 }else{
		     $options[0] = "--------------";
		 }
		
	     }else{
		     $options[0] = "--------------";
		  }

              return $options;
      }


	function _ajax_get_branch_options($foss_project, $foss_sub_project){

        $foss_sub_projectname=$foss_sub_project;
	$foss_project=$foss_project;


	     if($foss_project!='--------------'){

 		db_set_active($foss_project);//Active other database
 		$options = array();
		
		if($foss_sub_projectname=='Textbook Companion'){
		       $query = db_select('textbook_companion_proposal');
		       $query->fields('textbook_companion_proposal', array('branch'));
		       $query->distinct();
  		       $query->orderBy('branch', 'ASC');
		       $result = $query->execute();
		       $options['0'] = "--------------";
		       $x = 1;
                 	while ($foss_branch = $result->fetchObject())
                   	{
                   		$options[$x++] = $foss_branch->branch;
                   	}

		}else if($foss_sub_projectname=='No Sub-Project Available'||$foss_sub_projectname=='--------------'){

			$options[0] ="--------------";

		}else if($foss_sub_projectname=='Lab Migration'){

			$query = db_select('lab_migration_proposal');
			$query->fields('lab_migration_proposal', array('department'));
			$query->distinct();
 			$query->orderBy('department', 'ASC');
			$result = $query->execute();
		     	$options['0'] = "--------------";
			$x = 1;
                 	while ($foss_branch = $result->fetchObject())
                   	{
                  	 $options[$x++] = $foss_branch->department;
                  	 }
		}   
              
		db_set_active('default'); // We need to call the main (drupal) db back      
            	return $options;
  		db_set_active(); // without the paramater means set back to the default for the site
  		

             }else{

		$options[0] ="--------------";
	}		
    		return $options;     
    	}


	function ajax_example_dependent_dropdown_callback($form, $form_state){
		$foss_sub_project=$form_state['values']['foss_type'];
		$form['foss_sub_project_status']['#options']=_ajax_example_get_third_dropdown_options($foss_sub_project);
 		$form['foss_select_branch']['#value'] = '';
		$commands[] = ajax_command_replace("#dropdown-second-replace", drupal_render($form['foss_sub_project']));
		$commands[] = ajax_command_replace("#dropdown-third-replace", drupal_render($form['foss_sub_project_status']));
  		$commands[] = ajax_command_replace("#dropdown-fourth-replace", drupal_render($form['foss_select_branch']));
		return array('#type' => 'ajax', '#commands' => $commands);
	}

	function ajax_example_dependent_dropdown_callback1($form, $form_state){
  		$commands[] = ajax_command_replace("#dropdown-third-replace", drupal_render($form['foss_sub_project_status']));
		$commands[] = ajax_command_replace("#dropdown-fourth-replace", drupal_render($form['foss_select_branch']));
		return array('#type' => 'ajax', '#commands' => $commands);
	}
            
 	function ajax_example_submit_driven_callback($form, $form_state) {
		
		
		$foss_type=$form['foss_type']['#options'][$form_state['values']['foss_type']];
		$foss_sub_project=$form['foss_sub_project']['#options'][$form_state['values']['foss_sub_project']];
		$foss_sub_project_status=$form['foss_sub_project_status']['#options'][$form_state['values']['foss_sub_project_status']];
		$foss_select_branch=$form['foss_select_branch']['#options'][$form_state['values']['foss_select_branch']];
		$startdate=$form_state['values']['start_date'];
		$end_date=$form_state['values']['end_date'];
		

		if($foss_type!='--------------'){
		//Get completed book count from tbc
		db_set_active($foss_type);
		if($foss_sub_project!='--------------'){
			if($foss_sub_project=='Textbook Companion'){
				if($foss_sub_project_status!='--------------'){
				if($foss_sub_project_status=='Completed Books'){
				$query = db_select('textbook_companion_proposal');
				$query->addExpression('count(*)', 'count');
				$query->condition('proposal_status', 3);
				$query->where('FROM_UNIXTIME(completion_date) LIKE :val',  array('val'=>'%'));
				$query->condition('branch', '%', 'LIKE');
				$query->orderBy('id', 'ASC');
				$result = $query->execute();
				$completedbooks = $result->fetchObject();
				$value = 'Total number of books pending :'.(string)$completedbooks->count;
			}else{
				$query = db_select('textbook_companion_proposal');
				$query->addExpression('count(*)', 'count');
				$query->condition('proposal_status',3,'<>' );
				$query->where('FROM_UNIXTIME(completion_date) LIKE :val',  array('val'=>'%'));
				$query->condition('branch', '%', 'LIKE');
				$query->orderBy('id', 'ASC');
				$result = $query->execute();
				$pendingbooks = $result->fetchObject();
				$value = 'Total number of books pending :'.(string)$pendingbooks->count;
			}
			}
			}else{

				if($foss_sub_project_status!='--------------'){
				if($foss_sub_project_status=='Completed Labs'){
				$query = db_select('lab_migration_proposal');
				$query->addExpression('count(*)', 'count');
				$query->condition('approval_status', 3);
				$query->where('FROM_UNIXTIME(approval_date) LIKE :val',  array('val'=>'%'));
				$query->condition('department', '%', 'LIKE');
				$query->orderBy('id', 'ASC');
				$result = $query->execute();
				$completedlabs = $result->fetchObject();
				$value = 'Total number of completed labs :'.(string)$completedlabs->count;
			}else{
				$query = db_select('lab_migration_proposal');
				$query->addExpression('count(*)', 'count');
				$query->condition('approval_status',3,'<>' );
				$query->where('FROM_UNIXTIME(approval_date) LIKE :val',  array('val'=>'%'));
				$query->condition('department', '%', 'LIKE');
				$query->orderBy('id', 'ASC');
				$result = $query->execute();
				$pendinglabs = $result->fetchObject();
				$value = 'Total number of pending labs :'.(string)$pendinglabs->count;
			}
			}

			}
		}
		db_set_active('default'); // We need to call the main (drupal) db back
		db_set_active();

		$headers = array(
                	" ", "Total", "Completed", "Pending",
            	);
		$query = db_select('foss_type');
	        $query->fields('foss_type');	        
	        $result = $query->execute()->fetchAll();
		$rows = array();
                $i=1;
            foreach($result as $row) {
                $item = array(
                   $row->foss_name,
                    $row->tbc,
                    $row->tbc,
                    $row->lab_migration,
                    
                );
                array_push($rows, $item);
                $i++;
            }
		$value="Overall statistic of ".$foss_type." Project:";
		$form['box']['#markup']=get_count_For_Both_TBC_LAB($foss_type);
		//$form['chart']['#markup']=drupal_render(example_page());
		$form['chart']['#markup']="";
		$form['displaytext']['#markup']=t($value);
		$commands[] = ajax_command_replace("#displaytext", drupal_render($form['displaytext']));
                $commands[] = ajax_command_replace("#box", drupal_render($form['box']));
		$commands[] = ajax_command_replace("#chart", drupal_render($form['chart']));
                return array('#type' => 'ajax', '#commands' => $commands);
	}
	}

    	function bootstrap_table_format($headers, $rows) {
       		 $thead = "";
       		 $tbody = "";
        	foreach($headers as $header) {
            		$thead .= "<th>{$header}</th>";
        	}
        	foreach($rows as $row){
            	$tbody .= "<tr>";
            		foreach($row as $data) {
               		 $tbody .= "<td>{$data}</td>";
            		}
            	$tbody .= "</tr>";
        	}
        	$table = "
			
            		<table class='table table-bordered table-hover'>
                	<thead>{$thead}</thead>
                	<tbody>{$tbody}</tbody>
            		</table>
			
        		";
        	return $table;
    	}


function get_only_tbc($foss_name){

			db_set_active($foss_name);
			$query = db_select('textbook_companion_proposal');
			$query->addExpression('count(*)', 'count');
			$query->condition('proposal_status', 3);
			$result = $query->execute();
			$completedbookcount = $result->fetchObject()->count;
			db_set_active('default'); // We need to call the main (drupal) db back      
  			db_set_active(); // without the paramater means set back to the default for the site

return $completedbookcount;
}


	function get_count_For_Both_TBC_LAB($foss_type){
		 $query = db_select('foss_type');
		 $query->fields('foss_type', array('tbc'));
		 $query->fields('foss_type', array('lab_migration'));
		 $query->condition('foss_name',$foss_type,'LIKE');
		 $result = $query->execute();
		 $tbc_lm_detail = $result->fetchObject();

		if($foss_type!='--------------'){
		db_set_active($foss_type);
		if($foss_type!='Python'){
		  if(($tbc_lm_detail->tbc)!=0&&($tbc_lm_detail->lab_migration)!=0){
			//For TBC
			$query = db_select('textbook_companion_proposal');
			$query->addExpression('count(*)', 'count');
			$result = $query->execute();
			$totalbookcount = $result->fetchObject()->count;

			$query = db_select('textbook_companion_proposal');
			$query->addExpression('count(*)', 'count');
			$query->condition('proposal_status', 3);
			$result = $query->execute();
			$completedbookcount = $result->fetchObject()->count;

			$query = db_select('textbook_companion_proposal');
			$query->addExpression('count(*)', 'count');
			$query->condition('proposal_status',3,'<>' );
			$result = $query->execute();
			$pendingbookcount = $result->fetchObject()->count;
			$rows = array();
			$headers = array(
                	" ", "Total", "Completed", "Pending",
            		);
			
                	$item = array(
                   	"TEXTBOOK COMPANION",
                   	$totalbookcount,
                    	$completedbookcount,
                    	$pendingbookcount,);
                	array_push($rows, $item);

		//For Lab Migration
		
			$query = db_select('lab_migration_proposal');
			$query->addExpression('count(*)', 'count');
			$result = $query->execute();
			$totallabcount = $result->fetchObject()->count;

			$query = db_select('lab_migration_proposal');
			$query->addExpression('count(*)', 'count');
			$query->condition('approval_status', 3);
			$result = $query->execute();
			$completedlabcount = $result->fetchObject()->count;

			$query = db_select('lab_migration_proposal');
			$query->addExpression('count(*)', 'count');
			$query->condition('approval_status',3,'<>' );
			$result = $query->execute();
			$pendinglabcount = $result->fetchObject()->count;	
			
			$item = array(
                   	"LAB MIGRATION",
                   	$totallabcount,
                    	$completedlabcount,
                    	$pendinglabcount,);
                	array_push($rows, $item);

		      
		    }else if(($tbc_lm_detail->tbc)!=0&&($tbc_lm_detail->lab_migration)==0){

			//For TBC
			$query = db_select('textbook_companion_proposal');
			$query->addExpression('count(*)', 'count');
			$result = $query->execute();
			$totalbookcount = $result->fetchObject()->count;

			$query = db_select('textbook_companion_proposal');
			$query->addExpression('count(*)', 'count');
			$query->condition('proposal_status', 3);
			$result = $query->execute();
			$completedbookcount = $result->fetchObject()->count;

			$query = db_select('textbook_companion_proposal');
			$query->addExpression('count(*)', 'count');
			$query->condition('proposal_status',3,'<>' );
			$result = $query->execute();
			$pendingbookcount = $result->fetchObject()->count;
			$rows = array();
			$headers = array(
                	" ", "Total", "Completed", "Pending",
            		);
			
                	$item = array(
                   	"TEXTBOOK COMPANION",
                   	$totalbookcount,
                    	$completedbookcount,
                    	$pendingbookcount,);
                	array_push($rows, $item);
		      
		    }else if(($tbc_lm_detail->tbc)==0&&($tbc_lm_detail->lab_migration)!=0){
			//For Lab Migration
		
			$query = db_select('lab_migration_proposal');
			$query->addExpression('count(*)', 'count');
			$result = $query->execute();
			$totallabcount = $result->fetchObject()->count;

			$query = db_select('lab_migration_proposal');
			$query->addExpression('count(*)', 'count');
			$query->condition('approval_status', 3);
			$result = $query->execute();
			$completedlabcount = $result->fetchObject()->count;

			$query = db_select('lab_migration_proposal');
			$query->addExpression('count(*)', 'count');
			$query->condition('approval_status',3,'<>' );
			$result = $query->execute();
			$pendinglabcount = $result->fetchObject()->count;
			$rows = array();
			$headers = array(
                	" ", "Total", "Completed", "Pending",
            		);
					
			$item1 = array(
                   	"LAB MIGRATION",
                   	$totallabcount,
                    	$completedlabcount,
                    	$pendinglabcount,);
                	array_push($rows, $item1);
		       
		    }else if(($tbc_lm_detail->tbc)==0&&($tbc_lm_detail->lab_migration)==0) {
		      	$rows = array();
			$headers = array(
                	" ", "Status",
            		);
			$item = array(
                   	"TEXTBOOK COMPANION",
                    	"Not Available",);
                	array_push($rows, $item);

			$item1 = array(
                   	"LAB MIGRATION",
                    	"Not Available",);
                	array_push($rows, $item1);
		    }

		}else{

		//For Python TBC
			$query = db_select('tbc_book');
			$query->addExpression('count(*)', 'count');
			$result = $query->execute();
			$totalbookcount = $result->fetchObject()->count;

			$query = db_select('tbc_book');
			$query->addExpression('count(*)', 'count');
			$query->condition('approved', 1);
			$result = $query->execute();
			$completedbookcount = $result->fetchObject()->count;

			$query = db_select('tbc_book');
			$query->addExpression('count(*)', 'count');
			$query->condition('approved',1,'<>' );
			$result = $query->execute();
			$pendingbookcount = $result->fetchObject()->count;
			$rows = array();
			$headers = array(
                	" ", "Total", "Completed", "Pending",
            		);
			
                	$item = array(
                   	"TEXTBOOK COMPANION",
                   	$totalbookcount,
                    	$completedbookcount,
                    	$pendingbookcount,);
                	array_push($rows, $item);

		}
}

		
			db_set_active('default'); // We need to call the main (drupal) db back      
  			db_set_active(); // without the paramater means set back to the default for the site
		
                        $count = bootstrap_table_format($headers, $rows);
			return $count;

  		
}

function fossee_stats_init(){

$path = drupal_get_path('module', 'fossee_stats');
drupal_add_js($path . '/js/all_charts.js');

}
', '#suffix' => '	', '#suffix' => '
', '#suffix' => '	', '#suffix' => '
', '#suffix' => '	', '#suffix' => '