Create Zoom Meeting With Api V2 Through Simple PHP

Tuesday, April 27, 2021

Webutil Configuration steps for Oracle Fusion Middleware Forms 11g

Goal: How to Configure Webutil Library in Fusion Middleware Forms 11g (11.1.2.0).

The Webutil utility is largely configured in your 11g Forms installation. However, there are some additional steps you will need to accomplish in order to make it work properly.

Additional Webutil components maybe needed in order to configure Webutil for development purposes. These Components are:

1- Jacob Package 1.14.3 for (11.1.2.0)

You can found this package on mentioned below URL:

Download

In this package, there are three files:

1- Jacob.jar

2- jacob-1.14.3-x64.dll

3- jacob-1.14.3-x86.dll

Before Using the Above mentioned files, Follow the steps mentioned below to create Webutil user in Database.

1- Login from SYS

2- CREATE USER Webutil IDENTIFIED BY Webutil (Already Created in 11g)

3- Grant connect, resource to Webutil

4- Connect Webutil/Webutil

5- Run create_webutil_db.sql from /Weblogic/weblogic_10.3/Middleware/Oracle_FRHome1/forms/

6- Create public synonym webutil_db for webutil.webutil_db;

7- Connect sys as sysdba

8- Grant execute on webutil_db to public;

Now Place the Jacob.jar into /Weblogic/weblogic_10.3/Middleware/Oracle_FRHome1/forms/java Directory.

Place Jacob-1.14.3-x64.dll into /weblogic/weblogic_10.3/Middleware/Oracle_FRHome1/forms/webutil/win64 Directory.

Place Jacob-1.14.3-x86.dll into /weblogic/weblogic_10.3/Middleware/Oracle_FRHome1/forms/webutil/win32 Directory.

Create a backup of sign_webutil.sh with different name, this file can be found in

/Weblogic/weblogic_10.3/Middleware/asinst_1/bin Directory

Open sign_webutil.sh file in notepad and search for <Your KEYSTORE password> line. Replace it with “welcome1”. Similarly search for < Your private key password > line and replace it with “welcome1”. Save the file to the same directory after Editing.

Now run the Following command to sign both files with Jacob.jar and frmwebutil.jar files

[oracle@earth bin] $ ./sign_webutil.sh /Weblogic/weblogic_10.3/Middleware/Oracle_FRHome1/forms/java/Jacob.jar

[oracle@earth bin] $ ./sign_webutil.sh /Weblogic/weblogic_10.3/Middleware/Oracle_FRHome1/forms/java/frmwebutil.jar

After Jar Signing, Go to Browser and type the following command to open Oracle Fusion Middleware Console.

http://userid=username/password@sid:7001/em

Add /Weblogic/weblogic_10.3/Middleware/Oracle_FRHome1/forms/java/frmall.jar path into CLASSPATH Variable Default.env

Add Manually By using following command:

[oracle@earth bin] $ vi .bash_profile

Add /Weblogic/weblogic_10.3/Middleware/Oracle_FRHome1/forms/java/frmall.jar path into CLASSPATH variable in bash_profile.

Regenerate the webutil.pll using following command:

[oracle@earth bin] $ Frmcmp.sh module=webutil.pll module_type=library userid=username/password@sid compile_all=yes

Open & Edit the Following Parameters in formsweb.cfg, it can be found in:

/weblogic/weblogic_10.3/Middleware/user_projects/domains/webforms_domain/config/fmwconfig/servers/WLS_FORMS/

applications/formsapp_11.1.2/config Directory.

Archive= frmall.jar, frmwebutil.jar

Modification in [Webutil] Section:

WebUtilArchive=frmwebutil.jar, jacob.jar

Archive=frmall.jar, frmwebutil.jar, jacob.jar

Save the formsweb.cfg after editing.

Install a VNC Client on Windows to create Linux client session on Windows because linux do not support drag & Drop functions in Oracle Form 11g.

Open Oracle forms builder 11g on Linux client, Create a new form,a new block & a canvas.

after that attach webutil.pll on Navigator—> Attached Libraries in Forms that you have compiled earlier.

Attach Webutil.olb in Object Libraries in oracle Forms.

Open WebUtil.olb file Object group in builder and copy or subclass it into your form.

Create a Button (B1) and a text field (P1) on Already created canvas.

Copy & paste the following Code in When Button Pressed Trigger.

Declare
	v_file varchar2(500);
Begin
	v_file := CLIENT_GET_FILE_NAME (directory_name => 'C:\Forms\Reports',
	                               file_name       => NULL,
	                               file_filter     => NULL,
	                               message         => 'Open a file',
	                               dialog_type     => OPEN_FILE);
       :P1:=v_file;

End;

Compile & Save the form again.

Run the Form and browse any file in your Client PC in order to check the Webutil proper functionality.

Note: Browser will ask to certify these libraries first time Choose ALWAYS certify. Check Java Console icon on the task bar and see frmwebtul.jar and jacob.jar are loaded successfully.

Working With File Throgh WebUtill

-------------------------------------------------

Required Configuraion :

By default the file transfer is disabled in webutil for a security measure. So, you have to enable File transfer configuration in webutil.cfg file. The webutil.cfg file is located in forms\server.

Open The webuil.cfg file and edit the following parameters :

transfer.database.enabled=FALSE Change To TRUE

transfer.appsrv.enabled=FALSE Change to TRUE

WebUtil_File contains APIs to manipulate files and directories on the client. These Functions Or APIs are:

Copy_File : Copies a file Returns a Boolean to indicate success.

Syntax :

Webutil_File.Copy_File(SourceFileName in Varchar2 , Destination In Varchar2) Return Boolean

Example

Declare

vCopied Boolean;

Begin

vCopied := Webutil_File.Copy_File('C:\temp\mypic.jpg','X:\destination_folder');

If vCopied = true Then

Message('File copied Successfully');

Else

Message('Error in Copying File');

End if;

Delete_File: Deletes a file. Returns a Boolean to indicate success.

Rename_File Renames a file. Returns a Boolean to indicate success.

Create_Directory Creates the named directory if it does not exist.

Any intermediate directories will also be created.

Returns a Boolean to indicate success.

Directory_Root_List Returns a FILE_LIST containing the directory roots on the client system. On a Windows PC these would correspond to the drives on the computer.

Directory_List :Returns a FILE_LIST containing all the files and subdirectories in a particular directory. There is an optional Return_Files_Only argument to restrict the returned list to just files with no directories.

Directory_Filtered_List : Like Directory_List this will return a list of files in a directory but you are able to file filter using the '*' and '?' wildcards e.g. *.FMB to restrict the list.

File_Exists :Returns a Boolean value indicating if the named file exists on the client

File_Is_Directory Returns a Boolean value indicating of the file name supplied is actually a directory on the client.

File_Is_Hidden :Returns a Boolean value indicating of the file has it's hidden attribute set.

File_Is_Readable :Returns a Boolean value indicating of the file can be read.

File_Is_Writable :Returns a Boolean value indicating of the file canbe written to.

File_Size :Returns the size of the file in bytes.

Directory_Selection_Dialog :Displays a Directory selection dialog. The initial directory and the title for the dialog can be defined. The selected directory is returned.

File_Selection_Dialog :Allows the definition of a File Save or Open dialog with a configurable file filter. Returns a single file selection. The file filter can use ? and * as wildcards and is in the format |||. Multiple filters

can be specified, e.g. |Gif Files|*.gif|JPEG Files|*.jpg|.

File_Multi_Selection_Dialog :As File_Selection_Dialog except that the user can select multiple files and these are returned in a FILE_LIST.

File_Open_Dialog :A convenience method that creates a File Open Dialog. File_Save_Dialog A convenience method that creates a File Save Dialog.

Get_file_Separator :Returns the character used on the client computer as the file separator e.g. "\" on Windows.

Get_Path_Separator :Returns the character used to separate directory locations on Paths e.g. ";" on Windows.

Wednesday, August 5, 2020

Meeting View (Codeignitor)

<?php $this->load->view('header.php');?>

<br>

</div>

</div>

Create Meeting

</div>

<?php echo $content;?>

</div>

</div>

</div>

</div>

<!-- jQuery

</body>

</html>

-->

<?php $this->load->view('footer.php');?>

$(document).ready(function(){

$('#datetimepicker1').datetimepicker({minDate: moment().add(10,'minutes')});

});

$("#StartDate").change(function () {

var startdate = $("#StartDate").val();

var currentdate = new Date();

console.log('Schdule Date '+startdate);

console.log('Current Date '+currentdate);

if(startdate<currentdate)

{

alert('Back Date not allow.');

}

});

var site_url = "<?php echo site_url('addmeetings');?>"+"/";

$("#subject").change(function() {

$("#course").load(site_url+"GetCourses/" + $("#subject").val());

});

$("#course").change(function() {

$("#chapter").load(site_url+"GetChapters/" + $("#course").val());

});

$("#_file").click(function () {

$(".note-editor").hide();

$("#file_type").show();

});

$("#_text").click(function () {

$(".note-editor").show();

$("#file_type").hide();

});

// code to read selected table row cell data (values).

$("#dataTables-example").on('click','#fetchMedia',function(){

// get the current row

$("#medianame").val($(this).attr("data-id"));

$("#exampleModal").modal("hide");

});

$("#CreateZoomMeeting").click(function(){

var schedule_Date = $("#StartDate").val();

var Title = $("#title").val();

alert(schedule_Date);

var valid = this.form.checkValidity();

if(valid) {

event.preventDefault();

$.ajax({

type: "POST",

url: site_url+"CreateZoomMeeting",

dataType: "json",

data: {MeetingDate:schedule_Date,MeetingTitle:Title},

success : function(data){

var Info = '<strong>Meeting Url : </strong><a href="'+data.join_url+'" meeting-id="'+data.id+'" id="JoinZoomMeeting" target="_blank" class="btn btn-default">Join Meeting</a></br><strong>Password:</strong>'+data.password

$("#text_type").summernote('code',Info);

$("#Price").val(data.id);

$("#SaveMeeting").show();

$("#CreateZoomMeeting").hide();

}

});

}

});

</script>

Meeting Controller (CodeIgnitor)

<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');

require_once 'jwt/BeforeValidException.php';

require_once 'jwt/ExpiredException.php';

require_once 'jwt/SignatureInvalidException.php';

require_once 'jwt/JWT.php';

use \Firebase\JWT\JWT;

class Zoom_Api {

private $zoom_api_key = 'xxxxxxxxxxxxxxxx';

private $zoom_api_secret = 'xxxxxxxxx';

protected function sendRequest($data) {

$request_url = 'https://api.zoom.us/v2/users/me/meetings';

$headers = array(

"authorization: Bearer ".$this->generateJWTKey(),

'content-type: application/json'

);

$postFields = json_encode($data);

$ch = curl_init();

curl_setopt($ch, CURLOPT_HTTPHEADER, $headers);

curl_setopt($ch, CURLOPT_RETURNTRANSFER,1);

curl_setopt($ch, CURLOPT_URL, $request_url);

curl_setopt($ch, CURLOPT_POST, 1);

curl_setopt($ch, CURLOPT_POSTFIELDS, $postFields);

curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);

$response = curl_exec($ch);

$err = curl_error($ch);

curl_close($ch);

if(!$response){

return $err;

}

return json_decode($response);

}

//function to generate JWT

private function generateJWTKey() {

$key = $this->zoom_api_key;

$secret = $this->zoom_api_secret;

$token = array(

"iss" => $key,

"exp" => time() + 3600 //60 seconds as suggested

);

// $token = "eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJhdWQiOm51bGwsImlzcyI6IlI1OWZNMEViUXFPcWNrU0c4dzR2MmciLCJleHAiOjE1OTA1MTM4NDUsImlhdCI6MTU5MDUwODQ0N30.4ch2OZoFM_vZFdqhoMzJX8r8GPYjKlOkV_vUa7LprFc";

return JWT::encode( $token, $secret );

}

public function createAMeeting( $data = array() ) {

$post_time = $data['start_date'];

$start_time = gmdate( "Y-m-d\TH:i:s", strtotime( $post_time->format('Y-m-d H:i:s') ) );

$createAMeetingArray = array();

if ( ! empty( $data['alternative_host_ids'] ) ) {

if ( count( $data['alternative_host_ids'] ) > 1 ) {

$alternative_host_ids = implode( ",", $data['alternative_host_ids'] );

} else {

$alternative_host_ids = $data['alternative_host_ids'][0];

}

$createAMeetingArray['topic'] = $data['meetingTopic'];

$createAMeetingArray['agenda'] = ! empty( $data['agenda'] ) ? $data['agenda'] : "";

$createAMeetingArray['type'] = ! empty( $data['type'] ) ? $data['type'] : 2; //Scheduled

$createAMeetingArray['start_time'] = $start_time;

$createAMeetingArray['timezone'] = $data['timezone'];

$createAMeetingArray['password'] = ! empty( $data['password'] ) ? $data['password'] : "";

$createAMeetingArray['duration'] = ! empty( $data['duration'] ) ? $data['duration'] : 60;

$createAMeetingArray['settings'] = array(

'join_before_host' => ! empty( $data['join_before_host'] ) ? true : false,

'host_video' => ! empty( $data['option_host_video'] ) ? true : false,

'participant_video' => ! empty( $data['option_participants_video'] ) ? true : false,

'mute_upon_entry' => ! empty( $data['option_mute_participants'] ) ? true : false,

'enforce_login' => ! empty( $data['option_enforce_login'] ) ? true : false,

'auto_recording' => ! empty( $data['option_auto_recording'] ) ? $data['option_auto_recording'] : "none",

'alternative_hosts' => isset( $alternative_host_ids ) ? $alternative_host_ids : ""

);

return $this->sendRequest($createAMeetingArray);

}

class addmeetings extends CI_Controller {

function __construct()

{

parent::__construct();

$this->load->model('courses','',TRUE);

$this->load->model('dmlcourse','',TRUE);

$this->load->model('User','',TRUE);

$this->load->helper('url');

$session_data = $this->session->userdata('logged_in');

if (!isset($session_data['username']))

{

redirect('login', 'refresh');

}

$content;

}

function GetCourses($Subject){

$session_data = $this->session->userdata('logged_in');

$username = $session_data['username'];

$courses = $this ->courses->GetCourses_Subject($Subject,$username);

//$course_list = "";

echo '<option value="">Nil</option>';

foreach($courses as $course)

{

echo '<option value="'.$course['ID'].'">'.$course['Title'].'</option>';

}

function GetChapters($Course){

$Lists = $this ->courses->GetChapter_Course($Course);

//$course_list = "";

echo '<option value="">Nil</option>';

foreach($Lists as $List)

{

echo '<option value="'.$List['ChapterID'].'">'.$List['ChapterTitle'].'</option>';

}

function GetTopics($Chapter){

$Lists = $this ->courses->GetTopic_Chapter($Chapter);

//$course_list = "";

echo '<option value="">Nil</option>';

foreach($Lists as $List)

{

echo '<option value="'.$List['TopicID'].'">'.$List['TopicTitle'].'</option>';

}

function CreateZoomMeeting()

{

date_default_timezone_set("Asia/Karachi");

$Title = $this->input->post('MeetingTitle');

$scheduledate = $this->input->post('MeetingDate');

$date=date_create($scheduledate);

$js_Date= date_format($date,"Y/m/d H:i:s");

$dteStart = new DateTime($js_Date);

$zoom_meeting = new Zoom_Api();

try{

$z = $zoom_meeting->createAMeeting(

array(

'start_date'=>$dteStart,

'meetingTopic'=>$Title,

'timezone'=>'Asia/Tashkent'

)

);

echo json_encode($z);

} catch (Exception $ex) {

echo 'FAILED';

}

function index()

{

$error_code = $this->uri->segment(3);

$datetime = $this->uri->segment(4);

$error="";

if($error_code=='1')

{

$error= '<div class="alert alert-success" role="alert">Back Date('.$datetime.') Entry Not Allowed</div>';

}

$courses = $this ->courses->GetAllChapter();

$content = "";

foreach($courses as $course)

{

$content .= '<option value="'.$course['ChapterID'].'">'.$course['ChapterTitle'].'</option>';

}

$session_data = $this->session->userdata('logged_in');

$username = $session_data['username'];

$Medias = $this ->courses->GetAllMedia($username);

$tableRow = '';

foreach($Medias as $Media) {

$tableRow = $tableRow .

'<tr class="gradeA odd" role="row">

<td class="sorting">'.$Media['MediaName'].'</td>

<td>'.$Media['MediaType'].'</td>

<td>

<button type="button" data-id="'.$Media['MediaName'].'" id="fetchMedia" class="btn btn-danger">Select</button>

</td>

</tr>';

}

$grid = '<div class="row">

</div>

<thead>

<th class="sorting" tabindex="0" aria-controls="dataTables-example" rowspan="1" style="width:15%" aria-label="CSS grade: activate to sort column ascending" style="width: 50px;">Action</th>

</tr>

</thead>

<tbody>'.$tableRow.'</tbody>

</table></div></div>

</div>

</div>';

$modal = '<div class="modal fade" id="exampleModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">

<h5 class="modal-title" id="exampleModalLabel">Content</h5>

</button>

</div>

<div class="modal-body">'.

$grid

.'</div>

</div>

</div>';

$htmlcontent = '<div class="panel-body">

'.$error.'

<label>Subject</label>

<option value="">Yet To Select</option>

<option>Physics</option>

<option>Chemistry</option>

<option>Biology</option>

<option>Maths</option>

</select>

</div>

<label>Course</label>

<option value="">Yet To Select</option>

</select>

</div>

<label>Chapter</label>

<option value="">Yet To Select</option>

</select>

</div>

<label>Meeting Title</label>

</div>

<label>Schedule DateTime( Minimum 10 Minute Later)</label>

</span>

</div>

<label>Content</label>

<p class="help-block">Example: Physics</p>

</div>

<button type="submit" id="CreateZoomMeeting" style="background-color:#519CFE; color:white;" class="btn btn-default"><span class="fa fa-video-camera"> Create Zoom Meeting</button>

<button type="submit" style="background-color:#5CB85C; color:white;display:none;" id="SaveMeeting" class="btn btn-default">Save Meeting</button>

<button type="reset" class="btn btn-default">Reset</button>

</div>

</form>

</div>

</div>

</div>

$data['htmlcontent'] =$htmlcontent.$modal;

$data['error'] ='';

$this->load->view('addmeetings_view', array('content'=>$data['htmlcontent']));

}

function newtopic()

{

$data = array(

'TopicID' => null,

'TopicType' => '2',

'TopicTitle' => $this->input->post('title'),

'CourseID' => $this->input->post('chapter'),

'TopicDesc' => $this->input->post('topicDesc'),

'TopicContent' =>$this->input->post('topiccontent'),

'StartDate' => $this->input->post('StartDate'),

'ContentType' => 'Text',

'price' => $this->input->post('Price')

);

$scheduledate = $this->input->post('StartDate');

//$datetime = new DateTime(str_replace('/', '-', $scheduledate));

$date=date_create($scheduledate);

$js_Date= date_format($date,"Y/m/d H:i:s");

//$diff_future = abs(strtotime($js_Date)-strtotime(date("/m/d/Y h:i:s")));

//$minutes = $diff_future/60;

$minutes = 60;

date_default_timezone_set("Asia/Karachi");

$dteStart = new DateTime($js_Date);

$dteEnd = new DateTime(date("Y/m/d h:i:sa"));

//echo $dteEnd->format("Y/m/d H:i:s");

$dteDiff = $dteEnd->diff($dteStart);

$past_date = $dteDiff->format('%R');

//echo $past_date;

//$this->courses->add_topic($data);

if($past_date != '-')

{

$this->courses->add_topic($data);

redirect(site_url('ManipulateMeetings'));

}

else

{

//redirect(site_url('addmeetings'));

}

function MarkAttendance()

{

date_default_timezone_set("Asia/Karachi");

$session_data = $this->session->userdata('logged_in');

$username = $session_data['username'];

$data = array(

'MeetingID' => $this->input->post('TopicID'),

'Student' => $username,

'CreationDate' => date("Y/m/d h:i:sa")

);

$Topic = $this ->dmlcourse->GetParticularTopic($this->input->post('TopicID'));

$scheduledate = $Topic[0]['startdate'];

$date=date_create($scheduledate);

$js_Date= date_format($date,"Y/m/d H:i:s");

$dteStart = new DateTime($js_Date);

$dteEnd = new DateTime(date("Y/m/d h:i:sa"));

//echo $dteEnd->format("Y/m/d H:i:s");

$dteDiff = $dteEnd->diff($dteStart);

$past_date = $dteDiff->format('%R');

$day_left = $dteDiff->format('%d');

$hrs_left = $dteDiff->format('%h');

$net_hrs = $hrs_left + $day_left*24;

$minutes_left = $dteDiff->format('%i');

$net_minutes = $minutes_left + $net_hrs*60;

$seconds_left = $dteDiff->format('%s');

$net_seconds = $seconds_left + $net_minutes*60;

echo $net_minutes;

if($net_minutes >= 0 && $net_minutes <= 15 )

{

$this->dmlcourse->mark_attendance($data);

///redirect(site_url('ManipulateMeetings'));

}

function updatetopic()

{

$content="";

if($this->input->post('contenttype')=='Text')

{

$content = $this->input->post('topiccontent');

}

else

{

$content = $this->input->post('topiccontent1');

}

$data = array(

'TopicID' => $this->input->post('TopicID'),

'TopicType' => '3',

'TopicTitle' => $this->input->post('title'),

'CourseID' => $this->input->post('chapter'),

'TopicDesc' => $this->input->post('topicDesc'),

'TopicContent' => $content,

'StartDate' => $this->input->post('StartDate'),

'ContentType' => $this->input->post('contenttype'),

'price' => '0'

);

$scheduledate = $this->input->post('SessionSchedule');

//$datetime = new DateTime(str_replace('/', '-', $scheduledate));

$date=date_create($scheduledate);

$js_Date= date_format($date,"Y/m/d H:i:s");

//$diff_future = abs(strtotime($js_Date)-strtotime(date("/m/d/Y h:i:s")));

//$minutes = $diff_future/60;

$minutes = 60;

date_default_timezone_set("Asia/Karachi");

$dteStart = new DateTime($js_Date);

$dteEnd = new DateTime(date("Y/m/d h:i:sa"));

//echo $dteEnd->format("Y/m/d H:i:s");

$dteDiff = $dteEnd->diff($dteStart);

$past_date = $dteDiff->format('%R');

//echo $past_date;

if($past_date != '-')

{

$this->courses->updateTopic($data);

redirect(site_url('ManipulateMeetings'));

}

else

{

//$data['error'] ='<div class="alert alert-success" role="alert">Back Date Entry Not Allowed</div>';

//$data['Topics'] = $this ->dmlcourse->GetAllTopics('5');

redirect(site_url('addmeetings'));

}

function deletetopic($ID)

{

$this->courses->deleteTopics($ID);

redirect(site_url('ManipulateMeetings'));

}

function edittopic()

{

$session_data = $this->session->userdata('logged_in');

$username = $session_data['username'];

$topics = $this->session->userdata('topicdetail');

$htmlcontent = null;

$chapters = $this ->courses->GetChapter_Course($topics[0]['CourseID']);

$trns = $this ->courses->GetTrnTypes();

$courses_list = $this ->courses->GetCourses_Subject($topics[0]['Subject'],$username);

$subject_lists = $this ->courses->GetAllSubjects();

$content = "";

$trn_list="";

$course_list ="";

$subject_list="";

/*foreach($topics as $topic)

{

$content .= '<option value="'.$course['ID'].'">'.$course['Title'].'</option>';

}*/

$Medias = $this ->courses->GetAllMedia();

$tableRow = '';

$contenttypes="";

foreach($Medias as $Media) {

$tableRow = $tableRow .

'<tr class="gradeA odd" role="row">

<td class="sorting">'.$Media['MediaName'].'</td>

<td>'.$Media['MediaType'].'</td>

<td>

<button type="button" data-id="'.$Media['MediaName'].'" id="fetchMedia" class="btn btn-danger">Select</button>

</td>

</tr>';

}

$grid = '<div class="row">

</div>

<thead>

<th class="sorting" tabindex="0" aria-controls="dataTables-example" rowspan="1" style="width:15%" aria-label="CSS grade: activate to sort column ascending" style="width: 50px;">Action</th>

</tr>

</thead>

<tbody>'.$tableRow.'</tbody>

</table></div></div>

</div>

</div>';

$modal = '<div class="modal fade" id="exampleModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">

<h5 class="modal-title" id="exampleModalLabel">Content</h5>

</button>

</div>

<div class="modal-body">'.

$grid

.'</div>

</div>

</div>';

if(isset($topics)) {

foreach($topics as $topic) {

foreach($subject_lists as $subject_item)

{

if($subject_item['SubjectTitle']==$topic['Subject'])

{

$subject_list .= '<option selected value="'.$subject_item['SubjectTitle'].'">'.$subject_item['SubjectTitle'].'</option>';

}

else

{

$subject_list .= '<option value="'.$subject_item['SubjectTitle'].'">'.$subject_item['SubjectTitle'].'</option>';

}

foreach($courses_list as $courses_item)

{

if($courses_item['ID']==$topic['CourseID'])

{

$course_list .= '<option selected value="'.$courses_item['ID'].'">'.$courses_item['Title'].'</option>';

}

else

{

$course_list .= '<option value="'.$courses_item['ID'].'">'.$courses_item['Title'].'</option>';

}

foreach($chapters as $chapter)

{

if($chapter['ChapterID']==$topic['ChapterID'])

{

$content .= '<option selected value="'.$chapter['ChapterID'].'">'.$chapter['ChapterTitle'].'</option>';

}

else

{

$content .= '<option value="'.$chapter['ChapterID'].'">'.$chapter['ChapterTitle'].'</option>';

}

foreach($trns as $trn)

{

if ($topic['TopicType']==$trn['trn_type']) {

$trn_list .= '<option selected value="'.$trn['trn_type'].'">'.$trn['trn_name'].'</option>';

}

else

{

$trn_list .= '<option value="'.$trn['trn_type'].'">'.$trn['trn_name'].'</option>';

}

//$check=($course["Travelling"]!=null) ? "checked" : "";

if($topic['contenttype']=='File'){

$contenttypes ='

<input type="radio" name="contenttype" value="Text" autocomplete="off"> Text

</label>

<input type="radio" name="contenttype" value="File" autocomplete="off" checked> File

</label>

</div>

</br>

<label>Content</label>

</div>

<textarea style ="max-width:100%;height:150px;display:none;" name="topiccontent" type="text" class="form-control summernote"></textarea>';

}

else

{

$contenttypes ='

<input type="radio" name="contenttype" value="Text" autocomplete="off" checked> Text

</label>

<input type="radio" name="contenttype" value="File" autocomplete="off"> File

</label>

</div>

</br>

<label>Content</label>

</div>

<textarea style ="max-width:100%;height:150px" name="topiccontent" type="text" class="form-control summernote" required>'.$topic['TopicContent'].'</textarea>';

}

$htmlcontent = '<div class="panel-body">

<label>Subject</label>

<option value="">Yet To Select</option>

'.$subject_list.'

</select>

<label>Course</label>

<option value="">Yet To Select</option>

'.$course_list.'

</select>

<label>Chapter</label>

<select class="form-control" id="chapter" value="'.$topic['ChapterID'].'" name="chapter" required>'.$content.'</select>

<label>Title</label>

<label>Schedule DateTime</label>

</span>

</div>

<button type="submit" id="CreateZoomMeeting" style="background-color:#519CFE; color:white;" class="btn btn-default"><span class="fa fa-video-camera"> Re-Create Zoom Meeting</button>

<button type="submit" style="background-color:#5CB85C; color:white;" class="btn btn-default">Update Meeting</button>

<button type="reset" class="btn btn-default">Reset</button>

</form>

</div>

</div>

</div>

</div>';

}

$data['htmlcontent'] =$htmlcontent.$modal;

$data['error'] ='';

$this->load->view('addmeetings_view', array('content'=>$data['htmlcontent']));

}