About 20,871 results: "mysql_query"
Page 2 of 50
Filter Results
Sources
Languages
Lines
Any number of lines
Try Search On
  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. 	#echo $query;
  2. 	$resourceq = mysql_query($query,$database) ;
  3. 			$query = "update $GLOBALS[tablePrefix]filesystem set downloads=downloads+1 where id=$fileid";
  4. 			$result = mysql_query($query,$database);
  5. 		$query = "select * from $GLOBALS[tablePrefix]permissions inner join $GLOBALS[tablePrefix]clients on $GLOBALS[tablePrefix]permissions.clientid=$GLOBALS[tablePrefix]clients.id where userid=\"$_SESSION[userid]\" and $GLOBALS[tablePrefix]clients.name =\"$_SESSION[user]\" order by display";
  6. 		$result = mysql_query($query,$database);
  7. 		$query = "select * from $GLOBALS[tablePrefix]permissions inner join $GLOBALS[tablePrefix]clients on $GLOBALS[tablePrefix]permissions.clientid=$GLOBALS[tablePrefix]clients.id where userid=\"$_SESSION[userid]\" and $GLOBALS[tablePrefix]clients.name !=\"$_SESSION[user]\" order by display";
  8. 		$result = mysql_query($query,$database);
  9.       $query = "update $GLOBALS[tablePrefix]filesystem set description=\"$description\",flags=\"$flags\" where id=$fileid";
  10. 	  $result = mysql_query($query,$database);
  11. 	  $query = "update $GLOBALS[tablePrefix]filesystem set filename=\"$filename\" where id=$fileid";
  12. 	  $result = mysql_query($query,$database);
  13. 	    $query = "update $GLOBALS[tablePrefix]filesystem set path=\"$newPath\",rpath=\"$path/$newname\" where path=\"$currentPath\"";
  14. 	    $result = mysql_query($query,$database);
  15. 		  $query = "update $GLOBALS[tablePrefix]filesystem set path=\"$userNewPath\",rpath=\"$newpath/$name\" where path=\"$userPath\"";
  16. 		  $result = mysql_query($query,$database);









  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')");



  1.                 $tabel = "select * from penduduktrain";
  2. 				$hasilSelect = mysql_query($tabel) or die (mysql_error());
  3. 				$querycek = "select * from hasiltrain where hasil is not null";
  4. 				$c = mysql_query($querycek) or die (mysql_error());
  5. 				$queryPTsdPraSejahtera = "SELECT p.*,h.* FROM penduduktrain p, hasiltrain h WHERE p.nik = h.idpenduduk and p.pendidikanterakhir = 'SD' and h.hasil = 'PRASEJAHTERA'";
  6. 				$sdps = mysql_query($queryPTsdPraSejahtera) or die (mysql_error());
  7. 				$queryPTsmpSejahtera = "SELECT p.*,h.* FROM penduduktrain p, hasiltrain h WHERE p.nik = h.idpenduduk and p.pendidikanterakhir = 'SMP' and h.hasil = 'SEJAHTERA'";
  8. 				$smps = mysql_query($queryPTsdSejahtera) or die (mysql_error());
  9. 				$queryPTsmpPraSejahtera = "SELECT p.*,h.* FROM penduduktrain p, hasiltrain h WHERE p.nik = h.idpenduduk and p.pendidikanterakhir = 'SMP' and h.hasil = 'PRASEJAHTERA'";
  10. 				$smpps = mysql_query($queryPTsmpPraSejahtera) or die (mysql_error());
  11. 				$queryPTsmaSejahtera = "SELECT p.*,h.* FROM penduduktrain p, hasiltrain h WHERE p.nik = h.idpenduduk and p.pendidikanterakhir = 'SMA' and h.hasil = 'SEJAHTERA'";
  12. 				$smas = mysql_query($queryPTsmaSejahtera) or die (mysql_error());
  13. 				$queryPTsmaPraSejahtera = "SELECT p.*,h.* FROM penduduktrain p, hasiltrain h WHERE p.nik = h.idpenduduk and p.pendidikanterakhir = 'SMA' and h.hasil = 'PRASEJAHTERA'";
  14. 				$smaps = mysql_query($queryPTsmaPraSejahtera) or die (mysql_error());
  15. 				$queryPTd1Sejahtera = "SELECT p.*,h.* FROM penduduktrain p, hasiltrain h WHERE p.nik = h.idpenduduk and p.pendidikanterakhir = 'D1' and h.hasil = 'SEJAHTERA'";
  16. 				$d1s = mysql_query($queryPTd1Sejahtera) or die (mysql_error());



Back to Top