<commit_before><!doctype html>
<HTML>
<?php
do
{
$sys = 'MZD';
$urov = 3000;
$copern = $_REQUEST['copern'];
$tis = $_REQUEST['tis'];
if (!isset($tis)) $tis = 0;

$uziv = include("../uziv.php");
if ( !$uziv ) exit;

require_once("../pswd/password.php");
@$spojeni = mysql_connect($mysqlhost, $mysqluser, $mysqlpasswd);
  if (!$spojeni):
    echo "Spojenie so serverom nedostupne.";
    exit;
  endif;
  mysql_select_db($mysqldb);

//ramcek fpdf 1=zap,0=vyp
$rmc=0;
$rmc1=0;

//datumove funkcie
$sDat = include("../funkcie/dat_sk_us.php");

$pole = explode(".", $kli_vume);
$kli_vmes=$pole[0];
$kli_vrok=$pole[1];

$citfir = include("../cis/citaj_fir.php");
$mena1 = $fir_mena1;
$mena2 = $fir_mena2;
$kurz12 = $fir_kurz12;

$cislo_oc = $_REQUEST['cislo_oc'];
$subor = $_REQUEST['subor'];
$strana = 1*$_REQUEST['strana'];
if ( $strana == 0 ) { $strana = 1; }

$vsetkyprepocty=0;

//tlacove okno
$tlcuwin="width=700, height=' + vyskawin + ', top=0, left=200, status=yes, resizable=yes, scrollbars=yes, menubar=yes, toolbar=yes";
$tlcswin="width=980, height=' + vyskawin + ', top=0, left=20, status=yes, resizable=yes, scrollbars=yes, menubar=yes, toolbar=yes";
$tlcvwin="width=1020, height=' + vyskawin + ', top=0, left=20, status=yes, resizable=yes, scrollbars=yes, menubar=yes, toolbar=yes";
$uliscwin="width=' + sirkawic + ', height=' + vyskawic + ', top=0, left=0, status=yes, resizable=yes, scrollbars=yes, menubar=no, toolbar=no";

$sqtoz = "DELETE FROM F513_mzdrocnedane WHERE r00 > 99999999.98 ";
//$oznac = mysql_query("$sqtoz");

//kontrola ci nie je dva krat ak ano znovu napocitaj
$zupravy=0;
$tvpol=0;
if ( $copern == 10 OR $copern == 20 )
     {
$tovtt = "SELECT * FROM F$kli_vxcf"."_mzdrocnedane WHERE oc = $cislo_oc";
$tov = mysql_query("$tovtt");
if ( $tov ) { $tvpol = mysql_num_rows($tov); }

if ( $tvpol > 1 AND $copern == 20 ) { $copern=26; $zupravy=1; }
if ( $tvpol > 1 AND $copern == 10 ) { $copern=26; }
     }
//koniec kontroly

//$zablokovane=1;
if ( $_SERVER['SERVER_NAME'] == "localhost" ) { $zablokovane=0; }
if ( $zablokovane == 1 )
     {
?>
<script type="text/javascript">
alert ("Potvrdenie bude pripraven v priebehu janura 2015. Aktulne info njdete na vstupnej strnke v bode Novinky, tipy, triky.");
window.close();
</script>
<?php
exit;
     }

//znovu nacitaj
if ( $copern == 26 )
     {
//echo "citam";
$nasielvyplnene=0;

$sqlttt = "SELECT * FROM F$kli_vxcf"."_mzdrocnedane WHERE oc = $cislo_oc AND ( r00z2 != 0 OR r00a2 != 0 OR r04a2 != 0 OR r04b != 0 ".
" OR r00b2 != 0 OR r00c2 != 0 OR r11b != 0 OR r14b != 0  ) ORDER BY r00z1 ";
$sqldok = mysql_query("$sqlttt");
  if (@$zaznam=mysql_data_seek($sqldok,0))
  {
  $nasielvyplnene=1;

  $riaddok=mysql_fetch_object($sqldok);
  $xr00z2=1*$riaddok->r00z2;
  $xr00a2=1*$riaddok->r00a2;
  $xr00b2=1*$riaddok->r00b2;
  $xr00c2=1*$riaddok->r00c2;
  $xr02=1*$riaddok->r02;
  $xr04a2=1*$riaddok->r04a2;
  $xr04b=1*$riaddok->r04b;
  $xr11b=1*$riaddok->r11b;
  $xr14b=1*$riaddok->r14b;
  $xvyk=1*$riaddok->vyk;
  }
$sqtoz = "DELETE FROM F$kli_vxcf"."_mzdrocnedane WHERE oc = $cislo_oc";
$oznac = mysql_query("$sqtoz");
$copern=10;
if ( $zupravy == 1 ) $copern=20;
$subor=1;
$vsetkyprepocty=1;
     }
//koniec znovu nacitaj

//zapis do mzdy
if ( $copern == 27 )
     {
$dmx = 1*$_REQUEST['dmx'];
$umx = $_REQUEST['umx'];
$fix = 1*$_REQUEST['fix'];

if ( $umx == '1.2011' ) { $umx = "1.2014"; }
if ( $umx == '1.2012' ) { $umx = "1.2014"; }
if ( $umx == '1.2013' ) { $umx = "1.2014"; }
if ( $umx == '1.2014' ) { $umx = "1.2015"; }

$ned = 1*$_REQUEST['ned'];
$pre = 1*$_REQUEST['pre'];
$nedbon = 1*$_REQUEST['nedbon'];
$prebon = 1*$_REQUEST['prebon'];
$zampre = 1*$_REQUEST['zampre'];
$zamprex = 1*$_REQUEST['zamprex'];

//$h_kc=$ned-$pre-($nedbon-$prebon)+$zampre;
$h_kc=$ned-$pre;
$h_kcbon=$nedbon-$prebon;
$h_kczam=-1*($zampre-$zamprex);

if ( $dmx == 903 AND $umx > 0 AND $fix > 0 )
     {
$uprtxt = "UPDATE F$kli_vxcf"."_mzdrocnedaneprenos SET dmx='$dmx', umx='$umx', fix='$fix' ";
$upravene = mysql_query("$uprtxt"); 
$databaza="";

$dtb2 = include("../cis/oddel_dtbz3.php");
<commit_msg>MZDY RZ prenos do miezd<commit_after><!doctype html>
<HTML>
<?php
do
{
$sys = 'MZD';
$urov = 3000;
$copern = $_REQUEST['copern'];
$tis = $_REQUEST['tis'];
if (!isset($tis)) $tis = 0;

$uziv = include("../uziv.php");
if ( !$uziv ) exit;

require_once("../pswd/password.php");
@$spojeni = mysql_connect($mysqlhost, $mysqluser, $mysqlpasswd);
  if (!$spojeni):
    echo "Spojenie so serverom nedostupne.";
    exit;
  endif;
  mysql_select_db($mysqldb);

//ramcek fpdf 1=zap,0=vyp
$rmc=0;
$rmc1=0;

//datumove funkcie
$sDat = include("../funkcie/dat_sk_us.php");

$pole = explode(".", $kli_vume);
$kli_vmes=$pole[0];
$kli_vrok=$pole[1];

$citfir = include("../cis/citaj_fir.php");
$mena1 = $fir_mena1;
$mena2 = $fir_mena2;
$kurz12 = $fir_kurz12;

$cislo_oc = $_REQUEST['cislo_oc'];
$subor = $_REQUEST['subor'];
$strana = 1*$_REQUEST['strana'];
if ( $strana == 0 ) { $strana = 1; }

$vsetkyprepocty=0;

//tlacove okno
$tlcuwin="width=700, height=' + vyskawin + ', top=0, left=200, status=yes, resizable=yes, scrollbars=yes, menubar=yes, toolbar=yes";
$tlcswin="width=980, height=' + vyskawin + ', top=0, left=20, status=yes, resizable=yes, scrollbars=yes, menubar=yes, toolbar=yes";
$tlcvwin="width=1020, height=' + vyskawin + ', top=0, left=20, status=yes, resizable=yes, scrollbars=yes, menubar=yes, toolbar=yes";
$uliscwin="width=' + sirkawic + ', height=' + vyskawic + ', top=0, left=0, status=yes, resizable=yes, scrollbars=yes, menubar=no, toolbar=no";

$sqtoz = "DELETE FROM F513_mzdrocnedane WHERE r00 > 99999999.98 ";
//$oznac = mysql_query("$sqtoz");

//kontrola ci nie je dva krat ak ano znovu napocitaj
$zupravy=0;
$tvpol=0;
if ( $copern == 10 OR $copern == 20 )
     {
$tovtt = "SELECT * FROM F$kli_vxcf"."_mzdrocnedane WHERE oc = $cislo_oc";
$tov = mysql_query("$tovtt");
if ( $tov ) { $tvpol = mysql_num_rows($tov); }

if ( $tvpol > 1 AND $copern == 20 ) { $copern=26; $zupravy=1; }
if ( $tvpol > 1 AND $copern == 10 ) { $copern=26; }
     }
//koniec kontroly

//$zablokovane=1;
if ( $_SERVER['SERVER_NAME'] == "localhost" ) { $zablokovane=0; }
if ( $zablokovane == 1 )
     {
?>
<script type="text/javascript">
alert ("Potvrdenie bude pripraven v priebehu janura 2015. Aktulne info njdete na vstupnej strnke v bode Novinky, tipy, triky.");
window.close();
</script>
<?php
exit;
     }

//znovu nacitaj
if ( $copern == 26 )
     {
//echo "citam";
$nasielvyplnene=0;

$sqlttt = "SELECT * FROM F$kli_vxcf"."_mzdrocnedane WHERE oc = $cislo_oc AND ( r00z2 != 0 OR r00a2 != 0 OR r04a2 != 0 OR r04b != 0 ".
" OR r00b2 != 0 OR r00c2 != 0 OR r11b != 0 OR r14b != 0  ) ORDER BY r00z1 ";
$sqldok = mysql_query("$sqlttt");
  if (@$zaznam=mysql_data_seek($sqldok,0))
  {
  $nasielvyplnene=1;

  $riaddok=mysql_fetch_object($sqldok);
  $xr00z2=1*$riaddok->r00z2;
  $xr00a2=1*$riaddok->r00a2;
  $xr00b2=1*$riaddok->r00b2;
  $xr00c2=1*$riaddok->r00c2;
  $xr02=1*$riaddok->r02;
  $xr04a2=1*$riaddok->r04a2;
  $xr04b=1*$riaddok->r04b;
  $xr11b=1*$riaddok->r11b;
  $xr14b=1*$riaddok->r14b;
  $xvyk=1*$riaddok->vyk;
  }
$sqtoz = "DELETE FROM F$kli_vxcf"."_mzdrocnedane WHERE oc = $cislo_oc";
$oznac = mysql_query("$sqtoz");
$copern=10;
if ( $zupravy == 1 ) $copern=20;
$subor=1;
$vsetkyprepocty=1;
     }
//koniec znovu nacitaj

//zapis do mzdy
if ( $copern == 27 )
     {
$dmx = 1*$_REQUEST['dmx'];
$umx = $_REQUEST['umx'];
$fix = 1*$_REQUEST['fix'];

if ( $umx == '1.2011' ) { $umx = "1.2015"; }
if ( $umx == '1.2012' ) { $umx = "1.2015"; }
if ( $umx == '1.2013' ) { $umx = "1.2015"; }
if ( $umx == '1.2014' ) { $umx = "1.2015"; }
if ( $umx == '2.2011' ) { $umx = "2.2015"; }
if ( $umx == '2.2012' ) { $umx = "2.2015"; }
if ( $umx == '2.2013' ) { $umx = "2.2015"; }
if ( $umx == '2.2014' ) { $umx = "2.2015"; }
if ( $umx == '3.2011' ) { $umx = "3.2015"; }
if ( $umx == '3.2012' ) { $umx = "3.2015"; }
if ( $umx == '3.2013' ) { $umx = "3.2015"; }
if ( $umx == '3.2014' ) { $umx = "3.2015"; }

$ned = 1*$_REQUEST['ned'];
$pre = 1*$_REQUEST['pre'];
$nedbon = 1*$_REQUEST['nedbon'];
$prebon = 1*$_REQUEST['prebon'];
$zampre = 1*$_REQUEST['zampre'];
$zamprex = 1*$_REQUEST['zamprex'];

//$h_kc=$ned-$pre-($nedbon-$prebon)+$zampre;
$h_kc=$ned-$pre;
$h_kcbon=$nedbon-$prebon;
$h_kczam=-1*($zampre-$zamprex);

if ( $dmx == 903 AND $umx > 0 AND $fix > 0 )
     {
$uprtxt = "UPDATE F$kli_vxcf"."_mzdrocnedaneprenos SET dmx='$dmx', umx='$umx', fix='$fix' ";
$upravene = mysql_query("$uprtxt"); 
$databaza="";

$dtb2 = include("../cis/oddel_dtbz3.php");

$jetamostre=0;
$sqlfir = "SELECT * FROM ".$databaza."F$fix"."_mzdzalkun WHERE ume = '$umx' ";
$sql = mysql_query("$sqlfir");
$pol = 1*mysql_num_rows($sql);
if( $pol > 0 ) { $jetamostre=1; }

if ( $jetamostre == 1 )
     {
?>
<script type="text/javascript">
alert ("Nemete prena do <?php echo $umx; ?>. U bolo ostr spracovanie za mesiac <?php echo $umx; ?>.");
window.close();
</script>
<?php
exit;
     }

{'fraction_non_alphanumeric': 0.2263134261338123, 'fraction_numerical': 0.06409968567579703, 'mean_word_length': 4.589084065244667, 'pattern_counts': {'":': 0, '<': 20, '<?xml version=': 0, '>': 49, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 2, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '7522183', 'n_tokens_mistral': 4601, 'n_tokens_neox': 4240, 'n_words': 785}