/home/mip/public_html_/old-website/brokerxxx/sqldelete.php
<?php
// Files for deleting a field.
session_start();
require_once("common_msg.inc");
require_once("func_all.php");
$db = db_connect();

switch($what){

case 'officers':					 					
							
		 					$sql = "DELETE FROM company_officers WHERE officer_id=$officer_id"; 
              $result = mysql_query($sql);  
							echo mysql_error();
											
							header("Location: edit_configuration.php?msg=Officer deleted");											
      				break;

							
case 'user':       $sql = "DELETE FROM users WHERE user_id=$user_id"; 
                   $result = mysql_query($sql);  
							     echo mysql_error();
							     if($result){
									   header("Location: manage_user.php");
						       }
      				     break;

case 'applicant_status':       
		 							 
									 $duplicate = get_count("personal","status","$status");														
									 if(!empty($duplicate)) error_message('Cannot delete this status since an applicant has this status.');
														
									 $sql = "DELETE FROM applicant_status WHERE status='$status'"; 
                   $result = mysql_query($sql);  
							     echo mysql_error();

									   header("Location: manage_applicant_status.php");

      				     break;									 

case 'country':    
		 							 $mysql1 = "SELECT * from brokers WHERE country_id=$country_id";
		 							 $myresult1 = mysql_query($mysql1);									 
									 $num1 = mysql_num_rows($myresult1);
									 echo mysql_error();
								   
									 $mysql2 = "SELECT * from principals WHERE country_id=$country_id";
		 							 $myresult2 = mysql_query($mysql2);									 
									 $num2 = mysql_num_rows($myresult2);
									 echo mysql_error();
								   
									 $mysql3 = "SELECT * from personal WHERE country_id=$country_id";
		 							 $myresult3 = mysql_query($mysql3);									 
									 $num3 = mysql_num_rows($myresult3);
									 echo mysql_error();

									 if(($num1 || $num2 || $num3) > 0)
									 {									   
										 header("Location: manage_country.php?msg=Cannot be deleted since it is being used in the database.");		
										 exit;								 
								   }
									 
									 $sql = "DELETE FROM country WHERE country_id=$country_id";  
      					   $result = mysql_query($sql);  
								   echo mysql_error();
								   if($result){
									   header("Location: manage_country.php");										 
								   }
      					   break;
							
case 'broker':     
		 							 $mysql = "SELECT * from principals WHERE broker_id=$broker_id";
		 							 $myresult = mysql_query($mysql);									 
									 $num = mysql_num_rows($myresult);
									 echo mysql_error();

									 if($num > 0)
									 {									   
										 header("Location: manage_broker.php?msg=Cannot be deleted since it is being used in the database.");		
										 exit;								 
								   }
		 							 
									 $sql = "DELETE FROM brokers WHERE broker_id=$broker_id";
								   $result = mysql_query($sql);  
								   echo mysql_error();
								   if($result){
								     header("Location: manage_broker.php");
								   }
								   break;

case 'principal':  
		 							 $mysql = "SELECT * from process WHERE principal_id=$principal_id";
		 							 $myresult = mysql_query($mysql);									 
									 $num = mysql_num_rows($myresult);
									 echo mysql_error();
									 
									 $mysql = "SELECT * from job_order WHERE principal_id=$principal_id";
		 							 $myresult = mysql_query($mysql);									 
									 $num1 = mysql_num_rows($myresult);
									 echo mysql_error();
									 
									 $mysql = "SELECT * from cv_sents WHERE principal_id=$principal_id";
		 							 $myresult = mysql_query($mysql);									 
									 $num2 = mysql_num_rows($myresult);
									 echo mysql_error();
									 
									 if($num > 0 || $num1 > 0 || $num3 > 0)
									 {									   
										 header("Location: manage_principal.php?msg=Cannot be deleted since it is being used in the database.");		
										 exit;								 
								   }
									 
									 $sql = "DELETE FROM principals WHERE principal_id=$principal_id";
      						 $result = mysql_query($sql);  
									 echo mysql_error();
									 if($result){
									   header("Location: manage_principal.php");
									 }
      						 break;
  	 
case 'position':   
		 							 $mysql = "SELECT * from personal WHERE position_id1=$position_id || position_id2=$position_id";
		 							 $myresult = mysql_query($mysql);									 
									 $num = mysql_num_rows($myresult);
									 echo mysql_error();
									 
									 $mysql = "SELECT * from jo_position WHERE position_id=$position_id";
		 							 $myresult = mysql_query($mysql);									 
									 $num1 = mysql_num_rows($myresult);
									 echo mysql_error();
									 
									 if($num > 0 || $num1 > 0)
									 {									   
										 header("Location: manage_position.php?msg=Cannot be deleted since it is being used in the database.");		
										 exit;								 
								   }
									 
		 							 $sql = "DELETE FROM positions WHERE position_id=$position_id";
		 							 $result = mysql_query($sql);  
								   echo mysql_error();
								   if($result){
										 header("Location: manage_position.php");
								   }
      					   break;
														
case 'clinic':		 
		 							 $mysql = "SELECT * from medical WHERE clinic_id='$clinic_id'";
		 							 $myresult = mysql_query($mysql);									 
									 $num = mysql_num_rows($myresult);
									 echo mysql_error();

									 if($num > 0)
									 {									   
										 header("Location: manage_clinic.php?msg=Cannot be deleted since it is being used in the database.");		
										 exit;								 
								   }

		 							 $sql = "DELETE FROM clinics WHERE clinic_id=$clinic_id";		             
 									 $result = mysql_query($sql);  
									 echo mysql_error();
									 if($result){
										 header("Location: manage_clinic.php");
									 }
									 break;
									 
case 'education':	 
		 							 $sql = "DELETE FROM education WHERE id=$id";		             
 									 $result = mysql_query($sql);  
									 echo mysql_error();
									 if($result){
											header("Location: edit_education.php?Action=edit&applicant_id=$applicant_id");
									 }
									 break;

case 'employment':	 
		 							 $sql = "DELETE FROM employment WHERE id=$id";		             
 									 $result = mysql_query($sql);  
									 echo mysql_error();
									 if($result){
									  	header("Location: edit_employment.php?Action=edit&applicant_id=$applicant_id");
									 }
									 break;

case 'medical':	 
		 							 $sql = "DELETE FROM medical WHERE medical_id=$medical_id";		             
 									 $result = mysql_query($sql);  
									 echo mysql_error();
									 if($result){									 
									  	header("Location: edit_medical.php?Action=edit&applicant_id=$applicant_id");
									 }
									 break;

case 'training':	 
		 							 $sql = "DELETE FROM training WHERE training_id=$training_id";		             
 									 $result = mysql_query($sql);  
									 echo mysql_error();
									 if($result){									 
									  	header("Location: edit_training.php?Action=edit&applicant_id=$applicant_id");
									 }
									 break;
									 
case 'complaint':	 
		 							 $sql = "DELETE FROM complaints WHERE complaint_id=$complaint_id";		             
 									 $result = mysql_query($sql);  
									 echo mysql_error();
									 if($result){
									  	header("Location: edit_complaint.php?Action=edit&applicant_id=$applicant_id");
									 }
									 break;

case 'payment':	 
		 							 $sql = "DELETE FROM payment WHERE payment_id=$payment_id";		             
 									 $result = mysql_query($sql);  
									 echo mysql_error();
									 
									 $sql1 = "DELETE FROM payment_detail WHERE payment_id=$payment_id";		             
 									 $result1 = mysql_query($sql1);  
									 echo mysql_error();
									 
									 if($result){
									  	header("Location: edit_payment.php?Action=edit&applicant_id=$applicant_id");
									 }
									 break;

case 'payment_detail':	 
		 							      $sql = "DELETE FROM payment_detail WHERE id=$id";		             
 									 			$result = mysql_query($sql);  
									 			echo mysql_error();
									 			if($result){
													header("Location: edit_payment_detail.php?Action=edit&applicant_id=$applicant_id&payment_id=$payment_id");
									 			}
									 			break;
												
case 'applicant':	      
		 							      $mysql = "SELECT * from personal WHERE applicant_id='$applicant_id'";
		 							 			$myresult = mysql_query($mysql);
												$myrow = mysql_fetch_array($myresult);									 
									 			
												if($myrow[picture]){
												  $del_file =  unlink($pic_dir.$myrow[picture]);
												}
												
												$sql = "DELETE FROM personal WHERE applicant_id='$applicant_id'";		             
 									 			$result = mysql_query($sql);  
									 			echo mysql_error();
												
												$sql = "DELETE FROM complaints WHERE applicant_id='$applicant_id'";		             
 									 			$result = mysql_query($sql);  
									 			echo mysql_error();
												
												$sql = "DELETE FROM education WHERE applicant_id='$applicant_id'";		             
 									 			$result = mysql_query($sql);  
									 			echo mysql_error();
												
												$sql = "DELETE FROM employment WHERE applicant_id='$applicant_id'";		             
 									 			$result = mysql_query($sql);  
									 			echo mysql_error();
												
												
												$sql = "DELETE FROM medical WHERE applicant_id='$applicant_id'";		             
 									 			$result = mysql_query($sql);  
									 			echo mysql_error();
												
												$sql = "SELECT payment_id from payment WHERE applicant_id='$applicant_id'";		             
 									 			$myresult = mysql_query($sql);  
									 			echo mysql_error();
												
												while ($myrow = mysql_fetch_array($myresult)){
												  $payment_id = $myrow[payment_id];
												  $sql1 = "DELETE FROM payment_detail WHERE payment_id=$payment_id";		             
 									 			  $result1 = mysql_query($sql1);  
									 			  echo mysql_error();																								   
												}
									 			
												$sql = "DELETE FROM payment WHERE applicant_id='$applicant_id'";		             
 									 			$result = mysql_query($sql);  
									 			echo mysql_error();												
												
												$sql = "DELETE FROM prequalify WHERE applicant_id='$applicant_id'";		             
 									 			$result = mysql_query($sql);  
									 			echo mysql_error();
												
												$sql = "DELETE FROM process WHERE applicant_id='$applicant_id'";		             
 									 			$result = mysql_query($sql);  
									 			echo mysql_error();
																								
												$sql = "DELETE FROM training WHERE applicant_id='$applicant_id'";		             
 									 			$result = mysql_query($sql);  
									 			echo mysql_error();																																																																																																											
												
												if($result){
													header("Location: search_applicant.php?what=$next&date=$date&name=$name&num1=$num1&num2=$num2");
									 			}
									 			break;

case 'children':	 
		 							 $sql = "DELETE FROM children WHERE id=$id";		             
 									 $result = mysql_query($sql);  
									 echo mysql_error();
									 
									 header("Location: edit_dependents.php?applicant_id=$applicant_id");
									 
									 break;

case 'cv_sent':	 
		 							 $sql = "DELETE FROM cv_sents WHERE cvsent_id=$cvsent_id";		             
 									 $result = mysql_query($sql);  
									 echo mysql_error();
									 
									 header("Location: edit_cvsent.php?applicant_id=$applicant_id");
									 
									 break;												
									 
case 'job_order':	 
		 							 $mysql = "SELECT * from process WHERE job_order_id=$job_order_id";
		 							 $myresult = mysql_query($mysql);									 
									 $num = mysql_num_rows($myresult);
									 echo mysql_error();
									 									 
									 if($num > 0)
									 {									   
										 header("Location: manage_job_order.php?status=$status&msg=Cannot be deleted since it is being used in the database.");		
										 exit;								 
								   }
									 
									 $mysql = "SELECT * from jo_position WHERE job_order_id=$job_order_id";
		 							 $myresult = mysql_query($mysql);									 
									 $num1 = mysql_num_rows($myresult);
									 echo mysql_error();
									 									 
									 if($num1 > 0)
									 {									   
										 header("Location: manage_job_order.php?status=$status&msg=Pls. delete first the positions under this job order before you can delete it.");		
										 exit;								 
								   }
									 
									 $sql = "DELETE FROM job_order WHERE job_order_id=$job_order_id";		             
 									 $result = mysql_query($sql);  
									 echo mysql_error();
									 
									 $sql1 = "DELETE FROM jo_position WHERE job_order_id=$job_order_id";		             
 									 $result1 = mysql_query($sql1);  
									 echo mysql_error();
									 
									 if($result){
									  	header("Location: manage_job_order.php?status=$status");
									 }
									 break;

case 'jo_pos':	 
		 							 
									 $mysql = "SELECT * from process WHERE jo_pos_id=$jo_pos_id";
		 							 $myresult = mysql_query($mysql);									 
									 $num = mysql_num_rows($myresult);
									 echo mysql_error();
									 
									 $mysql = "SELECT * from cv_sents WHERE jo_pos_id=$jo_pos_id";
		 							 $myresult = mysql_query($mysql);									 
									 $num1 = mysql_num_rows($myresult);
									 echo mysql_error();
									 
									 if($num > 0 || $num1 > 0)
									 {									   
										 header("Location: edit_job_order.php?Action=edit&job_order_id=$job_order_id&msg=Cannot be deleted since it is being used in the database.");		
										 exit;								 
								   }
									 
									 $sql = "DELETE FROM jo_position WHERE jo_pos_id=$jo_pos_id";		             
 									 $result = mysql_query($sql);  
									 echo mysql_error();
									 
									 if($result){
									  	header("Location: edit_job_order.php?Action=edit&job_order_id=$job_order_id");
									 }
									 
									 break;		 
									 						 				
case 'visa':	 
		 							 $mysql = "SELECT * from process WHERE visa_id=$visa_id";
		 							 $myresult = mysql_query($mysql);									 
									 $num = mysql_num_rows($myresult);
									 echo mysql_error();
									 
									 if($num > 0)
									 {									   
										 header("Location: manage_visa.php?status=$status&msg=Cannot be deleted since it is being used in the database.");		
										 exit;								 
								   }
									 
									 $sql = "DELETE FROM visa WHERE visa_id=$visa_id";		             
 									 $result = mysql_query($sql);  
									 echo mysql_error();
									 
									 $sql1 = "DELETE FROM visa_position WHERE visa_id=$visa_id";		             
 									 $result1 = mysql_query($sql1);  
									 echo mysql_error();
									 
									 if($result){
									  	header("Location: manage_visa.php?status=$status");
									 }
									 break;

case 'visa_pos':	 
		 							 
									 $mysql = "SELECT * from process WHERE visa_pos_id=$visa_pos_id";
		 							 $myresult = mysql_query($mysql);									 
									 $num = mysql_num_rows($myresult);
									 echo mysql_error();
									 
									 if($num > 0)
									 {									   
										 header("Location: edit_visa.php?Action=edit&visa_id=$visa_id&msg=Cannot be deleted since it is being used in the database.");		
										 exit;								 
								   }
									 
									 $sql = "DELETE FROM visa_position WHERE visa_pos_id=$visa_pos_id";		             
 									 $result = mysql_query($sql);  
									 echo mysql_error();
									 
									 if($result){
									  	header("Location: edit_visa.php?Action=edit&visa_id=$visa_id");
									 }
									 
									 break;		 
									 																								 
case 'picture':	 		 							 									  											 																	
									 // delete the picture file attached to this person
							 	   if($picture) @$del_file =  unlink($pic_dir1.$picture);																		 			
											
									 $sql = "UPDATE personal SET picture='' WHERE applicant_id='$applicant_id'";
 									 $result = mysql_query($sql);  
									 echo mysql_error();									 
										
									 if($result){
									  	header("Location: edit_personal.php?Action=edit&applicant_id=$applicant_id");
									 }
									 break;
									 
case 'agency_logo':	 		 							 									  											 																	
									 // delete the agency logo
							 	   if($agency_logo) @unlink($agency_logo);																		 			
											
									 $sql = "UPDATE company SET agency_logo='' WHERE 1";
 									 $result = mysql_query($sql);  
									 echo mysql_error();									 
										
									 if($result){
									  	header("Location: edit_configuration.php");
									 }
									 break;									 
									  		
case 'agent':     
		 							 $mysql = "SELECT * from personal WHERE agent_id=$agent_id";
		 							 $myresult = mysql_query($mysql);									 
@									 $num = mysql_num_rows($myresult);

									 if($num > 0)
									 {									   
										 header("Location: manage_agent.php?msg=Cannot be deleted.");		
										 exit;								 
								   }
		 							 
									 $sql = "DELETE FROM acct_agents WHERE agent_id=$agent_id";
								   $result = mysql_query($sql);  
									 
									 header("Location: manage_agent.php");
								   break;
												
case 'account':    
 		 							 $mysql = "SELECT * from acct_expenses WHERE account_id=$account_id";
		 							 $myresult = mysql_query($mysql);									 
@									 $num = mysql_num_rows($myresult);
 		 							 $mysql = "SELECT * from acct_incomes WHERE account_id=$account_id";
		 							 $myresult = mysql_query($mysql);									 
@									 $num2 = mysql_num_rows($myresult);
									 if($num+$num2 > 0)			
									 {									   
										 header("Location: manage_accounts.php?msg=Cannot be deleted.");		
										 exit;								 
								   }
									 
                   $sql = "DELETE FROM acct_accounts WHERE account_id=$account_id"; 
                   $result = mysql_query($sql);  
									 header("Location: manage_accounts.php");
      				     break;									 
									 
case 'expense':    $sql = "DELETE FROM acct_expenses WHERE expense_id=$expense_id"; 
                   $result = mysql_query($sql);  
									 header("Location: input_expense.php");
      				     break;		
									 					 
case 'income':    $sql = "DELETE FROM acct_incomes WHERE income_id=$income_id"; 
                   $result = mysql_query($sql);  
									 header("Location: input_income.php");
      				     break;		
																	
																															 
}	
?>