Search options (Page 2 of 2)

<?php
/*
  Paycheck.php
  Begin to process paychecks
    list employees, enter hours, set pay period
    submit for calculation and review
*/

/////////////////////////////////////////////////////
//Includes
/////////////////////////////////////////////////////
$page_security = 'SA_PAYROLL';
$path_to_root="../..";

include($path_to_root . "/includes/session.inc");
add_access_extensions();

$js = "";
if ($use_popup_windows)
    $js .= get_js_open_window(900, 500);
if ($use_date_picker)
    $js .= get_js_date_picker();

include_once($path_to_root . "/includes/date_functions.inc");
include_once($path_to_root . "/includes/ui.inc");
include_once($path_to_root . "/includes/data_checks.inc");


/////////////////////////////////////////////////////
//Functions
/////////////////////////////////////////////////////

function payperiod_settings(){

  start_outer_table(TABLESTYLE2);
  table_section(1);
  date_row("Pay Period Ends:", 'PayPeriodEnd');
  date_row("Check date:", "CheckDate");

  table_section(2);
  bank_accounts_list_row("Bank Account:", "BankAccount");
  end_outer_table(1);
}

//--------------------------------------------------------------------------------------------
function get_employees(){
  //get all active employees
  $sql = "SELECT emp_id, emp_name, emp_paytype FROM ".TB_PREF."employees WHERE inactive = 0";

  $result = db_query($sql, "The employee table is inaccessible");

  return $result;
}

//--------------------------------------------------------------------------------------------
//display the list of employees
function list_employees($list){

    start_table(TABLESTYLE, "width=60%");

    $th = array(("check"),_("Name"), _("Hours"), _("Salary"));//add columns for commission, overtime, etc
    table_header($th);

      $k = 0;
      while ($myrow = db_fetch($list)){
      alt_table_row_color($k);
      check_cells(null, "check".$myrow["emp_id"], '', '', '', "width=15 align=center");//select employees to pay
      label_cell($myrow["emp_name"]);

      if ($myrow['emp_paytype'] == 'hr'){
        text_cells(null, 'hours'.$myrow["emp_id"], "get_last_hours()", 8, 4);//pre-fill this with hours from last paycheck?
      } else {
        echo "<td></td>";//blank cell for non hourly employees
      }

      if ($myrow['emp_paytype'] == 'sal'){
        text_cells(null, 'salary'.$myrow["emp_id"], null, 8, 4);//show something?
      } else {
        echo "<td></td>";//blank cell for non salaried employees
      }

      end_row();
      }

    end_table(1);

    div_start('controls');
    submit_center('submit', _("Proceed"), true, '', 'default');
    div_end();

}

//--------------------------------------------------------------------------------------------
function get_last_hours($id){
  //
}

//--------------------------------------------------------------------------------------------
function can_process(){
  //is at least one employee checked?
  
  //do all the checked hourly employees have positive hours listed?

  return true;
}

//--------------------------------------------------------------------------------------------
function handle_submit(){

  if (!can_process())
    return;

  //hand off to calculation/review page

}


/////////////////////////////////////////////////////
//Page Flow
/////////////////////////////////////////////////////
page("Enter Paycheck Information");

//display top table with date, check, and account info
payperiod_settings();


//display bottom table with employee info
$result = get_employees();
if (!$result)
  display_notification("There are no employees to pay.");
else
  list_employees($result);


end_page();

?>