// Current tab $currenttab = 'upload'; //adding tabs $instance->report_tabs($currenttab); echo $OUTPUT->box(get_string('uploadtabdes', 'local_admission')); echo '<div style="float:right;"><a href="sample.php?format=csv"><button>' . get_string('sample_excel', 'local_departments') . '</button></a></div>'; echo '<div style="float:right;"><a href="help.php"><button>' . get_string('dept_manual', 'local_departments') . '</button></a></div>'; $mform1->display(); echo $OUTPUT->footer(); die; } } else {//if not empty of variable $iid,it get the content from the csv content $cir = new csv_import_reader($iid, 'uploadadmission'); $filecolumns = uu_validate_admission_upload_columns($cir, $STD_FIELDS, $PRF_FIELDS, $returnurl); } // Print the header echo $OUTPUT->header(); echo $OUTPUT->heading(get_string('uploadadmissionsresult', 'local_admission')); $optype = 'UU_ADMISSION_ADDNEW'; // verification moved to two places: after upload and into form2 $admissionsnew = 0; $admissionsupdated = 0; $admissionsuptodate = 0; //not printed yet anywhere $admissionserrors = 0; $admissionsskipped = 0; // init csv import helper $cir->init(); $linenum = 1; //column header is first line // init upload progress tracker------this class used to keeping track of code(each rows and columns)-------------
function local_batches_upload_preview($cir,$previewrows=10){ global $DB,$CFG,$USER; // preview table data $returnurl = new moodle_url('/local/batches/bulk_enroll.php'); //$STD_FIELDS = array('firstname', 'middlename', 'lastname', 'gender', 'dob', 'birthcountry', 'birthplace', 'fathername', 'pob', 'region', 'town', 'current_home_no', 'current_country', 'phone', 'email', 'howlong', 'same', 'permenant_country', 'permenant_home_no', 'state', 'city', 'pincode', 'contactname', 'primary_school', 'primary_year', 'primary_score', 'primary_place', 'undergraduate_in', 'ugname', 'ug_year', 'ug_score', 'ug_place', 'graduate_in', 'graduate_name', 'graduate_year', 'graduate_score', 'graduate_place', 'examname', 'hallticketno', 'score', 'no_of_months', 'reason', 'description','typeofstudent', 'typeofapplication', 'previousstudent', 'serviceid', 'typeofprogram'); $STD_FIELDS = array('firstname', 'middlename', 'lastname', 'gender', 'dob','region','category', 'current_country', 'phone', 'email', 'otherphone','city', 'pincode', 'typeofapplication', 'serviceid', 'fatheremail','address'); $PRF_FIELDS = array(); $result = ''; $enrollablecount = 0; $createdgroupscount = 0; $createdgroupingscount = 0; $createdgroups = ''; $createdgroupings = ''; $filecolumns = uu_validate_admission_upload_columns($cir, $STD_FIELDS, $PRF_FIELDS, $returnurl); $data = array(); $cir->init(); $linenum = 1; //column header is first line $noerror = true; // Keep status of any error. while ($linenum <= $previewrows and $fields = $cir->next()) { $linenum++; $rowcols = array(); $rowcols['line'] = $linenum; foreach($fields as $key => $field) { $rowcols[$filecolumns[$key]] = s(trim($field)); } //$rowcols['status'] = array(); // //if (isset($rowcols['username'])) { // $stdusername = clean_param($rowcols['username'], PARAM_USERNAME); // if ($rowcols['username'] !== $stdusername) { // $rowcols['status'][] = get_string('invalidusernameupload'); // } // if ($userid = $DB->get_field('user', 'id', array('username'=>$stdusername, 'mnethostid'=>$CFG->mnet_localhost_id))) { // $rowcols['username'] = html_writer::link(new moodle_url('/user/profile.php', array('id'=>$userid)), $rowcols['username']); // } //} else { // // $rowcols['status'][] = get_string('missingusername'); //} if (isset($rowcols['email'])) { if (!validate_email($rowcols['email'])) { //$rowcols['status'][] = get_string('invalidemail'); } if ($DB->record_exists('user', array('email'=>$rowcols['email']))) { //$rowcols['status'][] = $stremailduplicate; } } if (isset($rowcols['city'])) { $rowcols['city'] = $rowcols['city']; } //// Check if rowcols have custom profile field with correct data and update error state. //$noerror = uu_check_custom_profile_data($rowcols) && $noerror; //$rowcols['status'] = implode('<br />', $rowcols['status']); $data[] = $rowcols; } if ($fields = $cir->next()) { $data[] = array_fill(0, count($fields) + 2, '...'); } $cir->close(); $table = new html_table(); $table->id = "uupreview"; $table->attributes['class'] = 'generaltable'; $table->tablealign = 'center'; $table->summary = get_string('uploaduserspreview', 'tool_uploaduser'); $table->head = array(); $table->data = $data; $table->head[] = get_string('uucsvline', 'tool_uploaduser'); foreach ($filecolumns as $column) { $table->head[] = $column; } $table->head[] = get_string('status'); echo html_writer::tag('div', html_writer::table($table), array('class'=>'flexible-wrap')); }