{"id":68,"date":"2021-07-05T15:45:52","date_gmt":"2021-07-05T15:45:52","guid":{"rendered":"http:\/\/localhost\/wordpress\/?page_id=68"},"modified":"2021-07-06T13:46:18","modified_gmt":"2021-07-06T13:46:18","slug":"dependant-dropdowns","status":"publish","type":"page","link":"https:\/\/xcrud.net\/wordpress\/index.php\/dependant-dropdowns\/","title":{"rendered":"Dependant dropdowns"},"content":{"rendered":"\n<pre style=\"background:#777;color:#ffffff\" class=\"wp-block-code has-small-font-size\"><code><strong>&#91;xcrud]\n\n    $xcrud = Xcrud::get_instance();\n    $xcrud-&amp;gt;table('consultation');\n    $xcrud-&amp;gt;relation('office','offices','officeCode','city');\n    $xcrud-&amp;gt;relation('manager','employees','employeeNumber',array('firstName','lastName'),'','','',' ','','officeCode','office');\n     \n    $xcrud-&amp;gt;relation('country','meta_location','id','local_name','type = \\'CO\\'');\n    $xcrud-&amp;gt;relation('region','meta_location','id','local_name','type = \\'RE\\'','','','','','in_location','country');\n    $xcrud-&amp;gt;relation('city','meta_location','id','local_name','type = \\'CI\\'','','','','','in_location','region');\n     \n    echo $xcrud-&amp;gt;render('create');\n\n&#91;\/xcrud]<\/strong><\/code><\/pre>\n\n\n<div class=\"xcrud\">\n<div style=\"display:none;\" class=\"xcrud-main-tab\">Consultation<small> <\/small><\/div>\n<div class=\"xcrud-container\">\n<div class=\"xcrud-ajax\">\n            <input type=\"hidden\" class=\"xcrud-data\" name=\"key\" value=\"c6ddc96372c7868848b67861fe8b1dfdd64f8632\" \/><input type=\"hidden\" class=\"xcrud-data\" name=\"orderby\" value=\"\" \/><input type=\"hidden\" class=\"xcrud-data\" name=\"order\" value=\"asc\" \/><input type=\"hidden\" class=\"xcrud-data\" name=\"start\" value=\"0\" \/><input type=\"hidden\" class=\"xcrud-data\" name=\"limit\" value=\"10\" \/><input type=\"hidden\" class=\"xcrud-data\" name=\"instance\" value=\"f0f11141aedd4b38c9e87ffb421bd61368013661\" \/><input type=\"hidden\" class=\"xcrud-data\" name=\"editmode\" value=\"\" \/><input type=\"hidden\" class=\"xcrud-data\" name=\"task\" value=\"create\" \/><\/p>\n<h2>Consultation<small> &#8211; Add<\/small><\/h2>\n<div class=\"xcrud-top-actions btn-group\">\n   <\/div>\n<div class=\"xcrud-top-actions btn-group\">\n    <a href=\"javascript:;\" data-task=\"save\" data-after=\"list\" class=\"btn btn-primary xcrud-action\">Save &amp; Return<\/a><a href=\"javascript:;\" data-task=\"save\" data-after=\"create\" class=\"btn btn btn-light xcrud-action\">Save &amp; New<\/a><a href=\"javascript:;\" data-task=\"save\" data-after=\"edit\" class=\"btn btn-light xcrud-action\">Save &amp; Edit<\/a><a href=\"javascript:;\" data-task=\"list\" class=\"btn btn-warning xcrud-action\">Return<\/a><\/div>\n<form data-parsley-validate='' class=\"parsley-form\">\n<div class=\"xcrud-view\">\n<div class=\"form-row\">\n<div class=\"form-group col-md-6\"><label class=\"control-label\">Name<\/label><\/p>\n<div><input class=\"xcrud-input form-control\" type=\"text\" data-type=\"text\" value=\"\" name=\"Y29uc3VsdGF0aW9uLm5hbWU-\" maxlength=\"50\" \/><\/div>\n<\/div>\n<div class=\"form-group col-md-6\"><label class=\"control-label\">Date<\/label><\/p>\n<div><input class=\"xcrud-input xcrud-datepicker form-control\" type=\"text\" data-type=\"date\" value=\"\" name=\"Y29uc3VsdGF0aW9uLmRhdGU-\" \/><\/div>\n<\/div>\n<div class=\"form-group col-md-6\"><label class=\"control-label\">Office<\/label><\/p>\n<div><select class=\"xcrud-input form-control form-control\" data-type=\"select\" name=\"Y29uc3VsdGF0aW9uLm9mZmljZQ--\" maxlength=\"50\"><option value=\"\">&#8211; none &#8211;<\/option><option value=\"9\"><\/option><option value=\"7\">London<\/option><option value=\"6\">Sydney<\/option><option value=\"5\">Tokyo<\/option><\/select><\/div>\n<\/div>\n<div class=\"form-group col-md-6\"><label class=\"control-label\">Manager<\/label><\/p>\n<div><select class=\"xcrud-input form-control form-control\" data-depend=\"Y29uc3VsdGF0aW9uLm9mZmljZQ--\" data-type=\"select\" name=\"Y29uc3VsdGF0aW9uLm1hbmFnZXI-\" maxlength=\"50\"><option value=\"\" selected=\"\">&#8211; none &#8211;<\/option><\/select><\/div>\n<\/div>\n<div class=\"form-group col-md-6\"><label class=\"control-label\">Country<\/label><\/p>\n<div><select class=\"xcrud-input form-control form-control\" data-type=\"select\" name=\"Y29uc3VsdGF0aW9uLmNvdW50cnk-\"><option value=\"\">&#8211; none &#8211;<\/option><option value=\"3\">Afghanistan<\/option><option value=\"16\">Aland Islands<br \/>\n\u00c5land Islands<\/option><option value=\"6\">Albania<\/option><option value=\"61\">Algeria<br \/>\n<\/option><option value=\"12\">American Samoa<br \/>\n<\/option><option value=\"1\">Andorra<\/option><option value=\"9\">Angola<br \/>\n<\/option><option value=\"5\">Anguilla<\/option><option value=\"10\">Antarctica<br \/>\n<\/option><option value=\"4\">Antigua and Barbuda<\/option><option value=\"11\">Argentina<br \/>\n<\/option><option value=\"7\">Armenia<br \/>\n<\/option><option value=\"15\">Aruba<br \/>\n<\/option><option value=\"14\">Australia<br \/>\n<\/option><option value=\"13\">Austria<br \/>\n<\/option><option value=\"17\">Azerbaijan<br \/>\n<\/option><option value=\"32\">Bahamas<br \/>\n<\/option><option value=\"24\">Bahrain<br \/>\n<\/option><option value=\"20\">Bangladesh<br \/>\n<\/option><option value=\"19\">Barbados<br \/>\n<\/option><option value=\"36\">Belarus<br \/>\n<\/option><option value=\"21\">Belgium<br \/>\n<\/option><option value=\"37\">Belize<br \/>\n<\/option><option value=\"26\">Benin<br \/>\n<\/option><option value=\"28\">Bermuda<br \/>\n<\/option><option value=\"33\">Bhutan<br \/>\n<\/option><option value=\"30\">Bolivia<br \/>\nBolivia, Plurinational state of<\/option><option value=\"18\">Bosnia and Herzegovina<br \/>\n<\/option><option value=\"35\">Botswana<br \/>\n<\/option><option value=\"34\">Bouvet Island<br \/>\n<\/option><option value=\"31\">Brazil<br \/>\n<\/option><option value=\"105\">British Indian Ocean Territory<br \/>\n<\/option><option value=\"29\">Brunei Darussalam<br \/>\n<\/option><option value=\"23\">Bulgaria<br \/>\n<\/option><option value=\"22\">Burkina Faso<br \/>\n<\/option><option value=\"25\">Burundi<br \/>\n<\/option><option value=\"116\">Cambodia<br \/>\n<\/option><option value=\"47\">Cameroon<br \/>\n<\/option><option value=\"38\">Canada<br \/>\n<\/option><option value=\"52\">Cape Verde<br \/>\n<\/option><option value=\"123\">Cayman Islands<br \/>\n<\/option><option value=\"41\">Central African Republic<br \/>\n<\/option><option value=\"212\">Chad<\/option><option value=\"46\">Chile<\/option><option value=\"48\">China<br \/>\n<\/option><option value=\"53\">Christmas Island<br \/>\n<\/option><option value=\"39\">Cocos (Keeling) Islands<br \/>\n<\/option><option value=\"49\">Colombia<br \/>\n<\/option><option value=\"118\">Comoros<br \/>\n<\/option><option value=\"42\">Congo<br \/>\n<\/option><option value=\"40\">Congo, The Democratic Republic of the<br \/>\n<\/option><option value=\"45\">Cook Islands<br \/>\n<\/option><option value=\"50\">Costa Rica<br \/>\n<\/option><option value=\"44\">C\u00f4te d&#039;Ivoire<\/option><option value=\"97\">Croatia<br \/>\n<\/option><option value=\"51\">Cuba<br \/>\n<\/option><option value=\"54\">Cyprus<br \/>\n<\/option><option value=\"55\">Czech Republic<br \/>\n<\/option><option value=\"58\">Denmark<br \/>\n<\/option><option value=\"57\">Djibouti<br \/>\n<\/option><option value=\"59\">Dominica<br \/>\n<\/option><option value=\"60\">Dominican Republic<br \/>\n<\/option><option value=\"62\">Ecuador<br \/>\n<\/option><option value=\"64\">Egypt<br \/>\n<\/option><option value=\"208\">El Salvador<br \/>\n<\/option><option value=\"87\">Equatorial Guinea<br \/>\n<\/option><option value=\"66\">Eritrea<br \/>\n<\/option><option value=\"63\">Estonia<br \/>\n<\/option><option value=\"68\">Ethiopia<br \/>\n<\/option><option value=\"71\">Falkland Islands (Malvinas)<br \/>\n<\/option><option value=\"73\">Faroe Islands<br \/>\n<\/option><option value=\"70\">Fiji<br \/>\n<\/option><option value=\"69\">Finland<br \/>\n<\/option><option value=\"74\">France<br \/>\n<\/option><option value=\"79\">French Guiana<\/option><option value=\"174\">French Polynesia<br \/>\n<\/option><option value=\"213\">French Southern Territories<\/option><option value=\"75\">Gabon<\/option><option value=\"84\">Gambia<br \/>\n<\/option><option value=\"78\">Georgia<\/option><option value=\"56\">Germany<br \/>\n<\/option><option value=\"81\">Ghana<br \/>\n<\/option><option value=\"82\">Gibraltar<br \/>\n<\/option><option value=\"88\">Greece<br \/>\n<\/option><option value=\"83\">Greenland<br \/>\n<\/option><option value=\"77\">Grenada<\/option><option value=\"86\">Guadeloupe<br \/>\n<\/option><option value=\"91\">Guam<br \/>\n<\/option><option value=\"90\">Guatemala<br \/>\n<\/option><option value=\"80\">Guernsey<\/option><option value=\"85\">Guinea<br \/>\n<\/option><option value=\"92\">Guinea-Bissau<br \/>\n<\/option><option value=\"93\">Guyana<br \/>\n<\/option><option value=\"98\">Haiti<br \/>\n<\/option><option value=\"95\">Heard Island and McDonald Islands<br \/>\n<\/option><option value=\"233\">Holy See (Vatican City State)<br \/>\n<\/option><option value=\"96\">Honduras<br \/>\n<\/option><option value=\"94\">Hong Kong<br \/>\n<\/option><option value=\"99\">Hungary<br \/>\n<\/option><option value=\"108\">Iceland<br \/>\n<\/option><option value=\"104\">India<br \/>\n<\/option><option value=\"100\">Indonesia<br \/>\n<\/option><option value=\"107\">Iran, Islamic Republic of<br \/>\n<\/option><option value=\"106\">Iraq<br \/>\n<\/option><option value=\"101\">Ireland<br \/>\n<\/option><option value=\"103\">Isle of Man<br \/>\n<\/option><option value=\"102\">Israel<br \/>\n<\/option><option value=\"109\">Italy<\/option><option value=\"111\">Jamaica<br \/>\n<\/option><option value=\"113\">Japan<br \/>\n<\/option><option value=\"110\">Jersey<br \/>\n<\/option><option value=\"112\">Jordan<br \/>\n<\/option><option value=\"124\">Kazakhstan<br \/>\n<\/option><option value=\"114\">Kenya<br \/>\n<\/option><option value=\"117\">Kiribati<br \/>\n<\/option><option value=\"120\">Korea, Democratic People&amp;#39;s Republic of<br \/>\n<\/option><option value=\"121\">Korea, Republic of<br \/>\n<\/option><option value=\"122\">Kuwait<br \/>\n<\/option><option value=\"115\">Kyrgyzstan<br \/>\n<\/option><option value=\"125\">Lao People&amp;#39;s Democratic Republic<br \/>\n<\/option><option value=\"134\">Latvia<br \/>\n<\/option><option value=\"126\">Lebanon<br \/>\n<\/option><option value=\"131\">Lesotho<br \/>\n<\/option><option value=\"130\">Liberia<br \/>\n<\/option><option value=\"135\">Libyan Arab Jamahiriya<br \/>\n<\/option><option value=\"128\">Liechtenstein<br \/>\n<\/option><option value=\"132\">Lithuania<br \/>\n<\/option><option value=\"133\">Luxembourg<br \/>\n<\/option><option value=\"147\">Macao<br \/>\n<\/option><option value=\"143\">Macedonia<br \/>\n<\/option><option value=\"141\">Madagascar<br \/>\n<\/option><option value=\"155\">Malawi<br \/>\n<\/option><option value=\"157\">Malaysia<br \/>\n<\/option><option value=\"154\">Maldives<br \/>\n<\/option><option value=\"144\">Mali<br \/>\n<\/option><option value=\"152\">Malta<br \/>\n<\/option><option value=\"142\">Marshall Islands<br \/>\n<\/option><option value=\"149\">Martinique<br \/>\n<\/option><option value=\"150\">Mauritania<br \/>\n<\/option><option value=\"153\">Mauritius<br \/>\n<\/option><option value=\"243\">Mayotte<br \/>\n<\/option><option value=\"156\">Mexico<br \/>\n<\/option><option value=\"72\">Micronesia, Federated States of<br \/>\n<\/option><option value=\"138\">Moldova, Republic of<br \/>\n<\/option><option value=\"137\">Monaco<br \/>\n<\/option><option value=\"146\">Mongolia<br \/>\n<\/option><option value=\"139\">Montenegro<br \/>\n<\/option><option value=\"151\">Montserrat<br \/>\n<\/option><option value=\"136\">Morocco<br \/>\n<\/option><option value=\"158\">Mozambique<br \/>\n<\/option><option value=\"145\">Myanmar<br \/>\n<\/option><option value=\"159\">Namibia<br \/>\n<\/option><option value=\"168\">Nauru<br \/>\n<\/option><option value=\"167\">Nepal<br \/>\n<\/option><option value=\"165\">Netherlands<br \/>\n<\/option><option value=\"8\">Netherlands Antilles<br \/>\n<\/option><option value=\"160\">New Caledonia<br \/>\n<\/option><option value=\"170\">New Zealand<br \/>\n<\/option><option value=\"164\">Nicaragua<br \/>\n<\/option><option value=\"161\">Niger<br \/>\n<\/option><option value=\"163\">Nigeria<br \/>\n<\/option><option value=\"169\">Niue<br \/>\n<\/option><option value=\"162\">Norfolk Island<br \/>\n<\/option><option value=\"148\">Northern Mariana Islands<br \/>\n<\/option><option value=\"166\">Norway<\/option><option value=\"171\">Oman<br \/>\n<\/option><option value=\"177\">Pakistan<br \/>\n<\/option><option value=\"184\">Palau<br \/>\n<\/option><option value=\"182\">Palestinian Territory, Occupied<\/option><option value=\"172\">Panama<br \/>\n<\/option><option value=\"175\">Papua New Guinea<br \/>\n<\/option><option value=\"185\">Paraguay<br \/>\n<\/option><option value=\"173\">Peru<br \/>\n<\/option><option value=\"176\">Philippines<br \/>\n<\/option><option value=\"180\">Pitcairn<br \/>\n<\/option><option value=\"178\">Poland<br \/>\n<\/option><option value=\"183\">Portugal<br \/>\n<\/option><option value=\"181\">Puerto Rico<br \/>\n<\/option><option value=\"186\">Qatar<br \/>\n<\/option><option value=\"187\">R\u00e9union<\/option><option value=\"188\">Romania<br \/>\n<\/option><option value=\"190\">Russian Federation<br \/>\n<\/option><option value=\"191\">Rwanda<br \/>\n<\/option><option value=\"27\">Saint Barthlemy<\/option><option value=\"198\">Saint Helena<br \/>\n<\/option><option value=\"119\">Saint Kitts and Nevis<br \/>\n<\/option><option value=\"127\">Saint Lucia<br \/>\n<\/option><option value=\"140\">Saint Martin<\/option><option value=\"179\">Saint Pierre and Miquelon<br \/>\n<\/option><option value=\"234\">Saint Vincent and the Grenadines<br \/>\n<\/option><option value=\"241\">Samoa<br \/>\n<\/option><option value=\"203\">San Marino<br \/>\n<\/option><option value=\"207\">Sao Tome and Principe<br \/>\n<\/option><option value=\"192\">Saudi Arabia<br \/>\n<\/option><option value=\"204\">Senegal<br \/>\n<\/option><option value=\"189\">Serbia<br \/>\n<\/option><option value=\"194\">Seychelles<br \/>\n<\/option><option value=\"202\">Sierra Leone<br \/>\n<\/option><option value=\"197\">Singapore<br \/>\n<\/option><option value=\"201\">Slovakia<br \/>\n<\/option><option value=\"199\">Slovenia<br \/>\n<\/option><option value=\"193\">Solomon Islands<br \/>\n<\/option><option value=\"205\">Somalia<br \/>\n<\/option><option value=\"244\">South Africa<br \/>\n<\/option><option value=\"89\">South Georgia and the South Sandwich Islands<br \/>\n<\/option><option value=\"67\">Spain<br \/>\n<\/option><option value=\"129\">Sri Lanka<br \/>\n<\/option><option value=\"195\">Sudan<br \/>\n<\/option><option value=\"206\">Suriname<br \/>\n<\/option><option value=\"200\">Svalbard and Jan Mayen<br \/>\n<\/option><option value=\"210\">Swaziland<br \/>\n<\/option><option value=\"196\">Sweden<br \/>\n<\/option><option value=\"43\">Switzerland<br \/>\n<\/option><option value=\"209\">Syrian Arab Republic<br \/>\n<\/option><option value=\"225\">Taiwan<br \/>\n<\/option><option value=\"216\">Tajikistan<\/option><option value=\"226\">Tanzania, United Republic of<br \/>\n<\/option><option value=\"215\">Thailand<\/option><option value=\"218\">Timor-Leste<\/option><option value=\"214\">Togo<\/option><option value=\"217\">Tokelau<\/option><option value=\"221\">Tonga<br \/>\n<\/option><option value=\"223\">Trinidad and Tobago<br \/>\n<\/option><option value=\"220\">Tunisia<br \/>\n<\/option><option value=\"222\">Turkey<\/option><option value=\"219\">Turkmenistan<br \/>\n<\/option><option value=\"211\">Turks and Caicos Islands<br \/>\n<\/option><option value=\"224\">Tuvalu<br \/>\n<\/option><option value=\"228\">Uganda<br \/>\n<\/option><option value=\"227\">Ukraine<br \/>\n<\/option><option value=\"2\">United Arab Emirates<\/option><option value=\"76\">United Kingdom<\/option><option value=\"230\">United States<br \/>\n<\/option><option value=\"229\">United States Minor Outlying Islands<br \/>\n<\/option><option value=\"231\">Uruguay<br \/>\n<\/option><option value=\"232\">Uzbekistan<br \/>\n<\/option><option value=\"239\">Vanuatu<br \/>\n<\/option><option value=\"235\">Venezuela, Bolivarian Republic of<\/option><option value=\"238\">Viet Nam<\/option><option value=\"236\">Virgin Islands, British<br \/>\n<\/option><option value=\"237\">Virgin Islands, U.S.<br \/>\n<\/option><option value=\"240\">Wallis and Futuna<br \/>\n<\/option><option value=\"65\">Western Sahara<br \/>\n<\/option><option value=\"242\">Yemen<br \/>\n<\/option><option value=\"245\">Zambia<br \/>\n<\/option><option value=\"246\">Zimbabwe<\/option><\/select><\/div>\n<\/div>\n<div class=\"form-group col-md-6\"><label class=\"control-label\">Region<\/label><\/p>\n<div><select class=\"xcrud-input form-control form-control\" data-depend=\"Y29uc3VsdGF0aW9uLmNvdW50cnk-\" data-type=\"select\" name=\"Y29uc3VsdGF0aW9uLnJlZ2lvbg--\"><option value=\"\" selected=\"\">&#8211; none &#8211;<\/option><\/select><\/div>\n<\/div>\n<div class=\"form-group col-md-6\"><label class=\"control-label\">City<\/label><\/p>\n<div><select class=\"xcrud-input form-control form-control\" data-depend=\"Y29uc3VsdGF0aW9uLnJlZ2lvbg--\" data-type=\"select\" name=\"Y29uc3VsdGF0aW9uLmNpdHk-\"><option value=\"\" selected=\"\">&#8211; none &#8211;<\/option><\/select><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/form>\n<div class=\"xcrud-nav form-inline\">\n    <\/div>\n<\/p><\/div>\n<div class=\"xcrud-overlay\"><\/div>\n<\/p><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"_links":{"self":[{"href":"https:\/\/xcrud.net\/wordpress\/index.php\/wp-json\/wp\/v2\/pages\/68"}],"collection":[{"href":"https:\/\/xcrud.net\/wordpress\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/xcrud.net\/wordpress\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/xcrud.net\/wordpress\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xcrud.net\/wordpress\/index.php\/wp-json\/wp\/v2\/comments?post=68"}],"version-history":[{"count":3,"href":"https:\/\/xcrud.net\/wordpress\/index.php\/wp-json\/wp\/v2\/pages\/68\/revisions"}],"predecessor-version":[{"id":136,"href":"https:\/\/xcrud.net\/wordpress\/index.php\/wp-json\/wp\/v2\/pages\/68\/revisions\/136"}],"wp:attachment":[{"href":"https:\/\/xcrud.net\/wordpress\/index.php\/wp-json\/wp\/v2\/media?parent=68"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}