<?php
	require_once('pdoconfig.php');

	$catid=$_REQUEST['catid'];
	$act=$_REQUEST['act'];
	$catname=$_REQUEST['cat_name'];
	$crs_name=$_REQUEST['crs_name'];
	$class_sch=$_REQUEST['class_sch'];
	$timings=$_REQUEST['timings'];
	$lvl=$_REQUEST['lvl'];
	$duration=$_REQUEST['duration'];
	$fee=$_REQUEST['fee'];
	$desc=$_REQUEST['desc'];
	$reg_chrg=$_REQUEST['reg_chrg'];
    $link=$_REQUEST['link'];
     $uploadresume=$_FILES["file"]["name"];
	//if($active=='on'){ $aa1=1;}else{ $aa1=0;}


/*if($category=='' || strlen($category)>50)
{
   die("Something went wrong! <br> <a href='category_master.php'>Continue</a>");   
}*/

       if($act == "add")
		{
			$sql="insert into aa_course_master set crs_name=?,class_sch=?, timings=?,fee=?,detail_link=?,description=?,reg_chrg=?"; 
			$arr=array($crs_name,$class_sch,$timings,$fee,$link,$desc,$reg_chrg);
			$res=$action->insertp($sql,$arr);
			$prod_id=$res;
	            if($res>0)
	            {
	                /***************Image1************************************/
           		 if($uploadresume!='')
                    {
		        $file_tmp =$_FILES['file']['tmp_name'];	   
	            $pos=strpos($uploadresume,".");     
	            if($uploadresume=="")
				{
				    $new_file_name="";
				}
				else
				{
    				$new_file_name="Course".'-'.$prod_id.substr($uploadresume, $pos,strlen($uploadresume)-$pos);
				}
				    move_uploaded_file($file_tmp,"upload/course_image/".$new_file_name);
    				//echo $new_file_name;
    				$qry="update aa_course_master set image=? where crs_id=?";
    				$arr=array($new_file_name,$prod_id);
    		        $action->updatep($qry,$arr);
			    }
			
	            ?>
			    <script>
			        alert("Data Save successfully");
			        window.location.href="course_master.php";				    
			    </script>
			    <?php
		    }
	    }
	    else if($act == "edit")
		{
			$sql="update aa_course_master set crs_name=?,class_sch=?, timings=?,fee=?,detail_link=?,description=?,reg_chrg=? where crs_id=?"; 
			$arr=array($crs_name,$class_sch,$timings,$fee,$link,$desc,$reg_chrg,$catid);			
			$res1=$action->updatep($sql,$arr);				
            $prod_id1=$res1;
            
	            if($res1>0)
	            {
	                	 if($uploadresume!='')
	            {
    		        $file_tmp =$_FILES['file']['tmp_name'];	   
	                $pos=strpos($uploadresume,".");     
	            if($uploadresume=="")
				{
				    $new_file_name="";
				}
				else
				{
    				$new_file_name="Course".'-'.$catid.substr($uploadresume, $pos,strlen($uploadresume)-$pos);
				}
				    move_uploaded_file($file_tmp,"upload/course_image/".$new_file_name);
				    $qry="update aa_course_master set image=? where crs_id=?";
				    $arr=array($new_file_name,$catid);
		            $action->updatep($qry,$arr);
			    }
	            ?>
			    <script>
			        alert("Data update successfully");
			        window.location.href="course_master.php";				    
			    </script>
			    <?php
		    }			
	    }
	    
	    else if($act == "del")
		{
			$sql="delete from aa_course_master where crs_id=?"; 
			
			$arr=array($catid);
			$res=$action->deletep($sql,$arr);
				

	            if($res)
	            {
	            ?>
			    <script>
			        alert("Data delete successfully");
			        window.location.href="course_master.php";				    
			    </script>
			    <?php
		    }	
	    }
	    
		
?>