Location: PHPKode > projects > MembersGear > membersgear/admin/admin_thankyoupage_tracking_v.php
    require_once "../config/config.php";   
    require_once INCLUDE_DIR."/product_class.php";
    require_once INCLUDE_DIR."/users_class.php";  
    $users=new users_class();
    if($users->IsAdminhavePermission($_SESSION[SESSION_PREFIX.'Admin_UserID'],'Can view products and thankyou page tracking')==false)
    $loProductClass = new product_class();
        $query = 'SELECT pp.name, ppr.id FROM '.TABLE_PREFIX.'products pp 
             join '.TABLE_PREFIX.'productpaymentoptions ppr on ppr.productid=pp.id
             WHERE pp.id='.$_GET['productid'];
        $laQueryResult = $loProductClass->View($query,null,null);
//   $laQueryResult[0]['id'];
  $query = 'SELECT id,name FROM '.TABLE_PREFIX.'products WHERE IsDeleted=0';
  $ProductData = $loProductClass->View($query,null,null);
            echo "<div id=\"content\" class=\"setdiv\"> ";
                echo "<div class=\"succmsg\" style=\"width:335px\">$lsmsg</div>";
            echo "<div id=\"full-contentdiv\">";
            echo "<div class=\"righttop\">";
            echo "<h2 align=\"center\">";
            if($laQueryResult[0]['name'] != '')
                echo "Thankyou Page Tracking Code Of Product \"".$laQueryResult[0]['name']."\"";
            echo "</h2>";
            echo "</div>";
            echo "<div class=\"whole-page clear\">";
                    <div class='formformat' style='margin-bottom:5px;text-align:center !important;'>
                          <form action="" method="get" name="frmProduct" id="frmProduct">
                                 <table border='0' cellspacing='0' cellpadding='0' align='center' style="">
                                             <td class='right-side-text' style="width:160px;">
                                                    <label>Please Select Product :</label>
                                             <td class='left-side-text' style='width:auto;padding-right:10px;'>
                                                    <select id='productid' class='selectcss' style='width:auto' name='productid' onchange="this.form.submit();">
                                                            <option value="0" selected="selected">Select...</option>
                                                                foreach($ProductData as $key=>$value)
                                                                     if($ProductData[$key]['id'] == $_GET['productid'])
                                                                        echo '<option value="'.$ProductData[$key]['id'].'" selected>'.$ProductData[$key]['name'].'</option>';
                                                                        echo '<option value="'.$ProductData[$key]['id'].'">'.$ProductData[$key]['name'].'</option>';
            * Updated By Jayesh : for display character based paging
            echo "<div class='controlDiv'>";
            echo PrintABCDPaging();
            echo "</div>";
             if(isset($_GET['letter']) and $_GET['letter'] != 'all')
                    $lsSearchLetter = $_GET['letter'];
                    $lsSearchLetter = '';   
              if(isset($_GET['productid']) and $_GET['productid'] != 0)
                    $sql = 'SELECT * FROM '.TABLE_PREFIX.'thankyoupage_tracking WHERE productpaymentoptionid ='.$laQueryResult[0]['id'].' AND trackingname LIKE "'.$lsSearchLetter.'%";';
                    $sql = 'SELECT * FROM '.TABLE_PREFIX.'thankyoupage_tracking WHERE productpaymentoptionid =0 AND trackingname LIKE "'.$lsSearchLetter.'%";';
                //echo $sql;
//                die;
                # execute the sql query

                # creates a new phpSortColumn object for ID´s 
                //$col_0 = new phpSortColumn("id", "ID");
                #creates a new phpSortcolunm objects for name
                $col_0 = new phpSortColumn("trackingname", "Tracking Name");
                $col_1 = new phpSortColumn("trackingby", "Tracking By");
                # creates a new phpSortColumn object for Tile
                # add the columns to an array 
                $columns = array(0=>$col_0, 1=>$col_1);

                # create a new phpSortable object with the abstracted db object
                # and the array of column object
                $sortable = new phpSortable($db, $columns);

                # define the table format: cellpadding, cellspacing, border
                $sortable->setTableFormat ("2", "2", "0");

                # define the table title
                $sortable->tableTitle = "";

                # Encrypt Edit and Delete Link
                $sortable->encryptlink = false;
                # define the link for edit of entries
                $sortable->editLink = "admin_thankyoupage_tracking_m.php?action=edit";

                # open the edit page in a new window
                //$sortable->editTarget = "_blank";

                # window format for the edit page
               // $sortable->editWindowFormat = "'width=300,height=400'";

                # define the link for delete of entries
                if(isset($_GET) && !empty($_GET))
                     foreach($_GET as $keyname => $value) {
                $sortable->deleteLink = "admin_thankyoupage_tracking_m.php?action=delete&productid=".$_GET['productid'].$quest;

                if(isset($laQueryResult[0]['id']) and $laQueryResult[0]['id'] !='')
                    # define the link for add new entries
                    $sortable->addLink = "admin_thankyoupage_tracking_m.php?paymentoptionid=".$laQueryResult[0]['id'];
                if($users->IsAdminhavePermission($_SESSION[SESSION_PREFIX.'Admin_UserID'],'Can manage products and thankyou page tracking')==false)
                # define the hint to be displyed over the add button
                $sortable->addText = "Add Tracking Code";

                # define the key name to be attached to links
                $sortable->urlKeyName = "id";

                # define the column name of to be attached to links as key value
                $sortable->tableKeyName = "id";

                # define the prompt message to be diplayed on clicking the edit button            
                //$sortable->editPromptMsg = "Are you sure you want to edit this affiliate?";

                # define the prompt message to be diplayed on clicking the delete button
                $sortable->deletePromptMsg = "Are you sure you want to delete this tracking code?";

                # define the message to be diplayed if there are no results found
                $sortable->emptyMsg = "No tracking code found for the thank you page of the selected product. Please select another product from the drop down list given above.";

                #define the deafult row number to be displayed
                $sortable->defaultRowsNum = "10";

                #define the path for the css file
                $sortable->cssFilePath = ADMIN_CSS_DIR."/phpSortable.css";

                #define the path for of the images directory
                $sortable->imgFilePath = ADMIN_IMAGE_DIR."/phpgrid/";

                # print the table            
            echo "</div>";
            echo "</div>";
            echo "</div>";

            //For display footer.php

Return current item: MembersGear