public function route_main(Request $request)
 {
     $reps = Rep::all();
     $routes = DB::select(DB::raw("Select A.*, IFNULL((Select B.rep_name from reps B where B.id = A.id),0) as rep_name from routes A"));
     return view('Management.routes')->with('reps', $reps)->with('routes', $routes);
 }
 public function del_reps(Request $request)
 {
     $id = $request->input('id');
     $reps = Rep::find($id);
     $reps->delete();
 }
 * You should have received a copy of the GNU Affero General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 *
 * @category  Homeopathy
 * @package   RepertorizationResult
 * @author    Henri Schumacher <*****@*****.**>
 * @copyright 2007-2014 Henri Schumacher
 * @license   http://www.gnu.org/licenses/agpl.html GNU Affero General Public License v3
 * @version   1.0
 * @link      http://openhomeo.org/openhomeopath/download/OpenHomeopath_1.0.tar.gz
 */
include_once "include/classes/login/session.php";
$skin = $session->skin;
$current_page = "rep_result";
include_once "include/classes/rep_class.php";
$rep = new Rep();
if (isset($_REQUEST['tab'])) {
    include "include/functions/layout.php";
} else {
    $head_title = _("Repertorization result") . " :: OpenHomeopath";
    include "skins/{$skin}/header.php";
}
if (isset($_REQUEST['tab'])) {
    ?>
  <div style='float: right; margin: 25px;'>
      <a id='history_back_tab_1' style='padding: 7px;'><img alt=""  id='arrow_left_tab_1' height='24' width='38' src='./img/arrow_left_inactive.gif'></a><a id='history_forward_tab_1' style='padding: 7px;'><img alt=""  id='arrow_right_tab_1' height='24' width='38' src='./img/arrow_right_inactive.gif'></a>
  </div>
<?php 
}
?>
<h1>
 * @package   SaveRep
 * @author    Henri Schumacher <*****@*****.**>
 * @copyright 2007-2014 Henri Schumacher
 * @license   http://www.gnu.org/licenses/agpl.html GNU Affero General Public License v3
 * @version   1.0
 * @link      http://openhomeo.org/openhomeopath/download/OpenHomeopath_1.0.tar.gz
 */
$task = "";
if (!empty($_REQUEST['task'])) {
    $task = $_REQUEST['task'];
}
if (!empty($_REQUEST['ajax']) || $task == 'save_PDF' || $task == 'print_PDF') {
    chdir("..");
    include_once "include/classes/login/session.php";
    require_once "include/classes/rep_class.php";
    $rep = new Rep();
}
if (!empty($task)) {
    // speichert Rep.-Ergebnis oder gibt PDF aus
    if ($task == 'save_rep' & $session->logged_in) {
        // speichert Rep.-Ergebnis
        $rep->save_rep();
        if (!empty($rep->rep_id)) {
            if (!empty($_REQUEST['rep'])) {
                printf("<p class='label'><span class='alert_box'>" . _("The repertorization no. %d was updated.") . "</span></p>\n", $rep->rep_id);
            } else {
                printf("<p class='label'><span class='alert_box'>" . _("The repertorization result has been saved as <em>Rep.-no.: %d</em>.") . "\n", $rep->rep_id);
                if (!$tabbed && !isset($_REQUEST['tab'])) {
                    $url = "userinfo.php?user="******"#reps";
                } else {
                    $url = 'javascript:userTabOpen("reps")';
 public function edit_stock(Request $request)
 {
     $id = $request->input('id');
     $rep = Rep::find($id);
     $rep->rep_name = $request->input('name');
     $rep->nic = $request->input('nic');
     $rep->remarks = $request->input('remarks');
     $rep->phone = $request->input('phone');
     $rep->save();
 }
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU Affero General Public License for more details.
 * You should have received a copy of the GNU Affero General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 *
 * @category  Homeopathy
 * @package   Details
 * @author    Henri Schumacher <*****@*****.**>
 * @copyright 2007-2014 Henri Schumacher
 * @license   http://www.gnu.org/licenses/agpl.html GNU Affero General Public License v3
 * @version   1.0
 * @link      http://openhomeo.org/openhomeopath/download/OpenHomeopath_1.0.tar.gz
 */
include_once "include/classes/login/session.php";
include_once "include/classes/rep_class.php";
$rep = new Rep();
if (empty($_GET['popup'])) {
    $head_title = _("Symptom-remedy-details") . " :: OpenHomeopath";
    $skin = $session->skin;
    include "skins/{$skin}/header.php";
}
?>
<h1>
  <?php 
echo _("Symptom-remedy-details");
?>
</h1>
<?php 
$kuenzli = 0;
unset($sources);
$sym_id = $_GET['sym'];