About 21,464 results: "mysql_query"
Page 1 of 50
Filter Results
Sources
Languages
Filter Results
Try Search On



  1.     $csv_escaped = "\\";
  2. 	mysql_query("insert into report_info (id,type,filename,createdOn,createdBy,updatedOn,updatedBy) values('','agentwisetotalcalls','".@$filename."','".@$time."','0','".@$time."','0')");
  3. 	$totalleadstatusids = array(7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,33,26,37,38,39,42,43);
  4. 	$chktableExist = mysql_query('DROP TABLE IF EXISTS '.$table.' ') or die(mysql_error());
  5. FROM `lead` join user on user.id=lead.currentAllocatedId left join leadStatus LS on LS.leadStatusId=lead.leadStatusId where lead.updatedOn >= "'.@$start.'"  and lead.updatedOn <= "'.@$end.'" group by lead.currentAllocatedId';
  6. 	$esx = mysql_query($tableres) or die(mysql_error());
  7. 
                        
  8. mysql_query($queryforinsert);	
  9.     // Gets the data from the database
  10.     $result = mysql_query($sql_query) or die(mysql_error());
  11. 	$time = time();
  12. 	mysql_query("insert into report_info (id,type,filename,createdOn,createdBy,updatedOn,updatedBy) values('','agentfreshleadsdisposition','".@$filename."','".@$time."','".@$_SESSION['id']."','".@$time."','".@$_SESSION['id']."')");
  13. 	$totalleadstatusids = '7,8,9,10,37,38,11,12,42,43,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,33,39,43';
  14. 	$time = time();
  15. 	mysql_query("insert into report_info (id,type,filename,createdOn,createdBy,updatedOn,updatedBy) values('','agentfreshleadsdisposition','".@$filename."','".@$time."','0','".@$time."','0')");
  16. 	$chktableExist = mysql_query('DROP TABLE IF EXISTS '.$table.' ') or die(mysql_error());

  1. 	$totalleadstatusids = '7,8,9,10,37,38,11,12,42,43,13,14,15,16,17,18,19,30,21,22,23,24,25,26,27,28,29,30,33,39,43';
  2. 	mysql_query("insert into report_info (id,type,filename,createdOn,createdBy,updatedOn,updatedBy) values('','agentwisetotalcalls','".@$filename."','".@$time."','".@$_SESSION['id']."','".@$time."','".@$_SESSION['id']."')");
  3. 	$chktableExist = mysql_query('DROP TABLE IF EXISTS '.$table.' ') or die(mysql_error());
  4. FROM `lead` join user on user.id=lead.currentAllocatedId left join leadStatus LS on LS.leadStatusId=lead.leadStatusId where lead.leadStatusId !=36 AND lead.currentAllocatedDate >= "'.@$start.'"  and lead.currentAllocatedDate <= "'.@$end.'" AND lead.leadId IN(select leadId from lead where lead.updatedOn >= "'.@$start.'"  and lead.updatedOn <= "'.@$end.'"  and lead.currentAllocatedDate >= "'.@$start.'"  and lead.currentAllocatedDate <= "'.@$end.'" ) group by lead.currentAllocatedId';
  5. 	$esx = mysql_query($tableres) or die(mysql_error());
  6. 	select 'Total',SUM(`Total Diposed`), SUM(`Sale Done`), SUM(`Follow Up`), SUM(`Do Not Call - Will Buy self on Website`), SUM(`Duplicate - Already In Talk With Team`), SUM(`In Contact with Oflline Agent`), SUM(`In Touch With Other Partner`), SUM(`Short Hangup`), SUM(`Call Later`), SUM(`Ringing Less Than Five Tries`), SUM(`Switched Off Less than Five Tries`), SUM(`Not Interested - Fund Problem`), SUM(`Just Checking Website`), SUM(`Not Interested - Insured From Employer`), SUM(`Not Interested - High Premium`), SUM(`Under Age`), SUM(`Not Visited Website`), SUM(`Do Not Call`), SUM(`Not Interested - General`), SUM(`Over Age`), SUM(`Not Interested - Already Insured`), SUM(`Duplicate Data - Not Interested`), SUM(`Not Eligible - PED`), SUM(`Not Interested - Govt. Employee`), SUM(`Not Interested - Senior Citizen`), SUM(`Wrong Number`), SUM(`Customer Not Available`), SUM(`Language Barrier`), SUM(`No Response`), SUM(`Invalid Number`), SUM(`Junk`), SUM(`Ringing no response after five tries`), SUM(`Switched Off/ Not Reachable after 5 tries`) from ".$table."";
  7. mysql_query($queryforinsert);	
  8.     // Gets the data from the database
  9.     $result = mysql_query($sql_query);
  10.  from leadSourceMaster LS left join lead L on L.ws_agentid=LS.leadSourceCode where L.leadStatusId !=36 AND  L.updatedOn >= "'.@$start.'"  and L.updatedOn <= "'.@$end.'" group by L.leadStatusId,LS.leadSourceCode';
  11. 	$esx = mysql_query($tableres) or die(mysql_error());
  12. 	select SUM(`Total Diposed`), SUM(`Sale Done`), SUM(`Follow Up`), SUM(`Do Not Call - Will Buy self on Website`), SUM(`Duplicate - Already In Talk With Team`), SUM(`In Contact with Oflline Agent`), SUM(`In Touch With Other Partner`), SUM(`Short Hangup`), SUM(`Call Later`), SUM(`Ringing Less Than Five Tries`), SUM(`Switched Off Less than Five Tries`), SUM(`Not Interested - Fund Problem`), SUM(`Just Checking Website`), SUM(`Not Interested - Insured From Employer`), SUM(`Not Interested - High Premium`), SUM(`Under Age`), SUM(`Not Visited Website`), SUM(`Do Not Call`), SUM(`Not Interested - General`), SUM(`Over Age`), SUM(`Not Interested - Already Insured`), SUM(`Duplicate Data - Not Interested`), SUM(`Not Eligible - PED`), SUM(`Not Interested - Govt. Employee`), SUM(`Not Interested - Senior Citizen`), SUM(`Wrong Number`), SUM(`Customer Not Available`), SUM(`Language Barrier`), SUM(`No Response`), SUM(`Invalid Number`), SUM(`Junk`), SUM(`Ringing no response after five tries`), SUM(`Switched Off/ Not Reachable after 5 tries`) from ".$table."";
  13. mysql_query($queryforinsert);	
  14.     // Gets the data from the database
  15.     $result = mysql_query($sql_query);

  1. 	$totalleadstatusids = '7,8,9,10,37,38,11,12,42,43,13,14,15,16,17,18,19,30,21,22,23,24,25,26,27,28,29,30,33,39,43';
  2. 	mysql_query("insert into report_info (id,type,filename,createdOn,createdBy,updatedOn,updatedBy) values('','agentwisetotalcalls','".@$filename."','".@$time."','".@$_SESSION['id']."','".@$time."','".@$_SESSION['id']."')");
  3. 	$chktableExist = mysql_query('DROP TABLE IF EXISTS '.$table.' ') or die(mysql_error());
  4. 	$tableres ='create table IF NOT EXISTS '.$table.' as SELECT
  5. FROM `lead` join user on user.id=lead.currentAllocatedId left join leadStatus LS on LS.leadStatusId=lead.leadStatusId where lead.leadStatusId !=36 AND lead.updatedOn >= "'.@$start.'"  and lead.updatedOn <= "'.@$end.'" group by lead.currentAllocatedId';
  6. 	$esx = mysql_query($tableres) or die(mysql_error());
  7. 	select 'Total',SUM(`Total Diposed`), SUM(`Sale Done`), SUM(`Follow Up`), SUM(`Do Not Call - Will Buy self on Website`), SUM(`Duplicate - Already In Talk With Team`), SUM(`In Contact with Oflline Agent`), SUM(`In Touch With Other Partner`), SUM(`Short Hangup`), SUM(`Call Later`), SUM(`Ringing Less Than Five Tries`), SUM(`Switched Off Less than Five Tries`), SUM(`Not Interested - Fund Problem`), SUM(`Just Checking Website`), SUM(`Not Interested - Insured From Employer`), SUM(`Not Interested - High Premium`), SUM(`Under Age`), SUM(`Not Visited Website`), SUM(`Do Not Call`), SUM(`Not Interested - General`), SUM(`Over Age`), SUM(`Not Interested - Already Insured`), SUM(`Duplicate Data - Not Interested`), SUM(`Not Eligible - PED`), SUM(`Not Interested - Govt. Employee`), SUM(`Not Interested - Senior Citizen`), SUM(`Wrong Number`), SUM(`Customer Not Available`), SUM(`Language Barrier`), SUM(`No Response`), SUM(`Invalid Number`), SUM(`Junk`), SUM(`Ringing no response after five tries`), SUM(`Switched Off/ Not Reachable after 5 tries`) from ".$table."";
  8. mysql_query($queryforinsert);	
  9. 	$time = time();
  10. 	mysql_query("insert into report_info (id,type,filename,createdOn,createdBy,updatedOn,updatedBy) values('','agentfreshleadsdisposition','".@$filename."','".@$time."','".@$_SESSION['id']."','".@$time."','".@$_SESSION['id']."')");
  11. 	$totalleadstatusids = '7,8,9,10,37,38,11,12,42,43,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,33,39,43';
  12. 	$chktableExist = mysql_query('DROP TABLE IF EXISTS '.$table.' ') or die(mysql_error());
  13.     $csv_escaped = "\\";
  14. 	mysql_query("insert into report_info (id,type,filename,createdOn,createdBy,updatedOn,updatedBy) values('','campaignwisedispositiondaily','".@$filename."','".@$time."','".@$_SESSION['id']."','".@$time."','".@$_SESSION['id']."')");
  15. 	$chktableExist = mysql_query('DROP TABLE IF EXISTS '.$table.' ') or die(mysql_error());
  16. 	$tableres ='create table IF NOT EXISTS '.$table.' as SELECT LS.leadSourceCode as `Agent Code`,LS.leadSourceTitle as `Name`,count(L.ws_agentid) as `Total Diposed`,


  1.     protected function tearDown() {
  2.     	$this->assertTrue(mysql_query("TRUNCATE TABLE `hs_hr_hsp_summary`"));
  3.     	$this->assertTrue(mysql_query("TRUNCATE TABLE `hs_hr_employee`"));
  4.     	$this->assertTrue(mysql_query("UPDATE `hs_hr_config` SET `value` = '0' WHERE `key` = 'hsp_current_plan'"));
  5.     }
  6. 
                        
  7. 		$this->assertTrue(mysql_query("TRUNCATE TABLE `hs_hr_pay_period`"));
  8. 		$this->assertTrue(mysql_query("TRUNCATE TABLE `hs_hr_hsp_summary`"));
  9. 
                        
  10. 		// Here 'check dates' don't mach with pay periods. They have been added to get three past check dates from current day.
  11. 		$this->assertTrue(mysql_query("INSERT INTO hs_hr_pay_period VALUES(1, '".date('Y')."-01-01', '".date('Y')."-01-31', '".date('Y')."-01-31', '".date('Y-m-d', time()-3600*24*3)."', '".date('Y')."-01-20')"));
  12. 		$this->assertTrue(mysql_query("INSERT INTO hs_hr_pay_period VALUES(2, '".date('Y')."-02-01', '".date('Y')."-02-29', '".date('Y')."-02-29', '".date('Y-m-d', time()-3600*24*2)."', '".date('Y')."-02-20')"));
  13. 		$this->assertTrue(mysql_query("INSERT INTO hs_hr_pay_period VALUES(3, '".date('Y')."-03-01', '".date('Y')."-03-31', '".date('Y')."-03-31', '".date('Y-m-d', time()-3600*24*1)."', '".date('Y')."-03-20')"));
  14. 
                        
  15. 		// Summary Insert
  16. 		$this->assertTrue(mysql_query("INSERT INTO hs_hr_hsp_summary VALUES(1, 1, 1, '".date('Y')."', 1, 1500, 50, 50, 0, 0)"), mysql_error());
  17. 		$this->assertTrue(mysql_query("INSERT INTO hs_hr_hsp_summary VALUES(2, 2, 1, '".date('Y')."', 1, 2500, 75, 75, 0, 0)"), mysql_error());







  1. 
                        
  2.             $result = mysql_query($sql);
  3.                 //delete cart
  4.                 mysql_query("DELETE FROM ticket_cart_details WHERE cart_id='".$row['id']."'") or die(mysql_error());
  5.                 mysql_query("DELETE FROM ticket_seat_booked WHERE cart_id='".$row['id']."'") or die(mysql_error());
  6.                 mysql_query("DELETE FROM ticket_carts WHERE id='".$row['id']."'") or die(mysql_error());
  7.             }
  8.             $userCountry = "select  user_details.c_id  , countries.country_name ,state.Name, user_details.state, user_details.city , CONCAT_WS(',',city_master.city_name,state.Name,countries.country_name) as CurrentLocation  from user_details LEFT JOIN  countries On  countries.id = user_details.c_id  LEFT JOIN state ON state.id = user_details.state LEFT JOIN city_master ON  user_details.city = city_master.city_id where user_details.user_id= ".$_SESSION['UserId']." ";
  9.             $userCountry_res = mysql_query($userCountry);
  10.                 $userCountry = "select  countries.id  , countries.country_name from countries Where countries.id = '6'";
  11.                 $userCountry_res = mysql_query($userCountry);
  12.         $userCountry = "select  IFNULL(countries.id,0) as countryId  ,  IFNULL(countries.country_name,'') as countryName  ,IFNULL(state.Name,'')as StateName, IFNULL(state.id,0) as StateId, IFNULL(city_master.city_id,0) as CityId , IFNULL(city_master.city_name,'')as CityName from countries LEFT JOIN state ON  state.c_id = countries.id  and state.id = ".$_REQUEST['province']." LEFT JOIN city_master ON  state_id = state.id and city_id = ".$_REQUEST['city']." where countries.id = ".$_REQUEST['country']."";
  13.         $userCountry_res = mysql_query($userCountry)or die(mysql_error());
  14.         $evtcat['0']="Select Category";
  15.         $select_ticket_cat = mysql_query("Select * from ticket_event_category");




  1. 
                        
  2. 		mysql_query("INSERT INTO `hs_hr_emp_reportto` VALUES ('012', '011', 1);");
  3. 
                        
  4. 		mysql_query("INSERT INTO `hs_hr_leavetype` VALUES ('LTY010', 'Medical', 1)");
  5. 
                        
  6. 		mysql_query("TRUNCATE TABLE `hs_hr_weekends`;");
  7. 		$this->assertTrue(mysql_query("INSERT INTO `hs_hr_weekends` (day, length) VALUES (1, 0);"), mysql_error());
  8. 		$this->assertTrue(mysql_query("INSERT INTO `hs_hr_weekends` (day, length) VALUES (2, 0);"), mysql_error());
  9. 		$this->assertTrue(mysql_query("INSERT INTO `hs_hr_weekends` (day, length) VALUES (3, 0);"), mysql_error());
  10. 		$this->assertTrue(mysql_query("INSERT INTO `hs_hr_weekends` (day, length) VALUES (4, 0);"), mysql_error());
  11. 		$this->assertTrue(mysql_query("INSERT INTO `hs_hr_weekends` (day, length) VALUES (5, 0);"), mysql_error());
  12. 		$this->assertTrue(mysql_query("INSERT INTO `hs_hr_weekends` (day, length) VALUES (6, 0);"), mysql_error());
  13. 		$this->assertTrue(mysql_query("INSERT INTO `hs_hr_weekends` (day, length) VALUES (7, 0);"), mysql_error());
  14. 
                        
  15. 		//Leave 1
  16. 		mysql_query("INSERT INTO `hs_hr_leave_requests` (`leave_request_id`, `leave_type_id`, `leave_type_name`, `date_applied`, `employee_id`) VALUES (10, 'LTY010', 'Medical', '".date('Y-m-d', time()+3600*24)."', '011')");
  17. 		mysql_query("INSERT INTO `hs_hr_leave` (`leave_request_id`, `leave_id`, `employee_id`, `leave_type_id`, `leave_date`, `leave_length_days`, `leave_length_hours`, `leave_status`, `leave_comments`) VALUES (10, 10, '011', 'LTY010', '".date('Y-m-d', time()+3600*24)."', 0.12, 1, 1, 'Leave 1')");


Back to Top