array( 'title' => t('View ISCFIP Reports'), 'description' => t('Access to view ISCFIP Reports.') ) ); } function iscfip_reports_menu(){ $items=array(); $items['progress-report/download'] = array( 'title' => t('Download'), 'page callback' => 'iscfip_reports_download', 'access arguments' => array('Add SCM Reports'), 'type' => MENU_CALLBACK ); return($items); } function iscfip_reports_block_info(){ $blocks['iscfip_report_left_menu']=array('info'=>t('ISCFIP Report Left Menu'),'cache'=>DRUPAL_CACHE_PER_ROLE); $blocks['iscfip_report_fellowship']=array('info'=>t('ISCFIP Report Fellowship'),'cache'=>DRUPAL_CACHE_PER_ROLE); $blocks['iscfip_report_internship']=array('info'=>t('ISCFIP Report Internship'),'cache'=>DRUPAL_CACHE_PER_ROLE); return($blocks); } function iscfip_reports_block_view($delta=''){ $block=array(); if(user_access('view_iscfip_reports')){ switch($delta){ case 'iscfip_report_left_menu': $block['subject']=t('Choose Report'); $block['content']=iscfip_reports_left_menu(); break; case 'iscfip_report_fellowship': $block['subject']=t('Fellowship Report'); $block['content']=iscfip_reports_fellowship(); break; case 'iscfip_report_internship': $block['subject']=t('Internship Report'); $block['content']=iscfip_reports_internship(); break; } } return($block); } function iscfip_reports_left_menu(){ $html='Fellowship ReportInternship Report'; return($html); } function iscfip_reports_fellowship(){ $html='
Download CSV
'; $html.='
'; $html.='
'; $res=iscfip_reports_fellowship_data(); $i=0; foreach($res as $row){ $i++; $arr_country=array('1'=>'India'); $arr_hdegree=array('option1'=>'Graduate Degree','option2'=>'Post-Graduate Degree','option3'=>'Other'); $arr_mtype=array('option1'=>'Percentage','option2'=>'CGPA'); if($row->other_degree != "") $degree=$row->other_degree; else $degree=$arr_hdegree[$row->highest_degree]; $html.='

'.$row->name.'

  • DOB: '.$row->dob.'
  • Address: '.$row->add_address.'
  • City: '.$row->add_city.'
  • State: '.$row->add_state.'
  • Country: '.$arr_country[$row->add_country].'
  • Email: '.$row->email.'
  • Contact: '.$row->contact.'
  • Highest Degree: '.$degree.'
  • Degree Title: '.$row->degree_title.'
  • University: '.$row->university.'
  • Specialisation: '.$row->specialization.'
  • Mark Type: '.$row->marks_type.'
  • Marks: '.$row->marks.'
  • Resume: Download
  • Total Exp Years: '.$row->total_exp_years.'
  • Preferred Sector: '.$row->pref_sectors.'
  • Concept Paper: Download
  • Analytical Skills: '.$row->skill_analytics.'
  • Research Skills: '.$row->skill_research.'
  • Documentation Skills: '.$row->skill_documentation.'
About Work:
Statement of Purpose:

References:

  • Name: '.$row->ref_per1_name.'
  • Designation and Institute: '.$row->ref_per1_des_ins.'
  • Email: '.$row->ref_per1_email.'
  • Contact: '.$row->ref_per1_contact.'
  • Name: '.$row->ref_per2_name.'
  • Designation and Institute: '.$row->ref_per2_des_ins.'
  • Email: '.$row->ref_per2_email.'
  • Contact:
'; } $html.='
'; return($html); } function iscfip_reports_internship(){ $html='
Download CSV
'; $html.='
'; $res=iscfip_reports_internship_data(); $i=0; foreach($res as $row){ $i++; $arr_country=array('1'=>'India'); $arr_hdegree=array('option1'=>'Graduate Degree','option2'=>'Post-Graduate Degree','option3'=>'Other'); if($row->other_degree != "") $degree=$row->other_degree; else $degree=$arr_hdegree[$row->highest_degree]; $html.='

'.$row->name.'

  • DOB: '.$row->dob.'
  • Address: '.$row->add_address.'
  • City: '.$row->add_city.'
  • State: '.$row->add_state.'
  • Country: '.$arr_country[$row->add_country].'
  • Email: '.$row->email.'
  • Contact: '.$row->contact.'
  • Highest Degree: '.$degree.'
  • Degree Title: '.$row->degree_title.'
  • University: '.$row->university.'
  • Specialisation: '.$row->specialization.'
  • Resume: Download
  • Total Exp Years: '.$row->total_exp_years.'
  • Preferred Sectors: '.$row->pref_sectors.'
  • NoC: Download
  • Analytical Skills: '.$row->skill_analytics.'
  • Research Skills: '.$row->skill_research.'
  • Documentation Skills: '.$row->skill_documentation.'
Statement of Purpose:

References:

  • Name: '.$row->ref_per1_name.'
  • Designation and Institute: '.$row->ref_per1_des_ins.'
  • Email: '.$row->ref_per1_email.'
  • Contact: '.$row->ref_per1_contact.'
  • Name: '.$row->ref_per2_name.'
  • Designation and Institute: '.$row->ref_per2_des_ins.'
  • Email: '.$row->ref_per2_email.'
  • Contact:
'; } $html.='
'; return($html); } function iscfip_reports_fellowship_data(){ $q="select * from {fellowship} order by id ASC"; $res=db_query($q); return($res); } function iscfip_reports_internship_data(){ $q="select * from {internship} order by id ASC"; $res=db_query($q); return($res); } function iscfip_reports_download(){ $type=$_POST['type']; $csv_data=''; $arr_hdegree=array('option1'=>'Graduate Degree','option2'=>'Post-Graduate Degree','option3'=>'Other'); $arr_mtype=array('option1'=>'Percentage','option2'=>'CGPA'); if($type=="fellowship"){ $file_name="fellowship_data_".date('d-m-Y_H-i-s').".csv"; $csv_data="Sr. No,Name,Address,City,State,Country,Email,Contact,DOB,Highest Degree,Degree Title,Specialisation,University,Marks Type,Marks,Resume,Total Experience Years,About Work Experience,Preferred Sectors,Concept Paper,Statement of Purpose,Ref1 Name,Ref1 Designation,Ref1 Email,Ref1 Contact,Ref2 Name,Ref2 Designation,Ref2 Email,Ref2 Contact,Analytical Skills,Research Skills,Documentation Skills\n"; $q="select * from {fellowship} where is_active=1"; $res=db_query($q); $c=1; foreach($res as $row){ if($row->other_degree != "") $degree=$row->other_degree; else $degree=$arr_hdegree[$row->highest_degree]; $csv_data.=$c.",".iscfip_reports_filter_csv($row->name).",".iscfip_reports_filter_csv($row->add_address).",".iscfip_reports_filter_csv($row->add_city).",".iscfip_reports_filter_csv($row->add_state).",".iscfip_reports_filter_csv($row->add_country).",".iscfip_reports_filter_csv($row->email).",".iscfip_reports_filter_csv($row->contact).",".iscfip_reports_filter_csv($row->dob).",".iscfip_reports_filter_csv($degree).",".iscfip_reports_filter_csv($row->degree_title).",".iscfip_reports_filter_csv($row->specialization).",".iscfip_reports_filter_csv($row->university).",".iscfip_reports_filter_csv($arr_mtype[$row->marks_type]).",".iscfip_reports_filter_csv($row->marks).",https://smartnet.niua.org/iscfip/".$row->resume.",".iscfip_reports_filter_csv($row->total_exp_years).",".iscfip_reports_filter_csv($row->about_work_exp).",".iscfip_reports_filter_csv($row->pref_sectors).",https://smartnet.niua.org/iscfip/".$row->concept_paper.",".iscfip_reports_filter_csv($row->stat_purpose).",".iscfip_reports_filter_csv($row->ref_per1_name).",".iscfip_reports_filter_csv($row->ref_per1_des_ins).",".iscfip_reports_filter_csv($row->ref_per1_email).",".iscfip_reports_filter_csv($row->ref_per1_contact).",".iscfip_reports_filter_csv($row->ref_per2_name).",".iscfip_reports_filter_csv($row->ref_per2_des_ins).",".iscfip_reports_filter_csv($row->ref_per2_email).",".iscfip_reports_filter_csv($row->ref_per2_contact).",".iscfip_reports_filter_csv($row->skill_analytics).",".iscfip_reports_filter_csv($row->skill_research).",".iscfip_reports_filter_csv($row->skill_documentation)."\n"; $c++; } file_put_contents(DRUPAL_ROOT."/iscfip/downloads/".$file_name,$csv_data); echo $file_name; exit; } if($type=="internship"){ $file_name="internship_data_".date('d-m-Y_H-i-s').".csv"; $csv_data="Sr. No,Name,Address,City,State,Country,Email,Contact,DOB,Highest Degree,Degree Title,Specialisation,University,Resume,Preferred Sectors,Statement of Purpose,NOC,Ref1 Name,Ref1 Designation,Ref1 Email,Ref1 Contact,Ref2 Name,Ref2 Designation,Ref2 Email,Ref2 Contact\n"; $q="select * from {internship} where is_active=1"; $res=db_query($q); $c=1; foreach($res as $row){ if($row->other_degree != "") $degree=$row->other_degree; else $degree=$arr_hdegree[$row->highest_degree]; $csv_data.=$c.",".iscfip_reports_filter_csv($row->name).",".iscfip_reports_filter_csv($row->add_address).",".iscfip_reports_filter_csv($row->add_city).",".iscfip_reports_filter_csv($row->add_state).",".iscfip_reports_filter_csv($row->add_country).",".iscfip_reports_filter_csv($row->email).",".iscfip_reports_filter_csv($row->contact).",".iscfip_reports_filter_csv($row->dob).",".iscfip_reports_filter_csv($degree).",".iscfip_reports_filter_csv($row->degree_title).",".iscfip_reports_filter_csv($row->specialization).",".iscfip_reports_filter_csv($row->university).",https://smartnet.niua.org/iscfip/".$row->resume.",".iscfip_reports_filter_csv($row->pref_sectors).",".iscfip_reports_filter_csv($row->stat_purpose).",https://smartnet.niua.org/iscfip/".$row->no_obj_cert.",".iscfip_reports_filter_csv($row->ref_per1_name).",".iscfip_reports_filter_csv($row->ref_per1_des_ins).",".iscfip_reports_filter_csv($row->ref_per1_email).",".iscfip_reports_filter_csv($row->ref_per1_contact).",".iscfip_reports_filter_csv($row->ref_per2_name).",".iscfip_reports_filter_csv($row->ref_per2_des_ins).",".iscfip_reports_filter_csv($row->ref_per2_email).",".iscfip_reports_filter_csv($row->ref_per2_contact)."\n"; $c++; } file_put_contents(DRUPAL_ROOT."/iscfip/downloads/".$file_name,$csv_data); echo $file_name; exit; } } function iscfip_reports_filter_csv($str){ $str=preg_replace('!\s+!',' ',$str); $str=str_replace(",",";",$str); $str=str_replace('"','',$str); return(strip_tags($str)); }