/** * new banksta store in database bankstaDoUpload() method and returns preprocessed * bank statement hash for further usage * * @param string $bankstadata array returned from * * @return string */ public function bankstaPreprocessingPrivatDbf($bankstadata) { $result = ''; if (!empty($bankstadata)) { if (file_exists(self::BANKSTA_PATH . $bankstadata['savedname'])) { //processing raw data $newHash = $bankstadata['hash']; $result = $newHash; $newFilename = $bankstadata['filename']; $newAdmin = whoami(); $payId = vf($this->altCfg['UKV_BSPB_PAYID'], 3); $dbf = new dbf_class(self::BANKSTA_PATH . $bankstadata['savedname']); $num_rec = $dbf->dbf_num_rec; $importCounter = 0; for ($i = 0; $i <= $num_rec; $i++) { $eachRow = $dbf->getRowAssoc($i); if (!empty($eachRow)) { if (@$eachRow[self::PB_BANKSTA_CONTRACT] != '') { $newDate = date("Y-m-d H:i:s"); $newContract = trim($eachRow[self::PB_BANKSTA_CONTRACT]); $newContract = mysql_real_escape_string($newContract); $newSumm = trim($eachRow[self::PB_BANKSTA_SUMM]); $newSumm = mysql_real_escape_string($newSumm); $newAddress = iconv(self::BANKSTA_IN_CHARSET, self::BANKSTA_OUT_CHARSET, $eachRow[self::PB_BANKSTA_ADDRESS]); $newAddress = mysql_real_escape_string($newAddress); $newRealname = iconv(self::BANKSTA_IN_CHARSET, self::BANKSTA_OUT_CHARSET, $eachRow[self::PB_BANKSTA_REALNAME]); $newRealname = mysql_real_escape_string($newRealname); $newNotes = iconv(self::BANKSTA_IN_CHARSET, self::BANKSTA_OUT_CHARSET, $eachRow[self::PB_BANKSTA_NOTES]); $newNotes = mysql_real_escape_string($newNotes); $pbDate = $eachRow[self::PB_BANKSTA_DATE]; $pbDate = strtotime($pbDate); $pbDate = date("Y-m-d", $pbDate); $newPdate = iconv(self::BANKSTA_IN_CHARSET, self::BANKSTA_OUT_CHARSET, $pbDate); $newPdate = mysql_real_escape_string($newPdate); $newPtime = iconv(self::BANKSTA_IN_CHARSET, self::BANKSTA_OUT_CHARSET, curtime()); $newPtime = mysql_real_escape_string($newPtime); $this->bankstaCreateRow($newDate, $newHash, $newFilename, $newAdmin, $newContract, $newSumm, $newAddress, $newRealname, $newNotes, $newPdate, $newPtime, $payId); $importCounter++; } } } log_register('UKV BANKSTA IMPORTED ' . $importCounter . ' ROWS'); } else { show_error(__('Strange exeption')); } } else { throw new Exception(self::EX_BANKSTA_PREPROCESS_EMPTY); } return $result; }
<?php if (cfr('CATVACT')) { catv_GlobalControlsShow(); if (wf_CheckGet(array('userid'))) { $userid = vf($_GET['userid']); //collect all data $alluseractivity = catv_ActivityGetAllByUser($userid); $lasuseractivity = catv_ActivityGetLastByUser($userid); $lasuseractivitytime = catv_ActivityGetTimeLastByUser($userid); $userdata = catv_UserGetData($userid); $curyear = curyear(); $curmonth = date("m"); $curday = date("d"); $curtime = curtime(); $address = $userdata['street'] . ' ' . $userdata['build'] . '/' . $userdata['apt']; //if creating new activity if (wf_CheckPost(array('newacttime', 'newactday'))) { $customdate = $_POST['newactyear'] . '-' . $_POST['newactmonth'] . '-' . $_POST['newactday'] . ' ' . $_POST['newacttime']; deb($customdate); catv_ActivityCreateCustomDate($userid, $_POST['newactivity'], $customdate); rcms_redirect('?module=catv_useractivity&userid=' . $userid); } //edit form construct $actinputs = ''; $actinputs .= wf_Trigger('newactivity', 'Connected', $lasuseractivity, true) . '<hr>'; $actinputs .= wf_TextInput('newactday', 'Day', $curday, false, '2'); $actinputs .= wf_MonthSelector('newactmonth', 'Month', $curmonth, false); $actinputs .= wf_YearSelector('newactyear', 'Year', true) . '<br>'; $actinputs .= wf_HiddenInput('newacttime', $curtime); $actinputs .= wf_Submit('Change');