summaryrefslogtreecommitdiff
path: root/cheque_manage.inc
diff options
context:
space:
mode:
authorprashantsinalkar2016-08-18 12:19:50 +0530
committerprashantsinalkar2016-08-18 12:19:50 +0530
commit237172fbbd89e594128ebad8ebfc6d732b89e660 (patch)
treea1c4eefdbb44fcf124360026d36f17a7f5f8024b /cheque_manage.inc
parenta2d6a21519a6765956dc6a6c390f55f29aac7583 (diff)
downloadscilab_textbook_companion-237172fbbd89e594128ebad8ebfc6d732b89e660.tar.gz
scilab_textbook_companion-237172fbbd89e594128ebad8ebfc6d732b89e660.tar.bz2
scilab_textbook_companion-237172fbbd89e594128ebad8ebfc6d732b89e660.zip
formated the code
Diffstat (limited to 'cheque_manage.inc')
-rwxr-xr-xcheque_manage.inc166
1 files changed, 86 insertions, 80 deletions
diff --git a/cheque_manage.inc b/cheque_manage.inc
index 8ddeffb..475fab5 100755
--- a/cheque_manage.inc
+++ b/cheque_manage.inc
@@ -1,87 +1,93 @@
-<?php
+<?php
function cheque_proposal_all()
{
-
-
- $form['#redirect'] = FALSE;
- $form['search_cheque'] = array(
- '#type' => 'textfield',
- '#title' => t('Search'),
- '#size' => 48,
- );
- $form['submit_cheque'] = array(
- '#type' => 'submit',
- '#value' => t('Search')
- );
- $form['cancel_cheque'] = array(
- '#type' => 'markup',
- '#value' => l(t('Cancel'), ''),
- );
-
-
- $count=20;
- /* get pending proposals to be approved */
- $proposal_rows = array();
-
- /*$proposal_q = "SELECT * FROM {textbook_companion_proposal} ORDER BY id DESC";*/
+ $form['#redirect'] = FALSE;
+ $form['search_cheque'] = array(
+ '#type' => 'textfield',
+ '#title' => t('Search'),
+ '#size' => 48
+ );
+ $form['submit_cheque'] = array(
+ '#type' => 'submit',
+ '#value' => t('Search')
+ );
+ $form['cancel_cheque'] = array(
+ '#type' => 'markup',
+ '#value' => l(t('Cancel'), '')
+ );
+ $count = 20;
+ /* get pending proposals to be approved */
+ $proposal_rows = array();
+ /*$proposal_q = "SELECT * FROM {textbook_companion_proposal} ORDER BY id DESC";*/
$query = db_select('textbook_companion_proposal');
$query->fields('textbook_companion_proposal');
$query->orderBy('id', 'DESC');
-
-
- /*$pagerquery = pager_query($proposal_q, $count); */
+ /*$pagerquery = pager_query($proposal_q, $count); */
$pagerquery = $query->extend('PagerDefault')->limit($count)->execute();
-
- while ($proposal_data = $pagerquery->fetchObject())
- {
- /* get preference */
-
- /*$preference_q = db_query("SELECT * FROM {textbook_companion_preference} WHERE proposal_id = %d AND approval_status = 1 LIMIT 1", $proposal_data->id);
- $preference_data = db_fetch_object($preference_q);*/
-
- $query = db_select('textbook_companion_preference');
- $query->fields('textbook_companion_preference');
- $query->condition('proposal_id', $proposal_data->id);
- $query->condition('approval_status', 1);
- $query->range(0, 1);
- $result = $query->execute();
- $preference_data =$result->fetchObject();
-
- /*$preference_q1 = db_query("SELECT * FROM {textbook_companion_proposal} WHERE uid = %d AND approval_status = 1 LIMIT 1", $proposal_data->id);
- $preference_data1 = db_fetch_object($preference_q1);*/
-
- $query = db_select('textbook_companion_proposal');
- $query->fields('textbook_companion_proposal');
- $query->condition('uid', $proposal_data->id);
- $query->condition('proposal_status', 1);
- $query->range(0, 1);
- $result = $query->execute();
- $preference_data1=$result->fetchObject();
-
-
- $proposal_status = '';
- switch ($proposal_data->proposal_status)
- {
- case 0: $proposal_status = 'Pending'; break;
- case 1: $proposal_status = 'Approved'; break;
- case 2: $proposal_status = 'Dis-approved'; break;
- case 3: $proposal_status = 'Completed'; break;
- default: $proposal_status = 'Unknown'; break;
- }
- $proposal_rows[] = array(date('d-m-Y', $proposal_data->creation_date), l($proposal_data->full_name, 'user/' . $proposal_data->uid), date('d-m-Y', $proposal_data->completion_date), l('Form Submission', 'manage_proposal/paper_submission/' . $proposal_data->id) . ' | ' . l('Cheque Details', 'cheque_contact/status/' . $proposal_data->id));
- }
-
- /* check if there are any pending proposals */
- if (!$proposal_rows)
- {
- drupal_set_message(t('There are no proposals.'), 'status');
- return '';
- }
-
- $proposal_header = array('Date of Submission', 'Contributor Name', 'Expected Date of Completion', 'Status');
- $output = theme('table',array('header' =>$proposal_header,'rows'=>$proposal_rows));
- return $output . theme_pager($count);
- }
- return $form;
-
+ while ($proposal_data = $pagerquery->fetchObject())
+ {
+ /* get preference */
+ /*$preference_q = db_query("SELECT * FROM {textbook_companion_preference} WHERE proposal_id = %d AND approval_status = 1 LIMIT 1", $proposal_data->id);
+ $preference_data = db_fetch_object($preference_q);*/
+ $query = db_select('textbook_companion_preference');
+ $query->fields('textbook_companion_preference');
+ $query->condition('proposal_id', $proposal_data->id);
+ $query->condition('approval_status', 1);
+ $query->range(0, 1);
+ $result = $query->execute();
+ $preference_data = $result->fetchObject();
+ /*$preference_q1 = db_query("SELECT * FROM {textbook_companion_proposal} WHERE uid = %d AND approval_status = 1 LIMIT 1", $proposal_data->id);
+ $preference_data1 = db_fetch_object($preference_q1);*/
+ $query = db_select('textbook_companion_proposal');
+ $query->fields('textbook_companion_proposal');
+ $query->condition('uid', $proposal_data->id);
+ $query->condition('proposal_status', 1);
+ $query->range(0, 1);
+ $result = $query->execute();
+ $preference_data1 = $result->fetchObject();
+ $proposal_status = '';
+ switch ($proposal_data->proposal_status)
+ {
+ case 0:
+ $proposal_status = 'Pending';
+ break;
+ case 1:
+ $proposal_status = 'Approved';
+ break;
+ case 2:
+ $proposal_status = 'Dis-approved';
+ break;
+ case 3:
+ $proposal_status = 'Completed';
+ break;
+ default:
+ $proposal_status = 'Unknown';
+ break;
+ } //$proposal_data->proposal_status
+ $proposal_rows[] = array(
+ date('d-m-Y', $proposal_data->creation_date),
+ l($proposal_data->full_name, 'user/' . $proposal_data->uid),
+ date('d-m-Y', $proposal_data->completion_date),
+ l('Form Submission', 'manage_proposal/paper_submission/' . $proposal_data->id) . ' | ' . l('Cheque Details', 'cheque_contact/status/' . $proposal_data->id)
+ );
+ } //$proposal_data = $pagerquery->fetchObject()
+ /* check if there are any pending proposals */
+ if (!$proposal_rows)
+ {
+ drupal_set_message(t('There are no proposals.'), 'status');
+ return '';
+ } //!$proposal_rows
+ $proposal_header = array(
+ 'Date of Submission',
+ 'Contributor Name',
+ 'Expected Date of Completion',
+ 'Status'
+ );
+ $output = theme('table', array(
+ 'header' => $proposal_header,
+ 'rows' => $proposal_rows
+ ));
+ return $output . theme_pager($count);
+}
+return $form;
?>