��ѧۧݧ�ӧ�� ާ֧ߧ֧էا֧�

��ѧۧݧ�ӧ�� ާ֧ߧ֧էا֧� - ��֧էѧܧ�ڧ��ӧѧ�� - /home/alphpwcp/public_html/us/alphachat/modules/lhcannedmsg/import.php

��ѧ٧ѧ�
<?php $currentUser = erLhcoreClassUser::instance(); $currentUser->getUserID(); $tpl = erLhcoreClassTemplate::getInstance('lhcannedmsg/import.tpl.php'); if (isset($_POST['remove_old']) && $_POST['remove_old'] == true) { $tpl->set('remove_old', true); } if (isset($_POST['UploadFileAction'])) { $errors = []; if (!erLhcoreClassSearchHandler::isFile('files',array('csv')) \|\| !mb_check_encoding(file_get_contents($_FILES['files']["tmp_name"]), 'UTF-8')) { $errors[] = erTranslationClassLhTranslation::getInstance()->getTranslation('canned/import','File is not UTF-8 encoded!'); } if (empty($errors)) { $dir = 'var/tmpfiles/'; erLhcoreClassChatEventDispatcher::getInstance()->dispatch('theme.temppath', array('dir' => & $dir)); erLhcoreClassFileUpload::mkdirRecursive( $dir ); $filename = erLhcoreClassSearchHandler::moveUploadedFile('files', $dir); $header = NULL; $data = array(); if (($handle = fopen($dir . $filename, 'r')) !== FALSE) { while (($row = fgetcsv($handle, 10000, ",")) !== FALSE) { if(!$header) $header = $row; else $data[] = array_combine($header, $row); } fclose($handle); } unlink($dir . $filename); $canned = array_keys((new erLhcoreClassModelCannedMsg())->getState()); $canned[] = 'subject'; $canned[] = 'tags_plain'; $canned[] = 'department_ids_front'; $stats = array( 'updated' => 0, 'imported' => 0, 'removed' => 0, ); if ($canned === $header) { if (isset($_POST['remove_old']) && $_POST['remove_old'] == true) { foreach (erLhcoreClassModelCannedMsg::getList(array('limit' => false)) as $oldCanned) { $oldCanned->removeThis(); $stats['removed']++; } } foreach ($data as $item) { $cannedMessage = null; if (!empty($item['unique_id'])) { $cannedMessage = erLhcoreClassModelCannedMsg::findOne(array('filter' => array('unique_id' => $item['unique_id']))); } if (!($cannedMessage instanceof erLhcoreClassModelCannedMsg)) { $cannedMessage = new erLhcoreClassModelCannedMsg(); $stats['imported']++; } else { $stats['updated']++; } // Set departments if (isset($item['department_ids_front']) && !empty($item['department_ids_front'])) { $cannedMessage->department_ids = explode(',', $item['department_ids_front']); } unset($item['id']); $cannedMessage->setState($item); $cannedMessage->saveThis(); // Delete any previous subjects if any $db = ezcDbInstance::get(); $stmt = $db->prepare('DELETE FROM `lh_canned_msg_subject` WHERE `canned_id` = :canned_id'); $stmt->bindValue(':canned_id', $cannedMessage->id,PDO::PARAM_INT); $stmt->execute(); if (isset($item['subject']) && !empty($item['subject'])) { $subjectsPlain = explode(',',$item['subject']); foreach ($subjectsPlain as $subjectIndex => $subject) { $subjectsPlain[$subjectIndex] = trim($subject); } $subjects = erLhAbstractModelSubject::getList(array('limit' => false, 'filterin' => array('name' => $subjectsPlain))); foreach ($subjects as $subject) { $cannedSubject = new erLhcoreClassModelCannedMsgSubject(); $cannedSubject->canned_id = $cannedMessage->id; $cannedSubject->subject_id = $subject->id; $cannedSubject->saveThis(); } } } $tpl->set('update', $stats); } else { $tpl->set('errors', [erTranslationClassLhTranslation::getInstance()->getTranslation('canned/import','Expected columns does not match!')]); } } else { $tpl->set('errors', [erTranslationClassLhTranslation::getInstance()->getTranslation('canned/import','Invalid file format')]); } } $Result['content'] = $tpl->fetch(); $Result['pagelayout'] = 'popup'; ?>

| ver. 1.4 | Github | . | PHP 8.2.30 | ��֧ߧ֧�ѧ�ڧ� ��ѧߧڧ��: 0.09 | proxy | phpinfo | ��ѧ��ۧܧ�