summaryrefslogtreecommitdiff
path: root/cheque_contact.inc
diff options
context:
space:
mode:
Diffstat (limited to 'cheque_contact.inc')
-rwxr-xr-xcheque_contact.inc1347
1 files changed, 670 insertions, 677 deletions
diff --git a/cheque_contact.inc b/cheque_contact.inc
index c623ef4..093d040 100755
--- a/cheque_contact.inc
+++ b/cheque_contact.inc
@@ -1,336 +1,337 @@
<?php
-
function paper_submission_form($form_state, $proposal_id)
{
- global $user;
- $proposal_id = arg(2);
-
- /* get current proposal */
-
- /*$preference4_q = db_query("SELECT * FROM {textbook_companion_paper} WHERE proposal_id=".$proposal_id);*/
-
- $query = db_select('textbook_companion_paper');
- $query->fields('textbook_companion_paper');
- $query->condition('proposal_id', $proposal_id);
- $preference4_q = $query->execute();
-
- $form1=0;
- $form2=0;
- $form3=0;
- $form4=0;
- if($data = $preference4_q->fetchObject())
- {
- $form1 = $data->internship_form;
- $form2 = $data->copyright_form;
- $form3 = $data->undertaking_form;
- $form4 = $data->reciept_form;
- }
- else
- {
- $query = "Insert into {textbook_companion_paper} (proposal_id) values (:proposal_id)";
- $args = array(
- ":proposal_id"=>$proposal_id,
- );
- $result = db_query($query, $args, array('return' => Database::RETURN_INSERT_ID));
- }
- $form['proposal_id'] =array(
- '#type' => 'hidden',
- '#default_value' => $proposal_id,
- );
- $form['internshipform'] = array(
- '#type' => 'checkbox',
- '#title' => t('Recieved Internship Application'),
- '#description' => t('Check if the Internship Application has been recieved.'),
- '#default_value' => $form1,
- );
- $form['copyrighttransferform'] = array(
- '#type' => 'checkbox',
- '#title' => t('Recieved Copyright Transfer Form'),
- '#description' => t('Check if the Copyright Transfer Form has been recieved.'),
- '#default_value' => $form2,
- );
- $form['undertakingform'] = array(
- '#type' => 'checkbox',
- '#title' => t('Recieved Undertaking Form'),
- '#description' => t('Check if the Undertaking Form has been recieved.'),
- '#default_value' => $form3,
- );
- $form['recieptform'] = array(
- '#type' => 'checkbox',
- '#title' => t('Recieved Reciept Form'),
- '#description' => t('Check if the Reciept Form has been recieved.'),
- '#default_value' => $form4,
- );
- $form['submit'] = array(
- '#type' => 'submit',
- '#value' => t('Send Email')
- );
- $form['cancel'] = array(
- '#type' => 'markup',
- '#value' => l(t('Cancel'), 'manage_proposal/all'),
+ global $user;
+ $proposal_id = arg(2);
+ /* get current proposal */
+ /*$preference4_q = db_query("SELECT * FROM {textbook_companion_paper} WHERE proposal_id=".$proposal_id);*/
+ $query = db_select('textbook_companion_paper');
+ $query->fields('textbook_companion_paper');
+ $query->condition('proposal_id', $proposal_id);
+ $preference4_q = $query->execute();
+ $form1 = 0;
+ $form2 = 0;
+ $form3 = 0;
+ $form4 = 0;
+ if ($data = $preference4_q->fetchObject())
+ {
+ $form1 = $data->internship_form;
+ $form2 = $data->copyright_form;
+ $form3 = $data->undertaking_form;
+ $form4 = $data->reciept_form;
+ } //$data = $preference4_q->fetchObject()
+ else
+ {
+ $query = "Insert into {textbook_companion_paper} (proposal_id) values (:proposal_id)";
+ $args = array(
+ ":proposal_id" => $proposal_id
);
+ $result = db_query($query, $args, array(
+ 'return' => Database::RETURN_INSERT_ID
+ ));
+ }
+ $form['proposal_id'] = array(
+ '#type' => 'hidden',
+ '#default_value' => $proposal_id
+ );
+ $form['internshipform'] = array(
+ '#type' => 'checkbox',
+ '#title' => t('Recieved Internship Application'),
+ '#description' => t('Check if the Internship Application has been recieved.'),
+ '#default_value' => $form1
+ );
+ $form['copyrighttransferform'] = array(
+ '#type' => 'checkbox',
+ '#title' => t('Recieved Copyright Transfer Form'),
+ '#description' => t('Check if the Copyright Transfer Form has been recieved.'),
+ '#default_value' => $form2
+ );
+ $form['undertakingform'] = array(
+ '#type' => 'checkbox',
+ '#title' => t('Recieved Undertaking Form'),
+ '#description' => t('Check if the Undertaking Form has been recieved.'),
+ '#default_value' => $form3
+ );
+ $form['recieptform'] = array(
+ '#type' => 'checkbox',
+ '#title' => t('Recieved Reciept Form'),
+ '#description' => t('Check if the Reciept Form has been recieved.'),
+ '#default_value' => $form4
+ );
+ $form['submit'] = array(
+ '#type' => 'submit',
+ '#value' => t('Send Email')
+ );
+ $form['cancel'] = array(
+ '#type' => 'markup',
+ '#value' => l(t('Cancel'), 'manage_proposal/all')
+ );
return $form;
}
-
function paper_submission_form_submit($form, &$form_state)
{
-
- /*$query ="UPDATE {textbook_companion_paper} SET internship_form = ".$form_state['values']['internshipform'].", copyright_form = ".$form_state['values']['copyrighttransferform'].", undertaking_form= ".$form_state['values']['undertakingform'].", reciept_form= ".$form_state['values']['recieptform']." WHERE proposal_id = ".$form_state['values']['proposal_id'];
- db_query($query);*/
-
+ /*$query ="UPDATE {textbook_companion_paper} SET internship_form = ".$form_state['values']['internshipform'].", copyright_form = ".$form_state['values']['copyrighttransferform'].", undertaking_form= ".$form_state['values']['undertakingform'].", reciept_form= ".$form_state['values']['recieptform']." WHERE proposal_id = ".$form_state['values']['proposal_id'];
+ db_query($query);*/
$query = db_update('textbook_companion_paper');
$query->fields(array(
- 'internship_form' => $form_state[ values ][ internshipform ],
- 'copyright_form' => $form_state[ values ][ copyrighttransferform ],
- 'undertaking_form' => $form_state[ values ][ undertakingform ],
- 'reciept_form' => $form_state[ values ][ recieptform ],
+ 'internship_form' => $form_state[values][internshipform],
+ 'copyright_form' => $form_state[values][copyrighttransferform],
+ 'undertaking_form' => $form_state[values][undertakingform],
+ 'reciept_form' => $form_state[values][recieptform]
));
$query->condition('proposal_id', $form_state['values']['proposal_id']);
$num_updated = $query->execute();
-
- /************************************************
- Check For the Internship Form is checked or not
- ************************************************/
- if ($form_state['values']['internshipform'] == 1)
- {
- /* sending email */
- $book_user = user_load($proposal_data->uid);
- $param['proposal_completed']['proposal_id'] = $proposal_id;
- $param['proposal_completed']['user_id'] = $proposal_data->uid;
- $email_to = $book_user->mail;
- if (!drupal_mail('textbook_companion', 'internship_form', $email_to , language_default(), $param, variable_get('textbook_companion_from_email', NULL), TRUE))
- drupal_set_message('Error sending email message.', 'error');
- drupal_set_message('Internship Form for Book proposal has been recieved. User has been notified .', 'status');
- }
- else
- {
- if (!drupal_mail('textbook_companion', 'internship_form_not', $email_to , language_default(), $param, variable_get('textbook_companion_from_email', NULL), TRUE))
+ /************************************************
+ Check For the Internship Form is checked or not
+ ************************************************/
+ if ($form_state['values']['internshipform'] == 1)
+ {
+ /* sending email */
+ $book_user = user_load($proposal_data->uid);
+ $param['proposal_completed']['proposal_id'] = $proposal_id;
+ $param['proposal_completed']['user_id'] = $proposal_data->uid;
+ $email_to = $book_user->mail;
+ if (!drupal_mail('textbook_companion', 'internship_form', $email_to, language_default(), $param, variable_get('textbook_companion_from_email', NULL), TRUE))
+ drupal_set_message('Error sending email message.', 'error');
+ drupal_set_message('Internship Form for Book proposal has been recieved. User has been notified .', 'status');
+ } //$form_state['values']['internshipform'] == 1
+ else
+ {
+ if (!drupal_mail('textbook_companion', 'internship_form_not', $email_to, language_default(), $param, variable_get('textbook_companion_from_email', NULL), TRUE))
drupal_set_message('Error sending email message.', 'error');
drupal_set_message('Internship Form for Book proposal has not been recieved. User has been notified .', 'status');
- }
-
- /************************************************
- Check For the Copyright Form is checked or not
- ************************************************/
+ }
+ /************************************************
+ Check For the Copyright Form is checked or not
+ ************************************************/
+ if ($form_state['values']['copyrighttransferform'] == 1)
+ {
+ /* sending email */
+ $book_user = user_load($proposal_data->uid);
+ $param['proposal_completed']['proposal_id'] = $proposal_id;
+ $param['proposal_completed']['user_id'] = $proposal_data->uid;
+ $email_to = $book_user->mail;
+ if (!drupal_mail('textbook_companion', 'copyrighttransfer_form', $email_to, language_default(), $param, variable_get('textbook_companion_from_email', NULL), TRUE))
+ drupal_set_message('Error sending email message.', 'error');
+ drupal_set_message('Copyright Form for Book proposal has been recieved. User has been notified .', 'status');
+ } //$form_state['values']['copyrighttransferform'] == 1
+ else
+ {
+ if (!drupal_mail('textbook_companion', 'copyrighttransfer_form_not', $email_to, language_default(), $param, variable_get('textbook_companion_from_email', NULL), TRUE))
+ drupal_set_message('Error sending email message.', 'error');
+ drupal_set_message('Copyright Transfer Form for Book proposal has not been recieved. User has been notified .', 'status');
+ }
+ /************************************************
+ Check For the Undertaking Form is checked or not
+ ************************************************/
+ if ($form_state['values']['undertakingform'] == 1)
+ {
+ /* sending email */
+ $book_user = user_load($proposal_data->uid);
+ $param['proposal_completed']['proposal_id'] = $proposal_id;
+ $param['proposal_completed']['user_id'] = $proposal_data->uid;
+ $email_to = $book_user->mail;
+ if (!drupal_mail('textbook_companion', 'undertakingform_form', $email_to, language_default(), $param, variable_get('textbook_companion_from_email', NULL), TRUE))
+ drupal_set_message('Error sending email message.', 'error');
+ drupal_set_message('Undertaking Form for Book proposal has been recieved. User has been notified .', 'status');
+ } //$form_state['values']['undertakingform'] == 1
+ else
+ {
+ if (!drupal_mail('textbook_companion', 'undertakingform_form_not', $email_to, language_default(), $param, variable_get('textbook_companion_from_email', NULL), TRUE))
+ drupal_set_message('Error sending email message.', 'error');
+ drupal_set_message('Undertaking Form for Book proposal has not been recieved. User has been notified .', 'status');
+ }
+ drupal_set_message(t('Proposal Updated'), 'status');
+}
+/*function proposal_edit_form_validate($form, &$form_state)
+{
+/* mobile */
+/*if (!preg_match('/^[0-9\ \+]{0,15}$/', $form_state['values']['mobile']))
+form_set_error('mobile', t('Invalid mobile number'));
- if ($form_state['values']['copyrighttransferform'] == 1)
- {
- /* sending email */
- $book_user = user_load($proposal_data->uid);
- $param['proposal_completed']['proposal_id'] = $proposal_id;
- $param['proposal_completed']['user_id'] = $proposal_data->uid;
- $email_to = $book_user->mail;
- if (!drupal_mail('textbook_companion', 'copyrighttransfer_form', $email_to , language_default(), $param, variable_get('textbook_companion_from_email', NULL), TRUE))
- drupal_set_message('Error sending email message.', 'error');
- drupal_set_message('Copyright Form for Book proposal has been recieved. User has been notified .', 'status');
- }
- else
- {
- if (!drupal_mail('textbook_companion', 'copyrighttransfer_form_not', $email_to , language_default(), $param, variable_get('textbook_companion_from_email', NULL), TRUE))
- drupal_set_message('Error sending email message.', 'error');
- drupal_set_message('Copyright Transfer Form for Book proposal has not been recieved. User has been notified .', 'status');
- }
-
- /************************************************
- Check For the Undertaking Form is checked or not
- ************************************************/
+/* date of completion */
+/*if (!preg_match('/^[0-9]{1,2}-[0-9]{1,2}-[0-9]{4}$/', $form_state['values']['completion_date']))
+form_set_error('completion_date', t('Invalid expected date of completion'));
- if ($form_state['values']['undertakingform'] == 1)
- {
- /* sending email */
- $book_user = user_load($proposal_data->uid);
- $param['proposal_completed']['proposal_id'] = $proposal_id;
- $param['proposal_completed']['user_id'] = $proposal_data->uid;
- $email_to = $book_user->mail;
- if (!drupal_mail('textbook_companion', 'undertakingform_form', $email_to , language_default(), $param, variable_get('textbook_companion_from_email', NULL), TRUE))
- drupal_set_message('Error sending email message.', 'error');
- drupal_set_message('Undertaking Form for Book proposal has been recieved. User has been notified .', 'status');
- }
- else
- {
- if (!drupal_mail('textbook_companion', 'undertakingform_form_not', $email_to , language_default(), $param, variable_get('textbook_companion_from_email', NULL), TRUE))
- drupal_set_message('Error sending email message.', 'error');
- drupal_set_message('Undertaking Form for Book proposal has not been recieved. User has been notified .', 'status');
- }
+list($d, $m, $y) = explode('-', $form_state['values']['completion_date']);
+$d = (int)$d; $m = (int)$m; $y = (int)$y;
-drupal_set_message(t('Proposal Updated'), 'status');
-}
+if (!checkdate($m, $d, $y))
+form_set_error('completion_date', t('Invalid expected date of completion'));
+if (mktime(0, 0, 0, $m, $d, $y) <= time())
+form_set_error('completion_date', t('Expected date of completion should be in future'));
-/*function proposal_edit_form_validate($form, &$form_state)
-{
- /* mobile */
- /*if (!preg_match('/^[0-9\ \+]{0,15}$/', $form_state['values']['mobile']))
- form_set_error('mobile', t('Invalid mobile number'));
+/* edition */
+/*if (!preg_match('/^[1-9][0-9]{0,1}$/', $form_state['values']['edition1']))
+form_set_error('edition1', t('Invalid edition for Book Preference 1'));
- /* date of completion */
- /*if (!preg_match('/^[0-9]{1,2}-[0-9]{1,2}-[0-9]{4}$/', $form_state['values']['completion_date']))
- form_set_error('completion_date', t('Invalid expected date of completion'));
+if (!preg_match('/^[1-9][0-9]{0,1}$/', $form_state['values']['edition2']))
+form_set_error('edition2', t('Invalid edition for Book Preference 2'));
+if (!preg_match('/^[1-9][0-9]{0,1}$/', $form_state['values']['edition3']))
+form_set_error('edition3', t('Invalid edition for Book Preference 3'));
- list($d, $m, $y) = explode('-', $form_state['values']['completion_date']);
- $d = (int)$d; $m = (int)$m; $y = (int)$y;
-
- if (!checkdate($m, $d, $y))
- form_set_error('completion_date', t('Invalid expected date of completion'));
-
- if (mktime(0, 0, 0, $m, $d, $y) <= time())
- form_set_error('completion_date', t('Expected date of completion should be in future'));
+/* year of publication */
+/*if (!preg_match('/^[1-3][0-9][0-9][0-9]$/', $form_state['values']['year1']))
+form_set_error('year1', t('Invalid year of pulication for Book Preference 1'));
- /* edition */
- /*if (!preg_match('/^[1-9][0-9]{0,1}$/', $form_state['values']['edition1']))
- form_set_error('edition1', t('Invalid edition for Book Preference 1'));
+if (!preg_match('/^[1-3][0-9][0-9][0-9]$/', $form_state['values']['year2']))
+form_set_error('year2', t('Invalid year of pulication for Book Preference 2'));
- if (!preg_match('/^[1-9][0-9]{0,1}$/', $form_state['values']['edition2']))
- form_set_error('edition2', t('Invalid edition for Book Preference 2'));
- if (!preg_match('/^[1-9][0-9]{0,1}$/', $form_state['values']['edition3']))
- form_set_error('edition3', t('Invalid edition for Book Preference 3'));
+if (!preg_match('/^[1-3][0-9][0-9][0-9]$/', $form_state['values']['year3']))
+form_set_error('year3', t('Invalid year of pulication for Book Preference 3'));
- /* year of publication */
- /*if (!preg_match('/^[1-3][0-9][0-9][0-9]$/', $form_state['values']['year1']))
- form_set_error('year1', t('Invalid year of pulication for Book Preference 1'));
+/* year of publication */
+/*$cur_year = date('Y');
+if ((int)$form_state['values']['year1'] > $cur_year)
+form_set_error('year1', t('Year of pulication should be not in the future for Book Preference 1'));
- if (!preg_match('/^[1-3][0-9][0-9][0-9]$/', $form_state['values']['year2']))
- form_set_error('year2', t('Invalid year of pulication for Book Preference 2'));
+if ((int)$form_state['values']['year2'] > $cur_year)
+form_set_error('year2', t('Year of pulication should be not in the future for Book Preference 2'));
- if (!preg_match('/^[1-3][0-9][0-9][0-9]$/', $form_state['values']['year3']))
- form_set_error('year3', t('Invalid year of pulication for Book Preference 3'));
+if ((int)$form_state['values']['year3'] > $cur_year)
+form_set_error('year3', t('Year of pulication should be not in the future for Book Preference 3'));
- /* year of publication */
- /*$cur_year = date('Y');
- if ((int)$form_state['values']['year1'] > $cur_year)
- form_set_error('year1', t('Year of pulication should be not in the future for Book Preference 1'));
-
- if ((int)$form_state['values']['year2'] > $cur_year)
- form_set_error('year2', t('Year of pulication should be not in the future for Book Preference 2'));
-
- if ((int)$form_state['values']['year3'] > $cur_year)
- form_set_error('year3', t('Year of pulication should be not in the future for Book Preference 3'));
+/* isbn */
+/*if (!preg_match('/^[0-9\-xX]+$/', $form_state['values']['isbn1']))
+form_set_error('isbn1', t('Invalid ISBN for Book Preference 1'));
- /* isbn */
- /*if (!preg_match('/^[0-9\-xX]+$/', $form_state['values']['isbn1']))
- form_set_error('isbn1', t('Invalid ISBN for Book Preference 1'));
-
- if (!preg_match('/^[0-9\-xX]+$/', $form_state['values']['isbn2']))
- form_set_error('isbn2', t('Invalid ISBN for Book Preference 2'));
-
- if (!preg_match('/^[0-9\-xX]+$/', $form_state['values']['isbn3']))
- form_set_error('isbn3', t('Invalid ISBN for Book Preference 3'));
+if (!preg_match('/^[0-9\-xX]+$/', $form_state['values']['isbn2']))
+form_set_error('isbn2', t('Invalid ISBN for Book Preference 2'));
+
+if (!preg_match('/^[0-9\-xX]+$/', $form_state['values']['isbn3']))
+form_set_error('isbn3', t('Invalid ISBN for Book Preference 3'));
return;
}*/
-
-
function cheque_contct_form()
{
global $user;
-
/*$preference4_q = db_query("SELECT id FROM {textbook_companion_proposal} WHERE uid=".$user->uid);*/
-
$query = db_select('textbook_companion_proposal');
- $query->fields('textbook_companion_proposal', array('id'));
+ $query->fields('textbook_companion_proposal', array(
+ 'id'
+ ));
$query->condition('uid', $user->uid);
$result = $query->execute();
$data = $result->fetchObject();
-
- $form1 = $data->id;
-
- if($user->uid)
- {
+ $form1 = $data->id;
+ if ($user->uid)
+ {
$form['#redirect'] = FALSE;
-
$form['search'] = array(
'#type' => 'textfield',
'#title' => t('Search'),
- '#size' => 48,
+ '#size' => 48
);
-
$form['submit'] = array(
'#type' => 'submit',
'#value' => t('Search')
);
-
$form['cancel'] = array(
'#type' => 'markup',
- '#value' => l(t('Cancel'), ''),
+ '#value' => l(t('Cancel'), '')
);
-
$form['submit2'] = array(
'#type' => 'markup',
'#value' => l(t('Generate Report'), 'cheque_contct/report'),
- '#attributes' => array('id' => 'perm_report'),
+ '#attributes' => array(
+ 'id' => 'perm_report'
+ )
);
-
/*$search_q = db_query("SELECT * FROM textbook_companion_proposal p,textbook_companion_cheque c WHERE c.address_con = 'Submitted' AND (p.id = c.proposal_id)");*/
$query = db_select('textbook_companion_proposal', 'p');
- $query->join('textbook_companion_cheque','c','p.id = c.proposal_id');
+ $query->join('textbook_companion_cheque', 'c', 'p.id = c.proposal_id');
$query->fields('p');
$query->fields('c');
- $query->condition('c.address_con','Submitted');
+ $query->condition('c.address_con', 'Submitted');
$search_q = $query->execute();
-
while ($search_data = $search_q->fetchObject())
- {
- $search_rows[] = array(l($search_data->full_name, 'cheque_contct/status/' . $search_data->proposal_id),$search_data->address_con,$search_data->cheque_no,$search_data->cheque_dispatch_date);
- }
+ {
+ $search_rows[] = array(
+ l($search_data->full_name, 'cheque_contct/status/' . $search_data->proposal_id),
+ $search_data->address_con,
+ $search_data->cheque_no,
+ $search_data->cheque_dispatch_date
+ );
+ } //$search_data = $search_q->fetchObject()
if ($search_rows)
{
- $search_header = array('Name Of The Student', 'Application Form Status', 'Cheque No', 'Cheque Clearance Date');
- $output .= theme('table',array('header'=>$search_header, 'rows'=>$search_rows));
+ $search_header = array(
+ 'Name Of The Student',
+ 'Application Form Status',
+ 'Cheque No',
+ 'Cheque Clearance Date'
+ );
+ $output .= theme('table', array(
+ 'header' => $search_header,
+ 'rows' => $search_rows
+ ));
$form['search_results'] = array(
'#type' => 'item',
- '#title' => $_POST['search'] ,
- '#markup' => $output,
+ '#title' => $_POST['search'],
+ '#markup' => $output
);
- }
+ } //$search_rows
else
{
$form['search_results'] = array(
'#type' => 'item',
'#title' => t('Search results for "') . $_POST['search'] . '"',
- '#markup' => 'No results found',
+ '#markup' => 'No results found'
);
}
if ($_POST)
- {
+ {
$output = '';
$search_rows = array();
$search_quert = '';
-
/*$search_q = db_query("SELECT * FROM textbook_companion_proposal p,textbook_companion_cheque c WHERE c.address_con = 'Submitted' AND (p.id = c.proposal_id) AND (p.full_name LIKE '%%%s%%')", $_POST['search']);*/
$query = db_select('textbook_companion_proposal', 'p');
- $query->join('textbook_companion_cheque','c','p.id = c.proposal_id');
+ $query->join('textbook_companion_cheque', 'c', 'p.id = c.proposal_id');
$query->fields('p');
$query->fields('c');
$query->condition('c.address_con', 'Submitted');
- $query->condition('p.full_name', '%%'.$_POST['search'].'%%', 'LIKE');
+ $query->condition('p.full_name', '%%' . $_POST['search'] . '%%', 'LIKE');
$result = $query->execute();
-
-
while ($search_data = $result->fetchObject())
{
- $search_rows[] = array(l($search_data->full_name, 'cheque_contct/status/' . $search_data->proposal_id),$search_data->address_con,$search_data->cheque_no,$search_data->cheque_dispatch_date);
- }
+ $search_rows[] = array(
+ l($search_data->full_name, 'cheque_contct/status/' . $search_data->proposal_id),
+ $search_data->address_con,
+ $search_data->cheque_no,
+ $search_data->cheque_dispatch_date
+ );
+ } //$search_data = $result->fetchObject()
if ($search_rows)
- {
- $search_header = array('Name Of The Student', 'Application Form Status', 'Cheque No', 'Cheque Clearance Date');
- $output .= theme('table',array('header'=>$search_header,'rows'=>$search_rows));
- $form['search_results'] = array(
- '#type' => 'item',
- '#title' => t('Search results for "') . $_POST['search'] . '"',
- '#markup' => $output,
- );
- }
+ {
+ $search_header = array(
+ 'Name Of The Student',
+ 'Application Form Status',
+ 'Cheque No',
+ 'Cheque Clearance Date'
+ );
+ $output .= theme('table', array(
+ 'header' => $search_header,
+ 'rows' => $search_rows
+ ));
+ $form['search_results'] = array(
+ '#type' => 'item',
+ '#title' => t('Search results for "') . $_POST['search'] . '"',
+ '#markup' => $output
+ );
+ } //$search_rows
else
{
- $form['search_results'] = array(
- '#type' => 'item',
- '#title' => t('Search results for "') . $_POST['search'] . '"',
- '#markup' => 'No results found',
- );
+ $form['search_results'] = array(
+ '#type' => 'item',
+ '#title' => t('Search results for "') . $_POST['search'] . '"',
+ '#markup' => 'No results found'
+ );
}
- }
- return $form;
- }
+ } //$_POST
+ return $form;
+ } //$user->uid
else
{
/*$preference5_q = db_query("SELECT * FROM {textbook_companion_paper} WHERE proposal_id=".$form1);
@@ -339,91 +340,90 @@ function cheque_contct_form()
$query->fields('textbook_companion_paper');
$query->condition('proposal_id', $form1);
$result = $query->execute();
- $data1=$result->fetchObject();
-
+ $data1 = $result->fetchObject();
$form2 = $data1->internship_form;
$form3 = $data1->copyright_form;
$form4 = $data1->undertaking_form;
$form5 = $data1->reciept_form;
-
/*$chq_q = db_query("SELECT * FROM {textbook_companion_proposal} WHERE id=".$form1);
$data_chq = db_fetch_object($chq_q);*/
-
$query = db_select('textbook_companion_proposal');
$query->fields('textbook_companion_proposal');
$query->condition('id', $form1);
$result = $query->execute();
- $data_chq=$result->fetchObject();
-
+ $data_chq = $result->fetchObject();
$form9 = $data_chq->full_name;
$form8 = $data->how_project;
$form10 = $data_chq->mobile;
$form11 = $data_chq->course;
$form12 = $data_chq->branch;
$form13 = $data_chq->university;
- if($form2&&$form3&&$form4&&$form5)
+ if ($form2 && $form3 && $form4 && $form5)
{
$form['full_name'] = array(
'#type' => 'textfield',
'#title' => t('Full Name'),
'#size' => 30,
'#maxlength' => 50,
- '#default_value' => $form9,
+ '#default_value' => $form9
);
$form['mobile'] = array(
'#type' => 'textfield',
'#title' => t('Mobile No.'),
'#size' => 30,
'#maxlength' => 15,
- '#default_value' => $form10,
+ '#default_value' => $form10
);
$form['how_project'] = array(
'#type' => 'select',
'#title' => t('How did you come to know about this project'),
- '#options' => array('Scilab Website' => 'Scilab Website',
+ '#options' => array(
+ 'Scilab Website' => 'Scilab Website',
'Friend' => 'Friend',
'Professor/Teacher' => 'Professor/Teacher',
'Mailing List' => 'Mailing List',
'Poster in my/other college' => 'Poster in my/other college',
- 'Others' => 'Others'),
- '#default_value' => $form8,
+ 'Others' => 'Others'
+ ),
+ '#default_value' => $form8
);
$form['course'] = array(
'#type' => 'textfield',
'#title' => t('Course'),
'#size' => 30,
'#maxlength' => 50,
- '#default_value' => $form11,
+ '#default_value' => $form11
);
$form['branch'] = array(
'#type' => 'select',
'#title' => t('Department/Branch'),
- '#options' => array('Electrical Engineering' => 'Electrical Engineering',
- 'Electronics Engineering' => 'Electronics Engineering',
- 'Computer Engineering' => 'Computer Engineering',
- 'Chemical Engineering' => 'Chemical Engineering',
- 'Instrumentation Engineering' => 'Instrumentation Engineering',
- 'Mechanical Engineering' => 'Mechanical Engineering',
- 'Civil Engineering' => 'Civil Engineering',
- 'Physics' => 'Physics',
- 'Mathematics' => 'Mathematics',
- 'Others' => 'Others'),
- '#default_value' => $form12,
- );
-
+ '#options' => array(
+ 'Electrical Engineering' => 'Electrical Engineering',
+ 'Electronics Engineering' => 'Electronics Engineering',
+ 'Computer Engineering' => 'Computer Engineering',
+ 'Chemical Engineering' => 'Chemical Engineering',
+ 'Instrumentation Engineering' => 'Instrumentation Engineering',
+ 'Mechanical Engineering' => 'Mechanical Engineering',
+ 'Civil Engineering' => 'Civil Engineering',
+ 'Physics' => 'Physics',
+ 'Mathematics' => 'Mathematics',
+ 'Others' => 'Others'
+ ),
+ '#default_value' => $form12
+ );
$form['university'] = array(
'#type' => 'textfield',
'#title' => t('University/Institute'),
'#size' => 30,
'#maxlength' => 100,
- '#default_value' => $form13,
+ '#default_value' => $form13
);
$form['addressforcheque'] = array(
'#type' => 'textfield',
'#title' => t('Address For Mailing Cheque'),
//'#required' => TRUE,
'#size' => 30,
- '#maxlength' => 100,
+ '#maxlength' => 100
);
$form['submit'] = array(
'#type' => 'submit',
@@ -433,168 +433,158 @@ function cheque_contct_form()
'#type' => 'markup',
'#value' => t('Cancel')
);
- }
+ } //$form2 && $form3 && $form4 && $form5
if (!$form2)
- {
+ {
drupal_set_message(t('Internship Form has not been recieved.'), 'error');
- }
- if(!$form3)
- {
+ } //!$form2
+ if (!$form3)
+ {
drupal_set_message(t('Copyright Form has not been recieved.'), 'error');
- }
- if(!$form4)
- {
+ } //!$form3
+ if (!$form4)
+ {
drupal_set_message(t('Undertaking Form has not been recieved.'), 'error');
- }
- return $form;
+ } //!$form4
+ return $form;
}
}
-
-
function cheque_status_form($form_state, $proposal_id)
{
global $user;
-
/* get current proposal */
$proposal_id = arg(2);
-
/*$proposal_q = db_query("SELECT * FROM {textbook_companion_proposal} WHERE id =".$proposal_id);*/
- $query = db_select('textbook_companion_proposal');
- $query->fields('textbook_companion_proposal');
- $query->condition('id', $proposal_id);
- $proposal_q = $query->execute();
-
+ $query = db_select('textbook_companion_proposal');
+ $query->fields('textbook_companion_proposal');
+ $query->condition('id', $proposal_id);
+ $proposal_q = $query->execute();
/*$proposal_q1 = db_query("SELECT * FROM {textbook_companion_cheque} WHERE proposal_id =".$proposal_id);*/
- $query = db_select('textbook_companion_cheque');
- $query->fields('textbook_companion_cheque');
- $query->condition('proposal_id', $proposal_id);
- $proposal_q1 = $query->execute();
-
-
+ $query = db_select('textbook_companion_cheque');
+ $query->fields('textbook_companion_cheque');
+ $query->condition('proposal_id', $proposal_id);
+ $proposal_q1 = $query->execute();
$proposal_data1 = $proposal_q1->fetchObject();
if (!$proposal_data = $proposal_q->fetchObject())
{
drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error');
drupal_goto('manage_proposal');
return;
- }
- $form['proposal_id'] =array(
+ } //!$proposal_data = $proposal_q->fetchObject()
+ $form['proposal_id'] = array(
'#type' => 'hidden',
- '#default_value' => $proposal_id,
+ '#default_value' => $proposal_id
);
-
/*$empty = db_query("SELECT * FROM {textbook_companion_proposal} WHERE id = ".$proposal_id);*/
- $query = db_select('textbook_companion_proposal');
- $query->fields('textbook_companion_proposal');
- $query->condition('id', $proposal_id);
- $empty = $query->execute();
-
- if(!$empty)
+ $query = db_select('textbook_companion_proposal');
+ $query->fields('textbook_companion_proposal');
+ $query->condition('id', $proposal_id);
+ $empty = $query->execute();
+ if (!$empty)
{
/*$prop =db_query("insert into {textbook_companion_cheque} (proposal_id) values(%d)",$proposal_id);*/
-
$query = "insert into {textbook_companion_cheque} (proposal_id) values (:proposal_id)";
$args = array(
- ":proposal_id"=>$proposal_id,
- );
- $result = db_query($query, $args, array('return' => Database::RETURN_INSERT_ID));
- }
+ ":proposal_id" => $proposal_id
+ );
+ $result = db_query($query, $args, array(
+ 'return' => Database::RETURN_INSERT_ID
+ ));
+ } //!$empty
$form['candidate_detail'] = array(
'#type' => 'fieldset',
'#title' => t('Candidate Details'),
'#collapsible' => TRUE,
'#collapsed' => FALSE,
- '#attributes' => array('id' => 'candidate_detail'),
+ '#attributes' => array(
+ 'id' => 'candidate_detail'
+ )
);
$form['candidate_detail']['full_name'] = array(
'#type' => 'item',
'#markup' => $proposal_data->full_name,
- '#title' => t('Contributor Name'),
+ '#title' => t('Contributor Name')
);
$form['candidate_detail']['email'] = array(
'#type' => 'item',
'#markup' => user_load($proposal_data->uid)->mail,
- '#title' => t('Email'),
+ '#title' => t('Email')
);
$form['candidate_detail']['mobile'] = array(
'#type' => 'item',
'#markup' => $proposal_data->mobile,
- '#title' => t('Mobile'),
+ '#title' => t('Mobile')
);
$form['candidate_detail']['alt_mobile'] = array(
'#type' => 'item',
'#markup' => $proposal_data1->alt_mobno,
- '#title' => t('Alternate Mobile No.'),
+ '#title' => t('Alternate Mobile No.')
);
/*$form_q=db_query("SELECT * FROM {textbook_companion_paper} WHERE proposal_id =".$proposal_id);
$form_data=db_fetch_object($form_q);*/
-
$query = db_select('textbook_companion_paper');
$query->fields('textbook_companion_paper');
$query->condition('proposal_id', $proposal_id);
$result = $query->execute();
- $form_data=$result->fetchObject();
-
+ $form_data = $result->fetchObject();
/* get book preference */
$preference_html = '<ul>';
-
/*$preference_q = db_query("SELECT * FROM {textbook_companion_preference} WHERE proposal_id = %d ORDER BY pref_number ASC", $proposal_id);*/
$query = db_select('textbook_companion_preference');
$query->fields('textbook_companion_preference');
$query->condition('proposal_id', $proposal_id);
$query->orderBy('pref_number', 'ASC');
$preference_q = $query->execute();
-
while ($preference_data = $preference_q->fetchObject())
{
if ($preference_data->approval_status == 1)
$preference_html .= '<li><strong>' . $preference_data->book . ' (Written by ' . $preference_data->author . ') - Approved Book</strong></li>';
else
$preference_html .= '<li>' . $preference_data->book . ' (Written by ' . $preference_data->author . ')</li>';
- }
+ } //$preference_data = $preference_q->fetchObject()
$preference_html .= '</ul>';
$form['book_preference_f'] = array(
'#type' => 'fieldset',
'#title' => t('Book Preferences/Application Status'),
'#collapsible' => FALSE,
'#collapsed' => FALSE,
- '#attributes' => array('id' => 'book_preference_f'),
+ '#attributes' => array(
+ 'id' => 'book_preference_f'
+ )
);
$form['book_preference_f']['book_preference'] = array(
'#type' => 'item',
'#markup' => $preference_html,
- '#title' => t('Book Preferences'),
+ '#title' => t('Book Preferences')
);
-
/*$chq_q=db_query("SELECT * FROM {textbook_companion_cheque} WHERE proposal_id = %d", $proposal_id);
$chq_data=db_fetch_object($chq_q);*/
$query = db_select('textbook_companion_cheque');
$query->fields('textbook_companion_cheque');
$query->condition('proposal_id', $proposal_id);
$result = $query->execute();
- $chq_data=$result->fetchObject();
-
+ $chq_data = $result->fetchObject();
$form_html .= '<ul>';
- if($form_data->internship_form)
+ if ($form_data->internship_form)
{
$form_html .= '<li><strong>Internship Application </strong> Form Submitted</li>';
- }
+ } //$form_data->internship_form
else
{
$form_html .= '<li><strong>Internship Application </strong> Form Not Submitted </li>';
}
- if($form_data->copyright_form)
+ if ($form_data->copyright_form)
{
$form_html .= '<li><strong>Copyright Application </strong> Form Submitted</li>';
- }
+ } //$form_data->copyright_form
else
{
$form_html .= '<li><strong>Copyright Application</strong> Form Not Submitted </li>';
}
- if($form_data->undertaking_form)
+ if ($form_data->undertaking_form)
{
$form_html .= '<li><strong>Undertaking Application </strong> Form Submitted</li>';
- }
+ } //$form_data->undertaking_form
else
{
$form_html .= '<li><strong>Undertaking Application</strong> Form Not Submitted </li>';
@@ -603,56 +593,67 @@ function cheque_status_form($form_state, $proposal_id)
$form['book_preference_f']['formsubmit'] = array(
'#type' => 'item',
'#markup' => $form_html,
- '#title' => t('Application Form Status'),
+ '#title' => t('Application Form Status')
);
$form['stu_cheque_details'] = array(
'#type' => 'fieldset',
'#title' => t('Student Cheque Details'),
'#collapsible' => TRUE,
'#collapsed' => FALSE,
- '#attributes' => array('id' => 'stu_cheque_details'),
+ '#attributes' => array(
+ 'id' => 'stu_cheque_details'
+ )
);
$form['tea_cheque_details'] = array(
'#type' => 'fieldset',
'#title' => t('Teacher Cheque Details'),
'#collapsible' => TRUE,
'#collapsed' => FALSE,
- '#attributes' => array('id' => 'tea_cheque_details'),
+ '#attributes' => array(
+ 'id' => 'tea_cheque_details'
+ )
);
$form['perm_cheque_address'] = array(
'#type' => 'fieldset',
'#title' => t('Permanent Address'),
'#collapsible' => TRUE,
'#collapsed' => FALSE,
- '#attributes' => array('id' => 'perm_cheque_address'),
+ '#attributes' => array(
+ 'id' => 'perm_cheque_address'
+ )
);
$form['temp_cheque_address'] = array(
'#type' => 'fieldset',
'#title' => t('Temporary Address'),
'#collapsible' => TRUE,
'#collapsed' => FALSE,
- '#attributes' => array('id' => 'temp_cheque_address'),
+ '#attributes' => array(
+ 'id' => 'temp_cheque_address'
+ )
);
$form['cheque_delivery'] = array(
'#type' => 'fieldset',
'#title' => t('Cheque Delivery'),
'#collapsible' => FALSE,
'#collapsed' => FALSE,
- '#attributes' => array('id' => 'cheque_delivery'),
+ '#attributes' => array(
+ 'id' => 'cheque_delivery'
+ )
);
$form['commentf'] = array(
'#type' => 'fieldset',
'#title' => t('Remark'),
'#collapsible' => FALSE,
'#collapsed' => FALSE,
- '#attributes' => array('id' => 'commentf'),
+ '#attributes' => array(
+ 'id' => 'commentf'
+ )
);
/*$chq4_q = db_query("SELECT * FROM {textbook_companion_cheque} WHERE proposal_id=".$proposal_id);*/
$query = db_select('textbook_companion_cheque');
$query->fields('textbook_companion_cheque');
$query->condition('proposal_id', $proposal_id);
$chq4_q = $query->execute();
-
$chq1 = '';
$chq2 = '';
$chq3 = '';
@@ -670,7 +671,7 @@ function cheque_status_form($form_state, $proposal_id)
$chq15 = '';
$chq16 = '';
$chq17 = '';
- if($chqe = $chq4_q->fetchObject())
+ if ($chqe = $chq4_q->fetchObject())
{
$chq1 = $chqe->cheque_no;
$chq2 = $chqe->address;
@@ -693,245 +694,250 @@ function cheque_status_form($form_state, $proposal_id)
'#type' => 'textfield',
'#default_value' => $chq1,
'#title' => t('Cheque No'),
- '#size' => 54,
+ '#size' => 54
);
$form['tea_cheque_details']['cheque_no_t'] = array(
'#type' => 'textfield',
'#default_value' => $chq17,
'#title' => t('Cheque No'),
- '#size' => 54,
+ '#size' => 54
);
$form['perm_cheque_address']['chq_address'] = array(
'#type' => 'textarea',
'#default_value' => $chq2,
- '#title' => t('Address Street 1'),
+ '#title' => t('Address Street 1')
);
$form['perm_cheque_address']['chq_address']['#attributes']['readonly'] = 'readonly';
$form['perm_cheque_address']['perm_city'] = array(
'#type' => 'textfield',
'#default_value' => $chq7,
'#title' => t('City'),
- '#size' => 35,
+ '#size' => 35
);
$form['perm_cheque_address']['perm_city']['#attributes']['readonly'] = 'readonly';
$form['perm_cheque_address']['perm_state'] = array(
'#type' => 'textfield',
'#default_value' => $chq8,
'#title' => t('State'),
- '#size' => 35,
+ '#size' => 35
);
$form['perm_cheque_address']['perm_state']['#attributes']['readonly'] = 'readonly';
$form['perm_cheque_address']['perm_pincode'] = array(
'#type' => 'textfield',
'#default_value' => $chq9,
'#title' => t('Zip code'),
- '#size' => 35,
+ '#size' => 35
);
$form['perm_cheque_address']['perm_pincode']['#attributes']['readonly'] = 'readonly';
$form['stu_cheque_details']['cheq_amt'] = array(
'#type' => 'textfield',
'#default_value' => $chq3,
'#title' => t('Cheque Amount'),
- '#size' => 54,
+ '#size' => 54
);
$form['tea_cheque_details']['cheq_amt_t'] = array(
'#type' => 'textfield',
'#default_value' => $chq17,
'#title' => t('Cheque Amount'),
- '#size' => 54,
+ '#size' => 54
);
$form['temp_cheque_address']['temp_chq_address'] = array(
'#type' => 'textarea',
'#default_value' => $chq10,
- '#title' => t('Address Street 1'),
+ '#title' => t('Address Street 1')
);
$form['temp_cheque_address']['temp_chq_address']['#attributes']['readonly'] = 'readonly';
$form['temp_cheque_address']['temp_city'] = array(
'#type' => 'textfield',
'#default_value' => $chq12,
'#title' => t('City'),
- '#size' => 35,
+ '#size' => 35
);
$form['temp_cheque_address']['temp_city']['#attributes']['readonly'] = 'readonly';
$form['temp_cheque_address']['temp_state'] = array(
'#type' => 'textfield',
'#default_value' => $chq13,
'#title' => t('State'),
- '#size' => 35,
+ '#size' => 35
);
$form['temp_cheque_address']['temp_state']['#attributes']['readonly'] = 'readonly';
$form['temp_cheque_address']['temp_pincode'] = array(
'#type' => 'textfield',
'#default_value' => $chq14,
'#title' => t('Zipcode'),
- '#size' => 35,
+ '#size' => 35
);
$form['temp_cheque_address']['temp_pincode']['#attributes']['readonly'] = 'readonly';
- }
+ } //$chqe = $chq4_q->fetchObject()
else
{
$form['stu_cheque_details']['cheque_no'] = array(
'#type' => 'textfield',
'#default_value' => $chq1,
- '#title' => t('Cheque No'),
+ '#title' => t('Cheque No')
);
$form['tea_cheque_details']['cheque_no_t'] = array(
'#type' => 'textfield',
'#default_value' => $chq16,
- '#title' => t('Cheque No'),
+ '#title' => t('Cheque No')
);
$form['perm_cheque_address']['chq_address'] = array(
'#type' => 'textarea',
'#default_value' => $chq2,
- '#title' => t('Address Street 1'),
+ '#title' => t('Address Street 1')
);
$form['perm_cheque_address']['perm_city'] = array(
'#type' => 'textfield',
'#default_value' => $chq7,
'#title' => t('City'),
- '#size' => 35,
+ '#size' => 35
);
$form['perm_cheque_address']['perm_state'] = array(
'#type' => 'textfield',
'#default_value' => $chq8,
'#title' => t('State'),
- '#size' => 35,
+ '#size' => 35
);
$form['perm_cheque_address']['perm_pincode'] = array(
'#type' => 'textfield',
'#default_value' => $chq9,
'#title' => t('Zip code'),
- '#size' => 35,
+ '#size' => 35
);
$form['perm_cheque_address']['same_address'] = array(
'#type' => 'checkbox',
'#title' => t('Same As Permanent Address'),
- '#attributes' => array('onclick' => 'copy_address()'),
- );
+ '#attributes' => array(
+ 'onclick' => 'copy_address()'
+ )
+ );
$form['stu_cheque_details']['cheq_amt'] = array(
'#type' => 'textfield',
'#default_value' => $chq3,
- '#title' => t('Cheque Amount'),
+ '#title' => t('Cheque Amount')
);
$form['tea_cheque_details']['cheq_amt'] = array(
'#type' => 'textfield',
'#default_value' => $chq17,
- '#title' => t('Cheque Amount'),
+ '#title' => t('Cheque Amount')
);
$form['temp_cheque_address']['temp_chq_address'] = array(
'#type' => 'textarea',
'#default_value' => $chq10,
- '#title' => t('Address Street 1'),
+ '#title' => t('Address Street 1')
);
$form['temp_cheque_address']['temp_city'] = array(
'#type' => 'textfield',
'#default_value' => $chq12,
'#title' => t('City'),
- '#size' => 35,
+ '#size' => 35
);
$form['temp_cheque_address']['temp_state'] = array(
'#type' => 'textfield',
'#default_value' => $chq13,
'#title' => t('State'),
- '#size' => 35,
+ '#size' => 35
);
$form['temp_cheque_address']['temp_pincode'] = array(
'#type' => 'textfield',
'#default_value' => $chq14,
'#title' => t('Zip code'),
- '#size' => 35,
+ '#size' => 35
);
$form['temp_cheque_address']['same_address'] = array(
'#type' => 'checkbox',
- '#title' => t('Same As Permanent Address'),
+ '#title' => t('Same As Permanent Address')
);
$form['temp_cheque_address']['same_address'] = array(
'#type' => 'checkbox',
'#title' => t('Same As Permanent Address'),
- '#attributes' => array('onclick' => 'copy_address()'),
- );
- }
- $form['cheque_delivery']['cheque_sent'] = array(
- '#type' => 'checkbox',
- '#title' => t('Cheque Sent'),
- '#default_value' => $chq4,
- '#description' => t('Check if the Cheque has been sent to the user.'),
- '#attributes' => array('id' => 'cheque_sent'),
- );
- $form['cheque_delivery']['cheque_cleared'] = array(
- '#type' => 'checkbox',
- '#title' => t('Cheque Cleared'),
- '#default_value' => $chq5,
- '#description' => t('Check if the Cheque has been <strong>Realised</strong> to the User Account.'),
- '#attributes' => array('id' => 'cheque_cleared'),
- );
- $form['commentf']['comment_cheque'] = array(
- '#type' => 'textarea',
- '#size' => 35,
- '#attributes' => array('id' => 'comment'),
- '#default_value' => $chq15,
- );
- $form['proposal_id'] = array(
- '#type' => 'hidden',
- '#value' => $proposal_id,
- );
-
- /*$preference1_p = db_query("SELECT * FROM {textbook_companion_paper} WHERE proposal_id = %d ORDER BY id ASC", $proposal_id); */
-
+ '#attributes' => array(
+ 'onclick' => 'copy_address()'
+ )
+ );
+ }
+ $form['cheque_delivery']['cheque_sent'] = array(
+ '#type' => 'checkbox',
+ '#title' => t('Cheque Sent'),
+ '#default_value' => $chq4,
+ '#description' => t('Check if the Cheque has been sent to the user.'),
+ '#attributes' => array(
+ 'id' => 'cheque_sent'
+ )
+ );
+ $form['cheque_delivery']['cheque_cleared'] = array(
+ '#type' => 'checkbox',
+ '#title' => t('Cheque Cleared'),
+ '#default_value' => $chq5,
+ '#description' => t('Check if the Cheque has been <strong>Realised</strong> to the User Account.'),
+ '#attributes' => array(
+ 'id' => 'cheque_cleared'
+ )
+ );
+ $form['commentf']['comment_cheque'] = array(
+ '#type' => 'textarea',
+ '#size' => 35,
+ '#attributes' => array(
+ 'id' => 'comment'
+ ),
+ '#default_value' => $chq15
+ );
+ $form['proposal_id'] = array(
+ '#type' => 'hidden',
+ '#value' => $proposal_id
+ );
+ /*$preference1_p = db_query("SELECT * FROM {textbook_companion_paper} WHERE proposal_id = %d ORDER BY id ASC", $proposal_id); */
$query = db_select('textbook_companion_paper');
$query->fields('textbook_companion_paper');
$query->condition('proposal_id', $proposal_id);
$query->orderBy('id', 'ASC');
$preference1_p = $query->execute();
-
- if (!($proposal_data1 = $preference1_p->fetchObject()))
- {
- drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error');
- drupal_goto('manage_proposal');
- return;
- }
- $form['submit'] = array(
- '#type' => 'submit',
- '#value' => t('Submit')
- );
- $form['cancel'] = array(
- '#type' => 'markup',
- '#value' => l(t('Cancel'), 'manage_proposal/all'),
- );
- return $form;
+ if (!($proposal_data1 = $preference1_p->fetchObject()))
+ {
+ drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error');
+ drupal_goto('manage_proposal');
+ return;
+ } //!($proposal_data1 = $preference1_p->fetchObject())
+ $form['submit'] = array(
+ '#type' => 'submit',
+ '#value' => t('Submit')
+ );
+ $form['cancel'] = array(
+ '#type' => 'markup',
+ '#value' => l(t('Cancel'), 'manage_proposal/all')
+ );
+ return $form;
}
/*function cheque_status_form_validate($form, &$form_state)
{
- //var_dump(($form_state['values']['stu_cheque_details']['cheque_amt']));
- //die;
- if((!$form_state['values']['cheque_no'])||(!is_numeric($form_state['values']['cheque_no'])))
- {
- form_set_error('cheque_no', t('Invalid Student Cheque No. Please enter a valid cheque no.'));
- return;
- }
- if((!$form_state['values']['cheq_amt'])||(!is_numeric($form_state['values']['cheq_amt'])))
- {
- form_set_error('cheq_amt', t('Invalid Student Amount. Please enter a valid numeric amount.'));
- return;
- }
- if((!$form_state['values']['cheque_no_t'])||(!is_numeric($form_state['values']['cheque_no_t'])))
- {
- form_set_error('cheque_no_t', t('Invalid Teacher Cheque No. Please enter a valid cheque no.'));
- return;
- }
- if((!$form_state['values']['cheq_amt_t'])||(!is_numeric($form_state['values']['cheq_amt_t'])))
- {
- form_set_error('cheq_amt_t', t('Invalid Teacher Amount. Please enter a valid numeric amount.'));
- return;
- }
+//var_dump(($form_state['values']['stu_cheque_details']['cheque_amt']));
+//die;
+if((!$form_state['values']['cheque_no'])||(!is_numeric($form_state['values']['cheque_no'])))
+{
+form_set_error('cheque_no', t('Invalid Student Cheque No. Please enter a valid cheque no.'));
+return;
+}
+if((!$form_state['values']['cheq_amt'])||(!is_numeric($form_state['values']['cheq_amt'])))
+{
+form_set_error('cheq_amt', t('Invalid Student Amount. Please enter a valid numeric amount.'));
+return;
+}
+if((!$form_state['values']['cheque_no_t'])||(!is_numeric($form_state['values']['cheque_no_t'])))
+{
+form_set_error('cheque_no_t', t('Invalid Teacher Cheque No. Please enter a valid cheque no.'));
+return;
+}
+if((!$form_state['values']['cheq_amt_t'])||(!is_numeric($form_state['values']['cheq_amt_t'])))
+{
+form_set_error('cheq_amt_t', t('Invalid Teacher Amount. Please enter a valid numeric amount.'));
+return;
+}
}*/
function cheque_status_form_submit($form, &$form_state)
{
global $user;
- $proposal_id=arg(2);
-
-
+ $proposal_id = arg(2);
/*$query ="UPDATE {textbook_companion_cheque} SET
cheque_no = ".$form_state['values']['cheque_no'].",
cheque_amt = ".$form_state['values']['cheq_amt'].",
@@ -950,158 +956,138 @@ function cheque_status_form_submit($form, &$form_state)
WHERE proposal_id = ".$proposal_id;
db_query($query);*/
-
$query = db_update('textbook_companion_cheque');
$query->fields(array(
- 'cheque_no' => $form_state[ values ][ cheque_no ],
- 'cheque_amt' => $form_state[ values ][ cheq_amt ],
- 'alt_mobno' => $form_state[ values ][ mobileno2 ],
- 'address' => $form_state[ values ][ chq_address ],
- 'perm_city' => $form_state[ values ][ perm_city ],
- 'perm_state' => $form_state[ values ][ perm_state ],
- 'perm_pincode' => $form_state[ values ][ perm_pincode ],
- 'temp_chq_address' => $form_state[ values ][ temp_chq_address ],
- 'temp_city' => $form_state[ values ][ temp_city ],
- 'temp_state' => $form_state[ values ][ temp_state ],
- 'temp_pincode' => $form_state[ values ][ temp_pincode ],
- 'commentf' => $form_state[ values ][ comment_cheque ],
- 't_cheque_no' => $form_state[ values ][ cheque_no_t ],
- 't_cheque_amt' => $form_state[ values ][ cheq_amt_t ],
+ 'cheque_no' => $form_state[values][cheque_no],
+ 'cheque_amt' => $form_state[values][cheq_amt],
+ 'alt_mobno' => $form_state[values][mobileno2],
+ 'address' => $form_state[values][chq_address],
+ 'perm_city' => $form_state[values][perm_city],
+ 'perm_state' => $form_state[values][perm_state],
+ 'perm_pincode' => $form_state[values][perm_pincode],
+ 'temp_chq_address' => $form_state[values][temp_chq_address],
+ 'temp_city' => $form_state[values][temp_city],
+ 'temp_state' => $form_state[values][temp_state],
+ 'temp_pincode' => $form_state[values][temp_pincode],
+ 'commentf' => $form_state[values][comment_cheque],
+ 't_cheque_no' => $form_state[values][cheque_no_t],
+ 't_cheque_amt' => $form_state[values][cheq_amt_t]
));
$query->condition('proposal_id', $proposal_id);
$num_updated = $query->execute();
-
if ($form_state['values']['cheque_sent'] == 1)
{
/* sending email */
/*$query ="UPDATE {textbook_companion_cheque} SET cheque_sent = ".$form_state['values']['cheque_sent']." WHERE proposal_id = ".$proposal_id;
db_query($query);*/
-
$query = db_update('textbook_companion_cheque');
$query->fields(array(
- 'cheque_sent' => $form_state[ values ][ cheque_sent ],
+ 'cheque_sent' => $form_state[values][cheque_sent]
));
$query->condition('proposal_id', $proposal_id);
$num_updated = $query->execute();
-
$book_user = user_load($proposal_data->uid);
$param['proposal_completed']['proposal_id'] = $proposal_id;
$param['proposal_completed']['user_id'] = $proposal_data->uid;
$email_to = $book_user->mail;
- if (!drupal_mail('textbook_companion', 'cheque_sent', $email_to , language_default(), $param, variable_get('textbook_companion_from_email', NULL), TRUE))
+ if (!drupal_mail('textbook_companion', 'cheque_sent', $email_to, language_default(), $param, variable_get('textbook_companion_from_email', NULL), TRUE))
drupal_set_message('Error sending email message.', 'error');
drupal_set_message('Cheque for Book proposal has been Sent. User has been notified .', 'status');
- }
-
-
+ } //$form_state['values']['cheque_sent'] == 1
if ($form_state['values']['cheque_cleared'] == 1)
{
/*$query ="UPDATE {textbook_companion_cheque} SET cheque_cleared = ".$form_state['values']['cheque_cleared']." WHERE proposal_id = ".$proposal_id;
db_query($query);*/
-
$query = db_update('textbook_companion_cheque');
$query->fields(array(
- 'cheque_cleared' => $form_state[ values ][ cheque_cleared ],
+ 'cheque_cleared' => $form_state[values][cheque_cleared]
));
$query->condition('proposal_id', $proposal_id);
$num_updated = $query->execute();
-
$curtime = MySQL_NOW();
echo $curtime;
drupal_set_message('Cheque Has Been Debited into User Account.', 'status');
/*$queryc ="UPDATE {textbook_companion_cheque} SET cheque_dispatch_date = NOW() WHERE proposal_id = ".$form_state['values']['proposal_id']."";
db_query($queryc);*/
-
$query = db_update('textbook_companion_cheque');
$query->fields(array(
- 'cheque_dispatch_date' => 'NOW',
+ 'cheque_dispatch_date' => 'NOW'
));
$query->condition('proposal_id', $form_state['values']['proposal_id']);
$num_updated = $query->execute();
- }
-
+ } //$form_state['values']['cheque_cleared'] == 1
/************************************************
- Check For the Remark
+ Check For the Remark
************************************************/
if ($form_state['values']['comment_cheque'])
{
/* sending email */
- $book_user = user_load($proposal_data->uid);
+ $book_user = user_load($proposal_data->uid);
$param['proposal_completed']['proposal_id'] = $proposal_id;
$param['proposal_completed']['user_id'] = $proposal_data->uid;
$email_to = $book_user->mail;
- if (!drupal_mail('textbook_companion', 'remark', $email_to , language_default(), $param, variable_get('textbook_companion_from_email', NULL), TRUE))
+ if (!drupal_mail('textbook_companion', 'remark', $email_to, language_default(), $param, variable_get('textbook_companion_from_email', NULL), TRUE))
drupal_set_message('Error sending email message.', 'error');
drupal_set_message(t('Remark Updated. User has been notified'), 'status');
- }
- else
+ } //$form_state['values']['comment_cheque']
+ else
{
- if (!drupal_mail('textbook_companion', 'remark_not', $email_to , language_default(), $param, variable_get('textbook_companion_from_email', NULL), TRUE))
+ if (!drupal_mail('textbook_companion', 'remark_not', $email_to, language_default(), $param, variable_get('textbook_companion_from_email', NULL), TRUE))
drupal_set_message('Error sending email message.', 'error');
- drupal_set_message('No Remarks. User has been notified .', 'status');
+ drupal_set_message('No Remarks. User has been notified .', 'status');
}
}
-function MySQL_NOW(){ return date('Y-m-d'); }
-
+function MySQL_NOW()
+{
+ return date('Y-m-d');
+}
function contact_details($form_state)
{
global $user;
- if(!isset($_REQUEST['msg']))
+ if (!isset($_REQUEST['msg']))
drupal_set_message('<strong>Caution</strong>:Please update Contact Detail carefully as this will be used for future reference during <strong>Payment</strong></li></ul>', 'error');
-
$x = $user->uid;
- /*$query2 = db_query("SELECT * FROM {textbook_companion_proposal} WHERE uid=".$x);
- $data2 = db_fetch_object($query2);*/
-
+ /*$query2 = db_query("SELECT * FROM {textbook_companion_proposal} WHERE uid=".$x);
+ $data2 = db_fetch_object($query2);*/
$query = db_select('textbook_companion_proposal');
$query->fields('textbook_companion_proposal');
$query->condition('uid', $x);
$result = $query->execute();
- $data2=$result->fetchObject();
-
-
- if(!$data2)
+ $data2 = $result->fetchObject();
+ if (!$data2)
{
drupal_set_message('Fill Up The <a href="proposal">Book Proposal Form</a>', 'error');
return '';
- }
+ } //!$data2
/*$query3 = db_query("SELECT * FROM {textbook_companion_preference} WHERE approval_status=1 AND proposal_id=".$data2->id);
$data3 = db_fetch_object($query3);*/
-
$query = db_select('textbook_companion_preference');
$query->fields('textbook_companion_preference');
$query->condition('approval_status', 1);
$query->condition('proposal_id', $data2->id);
$result = $query->execute();
- $data3=$result->fetchObject();
-
- if(!$data3->approval_status)
+ $data3 = $result->fetchObject();
+ if (!$data3->approval_status)
{
drupal_set_message('Book Proposal Has Not Been Accpeted .', 'error');
return '';
- }
-
+ } //!$data3->approval_status
$proposal_id = $data2->id;
-
/*$comment_qx = db_query("SELECT * FROM textbook_companion_cheque c WHERE proposal_id =".$proposal_id);
$commentv = db_fetch_object($comment_qx);*/
-
$query = db_select('textbook_companion_cheque', 'c');
$query->fields('c');
$query->condition('proposal_id', $proposal_id);
$result = $query->execute();
- $commentv=$result->fetchObject();
-
- $form16 = $commentv->commentf;
+ $commentv = $result->fetchObject();
+ $form16 = $commentv->commentf;
$mob_no = $data2->mobile;
$full_name = $data2->full_name;
-
/*$query1 = db_query("SELECT * FROM {textbook_companion_cheque} WHERE proposal_id=".$proposal_id);*/
$query = db_select('textbook_companion_cheque');
$query->fields('textbook_companion_cheque');
$query->condition('proposal_id', $proposal_id);
$result = $query->execute();
-
$form1 = 0;
$form2 = 0;
$form3 = 0;
@@ -1116,226 +1102,224 @@ function contact_details($form_state)
$form12 = 0;
$form13 = 0;
$form14 = 0;
- $form15 = 0;
-
- if($data = $result->fetchObject())
+ $form15 = 0;
+ if ($data = $result->fetchObject())
{
$form1 = $data->address;
$form8 = $data->alt_mobno;
- $form9 = $data->perm_city;
+ $form9 = $data->perm_city;
$form10 = $data->perm_state;
$form11 = $data->perm_pincode;
- $form12 = $data->temp_chq_address;
+ $form12 = $data->temp_chq_address;
$form13 = $data->temp_city;
$form14 = $data->temp_state;
- $form15 = $data->temp_pincode;
- }
- else
- {
+ $form15 = $data->temp_pincode;
+ } //$data = $result->fetchObject()
+ else
+ {
/*db_query("insert into {textbook_companion_cheque} (proposal_id) values(%d)",$proposal_id);*/
-
$query = "insert into {textbook_companion_cheque} (proposal_id) values (:proposal_id)";
$args = array(
- ":proposal_id"=>$proposal_id,
- );
- $result = db_query($query, $args, array('return' => Database::RETURN_INSERT_ID));
+ ":proposal_id" => $proposal_id
+ );
+ $result = db_query($query, $args, array(
+ 'return' => Database::RETURN_INSERT_ID
+ ));
}
$form['candidate_detail'] = array(
- '#type' => 'fieldset',
- '#value' => $form_html,
- '#title' => t('Candidate Detail'),
- '#attributes' => array('id' => 'candidate_detail'),
+ '#type' => 'fieldset',
+ '#value' => $form_html,
+ '#title' => t('Candidate Detail'),
+ '#attributes' => array(
+ 'id' => 'candidate_detail'
+ )
+ );
+ $form['proposal_id'] = array(
+ '#type' => 'hidden',
+ '#default_value' => $proposal_id
);
- $form['proposal_id'] =array(
- '#type' => 'hidden',
- '#default_value' => $proposal_id,
- );
$form['candidate_detail']['fullname'] = array(
- '#type' => 'textfield',
- '#title' => t('Full Name'),
- '#size' => 48,
- '#default_value' => $full_name,
- );
- $form['candidate_detail']['email'] = array(
- '#type' => 'textfield',
- '#title' => t('Email'),
- '#size' => 48,
- '#value' => $user->mail,
- '#disabled' => TRUE,
- );
+ '#type' => 'textfield',
+ '#title' => t('Full Name'),
+ '#size' => 48,
+ '#default_value' => $full_name
+ );
+ $form['candidate_detail']['email'] = array(
+ '#type' => 'textfield',
+ '#title' => t('Email'),
+ '#size' => 48,
+ '#value' => $user->mail,
+ '#disabled' => TRUE
+ );
$form['candidate_detail']['mobileno1'] = array(
- '#type' => 'textfield',
- '#title' => t('Mobile No'),
- '#size' => 48,
- '#default_value' => $mob_no,
- );
-
- $form['candidate_detail']['mobileno2'] = array(
- '#type' => 'textfield',
- '#title' => t('Alternate Mobile No'),
- '#size' => 48,
- '#default_value' => $form8,
- );
-
+ '#type' => 'textfield',
+ '#title' => t('Mobile No'),
+ '#size' => 48,
+ '#default_value' => $mob_no
+ );
+ $form['candidate_detail']['mobileno2'] = array(
+ '#type' => 'textfield',
+ '#title' => t('Alternate Mobile No'),
+ '#size' => 48,
+ '#default_value' => $form8
+ );
/*$chq_q=db_query("SELECT * FROM {textbook_companion_cheque} WHERE proposal_id=".$proposal_id);
- $chq_data=db_fetch_object($chq_q);*/
-
+ $chq_data=db_fetch_object($chq_q);*/
$query = db_select('textbook_companion_cheque');
$query->fields('textbook_companion_cheque');
$query->condition('proposal_id', $proposal_id);
$result = $query->execute();
- $chq_data=$result->fetchObject();
-
-
- /*$q_form = db_query("SELECT * FROM {textbook_companion_paper} WHERE proposal_id=".$proposal_id);
- $q_data = db_fetch_object($q_form);*/
-
+ $chq_data = $result->fetchObject();
+ /*$q_form = db_query("SELECT * FROM {textbook_companion_paper} WHERE proposal_id=".$proposal_id);
+ $q_data = db_fetch_object($q_form);*/
$query = db_select('textbook_companion_paper');
$query->fields('textbook_companion_paper');
$query->condition('proposal_id', $proposal_id);
$result = $query->execute();
- $q_data=$result->fetchObject();
-
- $form_html .= '<ul>';
- if($q_data->internship_form)
+ $q_data = $result->fetchObject();
+ $form_html .= '<ul>';
+ if ($q_data->internship_form)
{
$form_html .= '<li><strong>Internship Application </strong> Form Submitted</li>';
- }
+ } //$q_data->internship_form
else
{
$form_html .= '<li><strong>Internship Application </strong> Form Not Submitted.<br>Please submit it as soon as possible.</li>';
}
- if($q_data->copyright_form)
+ if ($q_data->copyright_form)
{
$form_html .= '<li><strong>Copyright Application </strong> Form Submitted</li>';
- }
+ } //$q_data->copyright_form
else
{
$form_html .= '<li><strong>Copyright Application</strong> Form Not Submitted.<br>Please submit it as soon as possible.</li>';
}
- if($q_data->undertaking_form)
+ if ($q_data->undertaking_form)
{
$form_html .= '<li><strong>Undertaking Application </strong> Form Submitted</li>';
- }
+ } //$q_data->undertaking_form
else
{
$form_html .= '<li><strong>Undertaking Application</strong> Form Not Submitted.<br>Please submit it as soon as possible.</li>';
}
$form_html .= '</ul>';
$form['Application Status'] = array(
- '#type' => 'fieldset',
- '#value' => $form_html,
- '#title' => t('Application Form Status'),
- '#attributes' => array('id' => 'app_status'),
+ '#type' => 'fieldset',
+ '#value' => $form_html,
+ '#title' => t('Application Form Status'),
+ '#attributes' => array(
+ 'id' => 'app_status'
+ )
+ );
+ $form['perm_cheque_address'] = array(
+ '#type' => 'fieldset',
+ '#title' => t('Permanent Address'),
+ '#collapsible' => TRUE,
+ '#collapsed' => FALSE,
+ '#attributes' => array(
+ 'id' => 'perm_cheque_address'
+ )
);
- $form['perm_cheque_address'] = array(
- '#type' => 'fieldset',
- '#title' => t('Permanent Address'),
- '#collapsible' => TRUE,
- '#collapsed' => FALSE,
- '#attributes' => array('id' => 'perm_cheque_address'),
- );
$form['temp_cheque_address'] = array(
- '#type' => 'fieldset',
- '#title' => t('Temporary Address'),
- '#collapsible' => TRUE,
- '#collapsed' => FALSE,
- '#attributes' => array('id' => 'temp_cheque_address'),
+ '#type' => 'fieldset',
+ '#title' => t('Temporary Address'),
+ '#collapsible' => TRUE,
+ '#collapsed' => FALSE,
+ '#attributes' => array(
+ 'id' => 'temp_cheque_address'
+ )
);
- $form['perm_cheque_address']['chq_address'] = array(
+ $form['perm_cheque_address']['chq_address'] = array(
'#type' => 'textarea',
'#title' => t('Address'),
'#size' => 35,
- '#default_value' => $form1,
+ '#default_value' => $form1
);
$form['perm_cheque_address']['perm_city'] = array(
'#type' => 'textfield',
'#default_value' => $form9,
'#title' => t('City'),
- '#size' => 35,
+ '#size' => 35
);
$form['perm_cheque_address']['perm_state'] = array(
'#type' => 'textfield',
'#default_value' => $form10,
'#title' => t('State'),
- '#size' => 35,
+ '#size' => 35
);
$form['perm_cheque_address']['perm_pincode'] = array(
'#type' => 'textfield',
'#default_value' => $form11,
'#title' => t('Zip code'),
- '#size' => 35,
+ '#size' => 35
);
$form['temp_cheque_address']['temp_chq_address'] = array(
'#type' => 'textarea',
'#default_value' => $form12,
'#title' => t('Address'),
- '#size' => 35,
+ '#size' => 35
);
$form['temp_cheque_address']['temp_city'] = array(
'#type' => 'textfield',
'#default_value' => $form13,
'#title' => t('City'),
- '#size' => 35,
+ '#size' => 35
);
$form['temp_cheque_address']['temp_state'] = array(
'#type' => 'textfield',
'#default_value' => $form14,
'#title' => t('State'),
- '#size' => 35,
+ '#size' => 35
);
$form['temp_cheque_address']['temp_pincode'] = array(
'#type' => 'textfield',
'#default_value' => $form15,
'#title' => t('Zip code'),
- '#size' => 35,
+ '#size' => 35
);
$form['temp_cheque_address']['same_address'] = array(
'#type' => 'checkbox',
- '#title' => t('Same As Permanent Address'),
+ '#title' => t('Same As Permanent Address')
);
- if($chq_data->commentf)
- {
+ if ($chq_data->commentf)
+ {
$form['commentu'] = array(
- '#type' => 'fieldset',
- '#title' => t('Remarks'),
- '#collapsible' => FALSE,
- '#collapsed' => FALSE,
- '#attributes' => array('id' => 'comment_cheque'),
- );
- $form['commentu']['comment_cheque'] = array(
- '#type' => 'textarea',
- '#size' => 35,
- '#default_value' => $form16,
+ '#type' => 'fieldset',
+ '#title' => t('Remarks'),
+ '#collapsible' => FALSE,
+ '#collapsed' => FALSE,
+ '#attributes' => array(
+ 'id' => 'comment_cheque'
+ )
);
- }
- $form['commentu']['comment_cheque'] ['#attributes']['readonly'] = 'readonly';
+ $form['commentu']['comment_cheque'] = array(
+ '#type' => 'textarea',
+ '#size' => 35,
+ '#default_value' => $form16
+ );
+ } //$chq_data->commentf
+ $form['commentu']['comment_cheque']['#attributes']['readonly'] = 'readonly';
$form['submit'] = array(
- '#type' => 'submit',
+ '#type' => 'submit',
'#value' => t('Update')
- );
- $form['cancel'] = array(
+ );
+ $form['cancel'] = array(
'#type' => 'markup',
- '#value' => l(t('Cancel'), 'manage_proposal/all'),
+ '#value' => l(t('Cancel'), 'manage_proposal/all')
);
- return $form;
+ return $form;
}
function contact_details_submit($form, &$form_state)
{
-
global $user;
$x = $user->uid;
-
/*$query2 = db_query("SELECT * FROM {textbook_companion_proposal} WHERE uid=".$x);
$data2 = db_fetch_object($query2);*/
-
$query = db_select('textbook_companion_proposal');
$query->fields('textbook_companion_proposal');
$query->condition('uid', $x);
$result = $query->execute();
- $data2=$result->fetchObject();
-
-
+ $data2 = $result->fetchObject();
/*$query ="UPDATE {textbook_companion_cheque} SET
alt_mobno = '".$form_state['values']['mobileno2']."' ,
address = '".$form_state['values']['chq_address']."',
@@ -1349,82 +1333,91 @@ function contact_details_submit($form, &$form_state)
address_con = 'Submitted'
WHERE proposal_id = ".$data2->id;
db_query($query);*/
-
$query = db_update('textbook_companion_cheque');
$query->fields(array(
- 'alt_mobno' => $form_state[ values ][ mobileno2 ],
- 'address' => $form_state[ values ][ chq_address ],
- 'perm_city' => $form_state[ values ][ perm_city ],
- 'perm_state' => $form_state[ values ][ perm_state ],
- 'perm_pincode' => $form_state[ values ][ perm_pincode ],
- 'temp_chq_address' => $form_state[ values ][ temp_chq_address ],
- 'temp_city' => $form_state[ values ][ temp_city ],
- 'temp_state' => $form_state[ values ][ temp_state ],
- 'temp_pincode' => $form_state[ values ][ temp_pincode ],
- 'address_con' => 'Submitted',
+ 'alt_mobno' => $form_state[values][mobileno2],
+ 'address' => $form_state[values][chq_address],
+ 'perm_city' => $form_state[values][perm_city],
+ 'perm_state' => $form_state[values][perm_state],
+ 'perm_pincode' => $form_state[values][perm_pincode],
+ 'temp_chq_address' => $form_state[values][temp_chq_address],
+ 'temp_city' => $form_state[values][temp_city],
+ 'temp_state' => $form_state[values][temp_state],
+ 'temp_pincode' => $form_state[values][temp_pincode],
+ 'address_con' => 'Submitted'
));
$query->condition('proposal_id', $data2->id);
$num_updated = $query->execute();
-
drupal_set_message('Contact Details Has Been Updated.....!', 'status');
- drupal_goto('mycontact', array('msg' => 0 ), $fragment = NULL, $http_response_code = 302);
+ drupal_goto('mycontact', array(
+ 'msg' => 0
+ ), $fragment = NULL, $http_response_code = 302);
}
function copy_address()
{
-
- alert("Hello");
- $form['temp_cheque_address']['temp_chq_address'] = array(
- '#type' => 'textarea',
- '#default_value' => $form['values']['chq_address'],
- '#title' => t('Address Street 1'),
- );
-
- $form['temp_cheque_address']['temp_city'] = array(
- '#type' => 'textfield',
- '#default_value' => $form['values']['perm_city'],
- '#title' => t('City'),
- '#size' => 35,
- );
- $form['temp_cheque_address']['temp_state'] = array(
- '#type' => 'textfield',
- '#default_value' => $form['values']['perm_state'],
- '#title' => t('State'),
- '#size' => 35,
- );
- $form['temp_cheque_address']['temp_pincode'] = array(
- '#type' => 'textfield',
- '#default_value' => $form['values']['perm_pincode'],
- '#title' => t('Zip code'),
- '#size' => 35,
- );
+ alert("Hello");
+ $form['temp_cheque_address']['temp_chq_address'] = array(
+ '#type' => 'textarea',
+ '#default_value' => $form['values']['chq_address'],
+ '#title' => t('Address Street 1')
+ );
+ $form['temp_cheque_address']['temp_city'] = array(
+ '#type' => 'textfield',
+ '#default_value' => $form['values']['perm_city'],
+ '#title' => t('City'),
+ '#size' => 35
+ );
+ $form['temp_cheque_address']['temp_state'] = array(
+ '#type' => 'textfield',
+ '#default_value' => $form['values']['perm_state'],
+ '#title' => t('State'),
+ '#size' => 35
+ );
+ $form['temp_cheque_address']['temp_pincode'] = array(
+ '#type' => 'textfield',
+ '#default_value' => $form['values']['perm_pincode'],
+ '#title' => t('Zip code'),
+ '#size' => 35
+ );
}
-
function cheque_report_form()
{
/*$search_qx = db_query("SELECT * FROM textbook_companion_proposal p,textbook_companion_cheque c WHERE c.address_con = 'Submitted' AND (p.id = c.proposal_id)");*/
-
- $query = db_select('textbook_companion_proposal', 'p');
- $query->join('textbook_companion_cheque','c','p.id = c.proposal_id');
- $query->fields('p',array('textbook_companion_proposal'));
- $query->fields('c',array('textbook_companion_cheque'));
- $query->condition('c.address_con', 'Submitted');
- $search_qx = $query->execute();
-
+ $query = db_select('textbook_companion_proposal', 'p');
+ $query->join('textbook_companion_cheque', 'c', 'p.id = c.proposal_id');
+ $query->fields('p', array(
+ 'textbook_companion_proposal'
+ ));
+ $query->fields('c', array(
+ 'textbook_companion_cheque'
+ ));
+ $query->condition('c.address_con', 'Submitted');
+ $search_qx = $query->execute();
while ($search_datax = $search_qx->fetchObject())
{
- $result = array($search_datax->full_name,$search_datax->address_con,$search_datax->cheque_no,$search_datax->cheque_dispatch_date);
- }
- if (!$result) die('Couldn\'t fetch records');
+ $result = array(
+ $search_datax->full_name,
+ $search_datax->address_con,
+ $search_datax->cheque_no,
+ $search_datax->cheque_dispatch_date
+ );
+ } //$search_datax = $search_qx->fetchObject()
+ if (!$result)
+ die('Couldn\'t fetch records');
$num_fields = count($result);
$headers = array();
- for ($i = 0; $i < $num_fields; $i++)
+ for ($i = 0; $i < $num_fields; $i++)
{
- $headers[] = mysql_field_name($result , $i);
- }
-
+ $headers[] = mysql_field_name($result, $i);
+ } //$i = 0; $i < $num_fields; $i++
$row = array();
$fp = fopen('php://output', 'w');
- $search_header = array('Name Of The Student', 'Application Form Status', 'Cheque No', 'Cheque Clearance Date');
+ $search_header = array(
+ 'Name Of The Student',
+ 'Application Form Status',
+ 'Cheque No',
+ 'Cheque Clearance Date'
+ );
fputcsv($fp, $search_header);
if ($fp && $result)
{
@@ -1433,11 +1426,11 @@ function cheque_report_form()
header('Pragma: no-cache');
header('Expires: 0');
fputcsv($fp, $headers);
- while ($row = mysql_fetch_row($result))
+ while ($row = mysql_fetch_row($result))
{
fputcsv($fp, array_values($row));
- }
+ } //$row = mysql_fetch_row($result)
die;
- }
+ } //$fp && $result
}
-?>
+
generated by cgit (git 2.34.1) at 2025-03-13 05:21:50 +0000