<? include('includes/main.php'); ?>
<? include('includes/prfunctions.php'); ?>
<? //adminprben.php - copyright 2001 by Noguska - Fostoria, OH
     templatetop(STR_PAYROLL_GENERAL_BENEFITS_PAY);
     if ($save) {
          for ($i=1;$i<=$bencount+4;$i++) {
               if (${"id".$i}) {
                      //this one already exists, update or delete
                      if (${"cancel".$i}) { //delete
                             $conn->Execute('update prbended set cancel=1, canceluserid='.sqlprep($userid).', canceldate=NOW() where id='.sqlprep(${"id".$i}));
                      } else { //update data
                             prbendedupdate(${"id".$i}, ${"paytype".$i}, ${"name".$i}, ${"howfig".$i},${"prdedgroupid".$i},${"rate".$i},${"ceilingperyear".$i},${"payableglacctid".$i},${"expenseglacctid".$i},${"vendorid".$i},${"lastchangedate".$i});
                      };
               } else {
                       //if a valid entry, insert into file
                       if (${"rate".$i}>0) if (${"howfig".$i}>0){
                           if ($conn->Execute('insert into prbended (gencompanyid,paytype,bendedtype,name,howfig,prdedgroupid,rate,expenseglacctid,entrydate,entryuserid,lastchangeuserid) values ('.sqlprep($active_company).','.sqlprep(${"paytype".$i}).',0,'.sqlprep(${"name".$i}).','.sqlprep(${"howfig".$i}).','.sqlprep(${"prdedgroupid".$i}).','.sqlprep(${"rate".$i}).','.sqlprep(${"expenseglacctid".$i}).', NOW(),'.sqlprep($userid).','.sqlprep($userid).')') === false) echo texterror(STR_PRBENDED_INSERT_FAILED);
                       };
               };
               ${"id".$i}=0;
               ${"paytype".$i}=0;
               ${"name".$i}='';
               ${"howfig".$i}=0;
               ${"prdedgroupid".$i}='';
               ${"rate".$i}=0;
               ${"expenseglacctid".$i}=0;
               ${"cancel".$i}=0;
          };
          echo textsuccess(STR_BENEFITS_UPDATED_SUCCESSFULLY);
     };
       $recordSet=&$conn->Execute('select id,paytype,name,howfig,prdedgroupid,rate,expenseglacctid,lastchangedate from prbended where gencompanyid='.sqlprep($active_company).' and bendedtype=0 and cancel=0 order by name,paytype');
       $bencount=0;
       while (!$recordSet->EOF) {
          $bencount++;
          ${"id".$bencount}=$recordSet->fields[0];
          ${"paytype".$bencount}=$recordSet->fields[1];
          ${"name".$bencount}=$recordSet->fields[2];
          ${"howfig".$bencount}=$recordSet->fields[3];
          ${"prdedgroupid".$bencount}=$recordSet->fields[4];
          ${"rate".$bencount}=$recordSet->fields[5];
          ${"expenseglacctid".$bencount}=$recordSet->fields[6];
          ${"lastchangedate".$bencount}=$recordSet->fields[7];
          ${"cancel".$bencount}=0;
          $recordSet->MoveNext();
       };
       echo '<form action="adminprben.php" method="post" name="mainform"><table>';
       echo '<tr><th>'.STR_HOURLY_SALARY.'</th><th>'.STR_DESCRIPTION.'</th><th>'.STR_HOW_FIGURED.'</th><th>'.STR_GRP.'</th><th>'.STR_RATE.'</th><th>'.STR_GL_EXPENSE_ACCOUNT.'</th><th>'.STR_DELETE.'<input type="checkbox" checked></th></tr>';
       echo '<input type="hidden" name="bencount" value="'.$bencount.'">';
       for ($i=1;$i<=$bencount+4;$i++) {
             echo '<input type="hidden" name="id'.$i.'" value="'.${"id".$i}.'">';
             echo '<input type="hidden" name="lastchangedate'.$i.'" value="'.${"lastchangedate".$i}.'">';
             echo '<tr><td><select name="paytype'.$i.'"'.INC_TEXTBOX.'>';
             echo '<option value="0"'.checkequal(${"paytype".$i},0," selected").'>Hrly';
             echo '<option value="1"'.checkequal(${"paytype".$i},1," selected").'>Sal.';
             echo '</select></td>';
             echo '<td><input type="text" name="name'.$i.'" value="'.${"name".$i}.'"'.INC_TEXTBOX.'>';

             echo '<td><select name="howfig'.$i.'"'.INC_TEXTBOX.'>';
             echo '<option value="1"'.checkequal(${"howfig".$i},1," selected").'>% '.STR_TAXABLE_PAY;
             echo '<option value="2"'.checkequal(${"howfig".$i},2," selected").'>% '.STR_TAXABLE_PAY_TAX;
             echo '<option value="3"'.checkequal(${"howfig".$i},3," selected").'>% '.STR_ST_PAY;
             echo '<option value="4"'.checkequal(${"howfig".$i},4," selected").'>'.STR_HOURS_WORKED;
             echo '<option value="5"'.checkequal(${"howfig".$i},5," selected").'>'.STR_HOURS_PAID;
             echo '<option value="6"'.checkequal(${"howfig".$i},6," selected").'>'.STR_ST_HOURS;
             echo '<option value="7"'.checkequal(${"howfig".$i},7," selected").'>'.STR_WEEKLY_AMT;
             echo '<option value="8"'.checkequal(${"howfig".$i},8," selected").'>'.STR_AMT_1_WEEK_MONTH;
             echo '</select></td>';
             echo '<td><select name="prdedgroupid'.$i.'"'.INC_TEXTBOX.'><option value="0">';
             $recordSet = &$conn->Execute('select id, name from prdedgroup where gencompanyid='.sqlprep($active_company).' order by name');
             while (!$recordSet->EOF) {
                     echo '<option value="'.$recordSet->fields[0].'"'.checkequal(${"prdedgroupid".$i},$recordSet->fields[0],' selected').'>'.$recordSet->fields[1]."\n";
                     $recordSet->MoveNext();
             };
             echo '</select></td>';
             echo '<td><input type="text" name="rate'.$i.'" value="'.${"rate".$i}.'" size="10"  onchange="validatenum(this)" maxlength="10" '.INC_TEXTBOX.'>';
             echo '<td><select name="expenseglacctid'.$i.'"'.INC_TEXTBOX.'>';
             $recordSet=&$conn->Execute('select glaccount.id,glaccount.name,glaccount.description from glaccount where glaccount.accounttypeid>=70 and (companyid=0 or companyid='.sqlprep($active_company).') order by glaccount.name');
             while (!$recordSet->EOF) {
                      echo '<option value="'.$recordSet->fields[0].'"'.checkequal(${"expenseglacctid".$i},$recordSet->fields[0]," selected").'>'.$recordSet->fields[1].' - '.$recordSet->fields[2]."\n";
                      $recordSet->MoveNext();
             };
             echo '</select></td>';
             echo '<td><input name="cancel'.$i.'" type="checkbox"></td></tr>';
       };

       echo '</table><input type="submit" name="save" value="'.STR_SAVE_CHANGES.'"></form>';
?>
<? include('includes/footer.php'); ?>