4: 2010-05-15 (土) 08:41:05 admin  |
5: 2010-05-15 (土) 13:49:05 admin |
| - | ** Block [#cd316551] | + | ** Moodle1.9 Programing [#l2cb4679] |
| | - http://docs.moodle.org/en/Development:Blocks | | - http://docs.moodle.org/en/Development:Blocks |
| | #br | | #br |
| - | global 変数 | |
| | | | |
| - | $CFG, $USER | + | *** global 変数 [#s52b390d] |
| | | | |
| - | $CFG->wwwroot top url | + | **** $CFG [#v460c415] |
| - | $CFG->prefix | + | - $CFG->wwwroot ： top url |
| - | $USER->id | + | - $CFG->prefix |
| - | empty($submit) | + | |
| | | | |
| - | $_POST | + | **** $USER [#ecf0673b] |
| | + | - $USER->id |
| | | | |
| | + | **** $_POST [#jf217b7d] |
| | + | - empty($_POST) |
| | | | |
| | + | #br |
| | + | *** POST, GET [#i893cfed] |
| | + | - required_param('course', PARAM_INT); |
| | + | - optional_param('mode', '', PARAM_ALPHA); |
| | + | #br |
| | | | |
| - | 権限 | + | *** 権限 [#kca35ac9] |
| | + | - isadmin() |
| | + | - isguest() |
| | + | - require_login($course->id); |
| | + | - isteacher($course->id) |
| | + | #br |
| | | | |
| - | isadmin() | |
| - | isguest() | |
| - | require_login($course->id); | |
| - | isteacher($course->id) | |
| | | | |
| | | | |
| - | パラメータ | |
| | | | |
| | + | *** メッセージ [#pb1c2054] |
| | + | - get_string( , ) |
| | + | #br |
| | | | |
| - | required_param('course', PARAM_INT); // Course id | + | *** DataBase [#v4abf387] |
| - | optional_param('mode', '', PARAM_ALPHA); // one or multiply or empty | + | - lib/dmllib.php |
| | + | #br |
| | | | |
| | + | **** count_records [#rc2a2d4a] |
| | + | $count = count_records('autoattend_sessions', 'courseid', $course->id, 'sessdate', $sdate, 'starttime', $starttime); |
| | | | |
| - | | + | **** get_record(s) [#z3e3f469] |
| - | メッセージ | + | - get_record($table, $field1, $value1, $field2='', $value2='', $field3='', $value3='', $fields='*') |
| - | | + | $course = get_record('course', 'id', $courseid); |
| - | get_string( , ) | + | $user = get_record("user", "id", $USER->id); |
| - | | + | - get_records($table, $field='', $value='', $sort='', $fields='*', $limitfrom='', $limitnum='') |
| - | | + | if (!$vars = get_records('autoattend_settings', 'courseid', $courseid, 'id')) { |
| - | DB操作 | + | $vars = get_records('autoattend_settings', 'courseid', 0); // use default |
| - | | + | } |
| - | $course = get_record('course', 'id', $courseid) | + | **** get_records_sql [#r096c770] |
| - | $user = get_record("user", "id", $USER->id) | + | $qey = "SELECT * FROM ......."; |
| - | delete_records('autoattend_settings', 'courseid', $course->id); | + | if ($users = get_records_sql($qry)) { |
| - | | + | foreach($users as $key => $user) { |
| - | insert_record('autoattend_sessions', $rec) | + | $return['id'] = $user->id; |
| - | | + | $return['attsid'] = $user->attsid; |
| - | $count = count_records('autoattend_sessions', 'courseid', $course->id, 'sessdate', $sdate, 'starttime', $starttime); | + | ............................. |
| - | | + | |
| - | lib/dmllib.php | + | |
| - | | + | |
| - | get_record($table, $field1, $value1, $field2='', $value2='', $field3='', $value3='', $fields='*') | + | |
| - | | + | |
| - | get_records($table, $field='', $value='', $sort='', $fields='*', $limitfrom='', $limitnum='') | + | |
| - | | + | |
| - | if ($rec = get_record('autoattend_settings', 'courseid', $course->id, 'status', $status[$i])) { | + | |
| - | $update = true; | + | |
| - | } | + | |
| - | $rec->courseid = $course->id; | + | |
| - | $rec->status = $status[$i]; | + | |
| - | $rec->grade = $grade[$i]; | + | |
| - | | + | |
| - | if (@$update) { | + | |
| - | $result = update_record('autoattend_settings', $rec); | + | |
| - | if (!$result) break; | + | |
| - | } | + | |
| - | else { | + | |
| - | $result = insert_record('autoattend_settings', $rec); | + | |
| - | if (!$result) break; | + | |
| - | } | + | |
| - | unset($rec); | + | |
| - | | + | |
| - | | + | |
| - | | + | |
| - | | + | |
| - | if ($users = get_records_sql($qry)) { | + | |
| - | foreach($users as $key => $user) { | + | |
| - | $return['id'] = $user->id; | + | |
| - | $return['attsid'] = $user->attsid; | + | |
| - | $return['studentid'] = $user->studentid; | + | |
| - | $return['status'] = $user->status; | + | |
| - | $return['called'] = $user->called; | + | |
| - | $return['calledby'] = $user->calledby; | + | |
| - | $return['calledtime'] = $user->calledtime; | + | |
| - | $return['remarks'] = $user->remarks; | + | |
| - | $return['ipaddress'] = $user->ipaddress; | + | |
| - | } | + | |
| | } | | } |
| | + | } |
| | | | |
| | + | **** update_record, insert_record [#bfdf5685] |
| | + | $update = false; |
| | + | if ($rec = get_record('autoattend_settings', 'courseid', $course->id, 'status', $status[$i])) { |
| | + | $update = true; |
| | + | } |
| | + | $rec->courseid = $course->id; |
| | + | ............................ |
| | + | if ($update) { |
| | + | $result = update_record('autoattend_settings', $rec); |
| | + | } |
| | + | else { |
| | + | $result = insert_record('autoattend_settings', $rec); |
| | + | } |
| | + | unset($rec); |
| | | | |
| | + | **** delete_records [#u570f164] |
| | + | delete_records('autoattend_settings', 'courseid', $course->id); |
| | | | |
| - | | + | **** XMLDB [#yaa09041] |
| - | add_to_log($course->id, 'autoattend', 'restore settings', 'att_settings.php?course='.$course->id); | + | |
| - | | + | |
| - | *** DataBase [#g7c2770d] | + | |
| - | *** XMLDB [#r9a4bceb] | + | |
| | - http://dev.moodle.org/mod/resource/view.php?id=48 | | - http://dev.moodle.org/mod/resource/view.php?id=48 |
| | - block にディレクトリを作成し，その中に dbディレクトリを作る． | | - block にディレクトリを作成し，その中に dbディレクトリを作る． |
| | - 「サイト管理」→「その他」→「XMLDBエディタ」 でデータベース定義用の db/install.xml を作成する． | | - 「サイト管理」→「その他」→「XMLDBエディタ」 でデータベース定義用の db/install.xml を作成する． |
| | + | #br |
| | + | |
| | + | *** ログ [#q8c98d5f] |
| | + | - add_to_log($course->id, 'autoattend', 'restore settings', 'att_settings.php?course='.$course->id); |
| | #br | | #br |
| | | | |
| | *** Form [#o9495a23] | | *** Form [#o9495a23] |
| | + | |
| | + | #br |
| | | | |
| | *** settings.php [#m49c050d] | | *** settings.php [#m49c050d] |
