<?php
	require_once('pdoconfig.php');
	
	$catid=$_REQUEST['catid'];
	$pid=$_REQUEST['project_id'];
	$act=$_REQUEST['act'];
	$pname=$_REQUEST['pname'];
	$plink=$_REQUEST['plink'];
	$user=$_REQUEST['user'];
	$action1=$_REQUEST['action'];
    $uploadresume=$_FILES["file"]["name"];
	


       if($act == "add")
		{
			$sql="insert into aa_advertisement_master set video_name=?,audio_link=?,approve=?"; 
			$arr=array($pname,$plink,$action1);
			$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="adv".'-'.$prod_id.substr($uploadresume, $pos,strlen($uploadresume)-$pos);
				}
				move_uploaded_file($file_tmp,"upload/projects/".$new_file_name);
				//echo $new_file_name;
				$qry="update aa_advertisement_master set file=? where adv_id=?";
				$arr=array($new_file_name,$prod_id);
		        $action->updatep($qry,$arr);
			}
			
	            ?>
			    <script>
			        alert("Data Save successfully");
			        window.location.href="advertisement_master.php";				    
			    </script>
			    <?php
		    }
	    }
	    else if($act == "edit")
		{
			$sql="update aa_advertisement_master set video_name=?,audio_link=?, approve=? where adv_id=?"; 
			$arr=array($pname,$plink,$action1,$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="adv".'-'.$catid.substr($uploadresume, $pos,strlen($uploadresume)-$pos);
				}
				move_uploaded_file($file_tmp,"upload/projects/".$new_file_name);
			
				$qry="update aa_advertisement_master set file=? where adv_id=?";
				$arr=array($new_file_name,$catid);
		        $action->updatep($qry,$arr);
			}
	            ?>
			    <script>
			        alert("Data update successfully");
			        window.location.href="advertisement_master.php";				    
			    </script>
			    <?php
		    }			
	    }
	    
	    else if($act == "del")
		{
		  
			$sql="delete from aa_advertisement_master where adv_id=?"; 
		//	echo $sql;
		//	die();
			$arr=array($pid);
			
			$res=$action->deletep($sql,$arr);
				
	            if($res)
	            {
	            ?>
			    <script>
			        alert("Data delete successfully");
			        window.location.href="advertisement_master.php";				    
			    </script>
			    <?php
		    }			
	    }
	    
		
?>