コード例 #1
0
ファイル: member_form.php プロジェクト: refirio/levis-members
<?php

import('libs/plugins/file.php');
import('libs/plugins/ui.php');
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    // ワンタイムトークン
    if ((empty($_POST['view']) || $_POST['view'] !== 'preview') && !token('check')) {
        error('不正なアクセスです。');
    }
    // 入力データを整理
    $post = array('member' => normalize_members(array('id' => isset($_POST['id']) ? $_POST['id'] : '', 'class_id' => isset($_POST['class_id']) ? $_POST['class_id'] : '', 'name' => isset($_POST['name']) ? $_POST['name'] : '', 'name_kana' => isset($_POST['name_kana']) ? $_POST['name_kana'] : '', 'grade' => isset($_POST['grade']) ? $_POST['grade'] : '', 'birthday' => isset($_POST['birthday']) ? $_POST['birthday'] : '', 'email' => isset($_POST['email']) ? $_POST['email'] : '', 'tel' => isset($_POST['tel']) ? $_POST['tel'] : '', 'memo' => isset($_POST['memo']) ? $_POST['memo'] : '', 'public' => isset($_POST['public']) ? $_POST['public'] : '', 'category_sets' => isset($_POST['category_sets']) ? $_POST['category_sets'] : array())));
    if (isset($_POST['view']) && $_POST['view'] === 'preview') {
        // プレビュー
        $_view['member'] = $post['member'];
    } else {
        // 入力データを検証&登録
        $warnings = validate_members($post['member']);
        if (isset($_POST['_type']) && $_POST['_type'] === 'json') {
            if (empty($warnings)) {
                ok();
            } else {
                warning($warnings);
            }
        } else {
            if (empty($warnings)) {
                $_SESSION['post']['member'] = $post['member'];
                // フォワード
                forward('/admin/member_post');
            } else {
                $_view['member'] = $post['member'];
                $_view['warnings'] = $warnings;
コード例 #2
0
ファイル: member.php プロジェクト: refirio/levis-members
/**
 * 名簿をインポート
 *
 * @param string $filename
 *
 * @return array
 */
function service_member_import($filename)
{
    if ($fp = fopen($filename, 'r')) {
        $options = array('grades' => array_flip($GLOBALS['config']['options']['member']['grades']), 'publics' => array_flip($GLOBALS['config']['options']['member']['publics']));
        if ($_POST['operation'] === 'replace') {
            // 元データ削除
            $resource = db_delete(array('delete_from' => DATABASE_PREFIX . 'members'));
            if (!$resource) {
                error('データを削除できません。');
            }
            $resource = db_delete(array('delete_from' => DATABASE_PREFIX . 'category_sets'));
            if (!$resource) {
                error('データを削除できません。');
            }
        }
        // CSVファイルの一行目を無視
        $dummy = file_getcsv($fp);
        // CSVファイル読み込み
        $all_warnings = array();
        $i = 1;
        while ($line = file_getcsv($fp)) {
            list($id, $created, $modified, $deleted, $class_id, $name, $name_kana, $grade, $birthday, $email, $tel, $memo, $image_01, $image_02, $public, $dummy, $category_sets) = $line;
            // 入力データを整理
            $post = array('member' => normalize_members(array('id' => mb_convert_encoding($id, 'UTF-8', 'SJIS-WIN'), 'created' => mb_convert_encoding($created, 'UTF-8', 'SJIS-WIN'), 'modified' => mb_convert_encoding($modified, 'UTF-8', 'SJIS-WIN'), 'deleted' => mb_convert_encoding($deleted, 'UTF-8', 'SJIS-WIN'), 'class_id' => mb_convert_encoding($class_id, 'UTF-8', 'SJIS-WIN'), 'name' => mb_convert_encoding($name, 'UTF-8', 'SJIS-WIN'), 'name_kana' => mb_convert_encoding($name_kana, 'UTF-8', 'SJIS-WIN'), 'grade' => $options['grades'][mb_convert_encoding($grade, 'UTF-8', 'SJIS-WIN')], 'birthday' => mb_convert_encoding($birthday, 'UTF-8', 'SJIS-WIN'), 'email' => mb_convert_encoding($email, 'UTF-8', 'SJIS-WIN'), 'tel' => mb_convert_encoding($tel, 'UTF-8', 'SJIS-WIN'), 'memo' => mb_convert_encoding($memo, 'UTF-8', 'SJIS-WIN'), 'image_01' => mb_convert_encoding($image_01, 'UTF-8', 'SJIS-WIN'), 'image_02' => mb_convert_encoding($image_02, 'UTF-8', 'SJIS-WIN'), 'public' => $options['publics'][mb_convert_encoding($public, 'UTF-8', 'SJIS-WIN')])));
            // 入力データを検証&登録
            $warnings = validate_members($post['member']);
            if (empty($warnings)) {
                if ($_POST['operation'] === 'update') {
                    // データ編集
                    $resource = db_update(array('update' => DATABASE_PREFIX . 'members', 'set' => array('created' => $post['member']['created'], 'modified' => $post['member']['modified'], 'deleted' => $post['member']['deleted'], 'class_id' => $post['member']['class_id'], 'name' => $post['member']['name'], 'name_kana' => $post['member']['name_kana'], 'grade' => $post['member']['grade'], 'birthday' => $post['member']['birthday'], 'email' => $post['member']['email'], 'tel' => $post['member']['tel'], 'memo' => $post['member']['memo'], 'image_01' => $post['member']['image_01'], 'image_02' => $post['member']['image_02'], 'public' => $post['member']['public']), 'where' => array('id = :id', array('id' => $post['member']['id']))));
                    if (!$resource) {
                        error('データを編集できません。');
                    }
                } else {
                    // データ登録
                    $resource = db_insert(array('insert_into' => DATABASE_PREFIX . 'members', 'values' => array('id' => $post['member']['id'], 'created' => $post['member']['created'], 'modified' => $post['member']['modified'], 'deleted' => $post['member']['deleted'], 'class_id' => $post['member']['class_id'], 'name' => $post['member']['name'], 'name_kana' => $post['member']['name_kana'], 'grade' => $post['member']['grade'], 'birthday' => $post['member']['birthday'], 'email' => $post['member']['email'], 'tel' => $post['member']['tel'], 'memo' => $post['member']['memo'], 'image_01' => $post['member']['image_01'], 'image_02' => $post['member']['image_02'], 'public' => $post['member']['public'])));
                    if (!$resource) {
                        error('データを登録できません。');
                    }
                }
                if ($category_sets) {
                    // 分類を登録
                    $category_sets = explode(',', $category_sets);
                    foreach ($category_sets as $category_id) {
                        $resource = db_insert(array('insert_into' => DATABASE_PREFIX . 'category_sets', 'values' => array('category_id' => $category_id, 'member_id' => $id)));
                        if (!$resource) {
                            return $resource;
                        }
                    }
                }
            } else {
                foreach ($warnings as $warning) {
                    $all_warnings[] = '[' . $i . '行目] ' . $warning;
                }
            }
            $i++;
        }
        fclose($fp);
        if (empty($all_warnings)) {
            return array();
        } else {
            return $all_warnings;
        }
    } else {
        return array('ファイルを読み込めません。');
    }
}