DropDownMenu | 一个实用的多条件筛选菜单

import React, { useState } from "react";
import {
  Collapse,
  Navbar,
  NavbarToggler,
  NavbarBrand,
  Nav,
  NavItem,
  NavLink,
  UncontrolledDropdown,
  DropdownToggle,
  DropdownMenu,
  DropdownItem,
  NavbarText,
} from "reactstrap";

const Example = (props) => {
  const [isOpen, setIsOpen] = useState(false);

  const toggle = () => setIsOpen(!isOpen);

  return (
    <div>
      <Navbar color="light" light expand="sm">
        <NavbarBrand href="/" className="mr-auto">
          reactstrap
        </NavbarBrand>
        <NavbarToggler onClick={toggle} className="mr-2" />
        <Collapse isOpen={isOpen} navbar>
          <Nav navbar>
            <NavItem>
              <NavLink href="https://www.google.com">Team</NavLink>
            </NavItem>
            <NavItem>
              <NavLink href="https://www.google.com">Events</NavLink>
            </NavItem>
            <UncontrolledDropdown nav inNavbar>
              <DropdownToggle nav caret>
                Unsere Beratung
              </DropdownToggle>
              <DropdownMenu right>
                <DropdownItem>Bipapo</DropdownItem>
                <DropdownItem>TomLongSchlong</DropdownItem>
                <DropdownItem divider />
                <DropdownItem>Der coole Reset</DropdownItem>
              </DropdownMenu>
            </UncontrolledDropdown>
            <NavItem>
              <NavLink href="https://www.google.com">Social Media</NavLink>
            </NavItem>
            <NavItem>
              <NavLink href="https://www.google.com">Kontakt</NavLink>
            </NavItem>
          </Nav>
        </Collapse>
      </Navbar>
    </div>
  );
};

export default Example;

 library(shiny)
library(DT)
shinyUI(
  navbarPage(title="Analysis",
             tabPanel(title="Input",
                      sidebarLayout(
                        sidebarPanel(
                          fileInput("file","Upload the file"),
                          checkboxInput('file_has_headers',"Take Column Names from the first row of the file",value= TRUE),
                          checkboxInput('show_head_only',"Display only first 6 rows. Uncheck this to see entire file",value= TRUE),
                          radioButtons(inputId = 'sep', label = 'Separator', choices = c(Comma=',',Semicolon=';',Tab='\t', Space=''), selected = ','),
                          textAreaInput("domains", 'Enter the comma seperated list of dimensions, for example: verbal ability, numerical ability' ),
                          width = 4
                        ),
                        mainPanel(
                          wellPanel(
                            DT::dataTableOutput("uploaded_table"
                            ),# Displays the uploaded table by using js dataTable from DT package
                          ),
                          width = 8
                        ),
                        position = 'left'
                      )      
             ), #End of Input Tab panel
             
             tabPanel(title="Verification",
                      
                    
                              fillCol(uiOutput('choose_columns')),
                             
                        ## end of fillRow
                      
             ), #End of Verification Tab Panel
             navbarMenu(title="Analayis",
                        tabPanel(title="Item Analysis", "content"
                                 
                        ), #End of Item Analysis Tab Panel
                        tabPanel(title="Test Analysis", "content"
                                 
                        ) #End of Test Analysis Tab Panel
             ) #End of navbarMenu
  ) #End of navbarPage
) #end of shinyUI

   library(shiny)
    library(DT)
    options(shiny.maxRequestSize=300*1024^2)
    shinyServer(function(input, output) {
      
  #1: Get the uploaded file in the data variable 
  data <- reactive({
    uploaded <- input$file
    #if(is.null(file1)){return("No file is selected or selected file is not in the right format. Please check the documentation and upload correct file.")} 
    req(uploaded) #req retruns a silence rather than error and is better than using if()
    if(input$show_head_only){
      head(read.csv(file=uploaded$datapath, sep=input$sep,header = input$file_has_headers)) #head() returns only first 6 rows
    } else {
      read.csv(file=uploaded$datapath, sep=input$sep,header = input$file_has_headers) 
    }
  })
  
  #3: set element to show the uploaded csv file as a table
  output$uploaded_table<- DT::renderDataTable(
    data(), # If a variable contains the output of reactive() function, it must be used as a function.
    server=TRUE, #Important to keep this as true so that large datasets do not crash the browser
    options = list(
      scrollX = TRUE
    ),
  ) # End of uploaded table output setting
  
  #4: Set dynamic checkboxes based on the number of columns in the data
  output$choose_columns <- renderUI({
    n <- length(names(data()))
    colnames <- names(data())
    items <- strsplit(input$domains,',')[[1]]
    tagList(
      lapply(1:n, function(i){
       
          
          div(
            div(style="display: inline-block; vertical-align:top; width: 150px ;",checkboxInput(paste0('Columns', i),"", value = TRUE )),
            div(style="display: inline-block; vertical-align:top; width: 150px ;",textInput(paste0('answer_key', i),"",placeholder = 'e.g. A')),
            div(style="display: inline-block; vertical-align:top; width: 150px ;",selectInput(inputId = "domains", label = "", choices =  items)),
            div(style="display: inline-block; vertical-align:top; width: 150px ;",textInput(paste0('valid_options',i),"",placeholder = 'e.g. A,B,C,D'))
          )
          
          
        
    
  })
  

  
      )
    
  })
  
})

def choosing_asset():

with open('symbols.csv', newline='') as f:
    reader = csv.reader(f)
    data = list(reader)


option = st.sidebar.selectbox('Select your asset',data)

name = option[0]
ticker = option[1]

return(name,ticker)

import { Link } from 'react-router-dom';

const Card = ({country}) => {
    const {flag, name, population, subregion, capital} = country;

    const new_population = population.toLocaleString();

    const newTo = {
        pathname: `/details/${name}`,
        country: country
    };

    return <Link to={newTo} className='card'>

        <img src={flag} alt={name}></img>
        <div className='subCard'>
            <h2>{name}</h2>
            <p>Population: {new_population}</p>
            <p>Region: {subregion}</p>
            <p>Capital: {capital}</p>
        </div>

    </Link>;
}

export default Card;

import { useLocation, Link } from 'react-router-dom';

const Details = () => {
    const { country } = useLocation();
    
    const { 
        flag, 
        name, 
        nativeName, 
        population, 
        region, 
        subregion, 
        capital, 
        topLevelDomain, 
        currencies, 
        languages, 
        borders } = country; 
        //arrays: currencies, languages, borders, topLevelDomain

    return <div className='details'>
        <Link to={`/`} >Back</Link>
        <img src={flag} alt={name}></img>
        
            //etc
    </div>;
export default Details;
}

import React, { useState, useEffect } from 'react';
import { useFetch } from './useFetch'
import Card from './Card';
import Searchbar from './Searchbar';

const Home = () => {
    const [url, setUrl] = useState('https://restcountries.eu/rest/v2/all');
    

    const { isLoading, countries, isError } = useFetch(url); //custom hook

    if(!isLoading && !isError){
        return <div className='home'>
        <Searchbar setUrl={setUrl}>
            <DropdownMenu setRegion={setRegion}></DropdownMenu>
            
        </Searchbar>
        <div className='cards'>
          {countries.map((country, index)=>{
              return <Card key={index} id={index} country={country} ></Card> 
          })} 
        </div>
    </div>;
//etc

import { BrowserRouter as Router, Route, Switch } from 'react-router-dom';

import Navbar from './Navbar';
//page(s)
import Home from './Home'
import Error from './Error'
import Details from './Details'

function App() {
  return (
    <Router>
    <Navbar></Navbar>
    <Switch>
      <Route exact path='/'>
        <Home />
      </Route>
      <Route path='/details/:id' children={<Details/>}></Route>
      <Route path='*'>
        <Error></Error>
      </Route>  
    </Switch>
  </Router>
  );
}

export default App;

    TopAppBar(
        modifier = Modifier
            .statusBarsPadding(),
        title = {
            Text(text = "Title")
        },
        actions = {
            var menuExpanded by remember { mutableStateOf(false) }

            IconButton(onClick = { menuExpanded = true }) {
                Icon(Icons.Default.MoreVert, contentDescription = null)
            }

            DropdownMenu(
                expanded = menuExpanded,
                onDismissRequest = {
                    menuExpanded = false
                },
            ) {
                DropdownMenuItem(onClick = {}) {
                    Text("Item 2")
                }
            }
        },
    )

 final Mapdropdownlist  = { 'Category': [ 'A', 'B', 'C', 'D', 'C', 'E' ], 'Availiblity': ['F,'G], 'From': [], 'Instant Booking': [], 'Pricing': [12,13,14], 'Rating': [], };

ListView listofdropdown() {
    return ListView.builder(
      scrollDirection: Axis.horizontal,
      itemCount: mapdropdownlist.keys.length,
      itemBuilder: (context, index) {
        var keymap = mapdropdownlist.keys.elementAt(index);

        return Container(
          width: 210,
          decoration: BoxDecoration(
            border: Border.all(
              color: Colors.white,
              width: .5,
            ),
            borderRadius: BorderRadius.all(Radius.circular(15)),
          ),
          padding: const EdgeInsets.symmetric(horizontal: 9.0),
          margin: const EdgeInsets.symmetric(horizontal: 9.0, vertical: 20),
          child: DropdownButton(
            value: valuechoose,
            onChanged: (val) {
              setState(() {
                valuechoose = val;
              });
            },
            dropdownColor: Colors.green,
            hint: Text("$keymap", style: TextStyle(color: Colors.white)),
            items: mapdropdownlist.keys.map((valitem) {
              return DropdownMenuItem(
                child: Text(
                  valitem,
                  style: TextStyle(color: Colors.white),
                ),
                value: valitem,
              );
            }).toList(),
          ),
          alignment: Alignment.center,
        );
      },
    );
  }
}

import 'dart:io';
import 'package:vers2cts/models/note_model.dart';
import 'package:vers2cts/models/customer_model.dart';
import 'package:vers2cts/services/db_service.dart';
import 'package:vers2cts/utils/db_helper.dart';
import 'package:flutter/material.dart';
import 'package:sqflite/sqflite.dart';

import 'new_note.dart';


class Note_Info extends StatefulWidget{
  final String appBarTitle;
  final CustomerModel customer;

  //Note_Info();
  Note_Info(this. customer, this.appBarTitle);

  @override
  State<StatefulWidget> createState() {
    //return Note_InfoState();
   return Note_InfoState(this. customer,this.appBarTitle);
  }

}

class Note_InfoState extends State<Note_Info> {
  DBService dbService = DBService();
  List<NoteModel> noteList;
  int count = 0;

  static final GlobalKey<ScaffoldState> scaffoldKey = new GlobalKey<ScaffoldState>();
  NoteModel note=NoteModel();
  String appBarTitle;
  CustomerModel customer=new CustomerModel();
  Note_InfoState(this.customer, this.appBarTitle);
 

  bool rememberMe = false;
  DateTime _date = DateTime.now();
  TextEditingController custfNameController = TextEditingController();

  @override
  void initState() {
    super.initState();
  }


  @override
  Widget build(BuildContext context) {
  updateListView();
    if (noteList == null) {
      noteList = List<NoteModel>();
      updateListView();
    }

    TextStyle titleStyle = Theme.of(context).textTheme.subhead;
    var height = MediaQuery.of(context).size.height;
    var name=customer.first_name+" "+customer.last_name;
    custfNameController.text = name;

    return DefaultTabController(
        length: 4,
        child: Scaffold(
            appBar: AppBar(
              actions: [
                IconButton(
                  icon: Icon(
                    Icons.add,

                  ),
                  onPressed: () {
                    Navigator.of(context).push(MaterialPageRoute(
                        builder: (BuildContext context) => NewNote(customer,note)));
                  },
                )
              ],
            ),
            body: Container(
              child: Column(
                  children: <Widget>[
                    TextField(controller: custfNameController,
                        style: TextStyle(
                            fontSize: 20.0, fontWeight: FontWeight.bold),

                        textAlign: TextAlign.center),
                    Padding(
                      padding: const EdgeInsets.all(15.0),
                      child: Row(children: [
                        ImageProfile(customer.cust_photo),
                        Padding(
                          padding: const EdgeInsets.only(left: 30.0),
                          child: IconButton(
                            icon: Icon(
                              Icons.call,
                              color: Colors.green,
                              size: 45,
                            ),
                            onPressed: () {

                            },
                          ),
                        ),

                      ],),
                    ),

                    SizedBox(
                      height: 50,
                      child: AppBar(
                        bottom: TabBar(
                          tabs: [
                            Tab(
                              text: "All",
                              
                            ),
                            Tab(
                              text: "Pending",
                             
                            ),
                            Tab(
                              text: "Cancelled",
                              
                            ),
                            Tab(
                              text: "Completed",
                              
                            ),
                          ],
                        ),
                      ),
                    ),

                    // create widgets for each tab bar here
                    Expanded(
                      child: TabBarView(
                        children: [
                          // first tab bar view widget
                          Container(
                              child: getNotecheckList()
                          ),

                          // second tab bar view widget
                          Container(

                          ),


                          Container(
                            child: Center(
                              child: Text(
                                'Cancelled',
                              ),
                            ),
                          ),
                          Container(

                            child: Center(
                              child: Text(
                                'Completed',
                              ),
                            ),
                          ),
                        ],
                      ),
                    ),
                    Padding(
                      padding: const EdgeInsets.all(8.0),
                      child: Container(
                        height: 55.0,
                        width: 200,
                        child: RaisedButton(
                          elevation: 2,

                          shape: RoundedRectangleBorder(
                              borderRadius: BorderRadius.circular(20)),
                          color: Theme
                              .of(context)
                              .primaryColorDark,
                          textColor: Colors.white,
                          child: Text('Save', textScaleFactor: 1.5,),
                          onPressed: () {
                            setState(() {
                              //_reset();
                            });
                          },
                        ),
                      ),
                    ),
                  ]
              ),
            )
        ));
  }

  Widget ImageProfile(String fileName) {
    return Center(
      child: CircleAvatar(
          radius: 80.0,
          backgroundImage:  fileName == null
              ?AssetImage('images/person_icon.jpg')
              :FileImage(File(customer.cust_photo))),

    );

  }
  Future<void> updateListView() {
    final Future<Database> dbFuture = DB.init();
    dbFuture.then((database) {
      int cid=customer.cust_id;

      Future<List<NoteModel>> noteListFuture = dbService.getCustomerNotes(cid);
      noteListFuture.then((noteList) {

        setState(() {
          this.noteList = noteList;
          this.count = noteList.length;
        });
      });
    });
  }
  int _isChecked=-1;

  ListView getNotecheckList() {

    return ListView.builder(
        itemCount: count,
        itemBuilder: (BuildContext context, int position) {



        return Card(
          color: Colors.white,
          elevation: 2.0,
          child: CheckboxListTile(
            title: Text(this.noteList[position].note),
            subtitle: Text(this.noteList[position].actn_on),
            //secondary: const Icon(Icons.web),
            
            value: position== _isChecked,
            onChanged: (bool value) {
              setState(() {
               _isChecked = value?position:-1;

              });
            },

            controlAffinity: ListTileControlAffinity.leading,
                ),
            );
          },
         );
        }
  }

import 'package:flutter/material.dart';
import 'package:flutter/painting.dart';
import 'package:table_calendar/table_calendar.dart';
import 'package:flutter_speed_dial/flutter_speed_dial.dart';
import 'package:smooth_star_rating/smooth_star_rating.dart';
import 'package:intl/intl.dart';
import 'package:vers2cts/models/customer_model.dart';
import 'package:vers2cts/models/note_model.dart';
import 'package:vers2cts/services/db_service.dart';
import 'package:vers2cts/utils/form_helper.dart';

class NewNote extends StatefulWidget{
  final NoteModel note;
  final CustomerModel customer;

  NewNote(this.customer,this. note);
//Dropdown
/*
 final String label;
   final Function(Color) onChanged;
  final double height;
  final double width;

  NewNote.fordropdwn({
    Key key,
    this.onChanged,
    this.height = 25,
    this.width = 150,
    this.label,
  }) : super(key: key);*/
  @override
  State<StatefulWidget> createState() {
    //return New_NoteState(this.customer);
    return New_NoteState(this.customer,this.note);
  }

}
class New_NoteState extends State<NewNote> with SingleTickerProviderStateMixin{
  New_NoteState(this.customer,this.note);
  NoteModel note=new NoteModel();
  CustomerModel customer=new CustomerModel();
  TextEditingController NoteController=TextEditingController();
  TextEditingController custfNameController = TextEditingController();
  DateTime _reminderDate = DateTime.now();
  DBService dbService=new DBService();

  SpeedDial _speedDial(){
    return SpeedDial(
      // child: Icon(Icons.add),
      animatedIcon: AnimatedIcons.add_event,

      animatedIconTheme: IconThemeData(size: 24.0),
      backgroundColor: Colors.yellow,
      curve: Curves.easeInCirc,
      children: [
        SpeedDialChild(
          child: Icon(Icons.location_on,color: Colors.yellow,),
          //backgroundColor: Theme.of(context).primaryColor,
          label: 'Add Location',
          //labelBackgroundColor:Theme.of(context).primaryColor,

        ),
        SpeedDialChild(
          child: Icon(Icons.keyboard_voice),
          //backgroundColor: Colors.yellow,
          label: 'Add voice',
          //labelBackgroundColor: Colors.yellow

        ),
        SpeedDialChild(
          child: Icon(Icons.attachment_outlined,color :Colors.redAccent),
          //backgroundColor:Theme.of(context).primaryColorLight,
          label: 'Add File',
          // labelBackgroundColor: Theme.of(context).primaryColorLight

        ),
        SpeedDialChild(
          child: Icon(Icons.image,color: Colors.lightBlue,),
          //backgroundColor: Colors.yellow,
          label: 'Add Image',
          // labelBackgroundColor: Colors.yellow,

        ),
      ],
    );
  }

  //for DropDownMenu
  Color value=Colors.red;
  final List<Color> colors = [
    Colors.red,
    Colors.blue,
    Colors.green,
    Colors.yellow,
    Colors.pink,
    Colors.purple,
    Colors.brown,
  ];

  //for Switch
  bool isSwitched = false;
  var textValue = 'Switch is OFF';

  void toggleSwitch(bool value) {

    if(isSwitched == false)
    {
      setState(() {
        isSwitched = true;
        note.rmnd_ind=1;
        //this.note.remindOn = _reminderDate.toString();

      });
    }
    else
    {
      setState(() {
        isSwitched = false;
        note.rmnd_ind=0;
      });
    }
  }
  @override
  Widget build(BuildContext context) {
    var height = MediaQuery.of(context).size.height;
    var width = MediaQuery.of(context).size.width;
    var name=customer.first_name+customer.last_name;
    custfNameController.text = name;

    return WillPopScope(

        onWillPop: () {
          // Write some code to control things, when user press Back navigation button in device navigationBar
          moveToLastScreen();
        },
        child: Scaffold(
          appBar:AppBar(),
          body:ListView(
            children: <Widget>[
              SizedBox(
                height: 2.0,
              ),
              TextField(controller: custfNameController,
                  style: TextStyle(
                      fontSize: 20.0, fontWeight: FontWeight.bold),

                  textAlign: TextAlign.center),
              Align(
                alignment: Alignment.centerLeft,
                child: Text("Add New",textAlign: TextAlign.left,
                  style: TextStyle(fontSize: 22,fontWeight: FontWeight.bold),),
              ),

              SizedBox(
                height: 2.0,
              ),
              Divider(),
              SizedBox(
                height: 2.0,
              ),
              Padding(
                padding: const EdgeInsets.all(8.0),
                child: TextField(
                  controller: NoteController,
                  decoration: InputDecoration(
                      border: OutlineInputBorder(
                        borderSide: const BorderSide(width: 2.0),)),
                  keyboardType: TextInputType.multiline,
                  minLines: 5,//Normal textInputField will be displayed
                  maxLines: 5, // when user presses enter it will adapt to it
                  onChanged: (value) {
                    this.note.note = value;
                  },

                ),
              ),
              TableCalendar(
                selectedDayPredicate: (day) {
                  return isSameDay(_reminderDate, day);
                },
                onDaySelected: (selectedDay, focusedDay) {
                  setState(() {
                    String _reminderDate = DateFormat('dd-MM-yyyy').format(selectedDay);
                    note.actn_on=_reminderDate.toString();

                  });
                },// Set initial date

                focusedDay: DateTime.now(),
                firstDay: DateTime.utc(2010, 10, 16),
                lastDay: DateTime.utc(2030, 3, 14),),

              SizedBox(
                height: height*0.03,
              ),
              Padding(
                padding: const EdgeInsets.all(10.0),
                child: Row(//mainAxisAlignment: MainAxisAlignment.start,
                  children: <Widget>[
                    Text("Remind me",style: TextStyle(fontSize: 20),),

                    Padding(
                      padding: const EdgeInsets.only(left:80.0),
                      child: Container(
                        child: Switch(
                          onChanged: toggleSwitch,
                          value: isSwitched,

                          //activeColor: Colors.blue,
                          //activeTrackColor: Colors.yellow,
                          //inactiveThumbColor: Colors.redAccent,
                          //inactiveTrackColor: Colors.orange,
                        ),
                      ),
                    ),

                  ],),
              ),
              Padding(
                padding: const EdgeInsets.all(10.0),
                child: Row(mainAxisAlignment: MainAxisAlignment.start,
                    children:<Widget>[
                      Text("Priority",style: TextStyle(fontSize: 20.0),),
                      Padding(
                        padding: const EdgeInsets.only(left:20.0),
                        child: Container(
                          child: SmoothStarRating(
                            size: height=50.0,
                            allowHalfRating: false,
                            onRated: (value) {
                              this.note.prty=value;
                              print("rating value -> $value");

                            },
                          ),
                        ),
                      )]),
              ),

              Padding(
                padding: const EdgeInsets.all(10.0),
                child: Row(mainAxisAlignment: MainAxisAlignment.start,
                  children: <Widget>[

                    Text("Color",style: TextStyle(fontSize: 20),),
                    Padding(
                      padding: const EdgeInsets.only(left:80.0),
                      child: Container(
                        child: DropdownButton<Color>(
                          value: value,
                          //hint: Text(widget.label ?? ''),
                          onChanged: (color) {
                            setState(() => value = color);
                            //widget.onChanged(color);
                          },
                          items: colors.map((e) => DropdownMenuItem(
                            value: e,
                            child: Container(
                              // width: 60.0,
                              //height: 10.0,
                              width: 60.0,
                              // height: widget.height,
                              color: e,
                            ),
                          ),
                          )
                              .toList(),
                        ),
                      ),
                    ),

                  ],),
              ),

              SizedBox(
                height: height*0.08,
              ),
              Padding(
                padding: const EdgeInsets.all(8.0),
                child: Container(
                  height: 55.0,
                  width: 200,
                  child: RaisedButton(
                    elevation: 2,

                    shape: RoundedRectangleBorder(
                        borderRadius: BorderRadius.circular(20)),
                    color: Theme.of(context).primaryColorDark,
                    textColor: Colors.white,
                    child: Text('Save',textScaleFactor: 1.5,),
                    onPressed: (){
                      setState(() {
                        _save();
                      });
                    },
                  ),
                ),
              ),



            ],



          ),
          floatingActionButton:_speedDial(),
          
        ));

  }
  void moveToLastScreen() {
    Navigator.pop(context, true);
  }

  void _save() async {
    moveToLastScreen();
    note.cust_id=customer.cust_id;
    print(customer.cust_id);
    print(note.cust_id);
  
    int result;
    if (note.note_id != null) {  // Case 1: Update operation
      result = await dbService.updateNote(note);
    } else { // Case 2: Insert Operation
      result = await dbService.insertNote(note);
    }

    if (result != 0) {  // Success
      FormHelper.showAlertDialog(context,'Status', 'Note Saved Successfully');
    } else {  // Failure
      FormHelper.showAlertDialog(context,'Status', 'Problem Saving Note');
    }

  }
}

import 'package:vers2cts/models/customer_model.dart';
import 'package:vers2cts/models/languages_model.dart';
import 'package:vers2cts/models/note_model.dart';
import 'package:vers2cts/models/user_model.dart';
import 'package:vers2cts/utils/db_helper.dart';

class DBService {
  Future<int> insertNote(NoteModel note) async {
    await DB.init();
    var result = await DB.insert(NoteModel.table, note);
    return result;
  }
  Future<List<NoteModel>> getCustomerNotes(int customer) async {
    await DB.init();
    var res = await DB.rawQuery("note WHERE cust_id = '$customer'");
    int count = res.length;
    List<NoteModel> notelist = List<NoteModel>();
    // For loop to create a 'Note List' from a 'Map List'
    for (int i = 0; i < count; i++) {
      notelist.add(NoteModel.fromMap(res[i]));
    }
    return notelist;
  }
}

import 'model.dart';

class NoteModel extends Model {
  static String table = 'note';
  bool isSelected=false;
  int note_id;
  int cust_id;
  String note;
  String actn_on;
  int rmnd_ind;
  double prty;
  String colr;
  String sts;

  int id;
  String cre_date;
  String cre_by;
  String mod_date;
  String mod_by;
  int txn_id;
  int delete_ind;

  NoteModel({
    this.note_id,
    this.cust_id,
    this.note,
    this.actn_on,
    this.rmnd_ind,
    this.prty,
    this.colr,
    this.sts,

    this.id,
    this.cre_date,
    this.cre_by,
    this.mod_date,
    this.mod_by,
    this.txn_id,
    this.delete_ind
  });

  static NoteModel fromMap(Map<String, dynamic> map) {
    return NoteModel(
      note_id: map["note_id"],
      cust_id: map['cust_id'],
      note: map['note'].toString(),
      actn_on: map['actn_on'].toString(),
      rmnd_ind: map['rmnd_ind'],
      prty: map['prty'],
      colr: map['colr'].toString(),
      sts: map['sts'].toString(),


      id: map['id'],
      cre_date: map['cre_date'].toString(),
      cre_by: map['cre_by'].toString(),
      mod_date: map['mod_date'].toString(),
      mod_by: map['mod_by'].toString(),
      txn_id: map['txn_id'],
      delete_ind: map['delete_ind'],
    );
  }

  Map<String, dynamic> toMap() {
    Map<String, dynamic> map = {
      'note_id': note_id,
      'cust_id': cust_id,
      'note':note,
      'actn_on': actn_on,
      'rmnd_ind': rmnd_ind,
      'prty': prty,
      'colr': colr,
      'sts':sts,


      'id': id,
      'cre_date': cre_date,
      'cre_by': cre_by,
      'mod_date':mod_date,
      'mod_by':mod_by,
      'txn_id':txn_id,
      'delete_ind': delete_ind

    };

    if (note_id != null) {
      map['note_id'] = note_id;
    }
    return map;
  }
}

import 'dart:async';
import 'package:vers2cts/models/model.dart';
import 'package:path/path.dart' as p;
import 'package:sqflite/sqflite.dart';

abstract class DB {
  static Database _db;

  static int get _version => 1;

  static Future<Database> init() async {
    if (_db != null) {
      return _db;
    }

    try {
      var databasesPath = await getDatabasesPath();
      String _path = p.join(databasesPath, 'CTS.db');
      _db = await openDatabase(_path, version: _version, onCreate: onCreate);
      print('db location:'+_path);

    } catch (ex) {
      print(ex);
    }
  }

  static void onCreate(Database db, int version) async {

    await db.execute(
        'CREATE TABLE note (note_id INTEGER PRIMARY KEY,cust_id INTEGER, '
            'note TEXT, '
            'actn_on TEXT, rmnd_ind INTEGER, prty REAL, colr TEXT,'
            'sts TEXT,'
            'id INTEGER, cre_date TEXT,cre_by TEXT, mod_date TEXT,mod_by TEXT, txn_id INTEGER, delete_ind INTEGER)');

  }

  static Future<List<Map<String, dynamic>>> query(String table) async =>
      _db.query(table);

  static Future<int> insert(String table, Model model) async =>
      await _db.insert(table, model.toMap());
  static Future<Batch> batch() async => _db.batch();
  static Future<List<Map<String, dynamic>>> rawQuery(String table) async =>
      _db.query(table);
}

DropdownMenu(
    toggle = {
        Text(
            text = selected.value.toString(),
            modifier = Modifier.clickable(onClick = { showMenu = true }),
            fontSize = 16.sp
        )
    },
    expanded = showMenu,
    onDismissRequest = { showMenu = false },
    toggleModifier = Modifier.background(Color.LightGray)
) {
    items.forEachIndexed { index, s ->
        DropdownMenuItem(
            onClick = {
                selected.value = items[index]
                showMenu = false
            }
        ) {
            Text(text = s.toString())
        }
    }
}

import 'package:flutter/material.dart';
import 'package:vers2cts/screens/user_login.dart';

void main() {
  runApp(MyApp());
}
Map<int, Color> color ={50:Color.fromRGBO(170, 0, 95,  .1),
  100:Color.fromRGBO(170, 0, 95, .2),
  200:Color.fromRGBO(170, 0, 95, .3),
  300:Color.fromRGBO(170, 0, 95, .4),
  400:Color.fromRGBO(170, 0, 95, .5),
  500:Color.fromRGBO(170, 0, 95, .6),
  600:Color.fromRGBO(170, 0, 95, .7),
  700:Color.fromRGBO(170, 0, 95, .8),
  800:Color.fromRGBO(170, 0, 95, .9),
  900:Color.fromRGBO(170,0,95, 1),};
MaterialColor colorCustom = MaterialColor(0xFF880E4F, color);
class MyApp extends StatelessWidget {
  // This widget is the root of your application.
  @override
  Widget build(BuildContext context) {
    return MaterialApp(
      title: 'NoteKeeper',
      debugShowCheckedModeBanner: false,
      theme: ThemeData(
          primarySwatch:colorCustom,
          primaryColor:colorCustom//primarySwatch: Colors.purple
      ),
      home: UserLogin(),
    );
  }
}

import 'dart:io';
import 'package:customer/models/CustomerNote.dart';
import 'package:customer/models/addCustomer.dart';
import 'package:customer/services/db_service.dart';
import 'package:customer/utils/database_helper.dart';
import 'package:flutter/material.dart';
import 'package:sqflite/sqflite.dart';
import 'New_Note.dart';


class Note_Info extends StatefulWidget{
  final String appBarTitle;
  final AddCustomer customer;


  Note_Info(this. customer, this.appBarTitle);
  @override
  State<StatefulWidget> createState() {
    return Note_InfoState(this. customer,this.appBarTitle);
  }

}

class Note_InfoState extends State<Note_Info> {
  DBService dbService = DBService();
  List<CustomerNote> noteList;
  int count = 0;

  static final GlobalKey<ScaffoldState> scaffoldKey = new GlobalKey<ScaffoldState>();
  CustomerNote note=CustomerNote();
  String appBarTitle;
  AddCustomer customer;
  Note_InfoState(this.customer, this.appBarTitle);


 
  DateTime _date = DateTime.now();
  TextEditingController custNameController = TextEditingController();

  @override
  void initState() {
    super.initState();
  }


  @override
  Widget build(BuildContext context) {
    int customerId=customer.custId;
    if (noteList == null) {
      noteList = List<CustomerNote>();
      updateListView();
    }

    TextStyle titleStyle = Theme.of(context).textTheme.subhead;
    var height = MediaQuery.of(context).size.height;
    custNameController.text = customer.custName;

    return DefaultTabController(
        length: 4,
        child: Scaffold(
            appBar: AppBar(
              actions: [
                IconButton(
                  icon: Icon(
                    Icons.add,

                  ),
                  onPressed: () {
                    Navigator.of(context).push(MaterialPageRoute(
                        builder: (BuildContext context) => NewNote(note)));
                  },
                )
              ],
            ),
            body: Container(
              child: Column(
                  children: <Widget>[
                    TextField(controller: custNameController,
                        style: TextStyle(
                            fontSize: 20.0, fontWeight: FontWeight.bold),

                        textAlign: TextAlign.center),
                    Padding(
                      padding: const EdgeInsets.all(15.0),
                      child: Row(children: [
                        ImageProfile(customer.custPhoto),
                        Padding(
                          padding: const EdgeInsets.only(left: 30.0),
                          child: IconButton(
                            icon: Icon(
                              Icons.call,
                              color: Colors.green,
                              size: 45,
                            ),
                            onPressed: () {

                            },
                          ),
                        ),

                      ],),
                    ),

                    SizedBox(
                      height: 50,
                      child: AppBar(
                        bottom: TabBar(
                          tabs: [
                            Tab(
                              text: "All",
                            ),
                            Tab(
                              text: "Pending",
                            ),
                            Tab(
                              text: "Cancelled",
                            ),
                            Tab(
                              text: "Completed",
                             
                            ),
                          ],
                        ),
                      ),
                    ),

                    // create widgets for each tab bar here
                    Expanded(
                      child: TabBarView(
                        children: [
                          // first tab bar view widget
                          Container(
                              child: getNoteListView()
                          ),

                          // second tab bar viiew widget
                          Container(

                          ),


                          Container(
                            child: Center(
                              child: Text(
                                'Cancelled',
                              ),
                            ),
                          ),
                          Container(

                            child: Center(
                              child: Text(
                                'Completed',
                              ),
                            ),
                          ),
                        ],
                      ),
                    ),
                    Padding(
                      padding: const EdgeInsets.all(8.0),
                      child: Container(
                        height: 55.0,
                        width: 200,
                        child: RaisedButton(
                          elevation: 2,

                          shape: RoundedRectangleBorder(
                              borderRadius: BorderRadius.circular(20)),
                          color: Theme
                              .of(context)
                              .primaryColorDark,
                          textColor: Colors.white,
                          child: Text('Save', textScaleFactor: 1.5,),
                          onPressed: () {
                            setState(() {
                              //_reset();
                            });
                          },
                        ),
                      ),
                    ),
                  ]
              ),
            )
        ));
  }

  Widget ImageProfile(String fileName) {
    return Center(
      child: CircleAvatar(
          radius: 80.0,
          backgroundImage:  fileName == null
              ?AssetImage('images/person_icon.jpg')
              :FileImage(File(customer.custPhoto))),

    );

  }


  ListView getNoteListView() {

    TextStyle titleStyle = Theme.of(context).textTheme.subhead;

    return ListView.builder(
      itemCount: count,
      itemBuilder: (BuildContext context, int position) {

        return Card(
          color: Colors.white,
          elevation: 2.0,
          child: ListTile(


            title: Text(this.noteList[position].note, style: titleStyle,),
          
            trailing: GestureDetector(
              child: Icon(Icons.delete, color: Colors.grey,),
              onTap: () {
               
              },
            ),
            onTap: () {
             
            },

          ),
        );
      },
    );
  }
  void updateListView() {
    final Future<Database> dbFuture = DB.init();
    dbFuture.then((database) {
      int cid=customer.custId;
      Future<List<CustomerNote>> noteListFuture = dbService.getCustomerNotes(cid);
      noteListFuture.then((noteList) {
        setState(() {
          this.noteList = noteList;
          this.count = noteList.length;
        });
      });
    });
  }

}

import 'package:customer/models/CustomerNote.dart';
import 'package:customer/models/addCustomer.dart';
import 'package:customer/screens/Note_info.dart';
import 'package:customer/services/db_service.dart';
import 'package:customer/utils/form_helper.dart';
import 'package:flutter/material.dart';
import 'package:flutter/painting.dart';
import 'package:table_calendar/table_calendar.dart';
import 'package:flutter_speed_dial/flutter_speed_dial.dart';
import 'package:smooth_star_rating/smooth_star_rating.dart';
import 'package:intl/intl.dart';

class NewNote extends StatefulWidget{
    final CustomerNote note;
    NewNote(this. note);

   final Function(Color) onChanged;
  final double height;
  final double width;

  NewNote({
    Key key,
    this.onChanged,
    this.height = 25,
    this.width = 150,
    this.label,
  }) : super(key: key);*/
  @override
  State<StatefulWidget> createState() {
    return New_NoteState(this.note);
  }

}
class New_NoteState extends State<NewNote> with SingleTickerProviderStateMixin{
  New_NoteState(this.note);
  CustomerNote note=new CustomerNote();
  AddCustomer customer=new AddCustomer();
  TextEditingController NoteController=TextEditingController();
  TextEditingController custNameController = TextEditingController();
  DateTime _reminderDate = DateTime.now();
DBService dbService=new DBService();

SpeedDial _speedDial(){
  return SpeedDial(
    animatedIcon: AnimatedIcons.add_event,

    animatedIconTheme: IconThemeData(size: 24.0),
    backgroundColor: Colors.yellow,
    curve: Curves.easeInCirc,
    children: [
      SpeedDialChild(
        child: Icon(Icons.location_on,color: Colors.yellow,),
        label: 'Add Location',
      ),
      SpeedDialChild(
          child: Icon(Icons.keyboard_voice),
          //backgroundColor: Colors.yellow,
          label: 'Add voice',
          //labelBackgroundColor: Colors.yellow

      ),
      SpeedDialChild(
          child: Icon(Icons.attachment_outlined,color :Colors.redAccent),
          label: 'Add File',
      ),
      SpeedDialChild(
          child: Icon(Icons.image,color: Colors.lightBlue,),
          label: 'Add Image',

      ),
    ],
  );
}

  //for DropDownMenu
  Color value=Colors.red;
  final List<Color> colors = [
    Colors.red,
    Colors.blue,
    Colors.green,
    Colors.yellow,
    Colors.pink,
    Colors.purple,
    Colors.brown,
  ];


  bool isSwitched = false;
  var textValue = 'Switch is OFF';

  void toggleSwitch(bool value) {

    if(isSwitched == false)
    {
      setState(() {
        isSwitched = true;
        this.note.remindOn = _reminderDate.toString();

      });
    }
    else
    {
      setState(() {
        isSwitched = false;
      });
    }
  }
  @override
  Widget build(BuildContext context) {
    var height = MediaQuery.of(context).size.height;
    var width = MediaQuery.of(context).size.width;
    custNameController.text = customer.custName;

    return WillPopScope(

      onWillPop: () {
        moveToLastScreen();
      },
child: Scaffold(
      appBar:AppBar(),
      body:ListView(
        children: <Widget>[
        SizedBox(
          height: 2.0,
        ),
          TextField(controller: custNameController,
              style: TextStyle(
                  fontSize: 20.0, fontWeight: FontWeight.bold),

              textAlign: TextAlign.center),
        Align(
      alignment: Alignment.centerLeft,
          child: Text("Add New",textAlign: TextAlign.left,
          style: TextStyle(fontSize: 22,fontWeight: FontWeight.bold),),
        ),

      SizedBox(
        height: 2.0,
      ),
      Divider(),
      SizedBox(
        height: 2.0,
      ),
      Padding(
        padding: const EdgeInsets.all(8.0),
        child: TextField(
          controller: NoteController,
          decoration: InputDecoration(
          border: OutlineInputBorder(
            borderSide: const BorderSide(width: 2.0),)),
          keyboardType: TextInputType.multiline,
          minLines: 5,
          maxLines: 5,
          onChanged: (value) {
            this.note.note = value;
          },

        ),
      ),
      TableCalendar(
        selectedDayPredicate: (day) {
          return isSameDay(_reminderDate, day);
        },
        onDaySelected: (selectedDay, focusedDay) {
          setState(() {
            _reminderDate = selectedDay;
          });
        },
              focusedDay: DateTime.now(),
              firstDay: DateTime.utc(2010, 10, 16),
              lastDay: DateTime.utc(2030, 3, 14),),

        SizedBox(
          height: height*0.03,
        ),
        Padding(
          padding: const EdgeInsets.all(10.0),
          child: Row(//mainAxisAlignment: MainAxisAlignment.start,
            children: <Widget>[
              Text("Remind me",style: TextStyle(fontSize: 20),),

            Padding(
              padding: const EdgeInsets.only(left:80.0),
              child: Container(
                child: Switch(
                    onChanged: toggleSwitch,
                    value: isSwitched,
                   
              ),
            ),

          ],),
        ),
        Padding(
          padding: const EdgeInsets.all(10.0),
          child: Row(mainAxisAlignment: MainAxisAlignment.start,
            children:<Widget>[
              Text("Priority",style: TextStyle(fontSize: 20.0),),
             Padding(
               padding: const EdgeInsets.only(left:20.0),
               child: Container(
                 child: SmoothStarRating(
                  size: height=50.0,
                   allowHalfRating: false,
                   onRated: (value) {
                    this.note.priority=value;
                     print("rating value -> $value");

                   },
            ),
               ),
             )]),
        ),

        Padding(
          padding: const EdgeInsets.all(10.0),
          child: Row(mainAxisAlignment: MainAxisAlignment.start,
            children: <Widget>[

            Text("Color",style: TextStyle(fontSize: 20),),
            Padding(
              padding: const EdgeInsets.only(left:80.0),
              child: Container(
                child: DropdownButton<Color>(
                value: value,
                
                onChanged: (color) {
                  setState(() => value = color);
                  
                },
                items: colors.map((e) => DropdownMenuItem(
                      value: e,
                      child: Container(
                       width: 60.0,
                        color: e,
                      ),
                  ),
                )
                      .toList(),
          ),
              ),
            ),

          ],),
        ),

          SizedBox(
          height: height*0.08,
        ),
        Padding(
          padding: const EdgeInsets.all(8.0),
          child: Container(
            height: 55.0,
            width: 200,
            child: RaisedButton(
              elevation: 2,

              shape: RoundedRectangleBorder(
                  borderRadius: BorderRadius.circular(20)),
              color: Theme.of(context).primaryColorDark,
              textColor: Colors.white,
              child: Text('Save',textScaleFactor: 1.5,),
              onPressed: (){
                setState(() {
                  _save();
                });
              },
            ),
          ),
        ),



      ],



    ),
 floatingActionButton:_speedDial(),
    ));

  }
  void moveToLastScreen() {
    Navigator.pop(context, true);
  }

  void _save() async {
    moveToLastScreen();
    note.custId=customer.custId;
    note.date = DateFormat.yMMMd().format(DateTime.now());
    int result;
    if (note.id != null) {  // Case 1: Update operation
      result = await dbService.updateNote(note);
    } else { // Case 2: Insert Operation
      result = await dbService.insertNote(note);
    }

    if (result != 0) {  // Success
      FormHelper.showAlertDialog(context,'Status', 'Note Saved Successfully');
    } else {  // Failure
      FormHelper.showAlertDialog(context,'Status', 'Problem Saving Note');
    }

  }
}

 Future<bool> insertCustomer(AddCustomer model) async {
      await DB.init();
      bool isSaved = false;
      if (model != null) {
        int inserted = await DB.insert(AddCustomer.table, model);

        isSaved = inserted == 1 ? true : false;
      }

      return isSaved;
  }
Future<List<Map<String, dynamic>>> getCustomerMapList() async {
    await DB.init();
    var result = await DB.query(AddCustomer.table);
    return result;
  }


  Future<List<AddCustomer>> getCustomerList() async {

    var CustomerMapList = await getCustomerMapList(); 
    int count = CustomerMapList.length;

    List<AddCustomer> customerList = List<AddCustomer>();
   
    for (int i = 0; i < count; i++) {
      customerList.add(AddCustomer.fromMap(CustomerMapList[i]));
    }
    return customerList;
  }
 Future<int> insertNote(CustomerNote note) async {
    await DB.init();
    var result = await DB.insert(CustomerNote.table, note);
    return result;
  }

    Future<List<CustomerNote>> getCustomerNotes(int customer) async {
        await DB.init();
        var res = await DB.rawQuery("noteDetails WHERE custId = '$customer'");
        int count = res.length;
        List<CustomerNote> notelist = List<CustomerNote>();
        for (int i = 0; i < count; i++) {
          notelist.add(CustomerNote.fromMap(res[i]));
        }
        return notelist;
      }

import 'dart:async';
import 'package:customer/models/model.dart';
import 'package:path/path.dart' as p;
import 'package:sqflite/sqflite.dart';

abstract class DB {
  static Database _db;

  static int get _version => 1;

  static Future<Database> init() async {
    if (_db != null) {
      return _db;
    }

    try {
      var databasesPath = await getDatabasesPath();
      String _path = p.join(databasesPath, 'Customer.db');
      _db = await openDatabase(_path, version: _version, onCreate: onCreate);
      print('db location:'+_path);

    } catch (ex) {
      print(ex);
    }
  }

  static void onCreate(Database db, int version) async {
    await db.execute(
        'CREATE TABLE userDetails (id INTEGER PRIMARY KEY AUTOINCREMENT, '
            'firstName STRING, '
            'lastName STRING, mobileNum STRING, emailId STRING, address String,'
            'userType STRING,password STRING)');
    await db.execute(
        'CREATE TABLE customerDetails (custId INTEGER PRIMARY KEY AUTOINCREMENT, '
            'custName STRING, '
            'mobileNum STRING, company STRING, custPhoto STRING, showOnCall bool,'
            'remindOn STRING,location STRING)');
    await db.execute(
        'CREATE TABLE noteDetails (noteId INTEGER PRIMARY KEY AUTOINCREMENT, '
            'custId STRING, '
            'custName STRING, date STRING, note STRING, remindOn STRING,'
            'priority STRING,status STRING,attachment STRING)');
    await db.execute(
    'CREATE TABLE languagesKnown(custId INTEGER REFERENCES customerDetails(custId),'
        ' languages STRING,PRIMARY KEY(custId))');

    }

  static Future<List<Map<String, dynamic>>> query(String table) async =>
      _db.query(table);

  static Future<int> insert(String table, Model model) async =>
      await _db.insert(table, model.toMap());

  static Future<int> update(String table, Model model) async => await _db
      .update(table, model.toMap(), where: 'id = ?', whereArgs: [model.id]);

  static Future<int> delete(String table, Model model) async =>
      await _db.delete(table, where: 'id = ?', whereArgs: [model.id]);

  static Future<int> deleteCustomer(String table, Model model) async =>
      await _db.delete(table, where: 'custId = ?', whereArgs: [model.custId]);

  static Future<Batch> batch() async => _db.batch();

  static Future<List<Map<String, dynamic>>> rawQuery(String table) async =>
      _db.query(table);


}

import 'package:customer/models/addCustomer.dart';
import 'package:customer/screens/Note_info.dart';
import 'package:customer/screens/User_Settings.dart';
import 'package:customer/screens/add_person.dart';
import 'package:customer/services/db_service.dart';
import 'package:customer/utils/database_helper.dart';
import 'package:customer/utils/form_helper.dart';
import 'package:flutter/material.dart';
import 'dart:io';
import 'package:sqflite/sqflite.dart';

class People_List extends StatefulWidget{


  @override
  State<StatefulWidget> createState() {
    return People_ListState();
  }

}

class People_ListState extends State<People_List> with SingleTickerProviderStateMixin{

  DBService dbService = DBService();
  List<AddCustomer> customerList;
  int count = 0;

  static final GlobalKey<ScaffoldState> scaffoldKey = new GlobalKey<ScaffoldState>();
  var _isSelectedItemIndex;
  
  @override
  void initState() {
    super.initState();
    _searchQuery = new TextEditingController();
  }

  
  

  Widget _buildTitle(BuildContext context) {
    var horizontalTitleAlignment =
    Platform.isIOS ? CrossAxisAlignment.center : CrossAxisAlignment.start;

    return new InkWell(
      onTap: () => scaffoldKey.currentState.openDrawer(),
      child: new Padding(
        padding: const EdgeInsets.symmetric(horizontal: 12.0),
        child: new Column(
          mainAxisAlignment: MainAxisAlignment.center,
          crossAxisAlignment: horizontalTitleAlignment,
          children: <Widget>[
            const Text(''),
          ],
        ),
      ),
    );
  }
  @override
  Widget build(BuildContext context) {
    var height = MediaQuery.of(context).size.height;
    var width = MediaQuery.of(context).size.width;
    if (customerList == null) {
      customerList = List<AddCustomer>();
      updateListView();
    }

    return Scaffold(
      appBar: new AppBar(
        
      ),
      body:getCustomerListView(),
      floatingActionButton: FloatingActionButton(
        onPressed: () {
          navigateToCustomer(AddCustomer(), 'Add Person');
        },

        child: const Icon(Icons.add),

      ),
      
  }

  ListView getCustomerListView() {

    TextStyle titleStyle = Theme.of(context).textTheme.subhead;

    return ListView.builder(
      itemCount: count,
      itemBuilder: (BuildContext context, int position) {
        var _imageFile=customerList[position].custPhoto;
        return Card(
          color: Colors.white,
          elevation: 2.0,
          child: ListTile(
            leading: CircleAvatar(
            backgroundImage: _imageFile==null?AssetImage('images/person_icon.jpg')
                :FileImage(File(_imageFile.toString()))),
            title: Text(this.customerList[position].custName, style: titleStyle,),
            trailing: Icon(Icons.keyboard_arrow_right),
            onTap: () {
              navigateToDetail(this.customerList[position],'Edit ');
            },

          ),
        );
      },
    );
  }
  
  void navigateToDetail(AddCustomer customer, String title) async {
    bool result = await Navigator.push(context, MaterialPageRoute(builder: (context) {
     return Note_Info(customer, title);
    }));

    if (result == true) {
      updateListView();
    }
  }
 
  void updateListView() {
    final Future<Database> dbFuture = DB.init();
    dbFuture.then((database) {

      Future<List<AddCustomer>> customerListFuture = dbService.getCustomerList();
      customerListFuture.then((customerList) {
        setState(() {
          this.customerList = customerList;
          this.count = customerList.length;
        });
      });
    });
  }

 
}