/[drupal]/contributions/modules/storm/storminvoice/storminvoice.admin.inc
ViewVC logotype

Diff of /contributions/modules/storm/storminvoice/storminvoice.admin.inc

Parent Directory Parent Directory | Revision Log Revision Log | View Revision Graph Revision Graph | View Patch Patch

revision 1.2.4.3, Wed Jul 23 19:37:49 2008 UTC revision 1.2.4.4, Mon Sep 1 08:50:21 2008 UTC
# Line 1  Line 1 
1  <?php  <?php
2  // $Id: storminvoice.admin.inc,v 1.2.4.2 2008/07/23 07:10:37 robertogerola Exp $  // $Id: storminvoice.admin.inc,v 1.2.4.3 2008/07/23 19:37:49 robertogerola Exp $
3    
4  /**  /**
5   * @file   * @file
# Line 31  function storminvoice_list() { Line 31  function storminvoice_list() {
31        'data' => ' ',        'data' => ' ',
32      ),      ),
33      array(      array(
34        'data' => t('Number'),        'data' => storm_t('Number'),
35        'field' => 'sin.number',        'field' => 'sin.number',
36        'sort' => 'asc',        'sort' => 'asc',
37        'nowrap' => 'nowrap',        'nowrap' => 'nowrap',
38      ),      ),
39      array(      array(
40        'data' => t('Organization'),        'data' => storm_t('Organization'),
41        'field' => 'sin.organization_title',        'field' => 'sin.organization_title',
42      ),      ),
43      array(      array(
44        'data' => t('Project'),        'data' => storm_t('Project'),
45        'field' => 'sin.project_title',        'field' => 'sin.project_title',
46      ),      ),
47      array(      array(
48        'data' => t('Description'),        'data' => storm_t('Description'),
49        'field' => 'n.title',        'field' => 'n.title',
50      ),      ),
51      array(      array(
52        'data' => t('Req. date'),        'data' => storm_t('Req. date'),
53        'field' => 'sin.requestdate',        'field' => 'sin.requestdate',
54      ),      ),
55      array(      array(
56        'data' => t('Total'),        'data' => storm_t('Total'),
57      ),      ),
58      array(      array(
59        'data' => storm_icon_add_node($i, $_GET),        'data' => storm_icon_add_node($i, $_GET),
# Line 63  function storminvoice_list() { Line 63  function storminvoice_list() {
63    
64    $s  = "SELECT n.title, sin.* FROM {node} AS n INNER JOIN {storminvoice} AS sin ON n.nid=sin.nid WHERE n.status=1 AND n.type='storminvoice' ";    $s  = "SELECT n.title, sin.* FROM {node} AS n INNER JOIN {storminvoice} AS sin ON n.nid=sin.nid WHERE n.status=1 AND n.type='storminvoice' ";
65    
66    $s_totals_topay = "SELECT SUM(amount) amount, SUM(vat) vat, SUM(total) total FROM {storminvoice} sin    $s_totals_topay = "SELECT SUM(amount) amount, SUM(tax) tax, SUM(total) total FROM {storminvoice} sin
67    INNER JOIN {node} n ON n.nid=sin.nid WHERE n.status=1 AND n.type='storminvoice' AND sin.paymentdate=0";    INNER JOIN {node} n ON n.nid=sin.nid WHERE n.status=1 AND n.type='storminvoice' AND sin.paymentdate=0";
68    
69    $s_totals_paid = "SELECT SUM(amount) amount, SUM(vat) vat, SUM(total) total FROM {storminvoice} sin    $s_totals_paid = "SELECT SUM(amount) amount, SUM(tax) tax, SUM(total) total FROM {storminvoice} sin
70    INNER JOIN {node} n ON n.nid=sin.nid WHERE n.status=1 AND n.type='storminvoice' AND sin.paymentdate<>0";    INNER JOIN {node} n ON n.nid=sin.nid WHERE n.status=1 AND n.type='storminvoice' AND sin.paymentdate<>0";
71    
72    $s_totals = "SELECT SUM(amount) amount, SUM(vat) vat, SUM(total) total FROM {storminvoice} sin    $s_totals = "SELECT SUM(amount) amount, SUM(tax) tax, SUM(total) total FROM {storminvoice} sin
73    INNER JOIN {node} n ON n.nid=sin.nid WHERE n.status=1 AND n.type='storminvoice'";    INNER JOIN {node} n ON n.nid=sin.nid WHERE n.status=1 AND n.type='storminvoice'";
74    
75    if ($_SESSION['storminvoice_list_filter']['organization_nid']) {    if ($_SESSION['storminvoice_list_filter']['organization_nid']) {
# Line 178  function storminvoice_list_filter() { Line 178  function storminvoice_list_filter() {
178    
179    $form['filter'] = array(    $form['filter'] = array(
180          '#type' => 'fieldset',          '#type' => 'fieldset',
181          '#title' => t('Search'),          '#title' => storm_t('Search'),
182          '#collapsible' => TRUE,          '#collapsible' => TRUE,
183          '#collapsed' => TRUE,          '#collapsed' => TRUE,
184    );    );
# Line 197  function storminvoice_list_filter() { Line 197  function storminvoice_list_filter() {
197    while ($organization = db_fetch_object($r)) {    while ($organization = db_fetch_object($r)) {
198      $organizations[$organization->nid] = $organization->title;      $organizations[$organization->nid] = $organization->title;
199    }    }
200    $organizations = array(0 => t('All')) + $organizations;    $organizations = array(0 => storm_t('All')) + $organizations;
201    $form['filter']['group1']['organization_nid'] = array(    $form['filter']['group1']['organization_nid'] = array(
202      '#type' => 'select',      '#type' => 'select',
203      '#title' => t('Organization'),      '#title' => storm_t('Organization'),
204      '#default_value' => $organization_nid,      '#default_value' => $organization_nid,
205      '#options' => $organizations,      '#options' => $organizations,
206      '#attributes' => array('onchange' => "stormproject_organization_projects(this, 'edit-project-nid', true, 'All')"),      '#attributes' => array('onchange' => "stormproject_organization_projects(this, 'edit-project-nid', true, 'All')"),
# Line 215  function storminvoice_list_filter() { Line 215  function storminvoice_list_filter() {
215    while ($project = db_fetch_array($r)) {    while ($project = db_fetch_array($r)) {
216      $projects[$project['nid']] = $project['title'];      $projects[$project['nid']] = $project['title'];
217    }    }
218    $projects = array(0 => t('All')) + $projects;    $projects = array(0 => storm_t('All')) + $projects;
219    $form['filter']['group1']['project_nid'] = array(    $form['filter']['group1']['project_nid'] = array(
220      '#type' => 'select',      '#type' => 'select',
221      '#title' => t('Project'),      '#title' => storm_t('Project'),
222      '#default_value' => $project_nid,      '#default_value' => $project_nid,
223      '#options' => $projects,      '#options' => $projects,
224      '#process' => array('storm_dependent_select_process'),      '#process' => array('storm_dependent_select_process'),
# Line 232  function storminvoice_list_filter() { Line 232  function storminvoice_list_filter() {
232    
233    $form['filter']['group2']['reqdatefrom'] = array(    $form['filter']['group2']['reqdatefrom'] = array(
234      '#type' => 'date',      '#type' => 'date',
235      '#title' => t('Req. date from'),      '#title' => storm_t('Req. date from'),
236      '#default_value' => $reqdatefrom,      '#default_value' => $reqdatefrom,
237    );    );
238    
239    $form['filter']['group2']['reqdateto'] = array(    $form['filter']['group2']['reqdateto'] = array(
240      '#type' => 'date',      '#type' => 'date',
241      '#title' => t('Req. date to'),      '#title' => storm_t('Req. date to'),
242      '#default_value' => $reqdateto,      '#default_value' => $reqdateto,
243    );    );
244    
245    $form['filter']['status'] = array(    $form['filter']['status'] = array(
246      '#type' => 'select',      '#type' => 'select',
247      '#title' => t('Status'),      '#title' => storm_t('Status'),
248      '#options' => array('-' => t('all'), 'to pay' => t('to pay'), 'paid' => t('paid'), 'overdue' => t('overdue')),      '#options' => array('-' => storm_t('all'), 'to pay' => storm_t('to pay'), 'paid' => storm_t('paid'), 'overdue' => storm_t('overdue')),
249      '#default_value' => $status,      '#default_value' => $status,
250    );    );
251    
# Line 256  function storminvoice_list_filter() { Line 256  function storminvoice_list_filter() {
256    
257    $form['filter']['group3']['submit'] = array(    $form['filter']['group3']['submit'] = array(
258      '#type' => 'submit',      '#type' => 'submit',
259      '#value' => t('Filter'),      '#value' => storm_t('Filter'),
260      '#submit' => array('storminvoice_list_filter_filter'),      '#submit' => array('storminvoice_list_filter_filter'),
261    );    );
262    
263    $form['filter']['group3']['reset'] = array(    $form['filter']['group3']['reset'] = array(
264      '#type' => 'submit',      '#type' => 'submit',
265      '#value' => t('Reset'),      '#value' => storm_t('Reset'),
266      '#submit' => array('storminvoice_list_filter_reset'),      '#submit' => array('storminvoice_list_filter_reset'),
267    );    );
268    
269    $form['filter']['group3']['itemsperpage'] = array(    $form['filter']['group3']['itemsperpage'] = array(
270      '#type' => 'textfield',      '#type' => 'textfield',
271      '#title' => t('Items'),      '#title' => storm_t('Items'),
272      '#size' => 10,      '#size' => 10,
273      '#default_value' => $itemsperpage,      '#default_value' => $itemsperpage,
274      '#prefix' => '<div class="container-inline">',      '#prefix' => '<div class="container-inline">',
Legend:
Removed from v.1.2.4.3  
changed lines
  Added in v.1.2.4.4
  ViewVC Help
Powered by ViewVC 1.1.2