API tools faq
paste
Guest User

Radio button; nested php switch

a guest
Jan 4th, 2020
268
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 32.94 KB | None | 0 0
raw download clone embed print report
  1. <label style="font-size:20px;"><strong>Filter Result:</strong></label>
  2.   <?php
  3.  $state=$_SESSION['state'];
  4.  $condition=$_SESSION['condition'];
  5.  echo "<label style='color:red;'>"." "."State:"." ".$state." "."-"." "."Condition:"." ".$condition."</label>";
  6.   ?>
  7. <br>
  8. <div class="filters">
  9. <?php
  10. }
  11. ?>
  12. <script>
  13.       function handleRadio(data){
  14.        window.location="sessionstate.php?state="+data.value;
  15.       }
  16.       function handleRadiocond(data2){
  17.         window.location="sessioncondition.php?condition="+data2.value;
  18.       }
  19. </script>
  20.  
  21. <span style="margin-left:35px;">STATE</span><br><br>
  22. <form>
  23. <input type="radio" name="state" id="state" value="allstate" onchange="javascript:handleRadio(this)" <?php echo $state==='allstate' ? 'checked' : '' ?>> All State <br>
  24. <input type="radio" name="state" id="new" value="new" onchange="javascript:handleRadio(this)" <?php echo $state==='new' ? 'checked' : '' ?>> New EQ <br>
  25. <input type="radio" name="state" id="old" value="old" onchange="javascript:handleRadio(this)" <?php echo $state==='old' ? 'checked' : '' ?>> Old EQ <br>
  26. <input type="radio" name="state" id="unknown" value="Unknown state" onchange="javascript:handleRadio(this)" <?php echo $state==='Unknown state' ? 'checked' : '' ?>> Unknown State <br>
  27. </form>
  28.                                           <!--    -->
  29. <form action="" method="POST" class="filters2">
  30. <span style="margin-left:150px;">CONDITION</span><br><br>
  31. <input type="radio" name="condition" value="allcondition" onchange="javascript:handleRadiocond(this)" <?php echo $condition==='allcondition' ? 'checked' : '' ?>> All Condition <br>
  32. <input type="radio" name="condition" value="working" onchange="javascript:handleRadiocond(this)" <?php echo $condition==='working' ? 'checked' : '' ?>> Working EQ (1 & 2):
  33. <?php
  34. switch($state){
  35.  case "allstate":
  36.  switch($condition){
  37.    case "allcondition":
  38.    case "working":
  39.    case "Available/Unassigned":
  40.    case "assigned":
  41.    if($condition=='working' || $condition=='allcondition'){
  42.      $sql3="SELECT *FROM eq_inv WHERE eq_condition IN ('Available/Unassigned','assigned')";
  43.    }
  44.    if($condition=='Available/Unassigned' || $condition=='assigned'){
  45.      $sql3="SELECT *FROM eq_inv WHERE eq_condition='$condition'";
  46.    }
  47.    break;
  48.    //so that Working will be zero if these are checked
  49.    case "repair":
  50.    case "missingeq":
  51.    case "missingpart":
  52.    case "defective":
  53.    case "refurbished":
  54.    case "Unknown condition":
  55.    $sql3="SELECT *FROM eq_inv WHERE eq_condition='none'";
  56.  }
  57.  //Values are allstate and allcondition, Available/Unassigned,working, assigned, etc.
  58.  break;
  59.  case "new":
  60.  switch($condition){
  61.    case "allcondition":
  62.    case "working":
  63.    case "Available/Unassigned":
  64.    case "assigned":
  65.    if($condition=='working' || $condition=='allcondition'){
  66.        $sql3 = "SELECT *FROM eq_inv WHERE eq_condition IN ('Available/Unassigned','assigned') AND eq_state='new'";
  67.    }
  68.    if($condition=='Available/Unassigned' || $condition=='assigned'){
  69.      $sql3 = "SELECT *FROM eq_inv WHERE eq_condition='$condition' AND eq_state='new'";
  70.    }
  71.    break;
  72.     //so that Working will be zero if these are checked
  73.    case "repair":
  74.    case "missingeq":
  75.    case "missingpart":
  76.    case "defective":
  77.    case "refurbished":
  78.    case "Unknown condition":
  79.    $sql3="SELECT *FROM eq_inv WHERE eq_condition='none'";
  80.  }
  81. //Values are new and allcondition, Available/Unassigned,working, assigned, etc.
  82.  break;
  83.  case "old":
  84.  switch($condition){
  85.    case "allcondition":
  86.    case "working":
  87.    case "Available/Unassigned":
  88.    case "assigned":
  89.    if($condition=='working' || $condition=='allcondition'){
  90.        $sql3 = "SELECT *FROM eq_inv WHERE eq_condition IN ('Available/Unassigned','assigned') AND eq_state='old'";
  91.    }
  92.    if($condition=='Available/Unassigned' || $condition=='assigned'){
  93.      $sql3 = "SELECT *FROM eq_inv WHERE eq_condition='$condition' AND eq_state='old'";
  94.    }
  95.    break;
  96.    //so that Working will be zero if these are checked
  97.    case "repair":
  98.    case "missingeq":
  99.    case "missingpart":
  100.    case "defective":
  101.    case "refurbished":
  102.    case "Unknown condition":
  103.    $sql3="SELECT *FROM eq_inv WHERE eq_condition='none'";
  104.  }
  105. //Values are old and allcondition, Available/Unassigned,working, assigned, etc.
  106.  break;
  107.  case "Unknown state":
  108.  switch($condition){
  109.    case "allcondition":
  110.    case "working":
  111.    case "Available/Unassigned":
  112.    case "assigned":
  113.    if($condition=='working' || $condition=='allcondition'){
  114.        $sql3 = "SELECT *FROM eq_inv WHERE eq_condition IN ('Available/Unassigned','assigned') AND eq_state='Unknown state'";
  115.    }
  116.    if($condition=='Available/Unassigned' || $condition=='assigned'){
  117.      $sql3 = "SELECT *FROM eq_inv WHERE eq_condition='$condition' AND eq_state='Unknown state'";
  118.    }
  119.    break;
  120.    //so that Working will be zero if these are checked
  121.    case "repair":
  122.    case "missingeq":
  123.    case "missingpart":
  124.    case "defective":
  125.    case "refurbished":
  126.    case "Unknown condition":
  127.    $sql3="SELECT *FROM eq_inv WHERE eq_condition='none'";
  128.  }
  129. //Values are Unknown state and allcondition, Available/Unassigned,working,assigned,etc.
  130.  break;
  131. }
  132. $result3=mysqli_query($conn,$sql3);
  133. $countavail=mysqli_num_rows($result3);
  134. echo "<label style='color:red;'><strong>".$countavail."</strong></label>";
  135. ?>
  136. <br>
  137.  
  138. <input type="radio" name="condition" value="Available/Unassigned" onchange="javascript:handleRadiocond(this)" <?php echo $condition==='Available/Unassigned' ? 'checked' : '' ?>>(1)Available/Unassigned EQ:
  139.                        <?php
  140.                        switch($state){
  141.                          case "allstate":
  142.                          switch($condition){
  143.                            case "allcondition":
  144.                            case "Available/Unassigned":
  145.                            case "working":
  146.                              $sql3="SELECT *FROM eq_inv WHERE eq_condition='Available/Unassigned'";
  147.                              break;
  148.                                         //so that Available/Unassigned will be zero if these are checked
  149.                            case "assigned":
  150.                            case "repair":
  151.                            case "missingpart":
  152.                            case "missingeq":
  153.                            case "defective":
  154.                            case "refurbished":
  155.                            case "Unknown condition":
  156.                              $sql3="SELECT *FROM eq_inv WHERE eq_condition='none'";
  157.                          }
  158.                                //Values are allstate and allcondition, Available/Unassigned,etc.
  159.                          break;
  160.                          case "new":
  161.                          switch($condition){
  162.                            case "allcondition":
  163.                            case "Available/Unassigned":
  164.                            case "working":
  165.                            $sql3 = "SELECT *FROM eq_inv WHERE eq_condition='Available/Unassigned' AND eq_state='new'";
  166.                          break;
  167.                                     //so that Available/Unassigned will be zero if these are checked
  168.                            case "assigned":
  169.                            case "repair":
  170.                            case "missingpart":
  171.                            case "missingeq":
  172.                            case "defective":
  173.                            case "refurbished":
  174.                            case "Unknown condition":
  175.                            $sql3="SELECT *FROM eq_inv WHERE eq_condition='none'";
  176.                        }
  177.                              //Values are new and allcondition, Available/Unassigned,etc.
  178.                        break;
  179.                          case "old":
  180.                          switch($condition){
  181.                            case "allcondition":
  182.                            case "Available/Unassigned":
  183.                            case "working":
  184.                          $sql3 = "SELECT *FROM eq_inv WHERE eq_condition='Available/Unassigned' AND eq_state='old'";
  185.                          break;
  186.                                     //so that Available/Unassigned will be zero if these are checked
  187.                            case "assigned":
  188.                            case "repair":
  189.                            case "missingpart":
  190.                            case "missingeq":
  191.                            case "defective":
  192.                            case "refurbished":
  193.                            case "Unknown condition":
  194.                            $sql3="SELECT *FROM eq_inv WHERE eq_condition='none'";
  195.                        }
  196.                              //Values are old and allcondition, Available/Unassigned, etc.
  197.                        break;
  198.                          case "Unknown state":
  199.                          switch($condition){
  200.                            case "allcondition":
  201.                            case "Available/Unassigned":
  202.                            case "working":
  203.                          $sql3 = "SELECT *FROM eq_inv WHERE eq_condition='Available/Unassigned' AND eq_state='Unknown state'";
  204.                          break;
  205.                                     //so that Available/Unassigned will be zero if these are checked
  206.                            case "assigned":
  207.                            case "repair":
  208.                            case "missingpart":
  209.                            case "missingeq":
  210.                            case "defective":
  211.                            case "refurbished":
  212.                            case "Unknown condition":
  213.                            $sql3="SELECT *FROM eq_inv WHERE eq_condition='none'";
  214.                        }
  215.                        //Values are Unknown state and allcondition, Available/Unassigned,etc.
  216.                        }
  217.                $result3=mysqli_query($conn,$sql3);
  218.                $countavail=mysqli_num_rows($result3);
  219.                echo "<label style='color:red;'><strong>".$countavail."</strong></label>";
  220.                ?>
  221.                <br>
  222. <input type="radio" name="condition" value="assigned" onchange="javascript:handleRadiocond(this)" <?php echo $condition==='assigned' ? 'checked' : '' ?>>(2)Assigned EQ:
  223.                        <?php //EDIT THE COMMENTS
  224.                        switch($state){
  225.                          case "allstate":
  226.                          switch($condition){
  227.                            case "allcondition":
  228.                            case "assigned":
  229.                            case "working":
  230.                            $sql3="SELECT *FROM eq_inv WHERE eq_condition='assigned'";
  231.                            break;
  232.                            //so that assigned will be zero if these are checked
  233.                            case "Available/Unassigned":
  234.                            case "repair":
  235.                            case "missingpart":
  236.                            case "missingeq":
  237.                            case "defective":
  238.                            case "refurbished":
  239.                            case "Unknown condition":
  240.                            $sql3="SELECT *FROM eq_inv WHERE eq_condition='none'";
  241.                          }
  242.                          //Values are allstate and allcondition, assigned,etc.
  243.                          break;
  244.                          case "new":
  245.                          switch($condition){
  246.                            case "allcondition":
  247.                            case "assigned":
  248.                            case "working":
  249.                            $sql3 = "SELECT *FROM eq_inv WHERE eq_condition='assigned' AND eq_state='new'";
  250.                            break;
  251.                            //so that assigned will be zero if these are checked
  252.                            case "Available/Unassigned":
  253.                            case "repair":
  254.                            case "missingpart":
  255.                            case "missingeq":
  256.                            case "defective":
  257.                            case "refurbished":
  258.                            case "Unknown condition":
  259.                            $sql3="SELECT *FROM eq_inv WHERE eq_condition='none'";
  260.                          }
  261.                          //Values are new and allcondition or assigned
  262.                          break;
  263.                          case "old":
  264.                          switch($condition){
  265.                            case "allcondition":
  266.                            case "assigned":
  267.                            case "working":
  268.                            $sql3 = "SELECT *FROM eq_inv WHERE eq_condition='assigned' AND eq_state='old'";
  269.                            break;
  270.                            //so that assigned will be zero if these are checked
  271.                            case "Available/Unassigned":
  272.                            case "repair":
  273.                            case "missingpart":
  274.                            case "missingeq":
  275.                            case "defective":
  276.                            case "refurbished":
  277.                            case "Unknown condition":
  278.                            $sql3="SELECT *FROM eq_inv WHERE eq_condition='none'";
  279.                          }
  280.                          //Values are old and allcondition or assigned
  281.                          break;
  282.                          case "Unknown state":
  283.                          switch($condition){
  284.                            case "allcondition":
  285.                            case "assigned":
  286.                            case "working":
  287.                            $sql3 = "SELECT *FROM eq_inv WHERE eq_condition='assigned' AND eq_state='Unknown state'";
  288.                            break;
  289.                            //so that assigned will be zero if these are checked
  290.                            case "Available/Unassigned":
  291.                            case "repair":
  292.                            case "missingpart":
  293.                            case "missingeq":
  294.                            case "defective":
  295.                            case "refurbished":
  296.                            case "Unknown condition":
  297.                            $sql3="SELECT *FROM eq_inv WHERE eq_condition='none'";
  298.                          }
  299.                          //Values are Unknown state and allcondition or assigned
  300.                          break;
  301.                        }
  302.                        $result3=mysqli_query($conn,$sql3);
  303.                        $countavail=mysqli_num_rows($result3);
  304.                        echo "<label style='color:red;'><strong>".$countavail."</strong></label>";
  305.                        ?>
  306.                        <br>
  307. <input type="radio" name="condition" value="repair" onchange="javascript:handleRadiocond(this)" <?php echo $condition==='repair' ? 'checked' : '' ?>> For Repair EQ:
  308.                        <?php
  309.                        switch($state){
  310.                          case "allstate":
  311.                          switch($condition){
  312.                            case "allcondition":
  313.                            case "repair":
  314.                            $sql3="SELECT *FROM eq_inv WHERE eq_condition='repair'";
  315.                            break;
  316.                            //so that repair will be zero if these are checked
  317.                            case "working":
  318.                            case "Available/Unassigned":
  319.                            case "assigned":
  320.                            case "missingpart":
  321.                            case "missingeq":
  322.                            case "defective":
  323.                            case "refurbished":
  324.                            case "Unknown condition":
  325.                            $sql3="SELECT *FROM eq_inv WHERE eq_condition='none'";
  326.                          }
  327.                          //Values are allstate and allcondition or repair
  328.                          break;
  329.                          case "new":
  330.                          switch($condition){
  331.                            case "allcondition":
  332.                            case "repair":
  333.                            $sql3 = "SELECT *FROM eq_inv WHERE eq_condition='repair' AND eq_state='new'";
  334.                            break;
  335.                            //so that repair will be zero if these are checked
  336.                            case "working":
  337.                            case "Available/Unassigned":
  338.                            case "assigned":
  339.                            case "missingpart":
  340.                            case "missingeq":
  341.                            case "defective":
  342.                            case "refurbished":
  343.                            case "Unknown condition":
  344.                            $sql3="SELECT *FROM eq_inv WHERE eq_condition='none'";
  345.                          }
  346.                          //Values are new and allcondition or repair
  347.                          break;
  348.                          case "old":
  349.                          switch($condition){
  350.                          case "allcondition":
  351.                          case "repair":
  352.                          $sql3 = "SELECT *FROM eq_inv WHERE eq_condition='repair' AND eq_state='old'";
  353.                          break;
  354.                          //so that repair will be zero if these are checked
  355.                          case "working":
  356.                          case "Available/Unassigned":
  357.                          case "assigned":
  358.                          case "missingpart":
  359.                          case "missingeq":
  360.                          case "defective":
  361.                          case "refurbished":
  362.                          case "Unknown condition":
  363.                          $sql3="SELECT *FROM eq_inv WHERE eq_condition='none'";
  364.                        }
  365.                        //Values are old and allcondition or repair, etc.
  366.                        break;
  367.                        case "Unknown state":
  368.                        switch($condition){
  369.                          case "allcondition":
  370.                          case "repair":
  371.                          $sql3 = "SELECT *FROM eq_inv WHERE eq_condition='repair' AND eq_state='Unknown state'";
  372.                          break;
  373.                          //so that repair will be zero if these are checked
  374.                          case "working":
  375.                          case "Available/Unassigned":
  376.                          case "assigned":
  377.                          case "missingpart":
  378.                          case "missingeq":
  379.                          case "defective":
  380.                          case "refurbished":
  381.                          case "Unknown condition":
  382.                          $sql3="SELECT *FROM eq_inv WHERE eq_condition='none'";
  383.                        }
  384.                        //Values are Unknown state and allcondition or repair
  385.                        break;
  386.                      }
  387.                      $result3=mysqli_query($conn,$sql3);
  388.                      $countavail=mysqli_num_rows($result3);
  389.                      echo "<label style='color:red;'><strong>".$countavail."</strong></label>";
  390.                      ?>
  391.                      <br>
  392. <div class="filters3">
  393. <input type="radio" name="condition" value="missingpart" onchange="javascript:handleRadiocond(this)" <?php echo $condition==='missingpart' ? 'checked' : '' ?>> W/ Missing Parts EQ:
  394.                      <?php
  395.                      switch($state){
  396.                        case "allstate":
  397.                        switch($condition){
  398.                          case "allcondition":
  399.                          case "missingpart":
  400.                          $sql3="SELECT *FROM eq_inv WHERE eq_condition='missingpart'";
  401.                          break;
  402.                          //so that missingpart will be zero if these are checked
  403.                          case "working":
  404.                          case "Available/Unassigned":
  405.                          case "assigned":
  406.                          case "repair":
  407.                          case "missingeq":
  408.                          case "defective":
  409.                          case "refurbished":
  410.                          case "Unknown condition":
  411.                          $sql3="SELECT *FROM eq_inv WHERE eq_condition='none'";
  412.                        }
  413.                        //Values are allstate and allcondition, missingpart, etc.
  414.                        break;
  415.                        case "new":
  416.                        switch($condition){
  417.                          case "allcondition":
  418.                          case "missingpart":
  419.                          $sql3 = "SELECT *FROM eq_inv WHERE eq_condition='missingpart' AND eq_state='new'";
  420.                          break;
  421.                          //so that missingpart will be zero if these are checked
  422.                          case "working":
  423.                          case "Available/Unassigned":
  424.                          case "assigned":
  425.                          case "repair":
  426.                          case "missingeq":
  427.                          case "defective":
  428.                          case "refurbished":
  429.                          case "Unknown condition":
  430.                          $sql3="SELECT *FROM eq_inv WHERE eq_condition='none'";
  431.                        }
  432.                        //Value are new and allcondition missingpart, etc.
  433.                        break;
  434.                        case "old":
  435.                        switch($condition){
  436.                          case "allcondition":
  437.                          case "missingpart":
  438.                          $sql3 = "SELECT *FROM eq_inv WHERE eq_condition='missingpart' AND eq_state='old'";
  439.                          break;
  440.                          //so that missingpasrt will be zero if these are checked
  441.                          case "working":
  442.                          case "Available/Unassigned":
  443.                          case "assigned":
  444.                          case "repair":
  445.                          case "missingeq":
  446.                          case "defective":
  447.                          case "refurbished":
  448.                          case "Unknown condition":
  449.                          $sql3="SELECT *FROM eq_inv WHERE eq_condition='none'";
  450.                        }
  451.                        //Values are old and allcondition, missingpart, etc.
  452.                        break;
  453.                        case "Unknown state":
  454.                        switch($condition){
  455.                          case "allcondition":
  456.                          case "missingpart":
  457.                          $sql3 = "SELECT *FROM eq_inv WHERE eq_condition='missingpart' AND eq_state='Unknown state'";
  458.                          break;
  459.                          //so that missingpart will be zero if these are checked
  460.                          case "working":
  461.                          case "Available/Unassigned":
  462.                          case "assigned":
  463.                          case "repair":
  464.                          case "missingeq":
  465.                          case "defective":
  466.                          case "refurbished":
  467.                          case "Unknown condition":
  468.                          $sql3="SELECT *FROM eq_inv WHERE eq_condition='none'";
  469.                        }
  470.                        //Values are Unknown state and allcondition, missingpart, etc.
  471.                        break;
  472.                      }
  473.                      $result3=mysqli_query($conn,$sql3);
  474.                      $countavail=mysqli_num_rows($result3);
  475.                      echo "<label style='color:red;'><strong>".$countavail."</strong></label>";
  476.                      ?>
  477.                      <br>
  478. <input type="radio" name="condition" value="missingeq" onchange="javascript:handleRadiocond(this)" <?php echo $condition==='missingeq' ? 'checked' : '' ?>> Missing EQ:
  479.                      <?php
  480.                      switch($state){
  481.  case "allstate":
  482.  switch($condition){
  483.    case "allcondition":
  484.    case "missingeq":
  485.    $sql3="SELECT *FROM eq_inv WHERE eq_condition='missingeq'";
  486.    break;
  487.    //so that missingeq will be zero if these are checked
  488.    case "working":
  489.    case "Available/Unassigned":
  490.    case "assigned":
  491.    case "repair":
  492.    case "missingpart":
  493.    case "defective":
  494.    case "refurbished":
  495.    case "Unknown condition":
  496.    $sql3="SELECT *FROM eq_inv WHERE eq_condition='none'";
  497.  }
  498.  //Values are allstate and allcondition, missingeq, etc.
  499.  break;
  500.  case "new":
  501.  switch($condition){
  502.    case "allcondition":
  503.    case "missingeq":
  504.    $sql3 = "SELECT *FROM eq_inv WHERE eq_condition='missingeq' AND eq_state='new'";
  505.    break;
  506.    //so that missingeq will be zero if these are checked
  507.    case "working":
  508.    case "Available/Unassigned":
  509.    case "assigned":
  510.    case "repair":
  511.    case "missingpart":
  512.    case "defective":
  513.    case "refurbished":
  514.    case "Unknown condition":
  515.    $sql3="SELECT *FROM eq_inv WHERE eq_condition='none'";
  516.  }
  517.  //Values are new and allcondition, missingeq, etc.
  518.  break;
  519.  case "old":
  520.  switch($condition){
  521.    case "allcondition":
  522.    case "missingeq":
  523.    $sql3 = "SELECT *FROM eq_inv WHERE eq_condition='missingeq' AND eq_state='old'";
  524.    break;
  525.    //so that missingeq will be zero if these are checked
  526.    case "working":
  527.    case "Available/Unassigned":
  528.    case "assigned":
  529.    case "repair":
  530.    case "missingpart":
  531.    case "defective":
  532.    case "refurbished":
  533.    case "Unknown condition":
  534.    $sql3="SELECT *FROM eq_inv WHERE eq_condition='none'";
  535.  }
  536.  //Values are old and allcondition, missingeq, etc.
  537.  break;
  538.  case "Unknown state":
  539.  switch($condition){
  540.    case "allcondition":
  541.    case "missingeq":
  542.    $sql3 = "SELECT *FROM eq_inv WHERE eq_condition='missingeq' AND eq_state='Unknown state'";
  543.    break;
  544.    //so that missingeq will be zero if these are checked
  545.    case "working":
  546.    case "Available/Unassigned":
  547.    case "assigned":
  548.    case "repair":
  549.    case "missingpart":
  550.    case "defective":
  551.    case "refurbished":
  552.    case "Unknown condition":
  553.    $sql3="SELECT *FROM eq_inv WHERE eq_condition='none'";
  554.  }
  555.  //Values are Unknown state and allcondition, missingeq, etc.
  556.  break;
  557. }
  558. $result3=mysqli_query($conn,$sql3);
  559. $countavail=mysqli_num_rows($result3);
  560. echo "<label style='color:red;'><strong>".$countavail."</strong></label>";
  561. ?>
  562. <br>
  563. <input type="radio" name="condition" value="defective" onchange="javascript:handleRadiocond(this)" <?php echo $condition==='defective' ? 'checked' : '' ?>> Defective EQ
  564. <?php
  565. switch($state){
  566. case "allstate":
  567. switch($condition){
  568. case "allcondition":
  569. case "defective":
  570. $sql3="SELECT *FROM eq_inv WHERE eq_condition='defective'";
  571. break;
  572. //so that defective will be zero if these are checked
  573. case "working":
  574. case "Available/Unassigned":
  575. case "assigned":
  576. case "repair":
  577. case "missingpart":
  578. case "missingeq":
  579. case "refurbished":
  580. case "Unknown condition":
  581. $sql3="SELECT *FROM eq_inv WHERE eq_condition='none'";
  582. }
  583. //Values are allstate and allcondition, defective, etc.
  584. break;
  585. case "new":
  586. switch($condition){
  587. case "allcondition":
  588. case "defective":
  589. $sql3 = "SELECT *FROM eq_inv WHERE eq_condition='defective' AND eq_state='new'";
  590. break;
  591. //so that defective will be zero if these are checked
  592. case "working":
  593. case "Available/Unassigned":
  594. case "assigned":
  595. case "repair":
  596. case "missingpart":
  597. case "missingeq":
  598. case "refurbished":
  599. case "Unknown condition":
  600. $sql3="SELECT *FROM eq_inv WHERE eq_condition='none'";
  601. }
  602. //Value are new and allcondition, defective, etc.
  603. break;
  604. case "old":
  605. switch($condition){
  606. case "allcondition":
  607. case "defective":
  608. $sql3 = "SELECT *FROM eq_inv WHERE eq_condition='defective' AND eq_state='old'";
  609. break;
  610. //so that defective will be zero if these are checked
  611. case "working":
  612. case "Available/Unassigned":
  613. case "assigned":
  614. case "repair":
  615. case "missingpart":
  616. case "missingeq":
  617. case "refurbished":
  618. case "Unknown condition":
  619. $sql3="SELECT *FROM eq_inv WHERE eq_condition='none'";
  620. }
  621. //Value are old and allcondition, defective, etc.
  622. break;
  623. case "Unknown state":
  624. switch($condition){
  625. case "allcondition":
  626. case "defective":
  627. $sql3 = "SELECT *FROM eq_inv WHERE eq_condition='defective' AND eq_state='Unknown state'";
  628. break;
  629. //so that defective will be zero if these are checked
  630. case "working":
  631. case "Available/Unassigned":
  632. case "assigned":
  633. case "repair":
  634. case "missingpart":
  635. case "missingeq":
  636. case "refurbished":
  637. case "Unknown condition":
  638. $sql3="SELECT *FROM eq_inv WHERE eq_condition='none'";
  639. }
  640. //Value are Unknown state and allcondition, defective, etc.
  641. break;
  642. }
  643. $result3=mysqli_query($conn,$sql3);
  644. $countavail=mysqli_num_rows($result3);
  645. echo "<label style='color:red;'><strong>".$countavail."</strong></label>";
  646. ?>
  647. <br>
  648. <input type="radio" name="condition" value="refurbished" onchange="javascript:handleRadiocond(this)" <?php echo $condition==='refurbished' ? 'checked' : '' ?>> Refurbished:
  649. <?php
  650. switch($state){
  651. case "allstate":
  652. switch($condition){
  653. case "allcondition":
  654. case "refurbished":
  655. $sql3="SELECT *FROM eq_inv WHERE eq_condition='refurbished'";
  656. break;
  657. //so that refurbished will be zero if these are checked
  658. case "working":
  659. case "Available/Unassigned":
  660. case "assigned":
  661. case "repair":
  662. case "missingpart":
  663. case "missingeq":
  664. case "defective":
  665. case "Unknown condition":
  666. $sql3="SELECT *FROM eq_inv WHERE eq_condition='none'";
  667. }
  668. //Value are allstate and allcondition, refurbished, etc.
  669. break;
  670. case "new":
  671. switch($condition){
  672. case "allcondition":
  673. case "refurbished":
  674. $sql3 = "SELECT *FROM eq_inv WHERE eq_condition='refurbished' AND eq_state='new'";
  675. break;
  676. //so that refurbished will be zero if these are checked
  677. case "working":
  678. case "Available/Unassigned":
  679. case "assigned":
  680. case "repair":
  681. case "missingpart":
  682. case "missingeq":
  683. case "defective":
  684. case "Unknown condition":
  685. $sql3="SELECT *FROM eq_inv WHERE eq_condition='none'";
  686. }
  687. //Values are new and allcondition, refurbished, etc.
  688. break;
  689. case "old":
  690. switch($condition){
  691. case "allcondition":
  692. case "refurbished":
  693. $sql3 = "SELECT *FROM eq_inv WHERE eq_condition='refurbished' AND eq_state='old'";
  694. break;
  695. //so that refurbished will be zero if these are checked
  696. case "working":
  697. case "Available/Unassigned":
  698. case "assigned":
  699. case "repair":
  700. case "missingpart":
  701. case "missingeq":
  702. case "defective":
  703. case "Unknown condition":
  704. $sql3="SELECT *FROM eq_inv WHERE eq_condition='none'";
  705. }
  706. //Value are old and allcondition, refurbished, etc.
  707. break;
  708. case "Unknown state":
  709. switch($condition){
  710. case "allcondition":
  711. case "refurbished":
  712. $sql3 = "SELECT *FROM eq_inv WHERE eq_condition='refurbished' AND eq_state='Unknown state'";
  713. break;
  714. //so that refurbished will be zero if these are checked
  715. case "working":
  716. case "Available/Unassigned":
  717. case "assigned":
  718. case "repair":
  719. case "missingpart":
  720. case "missingeq":
  721. case "defective":
  722. case "Unknown condition":
  723. $sql3="SELECT *FROM eq_inv WHERE eq_condition='none'";
  724. }
  725. //Value are Unknown state and allcondition, refurbished, etc.
  726. break;
  727. }
  728. $result3=mysqli_query($conn,$sql3);
  729. $countavail=mysqli_num_rows($result3);
  730. echo "<label style='color:red;'><strong>".$countavail."</strong></label>";
  731. ?>
  732.  
  733. <br>
  734. <input type="radio" name="condition" value="Unknown condition" onchange="javascript:handleRadiocond(this)" <?php echo $condition==='Unknown condition' ? 'checked' : '' ?>> Unknown Condition:
  735. <?php
  736. switch($state){
  737. case "allstate":
  738. switch($condition){
  739. case "allcondition":
  740. case "Unknown condition":
  741. $sql3="SELECT *FROM eq_inv WHERE eq_condition='Unknown condition'";
  742. break;
  743. //so that Unknown condition will be zero if these are checked
  744. case "working":
  745. case "Available/Unassigned":
  746. case "assigned":
  747. case "repair":
  748. case "missingpart":
  749. case "missingeq":
  750. case "defective":
  751. case "refurbished":
  752. $sql3="SELECT *FROM eq_inv WHERE eq_condition='none'";
  753. }
  754. //Value are allstate and allcondition, Unknown condition, etc.
  755. break;
  756. case "new":
  757. switch($condition){
  758. case "allcondition":
  759. case "Unknown condition":
  760. $sql3 = "SELECT *FROM eq_inv WHERE eq_condition='Unknown condition' AND eq_state='new'";
  761. break;
  762. //so that Unknown condition will be zero if these are checked
  763. case "working":
  764. case "Available/Unassigned":
  765. case "assigned":
  766. case "repair":
  767. case "missingpart":
  768. case "missingeq":
  769. case "defective":
  770. case "refurbished":
  771. $sql3="SELECT *FROM eq_inv WHERE eq_condition='none'";
  772. }
  773. //Values are new and allcondition, Unknown condition, etc.
  774. break;
  775. case "old":
  776. switch($condition){
  777. case "allcondition":
  778. case "Unknown condition":
  779. $sql3 = "SELECT *FROM eq_inv WHERE eq_condition='Unknown condition' AND eq_state='old'";
  780. break;
  781. //so that Unknown condition will be zero if these are checked
  782. case "working":
  783. case "Available/Unassigned":
  784. case "assigned":
  785. case "repair":
  786. case "missingpart":
  787. case "missingeq":
  788. case "defective":
  789. case "refurbished":
  790. $sql3="SELECT *FROM eq_inv WHERE eq_condition='none'";
  791. }
  792. //Values are old and allcondition, Unknown condition, etc.
  793. break;
  794. case "Unknown state":
  795. switch($condition){
  796. case "allcondition":
  797. case "Unknown condition":
  798. $sql3 = "SELECT *FROM eq_inv WHERE eq_condition='Unknown condition' AND eq_state='Unknown state'";
  799. break;
  800. //so that Unknown condition will be zero if these are checked
  801. case "working":
  802. case "Available/Unassigned":
  803. case "assigned":
  804. case "repair":
  805. case "missingpart":
  806. case "missingeq":
  807. case "defective":
  808. case "refurbished":
  809. $sql3="SELECT *FROM eq_inv WHERE eq_condition='none'";
  810. }
  811. //Values are Unknown state and allcondition, Unknown condition, etc.
  812. break;
  813. }
  814. $result3=mysqli_query($conn,$sql3);
  815. $countavail=mysqli_num_rows($result3);
  816. echo "<label style='color:red;'><strong>".$countavail."</strong></label>";
  817. ?>
  818.  
  819. <br>
  820. </div>
  821. </form>
  822. </div>
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!