@@ 623-636 (lines=14) @@ | ||
620 | ||
621 | switch ($column['column_type']) |
|
622 | { |
|
623 | case COLUMN_TYPE_ID: |
|
624 | ||
625 | array_push($clause_select, 'r.template_prefix'); |
|
626 | ||
627 | if ($i == $sort) |
|
628 | { |
|
629 | array_push($clause_order, 'record_id asc'); |
|
630 | } |
|
631 | elseif (-$i == $sort) |
|
632 | { |
|
633 | array_push($clause_order, 'record_id desc'); |
|
634 | } |
|
635 | ||
636 | break; |
|
637 | ||
638 | case COLUMN_TYPE_STATE_ABBR: |
|
639 | ||
@@ 638-651 (lines=14) @@ | ||
635 | ||
636 | break; |
|
637 | ||
638 | case COLUMN_TYPE_STATE_ABBR: |
|
639 | ||
640 | array_push($clause_select, 'r.state_abbr'); |
|
641 | ||
642 | if ($i == $sort) |
|
643 | { |
|
644 | array_push($clause_order, 'state_abbr asc'); |
|
645 | } |
|
646 | elseif (-$i == $sort) |
|
647 | { |
|
648 | array_push($clause_order, 'state_abbr desc'); |
|
649 | } |
|
650 | ||
651 | break; |
|
652 | ||
653 | case COLUMN_TYPE_PROJECT: |
|
654 | ||
@@ 653-666 (lines=14) @@ | ||
650 | ||
651 | break; |
|
652 | ||
653 | case COLUMN_TYPE_PROJECT: |
|
654 | ||
655 | array_push($clause_select, 'r.project_name'); |
|
656 | ||
657 | if ($i == $sort) |
|
658 | { |
|
659 | array_push($clause_order, 'project_name asc'); |
|
660 | } |
|
661 | elseif (-$i == $sort) |
|
662 | { |
|
663 | array_push($clause_order, 'project_name desc'); |
|
664 | } |
|
665 | ||
666 | break; |
|
667 | ||
668 | case COLUMN_TYPE_SUBJECT: |
|
669 | ||
@@ 668-681 (lines=14) @@ | ||
665 | ||
666 | break; |
|
667 | ||
668 | case COLUMN_TYPE_SUBJECT: |
|
669 | ||
670 | array_push($clause_select, 'r.subject'); |
|
671 | ||
672 | if ($i == $sort) |
|
673 | { |
|
674 | array_push($clause_order, 'subject asc'); |
|
675 | } |
|
676 | elseif (-$i == $sort) |
|
677 | { |
|
678 | array_push($clause_order, 'subject desc'); |
|
679 | } |
|
680 | ||
681 | break; |
|
682 | ||
683 | case COLUMN_TYPE_AUTHOR: |
|
684 | ||
@@ 683-697 (lines=15) @@ | ||
680 | ||
681 | break; |
|
682 | ||
683 | case COLUMN_TYPE_AUTHOR: |
|
684 | ||
685 | array_push($clause_select, 'ac.fullname as author_fullname'); |
|
686 | array_push($clause_join, 'left outer join tbl_accounts ac on ac.account_id = r.creator_id'); |
|
687 | ||
688 | if ($i == $sort) |
|
689 | { |
|
690 | array_push($clause_order, 'author_fullname asc'); |
|
691 | } |
|
692 | elseif (-$i == $sort) |
|
693 | { |
|
694 | array_push($clause_order, 'author_fullname desc'); |
|
695 | } |
|
696 | ||
697 | break; |
|
698 | ||
699 | case COLUMN_TYPE_RESPONSIBLE: |
|
700 | ||
@@ 699-713 (lines=15) @@ | ||
696 | ||
697 | break; |
|
698 | ||
699 | case COLUMN_TYPE_RESPONSIBLE: |
|
700 | ||
701 | array_push($clause_select, 'ar.fullname as responsible_fullname'); |
|
702 | array_push($clause_join, 'left outer join tbl_accounts ar on ar.account_id = r.responsible_id'); |
|
703 | ||
704 | if ($i == $sort) |
|
705 | { |
|
706 | array_push($clause_order, 'responsible_fullname asc'); |
|
707 | } |
|
708 | elseif (-$i == $sort) |
|
709 | { |
|
710 | array_push($clause_order, 'responsible_fullname desc'); |
|
711 | } |
|
712 | ||
713 | break; |
|
714 | ||
715 | case COLUMN_TYPE_LAST_EVENT: |
|
716 | ||
@@ 715-726 (lines=12) @@ | ||
712 | ||
713 | break; |
|
714 | ||
715 | case COLUMN_TYPE_LAST_EVENT: |
|
716 | ||
717 | if ($i == $sort) |
|
718 | { |
|
719 | array_push($clause_order, 'change_time asc'); |
|
720 | } |
|
721 | elseif (-$i == $sort) |
|
722 | { |
|
723 | array_push($clause_order, 'change_time desc'); |
|
724 | } |
|
725 | ||
726 | break; |
|
727 | ||
728 | case COLUMN_TYPE_AGE: |
|
729 | ||
@@ 746-759 (lines=14) @@ | ||
743 | ||
744 | break; |
|
745 | ||
746 | case COLUMN_TYPE_CREATION_DATE: |
|
747 | ||
748 | array_push($clause_select, 'r.creation_time'); |
|
749 | ||
750 | if ($i == $sort) |
|
751 | { |
|
752 | array_push($clause_order, 'creation_time asc'); |
|
753 | } |
|
754 | elseif (-$i == $sort) |
|
755 | { |
|
756 | array_push($clause_order, 'creation_time desc'); |
|
757 | } |
|
758 | ||
759 | break; |
|
760 | ||
761 | case COLUMN_TYPE_TEMPLATE: |
|
762 | ||
@@ 761-774 (lines=14) @@ | ||
758 | ||
759 | break; |
|
760 | ||
761 | case COLUMN_TYPE_TEMPLATE: |
|
762 | ||
763 | array_push($clause_select, 'r.template_name'); |
|
764 | ||
765 | if ($i == $sort) |
|
766 | { |
|
767 | array_push($clause_order, 'template_name asc'); |
|
768 | } |
|
769 | elseif (-$i == $sort) |
|
770 | { |
|
771 | array_push($clause_order, 'template_name desc'); |
|
772 | } |
|
773 | ||
774 | break; |
|
775 | ||
776 | case COLUMN_TYPE_STATE_NAME: |
|
777 | ||
@@ 776-789 (lines=14) @@ | ||
773 | ||
774 | break; |
|
775 | ||
776 | case COLUMN_TYPE_STATE_NAME: |
|
777 | ||
778 | array_push($clause_select, 'r.state_name'); |
|
779 | ||
780 | if ($i == $sort) |
|
781 | { |
|
782 | array_push($clause_order, 'state_name asc'); |
|
783 | } |
|
784 | elseif (-$i == $sort) |
|
785 | { |
|
786 | array_push($clause_order, 'state_name desc'); |
|
787 | } |
|
788 | ||
789 | break; |
|
790 | ||
791 | case COLUMN_TYPE_LAST_STATE: |
|
792 |