import requests
import scrapy


class QuotesSpider(scrapy.Spider):
    name = "uksite"
    login_url = 'https://myeplanning.oxfordshire.gov.uk/Disclaimer/Accept?returnUrl=%2FSearch%2FAdvanced'
    start_urls = [login_url]
    def parse(self, response):
        token = response.css('input[name="__RequestVerificationToken"]::attr(value)').extract_first()
        data = {'__RequestVerificationToken': token,
                'DateReceivedFrom': '2021-04-07',
                'DateReceivedTo': '2021-04-08',
                'AdvancedSearch': 'True',
                'SearchPlanning': 'True',
                }


        yield scrapy.FormRequest.from_response(response,
                                               url=self.login_url,
                                               formdata= data,
                                               clickdata={'class': 'occlss-button occlss-button--primary decompress'},
                                               callback = self.value,
                                               )
    def value(self, response):
   
        print(response._url)
   

        const tx = await baseAgreement.connect(user).withdraw(
            jobId,
            oracleFee
        );

    const signer = provider.getSigner();
    const tx = await baseAgreement.connect(signer).withdraw(jobId, oracleFee);

    function withdraw(
        bytes32 _jobId,
        uint256 _oracleFee
    )
        external
        onlyContractActive()
        returns(bytes32 requestId)
    {
        // check Link in this contract to see if we need to request more
        checkLINK(_oracleFee);

        // Build request
        Chainlink.Request memory req = buildChainlinkRequest(_jobId, address(this), this.fulfillWithdraw.selector);
        bytes memory url_bytes = abi.encodePacked(BASE_URL, mediaLink, API_KEY);
        req.add("get", string(url_bytes));


        req.add("path", "items.0.statistics.viewCount");
        return sendChainlinkRequestTo(chainlinkOracleAddress(), req, _oracleFee);
    }

    /**
     * @dev Callback for chainlink, this function pays the user
     */
    function fulfillWithdraw(
        bytes32 _requestId,
        bytes32 _response
    )
        external
        recordChainlinkFulfillment(_requestId)
    {
        // Convert api string response to an int
        string memory _responseString = bytes32ToString(_response);
        uint256 response = uint256(parseInt(_responseString, 0));
        emit IntResponse(response);
        // Pay the user
        payUser(response);
    }

    function payUser(
        uint256 _number
    )
        internal
    {
        // Calculate pay
        uint256 budgetRemaining = getAgreementBalance();
        uint256 accumulatedPay = budget - budgetRemaining;
        uint256 pay = (payPerNumber * _number) - accumulatedPay;
        if (pay > budgetRemaining) {
            pay = budgetRemaining;
        }
        // Calculate platform fee
        uint256 totalPlatformFee = (pay * PLATFORM_FEE) / 100;
        // Transfer funds
        paySomeone(payable(address(this)), user, pay-totalPlatformFee);
        paySomeone(payable(address(this)), platformAddress, totalPlatformFee);
    }

#create sample dataframe
df <- data.frame("number" = c(1,2.7,8,5), "binary1" = c(1,0,1,1), 
"answer" = c("Yes","No", "Yes", "No"), "binary2" = c(0,0,1,0))
n <- 3

#for each column
for (col in colnames(df)){
#check if the first entry is numeric
  if (is.numeric(df[col][1,1])){
# check that there are fewer than 3 unique values
    if ( length(unique(df[col])[,1]) < n ) {
    df[[col]] <- factor(df[[col]])
                                           }
                               }
                         }

import * as am4core from "@amcharts/amcharts4/core";
import * as am4charts from "@amcharts/amcharts4/charts";

import React, { useRef, useState, useEffect } from 'react';
import axios from "axios";

function UnderstandingGraph(props) {
    
    const [feedback, setFeedback] = useState('');    

    // ⬇ Creating the chart
    const chart = useRef(null);
    
    useEffect(() => {
        // ⬇ This calls my get request from the server
        getFeedback();
        // ⬇ This creates the kind of chart that I would like from am4charts
        let x = am4core.create("chartdiv", am4charts.XYChart);
        // ⬇ Padding to the right of the graph
        x.paddingRight =  20;
        // ⬇ This declares what kind of date format I would like.
        x.dateFormatter.dateFormat = "yyyy-MM-dd";
        // ⬇ Adding from the data that I set in the getFeedback function
        let data = dataArray;
        // ⬇ Making the data tied to the chart, called x.
        x.data = data;
        // ⬇ creating xAxes (the horizontal axis)
        let dateAxis = x.xAxes.push(new am4charts.DateAxis());
        // dateAxis.title.text = "Date";
        dateAxis.renderer.grid.template.location = 0;
        // ⬇ creating yAxes (the vertical axis)
        let valueAxis = x.yAxes.push(new am4charts.ValueAxis());
        valueAxis.tooltip.disabled = true;
        valueAxis.renderer.minWidth = 35;
        // ⬇ Creating the series for a line graph
        let series = x.series.push(new am4charts.LineSeries());
        // ⬇ Binding the data to the series
        series.dataFields.dateX = "date";
        series.dataFields.valueY = "understanding";
        series.tooltipText = "{valueY.value}";
        x.cursor = new am4charts.XYCursor();
        // ⬇ Scrollbar functionality at the top of the graph
        let scrollbarX = new am4charts.XYChartScrollbar();
        scrollbarX.series.push(series);
        x.scrollbarX = scrollbarX;

        chart.current = x;
        
        return () => {
            x.dispose();
        };
    }, []);

    // ⬇ This gets my data from the database and sets it to feedback
    const getFeedback = ()  => {
        axios.get('/feedback') 
        .then( (response) => {
            setFeedback(response.data)
        })
        .catch((error) => {
            console.log(`We have a server error`, error);
        });
    }

    //!! Want the graph to render? Cut nearly any line from this page, then the graph will force reload and show. Why?
    //! I have been copy/pasting line 71 to make the graph show.
    //! Interesting though, that when the page loads, I only see one console.log. When I re-paste it, I see two...
    //! It's almost like the computer can't think fast enough to get the data and then come back. Is there an async screen pause?
    console.log('feedback', feedback)
    
    // ⬇ Arrays of the data I will need:
    const dataArray = []
    // ⬇ Loops through feedback 
    for (let i=0; i < feedback.length; i++){
        // ⬇ Checking that I can get the dates that I want - I can!
        // console.log(feedback[i])
        // console.log(feedback[i].date) // Will log the long long date
        // console.log(feedback[i].understanding) // Will log the number

        // ⬇ Makes an object, called data, that I can use to push into the dataArray.
        // Later we will use this to set the data points of the graph.
        let data = {
            "date": feedback[i].date,
            "understanding": feedback[i].understanding
        }
        dataArray.push(data)
    }

    

    return(
        
    );
};

export default UnderstandingGraph;

useEffect(() => {
        // ⬇ This calls my get request from the server
        getFeedback();
}, [feedback]);

useEffect(() => {
        // ⬇ Code for the graph here
}, []);

useEffect(() => {
        // ⬇ This calls my get request from the server
        getFeedback();
}, []);

useEffect(() => {
        // ⬇ Code for the graph here
}, []);

//* GET REQUEST
// Will get all the responses
router.get('/', (req, res) => {
  let queryText = 'SELECT * from "feedback" ORDER BY "date" ASC;'
  pool.query(queryText).then( result => {
    // ⬇ Sends back the results in an object
      res.send(result.rows);
      console.log('Result from server:', result.rows)
  }).catch( error => {
      console.log('Error GET', error);
      res.sendStatus(500);
  });
});

CREATE TABLE "feedback" (
  "id" serial primary key,
  "feeling" INT not null,
  "understanding" INT not null,
  "support" INT not null,
  "comments" text,
  "flagged" boolean default false,
  "date" date not null default CURRENT_DATE
); 

-- Sample Data
INSERT INTO "feedback" ("feeling", "understanding", "support", "date")
VALUES 
(4, 4, 5, '2021-06-11'),
(4, 4, 5, '2021-06-10'),
(4, 2, 5, '2021-06-9'),
(2, 4, 5, '2021-06-7'),
(1, 3, 5, '2021-06-4'),
(4, 5, 5, '2021-06-2'),
(3, 3, 5, '2021-05-28'),
(3, 2, 5, '2021-05-26'),
(5, 4, 5, '2021-05-25'),
(2, 5, 5, '2021-05-24'),
(5, 5, 5, '2021-05-21');

 $(document).on('click', '.edit', function(){

          var id = $(this).attr('id');
         console.log(id);
           $('#form_result').html('');
          $.ajax({
          
             url:"castingss/"+id+"/edit",
           dataType:"json",
           type:"GET",
           success:function(html){
           /* $('#casting_name').val(html.data.casting_name);
            $('#casting_cin').val(html.data.casting_cin);
             $('#casting_email').val(html.data.casting_email);
            $('#casting_phone').val(html.data.casting_phone);
             $('#casting_age').val(html.data.casting_age);
            $('#casting_sexe').val(html.data.casting_sexe);
             $('#casting_city').val(html.data.casting_city);
            $('#casting_address').val(html.data.casting_address);
            $('#store_image').html("");
            $('#store_image').append("");
            $('#hidden_id').val(html.data.id);
            $('.modal-title').text("Edit New Record");
            $('#action_button').val("Edit");
            $('#action').val("Edit");*/
            $('#formModal').modal('show');
           }
          })
         });

public function edit($id_casting)
   
 {
         if(request()->ajax())
        {
            $data = Casting::findOrFail($id_casting);
            return response()->json(['data' => $data]);
        }
}

class Casting extends Model
{
    use HasFactory;
   
     protected $fillable = ["id_casting",
        "nom", "prenom" , "cine" , "date_naissance","lieu_naissance" ,"mineur","id_representant","id_type_facturation","artiste","fonction","id_type_casting ","tel1","tel2","email","photo","qualification","adresse","ville","pays"
    ];
}

Route::group(['middleware' => ['auth','role:admin']], function() { 
    Route::get('/castingss/{id_casting}/edit', [App\Http\Controllers\CastingController::class, 'edit']);
});

exception: "Illuminate\\Database\\QueryException"
file: "D:\\Projet_Cast_Infl\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php"
line: 678
message: "SQLSTATE[42S22]: Column not found: 1054 Champ 'castings.id' inconnu dans where clause (SQL: select * from `castings` where `castings`.`id` = 6 limit 1)"
trace: [{file: "D:\Projet_Cast_Infl\vendor\laravel\framework\src\Illuminate\Database\Connection.php",…},…]

set.seed(1000)
split = sample.split(query$Exited, SplitRatio = 0.65)
train = subset(query, split==TRUE)
test = subset(query, split==FALSE)
model = glm(Exited ~ CreditScore + Gender + Age + Balance + IsActiveMember, data = train, family=binomial)
summary(model)
predict = predict(model, type="response", newdata=test)
table(test$Exited, predict > 0.5)

# Accuracy of model:
(2717+107)/(2717+70+606+107)

(2717+107)/(2717+70+606+107)

Accuracy(y_pred = pred, y_true = train$Exited)

this.httpService
      .get('https://api.chucknorris.io/jokes/random')
      .subscribe((e) => console.log(e.data));

this.httpService
      .get('https://api.chucknorris.io/jokes/random')
      .subscribe((e) => e.data);

getpollsoup = BeautifulSoup(getpolldata, 'html.parser')
poll = getpollsoup.find_all("script")[0]
print(poll) 

    (function () {
        var config = {};

        // Transaction details
        config.transaction = {
            token: "36374fb17a52c4d145a7f689d8d20f85ca9e3747acb89f95f9b592fd4a4cf757",
            date: parseInt("1623792179"),
            expiry: parseInt("1623792479"),
            expiresIn: parseInt("299"), // "Expires in" calculated based on Server time
            expiresAfter: parseInt("300"),
            challengeMethod:  "delegate-sca" ,
            phoneNumberTail:  null         };

        // MPI data
        config.mpiData = JSON.parse(atob("eyJtZCI6IjQwMjkyNzc1NDIiLCJ0ZXJtVXJsIjoiaHR0cHM6XC9cL3d3dy5zaG9wZGlzbmV5LmNvLnVrXC9vblwvZGVtYW5kd2FyZS5zdG9yZVwvU2l0ZXMtZGlzbmV5dWstU2l0ZVwvZW5fR0JcL1dvcmxkUGF5LUhhbmRsZUF1dGhlbnRpY2F0aW9uUmVzcG9uc2U/bm89NDAyOTI3NzU0MiJ9"));

        // One-Time Code
        config.otcVerify = "https://retry.touchtechpayments.com/api/v1/:verify";
        config.otcResend = "https://retry.touchtechpayments.com/api/v1/:resend";

        // Poll
        config.pollUrl = "https://poll.touchtechpayments.com/poll";

        // Select
        config.selectUrl = "https://retry.touchtechpayments.com/api/v1/:select";

        // Macs
        config.macsConfirmUrl = "https://macs.touchtechpayments.com/v1/confirmTransaction";
        config.macsCancelUrl = "https://macs.touchtechpayments.com/v1/cancelAuthentication";

        window.ttConfig = config;
    })();
 

#/bin/python3
import requests

url = "https://api.bleepbloop.com/v8/account/555"
headers = {"Accept": "application/json", "Authorization": "Bearer 123456"}
response = requests.request("POST", url, headers=headers)
print(response.text)