From ea7b7f2d0b2feee86cc208174a5ce7c51d337cbd Mon Sep 17 00:00:00 2001 From: jhunkeler Date: Wed, 27 Jan 2010 23:07:49 +0000 Subject: Adding files previously not added to the SVN git-svn-id: http://svn.3rd-infantry-division.org/testing/branches/Bayonet CMS v2.1@479 c5b2fb0a-d05d-0410-98c8-828840a80ff6 --- admin/rudi/functions.php | 71 ++++++++ admin/rudi/includes/functions.awards.php | 20 +++ admin/rudi/includes/functions.members.php | 262 ++++++++++++++++++++++++++++++ admin/rudi/index.php | 58 +++++++ admin/rudi/views/view.awards.edit.php | 24 +++ admin/rudi/views/view.awards.php | 34 ++++ admin/rudi/views/view.members.award.php | 19 +++ admin/rudi/views/view.members.php | 49 ++++++ admin/rudi/views/view.members.profile.php | 195 ++++++++++++++++++++++ admin/rudi/views/view.members.service.php | 19 +++ admin/rudi/views/view.units.php | 0 11 files changed, 751 insertions(+) create mode 100644 admin/rudi/functions.php create mode 100644 admin/rudi/includes/functions.awards.php create mode 100644 admin/rudi/includes/functions.members.php create mode 100644 admin/rudi/index.php create mode 100644 admin/rudi/views/view.awards.edit.php create mode 100644 admin/rudi/views/view.awards.php create mode 100644 admin/rudi/views/view.members.award.php create mode 100644 admin/rudi/views/view.members.php create mode 100644 admin/rudi/views/view.members.profile.php create mode 100644 admin/rudi/views/view.members.service.php create mode 100644 admin/rudi/views/view.units.php (limited to 'admin/rudi') diff --git a/admin/rudi/functions.php b/admin/rudi/functions.php new file mode 100644 index 0000000..b22468b --- /dev/null +++ b/admin/rudi/functions.php @@ -0,0 +1,71 @@ +. + */ + /* + include $basedir.'rudi/functions.php'; + + //chek to see if the person is indeed an quartermaster + + if(isset($_GET['edit'])){ + + if($_GET['edit'] == "profile"){ + $member_id = $_GET['id']; + EditProfile($member_id); + return; + } + if($_GET['edit'] == "service"){ + if(isset($_GET['var'])){ + if($_GET['var'] == "add"){ + $member_id = $_GET['id']; + AddServiceRecord($member_id); + } + if($_GET['var'] == "edit"){ + $record_id = $_GET['id']; + EditServiceRecord($record_id); + } + if($_GET['var'] == "delete"){ + $record_id = $_GET['id']; + } + }else{ + $member_id = $_GET['id']; + ListServiceRecord($member_id); + } + return; + } + if($_GET['edit'] == "medals"){ + if(isset($_GET['var'])){ + if($_GET['var'] == "add"){ + + } + if($_GET['var'] == "edit"){ + + } + if($_GET['var'] == "delete"){ + + } + }else{ + $member_id = $_GET['id']; + ListMedalRecord($member_id); + } + + return; + } + } + + ListMembers(); */ + ?> \ No newline at end of file diff --git a/admin/rudi/includes/functions.awards.php b/admin/rudi/includes/functions.awards.php new file mode 100644 index 0000000..439f0e1 --- /dev/null +++ b/admin/rudi/includes/functions.awards.php @@ -0,0 +1,20 @@ +Query("SELECT `name`, `class_id` FROM `rudi_award_classes`"); + return $db->Fetch($result); + } + + function getAwardsByClass($class_id){ + global $db; + $result = $db->Query("SELECT `award_id`, `name`, `image`, `description` FROM `rudi_awards` WHERE `class_id` = '$class_id' ORDER BY `name`"); + return $db->Fetch($result); + } + + function getAward($award_id){ + global $db; + $result = $db->Query("SELECT `award_id`, `name`, `image`, `description`, `class_id` FROM `rudi_awards` WHERE `award_id` = '$award_id' LIMIT 1"); + return $db->FetchRow($result); + } +?> \ No newline at end of file diff --git a/admin/rudi/includes/functions.members.php b/admin/rudi/includes/functions.members.php new file mode 100644 index 0000000..6a4970e --- /dev/null +++ b/admin/rudi/includes/functions.members.php @@ -0,0 +1,262 @@ +Query("SELECT `unit_id`, `name` FROM `rudi_combat_units` WHERE `detachment` = '$previous_unit'"); + $row = $db->Fetch($result); + foreach($row as $unit){ + $unit_id = $unit['unit_id']; + $unit_name = $unit['name']; + if($members_unit==$unit_id) + echo ''; + else + echo ''; + + selectUnits($unit_id, $indent, $members_unit); + } + } + + function GetMember($member_id){ + + global $db; + $result = $db->Query("SELECT * FROM `rudi_unit_members` WHERE `member_id` = '$member_id' LIMIT 1"); + $row = $db->FetchRow($result); + return $row; + } + + function GetWeapons(){ + global $db; + $result = $db->Query("SELECT * FROM `rudi_weapons` ORDER BY `model` DESC"); + $row = $db->Fetch($result); + return $row; + } + + function GetMembersRoles($member_id){ + global $db; + $row = NULL; + $query = sprintf("SELECT r.role_id, r.name AS role_name FROM rudi_roles AS r LEFT OUTER JOIN rudi_roles_container AS rl USING(role_id) INNER JOIN rudi_unit_members AS rm USING(member_id) WHERE rm.member_id = %d AND r.name IS NOT NULL ORDER BY r.role_id ASC", + (int)$member_id); + + $result = $db->Query($query); + $row = $db->Fetch($result); + + return $row; + } + + function GetRoles(){ + global $db; + $result = $db->Query("SELECT * FROM `rudi_roles`"); + $row = $db->Fetch($result); + return $row; + } + + function GetCountry(){ + global $db; + $result = $db->Query("SELECT `country_id`, `name` FROM `rudi_countries` ORDER BY `name`"); + $row = $db->Fetch($result); + return $row; + } + + function GetRanks(){ + global $db; + $result = $db->Query("SELECT * FROM `rudi_ranks` ORDER BY `weight` DESC"); + $row = $db->Fetch($result); + return $row; + } + + function GetStatuses(){ + global $db; + $result = $db->Query("SELECT * FROM `rudi_statuses`"); + $row = $db->Fetch($result); + return $row; + } + + function GetServiceRecord($member_id){ + global $db; + $result = $db->Query("SELECT `record_id`, `date_added`, `record_note`, `added_by` FROM `rudi_service_record` WHERE `member_id` = '$member_id'"); + $row = $db->Fetch($result); + return $row; + } + + function ListServiceRecord($member_id){ + global $db; + + echo "Add New Record"; + + $records = GetServiceRecord($member_id); + echo ""; + echo ""; + foreach($records as $record){ + echo ""; + } + CloseTable(); + } + + function EditServiceRecord($record_id){ + global $db; + $result = $db->Query("SELECT `date_added`, `record_note`, `member_id` FROM `rudi_service_record` WHERE `record_id` = '$record_id' LIMIT 1"); + $row = $db->FetchRow($result); + + $form = new BayonetForm("", "POST"); + if($form->verifySubmit('processed')){ + $date = $form->request['date']; + $details = $form->request['details']; + + $db->Query("UPDATE `rudi_service_record` SET `date_added` = '$date', `record_note` = '$details' WHERE `record_id` = '$record_id' LIMIT 1"); + PageRedirect(1, "?op=rudi&show=members&service={$row['member_id']}&edit=".$record_id); + return; + } + + echo "Cancel"; + OpenTable(); +?> + + + +__destruct(); + + } + + function AddServiceRecord($member_id){ + global $db; + + $form = new BayonetForm("", "POST"); + if($form->verifySubmit('processed')){ + $date = $form->request['date']; + $details = $form->request['details']; + decho($form->request); + $db->Query("INSERT INTO `rudi_service_record` SET `member_id` = '$member_id', `date_added` = '$date', `record_note` = '$details', `added_by` = 1"); + PageRedirect(1, "?op=rudi&show=members&service={$member_id}"); + return; + } + + $result = $db->Query("SELECT `date_added`, `record_note`, `member_id` FROM `rudi_service_record` WHERE `record_id` = '$record_id' LIMIT 1"); + $row = $db->FetchRow($result); + echo "Cancel"; + OpenTable(); +?> + + + +__destruct(); + } + + function GetAwardRecord($member_id){ + global $db; + $result = $db->Query("SELECT r.record_id, r.date_added, r.record_note, r.added_by, a.name FROM rudi_award_record AS r LEFT OUTER JOIN rudi_awards AS a ON a.award_id = r.award_id WHERE r.member_id = '$member_id'"); + $row = $db->Fetch($result); + return $row; + } + + function GetAllAwards(){ + global $db; + $result = $db->Query("SELECT `award_id`, `name` FROM `rudi_awards` ORDER BY `name`"); + $row = $db->Fetch($result); + return $row; + } + + function ListAwardRecord($member_id){ + global $db; + + echo "Add New Record"; + + $records = GetAwardRecord($member_id); + echo "
Record DateRecord Details
".date("M j Y", strtotime($record['date_added']))." Edit Delete{$record['record_note']}
Date:textField('date', date('Y-m-d', strtotime($row['date_added']))); ?>
Details:textArea('details', 10, 30, $row['record_note']); ?>
submitButton('processed', 'Update'); ?>
Date:textField('date'); ?>
Details:textArea('details', 10, 30); ?>
submitButton('processed', 'Add'); ?>
"; + echo ""; + foreach($records as $record){ +?> + + + + + + + +Query("SELECT `award_id`, `date_added`, `record_note`, `member_id` FROM `rudi_award_record` WHERE `record_id` = '$record_id' LIMIT 1"); + $row = $db->FetchRow($result); + + $form = new BayonetForm("", "POST"); + if($form->verifySubmit('processed')){ + $date = $form->request['date']; + $details = $form->request['details']; + $award_id = $_POST['award']; + + $db->Query("UPDATE `rudi_award_record` SET `date_added` = '$date', `award_id` = '$award_id', `record_note` = '$details' WHERE `record_id` = '$record_id' LIMIT 1"); + PageRedirect(1, "?op=rudi&show=members&award={$row['member_id']}&edit=".$record_id); + return; + } + + echo "Cancel"; + OpenTable(); +?> + + + + +__destruct(); + + } + + function AddAwardRecord($member_id){ + global $db; + + $form = new BayonetForm("", "POST"); + if($form->verifySubmit('processed')){ + $date = $form->request['date']; + $details = $form->request['details']; + $award_id = $_POST['award']; + decho($form->request); + $db->Query("INSERT INTO `rudi_award_record` SET `member_id` = '$member_id', `award_id` = '$award_id', `date_added` = '$date', `record_note` = '$details', `added_by` = 1"); + PageRedirect(1, "?op=rudi&show=members&award={$member_id}"); + return; + } + + $result = $db->Query("SELECT `date_added`, `record_note`, `member_id` FROM `rudi_service_record` WHERE `record_id` = '$record_id' LIMIT 1"); + $row = $db->FetchRow($result); + echo "Cancel"; + OpenTable(); +?> + + + + +__destruct(); + } +?> \ No newline at end of file diff --git a/admin/rudi/index.php b/admin/rudi/index.php new file mode 100644 index 0000000..3d93bf0 --- /dev/null +++ b/admin/rudi/index.php @@ -0,0 +1,58 @@ +. + */ + + ?> + +

- RUDI/Quartermaster Control Panel

+ \ No newline at end of file diff --git a/admin/rudi/views/view.awards.edit.php b/admin/rudi/views/view.awards.edit.php new file mode 100644 index 0000000..09f041c --- /dev/null +++ b/admin/rudi/views/view.awards.edit.php @@ -0,0 +1,24 @@ +verifySubmit('processed')) + { + echo "Key states
\n"; + $keydump = print_r($form->getKeyStates($form->request), true); + echo "
{$keydump}
\n"; + + echo "

Transaction processed

\n"; + + } + OpenTable(); +?> + + + + + +__destruct(); +?> + diff --git a/admin/rudi/views/view.awards.php b/admin/rudi/views/view.awards.php new file mode 100644 index 0000000..2455018 --- /dev/null +++ b/admin/rudi/views/view.awards.php @@ -0,0 +1,34 @@ +Award Classes"; + $classes = getAwardClasses(); + OpenTable(); + echo ""; + foreach($classes as $class){ + echo ""; + } + echo ""; + CloseTable(); + + if(isset($_GET['cid'])){ + $class_id = $_GET['cid']; + $awards = getAwardsByClass($class_id); + echo "

Awards

"; + OpenTable(); + foreach($awards as $award){ + echo " + + "; + } + CloseTable(); + //include 'view.members.profile.php'; + }else if(isset($_GET['aid'])){ + $award_id = $_GET['aid']; + //include 'view.members.service.php'; + } + } +?> \ No newline at end of file diff --git a/admin/rudi/views/view.members.award.php b/admin/rudi/views/view.members.award.php new file mode 100644 index 0000000..cda8595 --- /dev/null +++ b/admin/rudi/views/view.members.award.php @@ -0,0 +1,19 @@ +Query("SELECT `first_name`, `last_name` FROM `rudi_unit_members` WHERE `member_id` = '$member_id' LIMIT 1"); + $member = $db->FetchRow($result); + echo "

Award Record of {$member['first_name']} {$member['last_name']}

"; + + if(isset($_GET['edit'])){ + $record_id = $_GET['edit']; + EditAwardRecord($record_id); + }else if(isset($_GET['add'])){ + if($_GET['add']){ + AddAwardRecord($_GET['award']); + } + }else{ + + echo "
".LinkInternal('Back to Roster', '?op=rudi&show=members')."
"; + ListAwardRecord($_GET['award']); + } +?> \ No newline at end of file diff --git a/admin/rudi/views/view.members.php b/admin/rudi/views/view.members.php new file mode 100644 index 0000000..659ef2b --- /dev/null +++ b/admin/rudi/views/view.members.php @@ -0,0 +1,49 @@ +Current Members"; + echo "
Award NameRecord DateRecord Details
EditDelete
Award: + +
Date:textField('date', date('Y-m-d', strtotime($row['date_added']))); ?>
Details:textArea('details', 10, 30, $row['record_note']); ?>
submitButton('processed', 'Update'); ?>
Award: + +
Date:textField('date'); ?>
Details:textArea('details', 10, 30); ?>
submitButton('processed', 'Add'); ?>
Name:textField('name', $award['name'], false, "50"); ?>
Image:
Text:textArea('text',10,30,$award['description']); ?>
".LinkInternal($class['name'],'?op=rudi&show=awards&cid='.$class['class_id'])."
".$award['name']."EditDelete
"; + echo ""; + $result = $db->Query("SELECT * FROM `rudi_unit_members` JOIN `rudi_ranks` ON rudi_unit_members.rank_id=rudi_ranks.rank_id WHERE rudi_unit_members.status_id != 4 AND rudi_unit_members.status_id != 5 ORDER BY rudi_ranks.weight DESC , rudi_unit_members.date_promotion ASC , rudi_unit_members.date_enlisted ASC"); + $row = $db->Fetch($result); + + foreach($row as $member){ + echo ""; + echo ""; + echo ""; + echo ""; + echo ""; + echo ""; + } + CloseTable(); + + echo "

Previous Members

"; + echo "
RankSoldierMain InfoService RecordMedal Record
{$member['shortname']}{$member['first_name']} {$member['last_name']}".LinkInternal('Edit','?op=rudi&show=members&profile='.$member['member_id'])."".LinkInternal('Edit','?op=rudi&show=members&service='.$member['member_id'])."".LinkInternal('Edit','?op=rudi&show=members&award='.$member['member_id'])."
"; + echo ""; + $result = $db->Query("SELECT * FROM `rudi_unit_members` JOIN `rudi_ranks` ON rudi_unit_members.rank_id=rudi_ranks.rank_id WHERE rudi_unit_members.status_id = 4 OR rudi_unit_members.status_id = 5 ORDER BY rudi_ranks.weight DESC, rudi_unit_members.date_promotion ASC, rudi_unit_members.date_enlisted ASC"); + $row = $db->Fetch($result); + + foreach($row as $member){ + echo ""; + echo ""; + echo ""; + echo ""; + echo ""; + echo ""; + } + CloseTable(); + } + +?> \ No newline at end of file diff --git a/admin/rudi/views/view.members.profile.php b/admin/rudi/views/view.members.profile.php new file mode 100644 index 0000000..fedabdd --- /dev/null +++ b/admin/rudi/views/view.members.profile.php @@ -0,0 +1,195 @@ +Query($query); + + /* do the role query as well */ + PageRedirect(1, "?op=rudi&show=members&profile={$member_id}"); + return; + } + $member = GetMember($member_id); +?> + Cancel
+ +
RankSoldierMain InfoService RecordMedal Record
{$member['shortname']}{$member['first_name']} {$member['last_name']}".LinkInternal('Edit','?op=rudi&show=members&profile='.$member['member_id'])."".LinkInternal('Edit','?op=rudi&show=members&service='.$member['member_id'])."".LinkInternal('Edit','?op=rudi&show=members&award='.$member['member_id'])."
+ + + +
Personnel File of
Rank: + +
Country: + +
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Vital Statistics
First:
Last:
Username:
City:
Province:
Status: + +
Primary MOS:
Role: + +
Unit: + +
Weapons: + +
Enlisted Date:" />
Promotion Date: + " /> +
Discharge Date:" />
Xfire:
E-Mail:
+
+ + + + +
Personal Bio
+ \ No newline at end of file diff --git a/admin/rudi/views/view.members.service.php b/admin/rudi/views/view.members.service.php new file mode 100644 index 0000000..eaf2233 --- /dev/null +++ b/admin/rudi/views/view.members.service.php @@ -0,0 +1,19 @@ +Query("SELECT `first_name`, `last_name` FROM `rudi_unit_members` WHERE `member_id` = '$member_id' LIMIT 1"); + $member = $db->FetchRow($result); + echo "

Service Record of {$member['first_name']} {$member['last_name']}

"; + + if(isset($_GET['edit'])){ + $record_id = $_GET['edit']; + EditServiceRecord($record_id); + }else if(isset($_GET['add'])){ + if($_GET['add']){ + AddServiceRecord($_GET['service']); + } + }else{ + + echo "
".LinkInternal('Back to Roster', '?op=rudi&show=members')."
"; + ListServiceRecord($_GET['service']); + } +?> \ No newline at end of file diff --git a/admin/rudi/views/view.units.php b/admin/rudi/views/view.units.php new file mode 100644 index 0000000..e69de29 -- cgit