<?php 
include ("include/makeSession.php");
include("checksmsbalance.php");
$installment_id=mysqli_query($con,"select * from admin where id='".$_SESSION["ecomid"]."'");
	  $installment_id=mysqli_fetch_array($installment_id); 
$installment_id=$installment_id['menuper'];
	  $menuper=explode(',',$installment_id);
	   
	   if(in_array('Communication',$menuper)){
		  
	   }else{
		 
	header("location:index.php");
		   
		}
$_SESSION['page_name']="Communication";
include('include/function.php');
include("include/header.php");
include("include/sidebar.php");
if(isset($_REQUEST['did']) && $_REQUEST['did']!=''){
	$dovalue="";
	$doid=$_REQUEST['did'];
	mysqli_query($con,"delete from studentenquiry where StudenEnquiryID='$doid'");
	echo '<META HTTP-EQUIV="Refresh" Content="0; URL=Communication.php">';
	exit;
}
if(isset($_REQUEST['upid']) && $_REQUEST['upid']!=''){
	  $dovalue="EditStudentEnquiryEntry";
	  $doid=$_REQUEST['upid'];
	  $upuserresult=mysqli_query($con,"select * from student_enqury_form where id='".$_REQUEST['upid']."'");
	  $upuserarr=mysqli_fetch_array($upuserresult);
}else{
 	  $dovalue="SendSMSAdd";
	  $doid='';
} 
?>
<div class="content-wrapper">
  <!-- Content Header (Page header) -->
  <section class="content-header">
    <h1> Send SMS Course Wise <small></small> </h1>
    <ol class="breadcrumb">
      <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
      <li><a href="#">Send SMS Course Wise </a></li>
    </ol>
  </section>
  <!-- Main content -->
  <section class="content">
    <div class="row">
      <div class="col-md-12">
        <div class="box box-info">
          <div class="box-header">
            <h3 class="box-title"> Send SMS Course Wise <small></small></h3>
            <!-- tools box -->
            <div class="pull-right box-tools">
              <button class="btn btn-info btn-sm" data-widget="collapse" data-toggle="tooltip" title="Collapse"><i class="fa fa-minus"></i></button>
              <button class="btn btn-info btn-sm" data-widget="remove" data-toggle="tooltip" title="Remove"><i class="fa fa-times"></i></button>
            </div><!-- /. tools -->
          </div><!-- /.box-header -->
          <div class="box-body pad">
            <div class="col-md-8">
			 <form method="post" action="action.php" name="addcategory" id="addcategory" enctype="multipart/form-data"  role="form">
              <input type="hidden"  name="do" value="<?php echo $dovalue;?>" />
                <input type="hidden"  name="doid" value="<?php echo $doid;?>" />
				 <input type="hidden"  name="types" value="course" />
                <input type="hidden"  name="UserID" value="<?php echo $_SESSION["ecomid"];?>" />
              
               
             
                <div class="form-group">
                  <label>Course Name *</label>
				
                 <select name="coursetype" id="coursealert" class="form-control subject">
                      <option >Select</option>
					  <?php $CourseQuery=mysqli_query($con,"select * from course");
	  				 while($CasteRow=mysqli_fetch_array($CourseQuery)){ 
                     echo '<option value="'.$CasteRow['id'].'" '.($upuserarr['course_id'] == $CasteRow['id'] ? 'selected="selected"' : '' ).' >'.$CasteRow['c_name'].'</option>';
					 } ?>
                                       
                  </select> 

                                
                </div>
                <div class="form-group">
                  <label>Session *</label>
				
                 <select name="session" id="session" class="form-control subject">
                      <option >Select</option>
                      
                  </select> 

                                
                </div>
                <div class="form-group">
                  <label>Contact  </label>
				  
                     <textarea name="contacts" id="contacts" class="form-control"></textarea>         
                </div>
                           <div class="form-group">
                  <label>Send SMS <span id="smscount"></span>  </label>
				  
                     <textarea name="sms" id="smsbox" class="form-control"></textarea>         
                </div>                                                       
                <div class="box-footer">
                  <input type="submit" class="btn btn-primary" name="ctl00$ContentPlaceHolder1$btnsave" value="Send"/>        <input type="reset" name="ctl00$ContentPlaceHolder1$btn_reset" value="Reset" id="ContentPlaceHolder1_btn_reset" class="btn btn-primary">           
                </div>
              </form>
			
            </div>
          </div>
        </div><!-- /.box -->
      </div><!-- /.col-->
    </div><!-- ./row -->
  </section><!-- /.content -->
</div>
<?php include('include/footer.php');?>
<script>
$(document).ready(function(){
    $("#smsbox").keyup(function(){
        $('#smscount').html("");
        $('#smscount').append(""+Math.ceil(($('#smsbox').val()).length/140)+"");
    });
});
$('#coursealert').on('change',function(){
    var course=$('#coursealert').val();
    $.ajax({
        type: "POST",
        url: 'postcourse.php',
		dataType: "json",
        data:{"course":course,"type":"getsession"},
        success: function(obj){
		   if(obj.length!=0){
		       for(var i=0;i<obj.length;i++){
		           $('#session').append("<option value='"+obj[i].id+"'>"+obj[i].academictitle+"</option>");
		       }
		   }
        }
    });
});
$('#session').on('change',function(){  
  var vat=$('#coursealert :selected').val();	
  var session=$('#session :selected').val();
 /* if(vat=='B.ED'){	

  }	
  if(vat=='D.El.Ed.'){		
	
  }  */
  var strVal='';
   $.ajax({
                type: "POST",
                url: 'postcourse.php',
				dataType: "json",
                data:{"data":vat,"type":"course","session":session},
                success: function(obj){
                   console.log(obj);
				   var html='';
				   $.each( obj, function( key, value ) {
                     html+=value.mobileno+',';
                  });
				   var lastChar = html.slice(-1);
				  if (lastChar == ',') {
				  strVal = html.slice(0, -1);
				  }
				  $('#contacts').html(strVal);
                }
            });
  });	
  
</script>