HASH_OPTIONS_COST, 'salt' => HASH_OPTIONS_SALT];
$password_ = password_hash($password, PASSWORD_BCRYPT, $options);
if (!password_verify($password, $user["password"]) || $password_ == $user["password"]) {
$password = password_hash($password, PASSWORD_BCRYPT, $options);
}
}
$uid = UpdateUser($id, $name, $username, $password, $isAdmin, $isDisabled);
if ($uid == 0 && $password_ == $user["password"]) // ha ugyanazt a jelszot adta, le kell kezelni, hogy ne adjon vissza hibat
$uid++;
} else
$uid++;
}
// beallitjuk a ragasztoadmin usereit, ha szukseges
SetRagasztoAdminUsers($id, $selectedUsers);
if ($uid > 0)
echo true;
else
echo false;
return;
} else if (isset($_POST['getusers'])) { // levalogatjuk a felhasznalokat
$page = $_POST['page'];
$limit = $_POST['rows'];
$sidx = $_POST['sidx'];
$sord = $_POST['sord'];
if (!$sidx)
$sidx = 1;
if ($_POST['filter']) {
$users = GetUsers();
$_SESSION['users'] = $users;
$page = 1;
} else {
if (isset($_SESSION['users']) && count($_SESSION['users']) > 0)
$users = $_SESSION['users'];
else {
$users = GetUsers();
$_SESSION['users'] = $users;
$page = 1;
}
}
$_SESSION["usercount"] = count($users);
usort($users, 'cmpi');
if ($sord == 'desc')
$users = array_reverse($users);
header("Content-type: text/xml;charset=utf-8");
$count = count($users);
if ($count == 0)
$limit = 0;
if ($count > 0 && $limit > 0)
$total_pages = ceil($count/$limit);
else
$total_pages = 0;
if ($page > $total_pages)
$page = $total_pages;
$count_ = $page * $limit;
if ($limit > 0 && $page == $total_pages)
$count_ = $count;
$ret = "";
$ret .= "";
$ret .= "" . $page . "";
$ret .= "" . $total_pages . "";
$ret .= "" . $count . "";
for ($i=($page-1)*$limit;$i<$count_;$i++) {
$row = $users[$i];
$row['isragasztoadmin'] = 0;
if ($row['isadmin'] == 2) {
$row['isadmin'] = 0;
$row['isragasztoadmin'] = 1;
}
$ret .= "";
$ret .= " | ";
$ret .= " | ";
$ret .= "" . $row['isadmin'] . " | ";
$ret .= "" . $row['isragasztoadmin'] . " | ";
$ret .= "" . $row['isdisabled'] . " | ";
$ret .= "" . $row['password'] . " | ";
$ret .= "
";
}
$ret .= "";
echo $ret;
return;
} else if (isset($_POST['getragasztoadminusers'])) { // levalogatjuk a felhasznalokat (ragasztousernek)
$page = $_POST['page'];
$limit = $_POST['rows'];
$sidx = $_POST['sidx'];
$sord = $_POST['sord'];
$raUserId = $_POST['rauserid'];
if (!$sidx)
$sidx = 1;
if ($_POST['filter']) {
$users = GetUsersByRagasztoAdmin($raUserId);
$_SESSION['usersforra'] = $users;
$page = 1;
} else {
if (isset($_SESSION['usersforra']) && count($_SESSION['usersforra']) > 0)
$users = $_SESSION['usersforra'];
else {
$users = GetUsersByRagasztoAdmin($raUserId);
$_SESSION['usersforra'] = $users;
$page = 1;
}
}
$_SESSION["usercount"] = count($users);
usort($users, 'cmpi');
if ($sord == 'desc')
$users = array_reverse($users);
header("Content-type: text/xml;charset=utf-8");
$count = count($users);
if ($count == 0)
$limit = 0;
if ($count > 0 && $limit > 0)
$total_pages = ceil($count/$limit);
else
$total_pages = 0;
if ($page > $total_pages)
$page = $total_pages;
$count_ = $page * $limit;
if ($limit > 0 && $page == $total_pages)
$count_ = $count;
$ret = "";
$ret .= "";
$ret .= "" . $page . "";
$ret .= "" . $total_pages . "";
$ret .= "" . $count . "";
$ret2 = "";
$ret3 = "";
for ($i=($page-1)*$limit;$i<$count_;$i++) {
$row = $users[$i];
if ($row['user_id'] == 1) {
$ret2 .= "";
$ret2 .= "| " . $row['user_id'] . " | ";
$ret2 .= "" . $row['selected'] . " | ";
$ret2 .= " | ";
$ret2 .= "
";
} else {
$ret3 .= "";
$ret3 .= "| " . $row['user_id'] . " | ";
$ret3 .= "" . $row['selected'] . " | ";
$ret3 .= " | ";
$ret3 .= "
";
}
}
$ret .= $ret2 . $ret3 . "";
echo $ret;
return;
} else if (isset($_POST['getrausers'])) { // levalogatjuk a ragaszto adminok felhasznaloit
if (isset($_POST['userid']) && $_POST['userid'] > 0) {
$userId = $_POST['userid'];
$users = GetRagasztoAdminUsers($userId);
$raUserIds = array();
foreach($users as $user) {
$raUserIds[] = $user["user_id"];
}
echo json_encode($raUserIds);
} else
echo json_encode(array());
} else if (isset($_POST['getragasztok'])) { // levalogatjuk a felhasznalokat
$users = GetUsers();
$options = '';
$i = 1;
foreach ($users as $user) {
$options .= '';
$i++;
}
echo $options;
return;
} else if (isset($_POST['getvarosok'])) { // levalogatjuk a varosokat
$varosok = GetVarosok();
$options = '';
$i = 1;
foreach ($varosok as $varos) {
$options .= '';
$i++;
}
echo $options;
return;
} else if (isset($_POST['importragacslist'])) {
if (isset($_POST["uploadedxlsfile"]) && isset($_POST["ragacsdate"]) && isset($_POST["cegid"])) {
$xlsFile = $_POST["uploadedxlsfile"];
$date = $_POST["ragacsdate"];
$cegId = $_POST["cegid"];
$isCenterFtpConnected = true;
if (SERVER_SIDE)
echo importServerSideRagLista($xlsFile);
else {
$xlsParts = explode("_", basename($xlsFile));
if (count($xlsParts) > 0) {
$newFile = "";
for ($i = 1; $i < count($xlsParts); $i++) {
$newFile .= $xlsParts[$i];
if ($i < count($xlsParts)-1)
$newFile .= "_";
}
}
$newFile = RAGLISTA_FELDOLGOZOTT_DIRECTORY . $newFile;
@copy($xlsFile, $newFile);
if (file_exists($newFile))
$xlsFile = $newFile;
// ragasztasi lista feltoltese a kozponti (BigTeam) Netfoto-ba, elmentjuk az adatbazisban a job-ot
if (EXCHANGE_DATA && !SERVER_SIDE) {
if (!InsertJobToServer($xlsFile)) {
errorlog("Server job letrehozasa sikertelen: " . $xlsFile);
sendEmail('Server job letrehozasa sikertelen: ' . $xlsFile);
}
}
// ragasztasi lista importalasa
echo importRagLista($xlsFile, $date, $cegId);
}
} else
echo "Az xls file nem található!";
return;
} else if (isset($_POST['getragasztaslista'])) { // elkeszitjuk a ragasztaslistat
$filename = TMP_DIRECTORY . uniqid("raglista_") . ".xls";
$dfrom = $_POST['dfrom'];
$dto = $_POST['dto'];
$userId = $_POST['userid'];
$isAdmin = $_SESSION["user"]["isadmin"];
$varosId = $_POST['varosid'];
$kampanyId = trim($_POST['kampanyid']);
$feluletKod = trim($_POST['feluletkod']);
$searchFeluletKodCenter = $_POST['searchfeluletkodcenter'];
$surfaceId = $_POST['surfaceid'];
$isNeedPhoto = $_POST['isneedphoto'];
$plakatNev = $_POST['plakatnev'];
$fkezdodatum = $_POST['fdfrom'];
$fvegsodatum = $_POST['fdto'];
$uploadedPhoto = trim($_POST['uploadedphoto']);
$cegId = $_POST['cegid'];
$surfaceType = 0;
if (isset($_POST['surfacetype']))
$surfaceType = $_POST['surfacetype'];
if ($isAdmin == 2)
$userId = $_SESSION["user"]["user_id"];
$feluletek = GetFeluletek($dfrom, $dto, $userId, $isAdmin, $varosId, $kampanyId, $feluletKod, $searchFeluletKodCenter, $surfaceId, true, $isNeedPhoto, $fkezdodatum, $fvegsodatum, $uploadedPhoto, $cegId, $plakatNev, $surfaceType);
if ($fkezdodatum != "" || $fvegsodatum != "") {
$surfaces_ = array();
foreach ($feluletek as $surface) {
$feluletId = $surface["ragacslist_id"];
$feluletKod = $surface["felulet_kod"];
$sajatKod = $surface["sajat_kod"];
$kampanyId = $surface["kampany_id"];
$ragacsDatumAsTimeStamp = strtotime($surface["ragasztas_datum"]);
$ragasztasDatum = date("Y.m.d.", $ragacsDatumAsTimeStamp);
$fkezdodatumAsTimeStamp = 0;
if ($fkezdodatum != "")
$fkezdodatumAsTimeStamp = strtotime(substr($fkezdodatum, 0, 4) . "-" . substr($fkezdodatum, 5, 2) . "-" . substr($fkezdodatum, 8, 2));
$fvegsodatumAsTimeStamp = 0;
if ($fvegsodatum != "")
$fvegsodatumAsTimeStamp = strtotime(substr($fvegsodatum, 0, 4) . "-" . substr($fvegsodatum, 5, 2) . "-" . substr($fvegsodatum, 8, 2) . " 23:59:59");
$kKepek = array();
if (trim($surface['kihelyezesi_foto_datumok']) != "")
$kKepek = json_decode($surface['kihelyezesi_foto_datumok'], true);
$jKepek = array();
if (trim($surface['javito_foto_datumok']) != "")
$jKepek = json_decode($surface['javito_foto_datumok'], true);
if ($surface["uploadedphoto"] > 0 && (count($kKepek) == 0 && count($jKepek) == 0))
updateFotoDatumok($feluletId);
$surfaceAdd = false;
foreach ($kKepek as $kKep) {
$imgTimestamp = strtotime(substr($kKep["timestamp"], 0, 4) . "-" . substr($kKep["timestamp"], 5, 2) . "-" . substr($kKep["timestamp"], 8, 2));
if ($fkezdodatumAsTimeStamp > 0 && $fvegsodatumAsTimeStamp > 0) {
if ($fkezdodatumAsTimeStamp <= $imgTimestamp && $imgTimestamp <= $fvegsodatumAsTimeStamp)
$surfaceAdd = true;
} else if ($fkezdodatumAsTimeStamp > 0) {
if ($fkezdodatumAsTimeStamp <= $imgTimestamp)
$surfaceAdd = true;
} else if ($fvegsodatumAsTimeStamp > 0) {
if ($imgTimestamp <= $fvegsodatumAsTimeStamp)
$surfaceAdd = true;
}
}
foreach ($jKepek as $jKep) {
$imgTimestamp = strtotime(substr($jKep["timestamp"], 0, 4) . "-" . substr($jKep["timestamp"], 5, 2) . "-" . substr($jKep["timestamp"], 8, 2));
if ($fkezdodatumAsTimeStamp > 0 && $fvegsodatumAsTimeStamp > 0) {
if ($fkezdodatumAsTimeStamp <= $imgTimestamp && $imgTimestamp <= $fvegsodatumAsTimeStamp)
$surfaceAdd = true;
} else if ($fkezdodatumAsTimeStamp > 0) {
if ($fkezdodatumAsTimeStamp <= $imgTimestamp)
$surfaceAdd = true;
} else if ($fvegsodatumAsTimeStamp > 0) {
if ($imgTimestamp <= $fvegsodatumAsTimeStamp)
$surfaceAdd = true;
}
}
if ($surfaceAdd) {
$surfaces_[] = $surface;
}
}
$feluletek = $surfaces_;
}
$workbook = new Spreadsheet_Excel_Writer($filename);
$workbook->setVersion(8);
$worksheet =& $workbook->addWorksheet('Ragasztási lista');
$worksheet->setInputEncoding('UTF-8');
$cim_format =& $workbook->addFormat();
$cim_format->setBold();
$header_format =& $workbook->addFormat();
$header_format->setBold();
$header_format->setAlign("center");
$format_center =& $workbook->addFormat();
$format_center->setAlign("center");
// oszlopok formazasa
$worksheet->setColumn(0, 0, 20);
$worksheet->setColumn(1, 1, 20);
$worksheet->setColumn(2, 2, 28);
$worksheet->setColumn(3, 3, 40);
$worksheet->setColumn(4, 4, 25);
$worksheet->setColumn(5, 5, 12);
$worksheet->setColumn(6, 6, 32);
$worksheet->setColumn(7, 7, 35);
$worksheet->setColumn(8, 8, 16);
$worksheet->setColumn(9, 9, 20);
$worksheet->setColumn(10, 10, 20);
$worksheet->setColumn(11, 11, 14);
if (SERVER_SIDE) {
$worksheet->setColumn(12, 12, 20);
$worksheet->setColumn(13, 13, 55);
$worksheet->setColumn(14, 14, 55);
} else {
$worksheet->setColumn(12, 12, 55);
$worksheet->setColumn(13, 13, 55);
}
// fejlecek elkeszitese
$filterText = "Ragasztási lista - Ragasztás dátuma: " . $dfrom . ", Dátumig: " . $dto . ", (";
if (SERVER_SIDE) {
if (intval($cegId) != 0) {
$ceg = GetClientData($cegId);
$filterText .= "Cég: " . $ceg["nev"] . ", ";
} else
$filterText .= "Cég: Minden cég, ";
}
if (intval($userId) != 0 && isset($feluletek[0]))
$filterText .= "Ragasztó: " . $feluletek[0]["ragaszto"];
else
$filterText .= "Ragasztó: Minden ragasztó";
if (intval($varosId) != 0 && isset($feluletek[0]))
$filterText .= ", Város: " . $feluletek[0]["varos"];
else
$filterText .= ", Város: Minden város";
if ($surfaceId == 0)
$filterText .= ", Felület: Minden felület";
else if ($surfaceId == 1)
$filterText .= ", Felület: Felülethez van kép feltöltve";
else if ($surfaceId == 2)
$filterText .= ", Felület: Felülethez nincs kép feltöltve";
else if ($surfaceId == 3)
$filterText .= ", Felület: Felülethez van javító kép feltöltve";
if ($kampanyId != "")
$filterText .= ", Kampány ID: " . $kampanyId;
if ($feluletKod != "")
$filterText .= ", Felület kód: " . $feluletKod;
if ($searchFeluletKodCenter)
$filterText .= ", Keresés felületkód közepére: Igen";
else
$filterText .= ", Keresés felületkód közepére: Nem";
if ($isNeedPhoto)
$filterText .= ", Fotó szükséges: Igen";
else
$filterText .= ", Fotó szükséges: Nem";
if ($plakatNev != "")
$filterText .= ", Plakát: " . $plakatNev;
if ($surfaceType == 0)
$filterText .= ", Felülettípus: Minden";
else if ($surfaceType == 1)
$filterText .= ", Felülettípus: CityLight felületek";
else if ($surfaceType == 2)
$filterText .= ", Felülettípus: Nem CityLight felületek";
if (trim($fkezdodatum) != "" || trim($fvegsodatum) != "")
$filterText .= ", Feltöltési időszak: " . $fkezdodatum . " - " . $fvegsodatum;
if ($uploadedPhoto != "")
$filterText .= ", Feltöltött képek száma: " . $uploadedPhoto;
$filterText .= ")";
$worksheet->write(0, 0, $filterText, $cim_format);
$worksheet->write(1, 0, 'Felület kód', $header_format);
$worksheet->write(1, 1, 'Saját kód', $header_format);
$worksheet->write(1, 2, 'Város', $header_format);
$worksheet->write(1, 3, 'Cím', $header_format);
$worksheet->write(1, 4, 'Ragasztó', $header_format);
$worksheet->write(1, 5, 'Kampány ID', $header_format);
$worksheet->write(1, 6, 'Kampány név', $header_format);
$worksheet->write(1, 7, 'Plakát', $header_format);
$worksheet->write(1, 8, 'Ragasztás dátum', $header_format);
$worksheet->write(1, 9, 'Utolsó feltöltés dátum', $header_format);
$worksheet->write(1, 10, 'Feltöltött képek száma', $header_format);
$worksheet->write(1, 11, 'Felülettípus', $header_format);
if (SERVER_SIDE) {
$worksheet->write(1, 12, 'Cég', $header_format);
$worksheet->write(1, 13, 'Kihelyezési fotók feltöltési ideje', $header_format);
$worksheet->write(1, 14, 'Javító fotók feltöltési ideje', $header_format);
} else {
$worksheet->write(1, 12, 'Kihelyezési fotók feltöltési ideje', $header_format);
$worksheet->write(1, 13, 'Javító fotók feltöltési ideje', $header_format);
}
$sor = 2;
foreach ($feluletek as $row) {
$worksheet->writeString($sor, 0, $row['felulet_kod'], $format_center);
$worksheet->writeString($sor, 1, $row['sajat_kod'], $format_center);
$worksheet->writeString($sor, 2, $row['varos']);
$worksheet->writeString($sor, 3, $row['felulet_cim']);
$worksheet->writeString($sor, 4, $row['ragaszto']);
$worksheet->write($sor, 5, $row['kampany_id'], $format_center);
$worksheet->writeString($sor, 6, $row['kampany_nev']);
$worksheet->writeString($sor, 7, $row['plakat']);
$worksheet->write($sor, 8, date("Y.m.d.", strtotime($row['ragasztas_datum'])), $format_center);
if (date("Y.m.d.", strtotime($row['lastuploadedphoto_datum'])) == "1970.01.01.")
$worksheet->write($sor, 9, "");
else
$worksheet->write($sor, 9, date("Y.m.d.", strtotime($row['lastuploadedphoto_datum'])), $format_center);
$worksheet->write($sor, 10, $row['uploadedphoto']);
$worksheet->writeString($sor, 11, $row['felulettipus']);
$kfotoStr = "";
$jfotoStr = "";
if (trim($row['kihelyezesi_foto_datumok']) != "") {
$kKepek = json_decode($row['kihelyezesi_foto_datumok'], true);
foreach ($kKepek as $kep) {
if ($kfotoStr == "")
$kfotoStr .= $kep["timestamp"];
else
$kfotoStr .= ", " . $kep["timestamp"];
}
}
if (trim($row['javito_foto_datumok']) != "") {
$jKepek = json_decode($row['javito_foto_datumok'], true);
foreach ($jKepek as $kep) {
if ($jfotoStr == "")
$jfotoStr .= $kep["timestamp"];
else
$jfotoStr .= ", " . $kep["timestamp"];
}
}
if (SERVER_SIDE) {
$ceg = GetClientData($row['ceg_id']);
$worksheet->writeString($sor, 12, $ceg['nev']);
$worksheet->writeString($sor, 13, $kfotoStr);
$worksheet->writeString($sor, 14, $jfotoStr);
} else {
$worksheet->writeString($sor, 12, $kfotoStr);
$worksheet->writeString($sor, 13, $jfotoStr);
}
$sor = $sor+1;
}
$workbook->close();
if (file_exists($filename))
echo $filename;
else
echo "";
} else if (isset($_POST['getphotos'])) { // levalogatjuk a fotokat
$kepek = array();
if (isset($_POST["feluletid"])) {
$feluletId = $_POST["feluletid"];
$felulet = GetFelulet($feluletId);
$kampanyId = $felulet["kampany_id"];
$feluletKod = $felulet["felulet_kod"];
$sajatKod = $felulet["sajat_kod"];
$ragacsDatumAsTimeStamp = strtotime($felulet["ragasztas_datum"]);
$ragacsDatum = date("Y.m.d.", $ragacsDatumAsTimeStamp);
$folder = PHOTO_DIRECTORY . date("Y", $ragacsDatumAsTimeStamp) . "/" . date("m", $ragacsDatumAsTimeStamp) . "/" . $kampanyId . "/" . $ragacsDatum;
if (file_exists($folder)) {
$fnames = scandir($folder);
$fnames = sortPhotos($fnames);
foreach ($fnames as $fname) {
if (($fname != '.') && ($fname != '..') && ($fname != basename($_SERVER['PHP_SELF']))) {
// if (!is_dir($folder . "/" . $fname) && (strpos($fname, $feluletKod) !== false || (trim($sajatKod) != "" && strpos($fname, $sajatKod) !== false))) {
if (!is_dir($folder . "/" . $fname) && (fnmatch(strtoupper($feluletKod . ".jpg"), strtoupper(basename($fname))) !== false || fnmatch(strtoupper($feluletKod . "_J.jpg"), strtoupper(basename($fname))) !== false || fnmatch(strtoupper($feluletKod . "-F*.jpg"), strtoupper(basename($fname))) !== false || (trim($sajatKod) != "" && (fnmatch(strtoupper($sajatKod . ".jpg"), strtoupper(basename($fname))) !== false || fnmatch(strtoupper($sajatKod . "_J.jpg"), strtoupper(basename($fname))) !== false || fnmatch(strtoupper($sajatKod . "-F*.jpg"), strtoupper(basename($fname))) !== false)))) {
$img = $folder . "/" . $fname;
$kepek[] = array("image" => $img, "timestamp" => date("Y.m.d. H:i:s", filemtime($img)));
}
}
}
}
}
if (count($kepek) > 0)
$_SESSION["kepek"] = $kepek;
else
$_SESSION["kepek"] = array();
} else if (isset($_POST['changepassword'])) { // jelszo modositasa
$ret = 0;
$oldPassword = $_POST["oldpassword"];
$newPassword = $_POST["password"];
$userId = $_SESSION["user"]["user_id"];
$userPassword = GetUserPassword($userId);
if (password_verify($oldPassword, $userPassword)) {
$options = ['cost' => HASH_OPTIONS_COST, 'salt' => HASH_OPTIONS_SALT];
$newPassword_ = password_hash($newPassword, PASSWORD_BCRYPT, $options);
$ret = UpdateUserPassword($userId, $newPassword_);
if ($ret) {
if (strtolower($_SESSION["user"]["username"]) != strtolower($newPassword))
$_SESSION["user"]["goodpassword"] = true;
else
$_SESSION["user"]["goodpassword"] = false;
}
} else {
$ret = "A megadott jelenlegi jelszó nem megfelelő!";
}
echo $ret;
return;
} else if (isset($_POST['closeragacslist'])) { // ragasztasi lista lezarasa
$ret = 0;
$datum = $_POST["closedate"];
$ret = CloseRagacsList($datum);
echo $ret;
return;
} else if (isset($_POST['openragacslist'])) { // ragasztasi lista megnyitasa
$ret = 0;
$datum = $_POST["opendate"];
$ret = OpenRagacsList($datum);
echo $ret;
return;
} else if (isset($_POST['deleteragacslist'])) { // ragasztasi lista torlese
$ret = 0;
$datum = $_POST["deletedate"];
$db = GetUploadedPhotoDb($datum);
if ($db == null) {
$ret = "nolist";
} else if (intval($db) > 0) {
$ret = 0;
} else if (intval($db) == 0) {
$feluletek = GetFeluletekByRagasztasDatum($datum);
$users = GetUsersByRagasztasDatum($datum);
$ret = DeleteRagacsList($datum);
// add delete job to server
if ($ret > 0 && count($feluletek) > 0 && !SERVER_SIDE && EXCHANGE_DATA) {
foreach ($feluletek as $felulet) {
if (is_array($felulet) && isset($felulet["felulet_kod"]) && isset($felulet["ragasztas_datum"]))
InsertJobToServer("", $felulet["felulet_kod"], 0, $felulet["ragasztas_datum"]);
}
}
foreach ($users as $user) {
if (GetFeluletDbByUser($user["user_id"]) == 0)
DeleteUser($user["user_id"]);
}
}
echo $ret;
return;
} else if (isset($_POST['closekampany'])) { // kampany lezarasa
$ret = 0;
if (isset($_POST["kampanyid"]) && isset($_POST["closekampanydate"])) {
$kampanyId = $_POST["kampanyid"];
$datum = $_POST["closekampanydate"];
}
$ret = CloseKampany($kampanyId, $datum);
echo $ret;
return;
} else if (isset($_POST['openkampany'])) { // kampany megnyitasa
$ret = 0;
if (isset($_POST["kampanyid"]) && isset($_POST["openkampanydate"])) {
$kampanyId = $_POST["kampanyid"];
$datum = $_POST["openkampanydate"];
$ret = OpenKampany($kampanyId, $datum);
}
echo $ret;
return;
} else if (isset($_POST['deletekampany'])) { // kampany torlese
$ret = array("result" => 0, "message" => "");
if (isset($_POST["kampanyid"]) && isset($_POST["deletekampanydate"])) {
$kampanyId = $_POST["kampanyid"];
$datum = $_POST["deletekampanydate"];
$db = GetFeluletDbByKampanyIdDatum($kampanyId, $datum);
if ($db == 0) {
$db_ = DeleteKampany($kampanyId, $datum);
if ($db_ > 0) {
$ret = array("result" => 1, "message" => "A kampány törlése sikeresen megtörtént!");
if (EXCHANGE_DATA && !SERVER_SIDE)
InsertJobToServer("", "", $kampanyId, $datum);
} else
$ret = array("result" => 0, "message" => "Nincs törlendő kampány!");
} else {
$ret = array("result" => 0, "message" => "A kampányhoz már van feltöltve kép!");
}
} else {
$ret = array("result" => 0, "message" => "Hiányzó bemeneti paraméter!");
}
echo json_encode($ret);
return;
} else if (isset($_POST['downloadphotos'])) { // fotok letoltese zip-ben
$zipFile = "";
$workingDir = getcwd();
// chdir("photos");
$onlyRepairedPhoto = 0;
if (isset($_POST["onlyrepairedphoto"]))
$onlyRepairedPhoto = $_POST["onlyrepairedphoto"];
$onlyStationPhoto = 0;
if (isset($_POST["onlystationphoto"]))
$onlyStationPhoto = $_POST["onlystationphoto"];
$fdfrom = "";
if (isset($_POST["fdfrom"]))
$fdfrom = $_POST["fdfrom"];
$fdto = "";
if (isset($_POST["fdto"]))
$fdto = $_POST["fdto"];
$fkezdodatumAsTimeStamp = 0;
if ($fdfrom != "")
$fkezdodatumAsTimeStamp = strtotime(substr($fdfrom, 0, 4) . "-" . substr($fdfrom, 5, 2) . "-" . substr($fdfrom, 8, 2));
$fvegsodatumAsTimeStamp = 0;
if ($fdto != "")
$fvegsodatumAsTimeStamp = strtotime(substr($fdto, 0, 4) . "-" . substr($fdto, 5, 2) . "-" . substr($fdto, 8, 2) . " 23:59:59");
if (isset($_POST["feluletid"])) {
$feluletId = $_POST["feluletid"];
$felulet = GetFelulet($feluletId);
$feluletKod = $felulet["felulet_kod"];
$sajatKod = $felulet["sajat_kod"];
// $zipFile = "../" . TMP_DIRECTORY . date("Ymd", strtotime($felulet["ragasztas_datum"])) . "_" . $feluletKod . "_" . uniqid() . ".zip";
$zipFile = TMP_DIRECTORY . date("Ymd", strtotime($felulet["ragasztas_datum"])) . "_" . $feluletKod . "_" . uniqid() . ".zip";
$zip = new ZipArchive;
$zip->open($zipFile, ZipArchive::CREATE);
$dir = PHOTO_DIRECTORY . date("Y", strtotime($felulet["ragasztas_datum"])) . "/" . date("m", strtotime($felulet["ragasztas_datum"])) . "/" . $felulet["kampany_id"] . "/" . date("Y.m.d.", strtotime($felulet["ragasztas_datum"]));
chdir($dir);
// $files = glob(date("Y", strtotime($felulet["ragasztas_datum"])) . "/" . date("m", strtotime($felulet["ragasztas_datum"])) . "/" . $felulet["kampany_id"] . "/" . date("Y.m.d.", strtotime($felulet["ragasztas_datum"])) . "/*");
$files = glob("*");
foreach ($files as $file) {
if (fnmatch(strtoupper($feluletKod . ".jpg"), strtoupper(basename($file))) !== false || fnmatch(strtoupper($feluletKod . "_J.jpg"), strtoupper(basename($file))) !== false || fnmatch(strtoupper($feluletKod . "-F*.jpg"), strtoupper(basename($file))) !== false || (trim($sajatKod) != "" && (fnmatch(strtoupper($sajatKod . ".jpg"), strtoupper(basename($file))) !== false || fnmatch(strtoupper($sajatKod . "_J.jpg"), strtoupper(basename($file))) !== false || fnmatch(strtoupper($sajatKod . "-F*.jpg"), strtoupper(basename($file))) !== false))) {
if (isAddFile($file, $onlyRepairedPhoto, $onlyStationPhoto, $fkezdodatumAsTimeStamp, $fvegsodatumAsTimeStamp))
if (defined("USE_SAJATKOD_AS_FILENAME_FOR_DOWNLOAD") && USE_SAJATKOD_AS_FILENAME_FOR_DOWNLOAD == 1)
$zip->addFile($file, $felulet["kampany_id"] . "/" . date("Y.m.d.", strtotime($felulet["ragasztas_datum"])) . "/" . str_replace($feluletKod, $sajatKod, $file));
else
$zip->addFile($file, $felulet["kampany_id"] . "/" . date("Y.m.d.", strtotime($felulet["ragasztas_datum"])) . "/" . $file);
}
}
$zip->close();
}
chdir($workingDir);
if (!file_exists($zipFile))
$zipFile = "";
echo $zipFile;
return;
} else if (isset($_POST['downloadkampanyphotos'])) { // kampanyfotok letoltese zip-ben
$zipFile = "";
$workingDir = getcwd();
// chdir("photos");
$onlyRepairedPhoto = 0;
if (isset($_POST["onlyrepairedphoto"]))
$onlyRepairedPhoto = $_POST["onlyrepairedphoto"];
$onlyStationPhoto = 0;
if (isset($_POST["onlystationphoto"]))
$onlyStationPhoto = $_POST["onlystationphoto"];
if (isset($_POST["kampanyid"])) {
$kampanyId = $_POST["kampanyid"];
$feluletek = GetFeluletekByKampanyId($kampanyId);
$zipFile = "";
$fdfrom = "";
if (isset($_POST["fdfrom"]))
$fdfrom = $_POST["fdfrom"];
$fdto = "";
if (isset($_POST["fdto"]))
$fdto = $_POST["fdto"];
$fkezdodatumAsTimeStamp = 0;
if ($fdfrom != "")
$fkezdodatumAsTimeStamp = strtotime(substr($fdfrom, 0, 4) . "-" . substr($fdfrom, 5, 2) . "-" . substr($fdfrom, 8, 2));
$fvegsodatumAsTimeStamp = 0;
if ($fdto != "")
$fvegsodatumAsTimeStamp = strtotime(substr($fdto, 0, 4) . "-" . substr($fdto, 5, 2) . "-" . substr($fdto, 8, 2) . " 23:59:59");
if (count($feluletek) > 0) {
$zipFile = TMP_DIRECTORY . date("Ymd", strtotime($feluletek[0]["ragasztas_datum"])) . "_" . $feluletek[0]["kampany_id"] . "_" . uniqid() . ".zip";
$zip = new ZipArchive;
$zip->open($zipFile, ZipArchive::CREATE);
foreach($feluletek as $felulet) {
$feluletKod = $felulet["felulet_kod"];
$sajatKod = $felulet["sajat_kod"];
$dir = PHOTO_DIRECTORY . date("Y", strtotime($felulet["ragasztas_datum"])) . "/" . date("m", strtotime($felulet["ragasztas_datum"])) . "/" . $felulet["kampany_id"] . "/" . date("Y.m.d.", strtotime($felulet["ragasztas_datum"]));
if (file_exists($dir)) {
chdir($dir);
$files = glob("*");
foreach ($files as $file) {
if (fnmatch(strtoupper($feluletKod . ".jpg"), strtoupper(basename($file))) !== false || fnmatch(strtoupper($feluletKod . "_J.jpg"), strtoupper(basename($file))) !== false || fnmatch(strtoupper($feluletKod . "-F*.jpg"), strtoupper(basename($file))) !== false || (trim($sajatKod) != "" && (fnmatch(strtoupper($sajatKod . ".jpg"), strtoupper(basename($file))) !== false || fnmatch(strtoupper($sajatKod . "_J.jpg"), strtoupper(basename($file))) !== false || fnmatch(strtoupper($sajatKod . "-F*.jpg"), strtoupper(basename($file))) !== false))) {
if (isAddFile($file, $onlyRepairedPhoto, $onlyStationPhoto, $fkezdodatumAsTimeStamp, $fvegsodatumAsTimeStamp))
if (defined("USE_SAJATKOD_AS_FILENAME_FOR_DOWNLOAD") && USE_SAJATKOD_AS_FILENAME_FOR_DOWNLOAD == 1)
$zip->addFile($file, $felulet["kampany_id"] . "/" . date("Y.m.d.", strtotime($felulet["ragasztas_datum"])) . "/" . str_replace($feluletKod, $sajatKod, $file));
else
$zip->addFile($file, $felulet["kampany_id"] . "/" . date("Y.m.d.", strtotime($felulet["ragasztas_datum"])) . "/" . $file);
}
}
}
chdir($workingDir);
}
$zip->close();
}
}
if ($zipFile == "" || !file_exists($zipFile))
$zipFile = "";
echo $zipFile;
return;
} else if (isset($_POST['downloadallphotos'])) { // feltetelek alapjan levalogatott feluletek fotoinak letoltese zip-ben
$zipFile = "";
$workingDir = getcwd();
$dfrom = $_POST['dfrom'];
$dto = $_POST['dto'];
$userId = $_POST['userid'];
$isAdmin = $_SESSION["user"]["isadmin"];
$varosId = $_POST['varosid'];
$kampanyId = trim($_POST['kampanyid']);
$feluletKod = trim($_POST['feluletkod']);
$searchFeluletKodCenter = $_POST['searchfeluletkodcenter'];
$surfaceId = $_POST['surfaceid'];
$isNeedPhoto = $_POST['isneedphoto'];
$plakatNev = $_POST['plakatnev'];
$fdfrom = $_POST['fdfrom'];
$fdto = $_POST['fdto'];
$fkezdodatumAsTimeStamp = 0;
if ($fdfrom != "")
$fkezdodatumAsTimeStamp = strtotime(substr($fdfrom, 0, 4) . "-" . substr($fdfrom, 5, 2) . "-" . substr($fdfrom, 8, 2));
$fvegsodatumAsTimeStamp = 0;
if ($fdto != "")
$fvegsodatumAsTimeStamp = strtotime(substr($fdto, 0, 4) . "-" . substr($fdto, 5, 2) . "-" . substr($fdto, 8, 2) . " 23:59:59");
$uploadedPhoto = trim($_POST['uploadedphoto']);
$cegId = $_POST['cegid'];
$onlyRepairedPhoto = 0;
if (isset($_POST["onlyrepairedphoto"]))
$onlyRepairedPhoto = $_POST["onlyrepairedphoto"];
$onlyStationPhoto = 0;
if (isset($_POST["onlystationphoto"]))
$onlyStationPhoto = $_POST["onlystationphoto"];
$surfaceType = 0;
if (isset($_POST['surfacetype']))
$surfaceType = $_POST['surfacetype'];
$feluletek = GetFeluletek($dfrom, $dto, $userId, $isAdmin, $varosId, $kampanyId, $feluletKod, $searchFeluletKodCenter, $surfaceId, true, $isNeedPhoto, $fdfrom, $fdto, $uploadedPhoto, $cegId, $plakatNev, $surfaceType);
if (count($feluletek) > 0) {
$zipFile = TMP_DIRECTORY . uniqid() . ".zip";
$zip = new ZipArchive;
$zip->open($zipFile, ZipArchive::CREATE);
foreach($feluletek as $felulet) {
$feluletKod = $felulet["felulet_kod"];
$sajatKod = $felulet["sajat_kod"];
$dir = PHOTO_DIRECTORY . date("Y", strtotime($felulet["ragasztas_datum"])) . "/" . date("m", strtotime($felulet["ragasztas_datum"])) . "/" . $felulet["kampany_id"] . "/" . date("Y.m.d.", strtotime($felulet["ragasztas_datum"]));
if (file_exists($dir)) {
chdir($dir);
$files = glob("*");
foreach ($files as $file) {
if (fnmatch(strtoupper($feluletKod . ".jpg"), strtoupper(basename($file))) !== false || fnmatch(strtoupper($feluletKod . "_J.jpg"), strtoupper(basename($file))) !== false || fnmatch(strtoupper($feluletKod . "-F*.jpg"), strtoupper(basename($file))) !== false || (trim($sajatKod) != "" && (fnmatch(strtoupper($sajatKod . ".jpg"), strtoupper(basename($file))) !== false || fnmatch(strtoupper($sajatKod . "_J.jpg"), strtoupper(basename($file))) !== false || fnmatch(strtoupper($sajatKod . "-F*.jpg"), strtoupper(basename($file))) !== false))) {
if (isAddFile($file, $onlyRepairedPhoto, $onlyStationPhoto, $fkezdodatumAsTimeStamp, $fvegsodatumAsTimeStamp)) {
if (defined("USE_SAJATKOD_AS_FILENAME_FOR_DOWNLOAD") && USE_SAJATKOD_AS_FILENAME_FOR_DOWNLOAD == 1)
$zip->addFile($file, $felulet["kampany_id"] . "/" . date("Y.m.d.", strtotime($felulet["ragasztas_datum"])) . "/" . str_replace($feluletKod, $sajatKod, $file));
else
$zip->addFile($file, $felulet["kampany_id"] . "/" . date("Y.m.d.", strtotime($felulet["ragasztas_datum"])) . "/" . $file);
}
}
}
}
chdir($workingDir);
}
$zip->close();
}
if ($zipFile == "" || !file_exists($zipFile))
$zipFile = "";
echo $zipFile;
} else if (isset($_POST['deletefelulet'])) { // felulet torlese
$ret = array("result" => 0, "message" => "");
$feluletIds = array();
$felulet = null;
$result = 1;
$message = "";
if (isset($_POST["feluletids"])) {
$feluletIds = $_POST["feluletids"];
foreach ($feluletIds as $feluletId) {
$felulet = GetFelulet($feluletId);
$ret = DeleteFelulet($feluletId);
if ($ret < 1) {
$result = 0;
$message .= "Felület törlése sikertelen! Felületkód: " . $felulet["felulet_kod"] . "\n";
} else {
// add delete job to server
if ($ret > 0 && !SERVER_SIDE && EXCHANGE_DATA) {
if (is_array($felulet) && isset($felulet["felulet_kod"]) && isset($felulet["ragasztas_datum"]))
InsertJobToServer("", $felulet["felulet_kod"], 0, $felulet["ragasztas_datum"]);
}
}
}
}
if ($result == 1) {
if (count($feluletIds) > 1)
$message = "Felületek törlése sikeresen megtörtént!";
else
$message = "Felület törlése sikeresen megtörtént!";
}
$ret = array("result" => $result, "message" => $message);
echo json_encode($ret);
return;
} else if (isset($_POST['importosztolist'])) { // plakat nevenek modositasa
if (isset($_POST["uploadedxlsfile"])) {
$xlsFile = $_POST["uploadedxlsfile"];
$ret = importOsztoLista($xlsFile);
} else {
$ret = array("ret" => "Az xls file nem található!", "filename" => "");
}
echo json_encode($ret);
return;
} else if (isset($_POST['serverjob']) && $_POST['serverjob'] == 1) { // server job
$ret = array("result" => 0, "message" => "");
$feluletKod = "";
if (isset($_POST["feluletkod"]))
$feluletKod = $_POST["feluletkod"];
$kampanyId = 0;
if (isset($_POST["kampanyid"]))
$kampanyId = $_POST["kampanyid"];
$ragacsDatum = 0;
if (isset($_POST["ragacsdatum"]))
$ragacsDatum = date("Y.m.d.", $_POST["ragacsdatum"]);
if ($feluletKod != "") {
$felulet = GetFeluletByFeluletKodRagasztasiDatum($feluletKod, $ragacsDatum);
if (is_array($felulet) && isset($felulet["ragacslist_id"]) && isset($felulet["uploadedphoto"])) {
if ($felulet["uploadedphoto"] == 0) {
$ret = DeleteFelulet($felulet["ragacslist_id"]);
if ($ret == 1) {
$ret = array("result" => 1, "message" => "A felület (" . $feluletKod . ", " . $ragacsDatum . ") törölve!");
errorlog("A felület (" . $felulet["ragacslist_id"] . ") törölve!");
} else {
$ret = array("result" => 0, "message" => "A felület (" . $feluletKod . ", " . $ragacsDatum . ") törlése sikertelen!");
errorlog("A felület (" . $felulet["ragacslist_id"] . ") törlése sikertelen!");
}
} else {
$ret = array("result" => 0, "message" => "A felülethez (" . $feluletKod . ", " . $ragacsDatum . ") már van kép feltöltve!");
errorlog("A felülethez (" . $felulet["ragacslist_id"] . ") már van kép feltöltve!");
}
} else {
$ret = array("result" => 1, "message" => "A felület (" . $feluletKod . ", " . $ragacsDatum . ") nem található");
errorlog("A felület (" . $feluletKod . ", " . $ragacsDatum . ") nem található");
}
} else if ($kampanyId > 0) {
$db = GetFeluletDbByKampanyIdDatum($kampanyId, $ragacsDatum);
if ($db == 0) {
$db_ = DeleteKampany($kampanyId, $ragacsDatum);
if ($db_ > 0)
$ret = array("result" => 1, "message" => "A kampány törlése sikeresen megtörtént!");
else
$ret = array("result" => 1, "message" => "Nincs törlendő kampány!");
} else {
$ret = array("result" => 0, "message" => "A kampányhoz már van feltöltve kép!");
}
} else {
$ret = array("result" => 0, "message" => "Nem érkezett meg a törléshez szükséges minden adat! (Felület kód: " . $feluletKod . ", kampány id: " . $kampanyId . ", ragasztás dátum: " . $ragacsDatum . ")");
errorlog("Nem érkezett meg a törléshez szükséges minden adat! (Felület kód: " . $feluletKod . ", kampány id: " . $kampanyId . ", ragasztás dátum: " . $ragacsDatum . ")");
}
echo json_encode($ret);
return;
} else if (isset($_POST['selectdisablingragasztok']) && $_POST['selectdisablingragasztok'] == 1) { // select disabling ragasztok for ragasztok select widget
// levalogatjuk a ragasztokat feltetelek alapjan
$kezdodatum = $_POST['kezdodatum'];
$vegsodatum = $_POST['vegsodatum'];
if ($_POST['varosid'] == null)
$varosId = array();
else
$varosId = $_POST['varosid'];
$kampanyId = trim($_POST['kampanyid']);
$feluletKod = trim($_POST['feluletkod']);
$searchFeluletKodCenter = $_POST['searchfeluletkodcenter'];
$surfaceId = $_POST['surfaceid'];
$isNeedPhoto = $_POST['isneedphoto'];
$plakatNev = $_POST['plakatnev'];
$fkezdodatum = $_POST['fkezdodatum'];
$fvegsodatum = $_POST['fvegsodatum'];
$uploadedPhoto = trim($_POST['uploadedphoto']);
$cegId = $_POST['cegid'];
$surfaceType = 0;
if (isset($_POST['surfacetype']))
$surfaceType = $_POST['surfacetype'];
$ragasztok = GetDisablingRagasztok($kezdodatum, $vegsodatum, $varosId, $kampanyId, $feluletKod, $searchFeluletKodCenter, $surfaceId, $isNeedPhoto, $fkezdodatum, $fvegsodatum, $uploadedPhoto, $cegId, $plakatNev, $surfaceType);
echo json_encode($ragasztok);
} else {
unset($_SESSION["kepek"]);
if ($_SESSION["user"]["isadmin"] == 0)
header("Location: /ragasztas");
$ragasztoUsers = GetRagasztoUsers();
$ragasztoUsers_ = array(0 => "Minden ragasztó");
foreach ($ragasztoUsers as $ragasztoUser) {
$ragasztoUsers_[$ragasztoUser["user_id"]] = $ragasztoUser["name"];
}
$smarty->assign('ragasztoUsers', $ragasztoUsers_);
$varosok = GetVarosok();
$varosok_ = array(0 => "Minden város");
foreach ($varosok as $varos) {
$varosok_[$varos["varos_id"]] = $varos["varos"];
}
$smarty->assign('varosok', $varosok_);
$cegek = GetCegek();
$cegek_ = array(0 => "Minden cég");
foreach ($cegek as $ceg) {
$cegek_[$ceg["ceg_id"]] = $ceg["nev"];
}
$smarty->assign('cegek', $cegek_);
$localCegek = GetLocalCegek();
$localCegek_ = array(0 => "Válassz!");
foreach ($localCegek as $localCeg) {
$localCegek_[$localCeg["ceg_id"]] = $localCeg["nev"];
}
$smarty->assign('localcegek', $localCegek_);
/* $datumok = GetRagasztasDatumIntervallum(0);
$dateFrom = "";
$dateTo = "";
if (isset($datumok["datefrom"]))
$dateFrom = date("Y.m.d.", strtotime($datumok["datefrom"]));
else
$dateFrom = date("Y.m.d.");
if (isset($datumok["dateto"]))
$dateTo = date("Y.m.d.", strtotime($datumok["dateto"]));
else
$dateTo = date("Y.m.d.");
*/
$dateFrom = date("Y.m.01.");
$dateTo = date("Y.m.d.");
$smarty->assign('login', 1);
$smarty->assign('isadmin', $_SESSION["user"]["isadmin"]);
if (SERVER_SIDE)
$smarty->assign('isserverside', 1);
else
$smarty->assign('isserverside', 0);
$smarty->assign('datumfrom', $dateFrom);
$smarty->assign('datumto', $dateTo);
$smarty->assign('name', $_SESSION["user"]["name"]);
$smarty->assign('version', VERSIONNUMBER);
$smarty->assign('company', COMPANYNAME);
$smarty->display('admin.tpl');
}
?>