About 293 results: "mysql_query repo:lecturer34/hrmis"
Page 1 of 15
Filter Results
Sources
Languages
Filter Results
Try Search On


viewcv.php in hrmis https://bitbucket.org/lecturer34/hrmis | 996 lines | PHP
  1. GetSQLValueString($employid_emploeeRec, "int"));
  2. $emploeeRec = mysql_query($query_emploeeRec, $cnpgdataport) or die(mysql_error());
  3. $query_confirmation = sprintf("SELECT effectivedate FROM tblconfirmation WHERE employeeid = %s", GetSQLValueString($colname_confirmation, "int"));
  4. $confirmation = mysql_query($query_confirmation, $cnpgdataport) or die(mysql_error());
  5. $query_positions = sprintf("SELECT * FROM tblpositionsheld WHERE employeeid = %s", GetSQLValueString($colname_positions, "int"));
  6. $positions = mysql_query($query_positions, $cnpgdataport) or die(mysql_error());
  7. $query_profSoc = sprintf("SELECT * FROM tblprofmembership WHERE employeeid = %s", GetSQLValueString($colname_profSoc, "int"));
  8. $profSoc = mysql_query($query_profSoc, $cnpgdataport) or die(mysql_error());
  9. $query_teaching = sprintf("SELECT * FROM tblteaching WHERE employeeid = %s", GetSQLValueString($colname_teaching, "int"));
  10. $teaching = mysql_query($query_teaching, $cnpgdataport) or die(mysql_error());
  11. $query_adminduties = sprintf("SELECT tbladminduty.dutylevel, tbladminduty.datefrom, tbladminduty.dateto, tbladminduty.institution, tbladmindutytype.dutyname  FROM tbladminduty, tbladmindutytype WHERE employeeid = %s AND tbladminduty.dutytype=tbladmindutytype.dutytypeid", GetSQLValueString($colname_adminduties, "int"));
  12. $adminduties = mysql_query($query_adminduties, $cnpgdataport) or die(mysql_error());
  13. //echo $query_localconferences; exit;
  14. $localconferences = mysql_query($query_localconferences, $cnpgdataport) or die(mysql_error());
  15. $query_internationalconf = sprintf("SELECT * FROM tblconferences WHERE employeeid = %s AND tblconferences.conferencetype='international' ORDER BY datefrom DESC", GetSQLValueString($colname_internationalconf, "int"));
  16. $internationalconf = mysql_query($query_internationalconf, $cnpgdataport) or die(mysql_error());


computecv.php in hrmis https://bitbucket.org/lecturer34/hrmis | 712 lines | PHP
  1. //echo $query;
  2. $result = @mysql_query($query) or die(mysql_error());
  3. GetSQLValueString($employid_emploeeRec, "int"));
  4. $emploeeRec = mysql_query($query_emploeeRec) or die(mysql_error());
  5. $query_confirmation = sprintf("SELECT effectivedate FROM tblconfirmation WHERE employeeid = %s", GetSQLValueString($colname_confirmation, "int"));
  6. $confirmation = mysql_query($query_confirmation) or die(mysql_error());
  7. $query_promotion = sprintf("SELECT personnelno, rank, salaryid, effectivedate FROM tblpromotions WHERE employeeid = %s", GetSQLValueString($colname_promotion, "int"));
  8. $promotion = mysql_query($query_promotion) or die(mysql_error());
  9. $query_contactaddr = sprintf("SELECT tblcontactaddr.city, tblcontactaddr.`state`, tblcontactaddr.contactaddress, tblstate.statename  FROM tblcontactaddr, tblstate WHERE employeeid = %s AND tblstate.stateid=tblcontactaddr.`state`", GetSQLValueString($colname_contactaddr, "int"));
  10. $contactaddr = mysql_query($query_contactaddr) or die(mysql_error());
  11. $query_workexp = sprintf("SELECT * FROM tblempworkingexp WHERE employeeid = %s ORDER BY `from` DESC", GetSQLValueString($colname_workexp, "int"));
  12. $workexp = mysql_query($query_workexp) or die(mysql_error());
  13. $query_adminduties = sprintf("SELECT tbladminduty.dutylevel, tbladminduty.datefrom, tbladminduty.dateto, tbladminduty.institution, tbladmindutytype.dutyname  FROM tbladminduty, tbladmindutytype WHERE employeeid = %s AND tbladminduty.dutytype=tbladmindutytype.dutytypeid", GetSQLValueString($colname_adminduties, "int"));
  14. $adminduties = mysql_query($query_adminduties) or die(mysql_error());
  15. //echo $query_localconferences; exit;
  16. $localconferences = mysql_query($query_localconferences) or die(mysql_error());

viewcv.php in hrmis https://bitbucket.org/lecturer34/hrmis | 654 lines | PHP
  1. GetSQLValueString($employid_emploeeRec, "int"));
  2. $emploeeRec = mysql_query($query_emploeeRec) or die(mysql_error());
  3. $query_confirmation = sprintf("SELECT effectivedate FROM tblconfirmation WHERE employeeid = %s", GetSQLValueString($colname_confirmation, "int"));
  4. $confirmation = mysql_query($query_confirmation) or die(mysql_error());
  5. $query_profSoc = sprintf("SELECT * FROM tblprofmembership WHERE employeeid = %s", GetSQLValueString($colname_profSoc, "int"));
  6. $profSoc = mysql_query($query_profSoc) or die(mysql_error());
  7. $query_teaching = sprintf("SELECT * FROM tblteaching WHERE employeeid = %s", GetSQLValueString($colname_teaching, "int"));
  8. $teaching = mysql_query($query_teaching) or die(mysql_error());
  9. $query_adminduties = sprintf("SELECT tbladminduty.dutylevel, tbladminduty.datefrom, tbladminduty.dateto, tbladminduty.institution, tbladmindutytype.dutyname  FROM tbladminduty, tbladmindutytype WHERE employeeid = %s AND tbladminduty.dutytype=tbladmindutytype.dutytypeid", GetSQLValueString($colname_adminduties, "int"));
  10. $adminduties = mysql_query($query_adminduties) or die(mysql_error());
  11. //echo $query_localconferences; exit;
  12. $localconferences = mysql_query($query_localconferences) or die(mysql_error());
  13. $query_internationalconf = sprintf("SELECT * FROM tblconferences WHERE employeeid = %s AND tblconferences.conferencetype='international' ORDER BY datefrom DESC", GetSQLValueString($colname_internationalconf, "int"));
  14. $internationalconf = mysql_query($query_internationalconf) or die(mysql_error());
  15. $query_publications = sprintf("SELECT  tbljournalspublication.title, tbljournalspublication.journalname, tbljournalspublication.authors, tbljournalspublication.publicationdate, tbljournalspublication.url, tblpublictiontype.publictiontypeid, tblpublictiontype.eventoractivity FROM tbljournalspublication, tblpublictiontype WHERE tblpublictiontype.publictiontypeid=tbljournalspublication.typeid AND tbljournalspublication.employeeid=%s and typeid=1", GetSQLValueString($emplid_publications, "int"));
  16. $publications = mysql_query($query_publications) or die(mysql_error());


recruitmentreport.ajax.php in hrmis https://bitbucket.org/lecturer34/hrmis | 714 lines | PHP
  1.     $result3 = mysql_query($sql3);
  2.     $result4 = mysql_query($sql4);
  3. 
                        
  4. 
                        
  5.     $result = mysql_query($sql);
  6. 
                        
  7.     $result = mysql_query($sql);
  8. 
                        
  9.     $result = mysql_query($sql);
  10. 	
  11.     $result = mysql_query($sql);
  12. $sqlsearch = "SELECT tblapplicantsdetails.appaccountrowid as rowid, tblapplicantsdetails.titleid as tid, tblsalutations_lookup.salutation as salute, tblapplicantsdetails.surname as sname, tblapplicantsdetails.firstname as fname, tblapplicantsdetails.othernames as oname, concat(salutation,' ', surname,', ', firstname,' ', othernames) as fullname, tblapplicantsaccount.accountemail as email, tblapplicantsdetails.birthdate as dob, tblapplicantsdetails.birthplace as pob, tblapplicantsdetails.hometown as htw FROM tblapplicantsaccount INNER JOIN tblapplicantsdetails ON (tblapplicantsdetails.appaccountrowid = tblapplicantsaccount.account_rowid) INNER JOIN tblsalutations_lookup ON (tblapplicantsdetails.titleid = tblsalutations_lookup.salutationid) WHERE tblapplicantsdetails.surname LIKE $name OR tblapplicantsdetails.firstname LIKE $name OR tblapplicantsdetails.othernames LIKE $name OR tblsalutations_lookup.salutation LIKE $name";
  13. $querysearch = mysql_query($sqlsearch);
  14. $sqlsearch = "SELECT tbldepartment.name AS dnm, tblrank.name AS rnm, tblvacancies.vacantslots as vsl, tblvacancies.vacancyid as vid, tblvacancies.jobschedule as jsh, tblvacancies.jobshifts as jsf, tblvacancies.status as sts, tblvacancies.vacancyreason as vrs, tblvacancies.isadvertised as adv, tblvacancies.effectivedate as eff FROM tblvacancies INNER JOIN tbldepartment ON (tblvacancies.departmentid = tbldepartment.departmentid) INNER JOIN tblrank ON (tblvacancies.rankid = tblrank.rankid) WHERE tblrank.name LIKE $jname";
  15. $querysearch = mysql_query($sqlsearch);


advertreport.php in hrmis https://bitbucket.org/lecturer34/hrmis | 344 lines | PHP
  1. $query_vcDate = "SELECT tbldepartment.name AS dnm, tblrank.name AS rnm, tblvacancies.vacantslots as vsl, tblvacancies.vacancyid as vid, tblvacancies.jobschedule as jsh, tblvacancies.jobshifts as jsf, tblvacancies.status as sts, tblvacancies.vacancyreason as vrs, tblvacancies.isadvertised as adv, tblvacancies.effectivedate as eff FROM tblvacancies INNER JOIN tbldepartment ON (tblvacancies.departmentid = tbldepartment.departmentid) INNER JOIN tblrank ON (tblvacancies.rankid = tblrank.rankid)";
  2. $vcDate = mysql_query($query_vcDate, $hrConn) or die(mysql_error());
  3. $query_lsFacCen = "SELECT facid, fame FROM tblfaccentres";
  4. $lsFacCen = mysql_query($query_lsFacCen, $hrConn) or die(mysql_error());
  5. $query_lsDeps = "SELECT * FROM tbldepartment";
  6. $lsDeps = mysql_query($query_lsDeps, $hrConn) or die(mysql_error());
  7. $query_vacQty = "SELECT COUNT(vacancyid) as vacqty FROM tblvacancies";
  8. $vacQty = mysql_query($query_vacQty, $hrConn) or die(mysql_error());
  9. $query_advQty = "SELECT COUNT(advertisementid) as advqty FROM tbladvertisements";
  10. $advQty = mysql_query($query_advQty, $hrConn) or die(mysql_error());
  11. $query_appQty = "SELECT COUNT(account_rowid) as appqty FROM tblapplicantsaccount";
  12. $appQty = mysql_query($query_appQty, $hrConn) or die(mysql_error());
  13. $query_empQty = "SELECT SUM(vacantslots) as empqty, status FROM tblvacancies WHERE status = 'Occupied'";
  14. $empQty = mysql_query($query_empQty, $hrConn) or die(mysql_error());
  15. $query_pos = "SELECT * FROM tblrank ORDER BY name ASC";
  16. $pos = mysql_query($query_pos, $hrConn) or die(mysql_error());









interfacejobs.php in hrmis https://bitbucket.org/lecturer34/hrmis | 291 lines | PHP
  1. $query_pos = "SELECT * FROM tblrank ORDER BY name ASC";
  2. $pos = mysql_query($query_pos, $hrConn) or die(mysql_error());
  3. $query_summ = "SELECT tblapplicantsdetails.appaccountrowid as rowid, tblapplicantsdetails.titleid as tid, tblsalutations_lookup.salutation as salute,  tblapplicantsdetails.surname as sname, tblapplicantsdetails.firstname as fname, tblapplicantsdetails.othernames as oname, concat(salutation,' ', surname,', ', firstname,' ', othernames) as fullname, tblapplicantsaccount.accountemail as email, tblapplicantsdetails.birthdate as dob, tblapplicantsdetails.birthplace as pob, tblapplicantsdetails.hometown as htw FROM tblapplicantsaccount INNER JOIN tblapplicantsdetails ON (tblapplicantsdetails.appaccountrowid = tblapplicantsaccount.account_rowid) INNER JOIN tblsalutations_lookup ON (tblapplicantsdetails.titleid = tblsalutations_lookup.salutationid)";
  4. $summ = mysql_query($query_summ, $hrConn) or die(mysql_error());
  5. $query_limit_jobs = sprintf("%s LIMIT %d, %d", $query_jobs, $startRow_jobs, $maxRows_jobs);
  6. $jobs = mysql_query($query_limit_jobs, $hrConn) or die(mysql_error());
  7. } else {
  8.   $all_jobs = mysql_query($query_jobs);
  9. 	$sqlsearch = "SELECT tblapplicantsdetails.appaccountrowid as rowid, tblapplicantsdetails.titleid as tid, tblsalutations_lookup.salutation as salute, tblapplicantsdetails.surname as sname, tblapplicantsdetails.firstname as fname, tblapplicantsdetails.othernames as oname, concat(salutation,' ', surname,', ', firstname,' ', othernames) as fullname, tblapplicantsaccount.accountemail as email, tblapplicantsdetails.birthdate as dob, tblapplicantsdetails.birthplace as pob, tblapplicantsdetails.hometown as htw FROM tblapplicantsaccount INNER JOIN tblapplicantsdetails ON (tblapplicantsdetails.appaccountrowid = tblapplicantsaccount.account_rowid) INNER JOIN tblsalutations_lookup ON (tblapplicantsdetails.titleid = tblsalutations_lookup.salutationid) WHERE tblapplicantsdetails.surname LIKE $name OR tblapplicantsdetails.firstname LIKE $name OR tblapplicantsdetails.othernames LIKE $name OR tblsalutations_lookup.salutation LIKE $name";
  10. 	$querysearch = mysql_query($sqlsearch);


Back to Top