/**
* 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');
